Transdev’s relationship with DevScope dates back to 2010 when Rui Romano developed an HTML5 reporting platform that allowed employees to analyze and comment on some indicators that still live on their current Business Intelligence solution. When Transdev contacted him again, asking for a way to unify all their different operations, he was well aware of the company’s current situation. The project seemed challenging and presented another perfect opportunity to put Rui Romano’s “Start Small and Grow Big” work methodology to good use. In practice, it means implementing a solution in an Agile way with short and fast stages, modifying it to answer any of the clients’ problems, and scaling it according to their needs. Since this allows for a tailored approach, clients only need to implement solutions according to their business needs.
Stage #1 – Unifying different systems through a Data Warehouse
Nuno Miguel Silva, José Barbosa, and Bruno Ferreira, BI consultants at DevScope, designed a Data Warehouse – nicknamed Prometheus – that would feed on over a dozen of Transdev’s Ticketing (Datacar, Wayfarer, and Card4B) and Operation (ABC) databases.

Due to the different nature of these systems, the DevScope team developed a fast and dynamic ETL Framework for Microsoft SQL Server Integration Services (SSIS), allowing for faster design and development of ETL solutions and making it easier to change configurations. Prometheus serves as an intermediary on the entire processing, receiving data from its original databases and transforming it to be used afterward.
“The diversity of systems made the process a little bit more complicated. And, on top of that, we found that users would be using different methods, even when working on the same system. Because of that, we had to standardize processes.”
– Maria Gabriel, Application Manager and Data Scientist at Transdev
The Data Warehouse with DevScope’s ETL framework gave Transdev a central platform to extract, transform and load data. Whenever a new data source comes in, Transdev’s IT department has no trouble adding it to the data warehouse: all they need to do is configure a few metadata tables. The company also had to normalize the way their workers handled it. Prior to the introduction of Prometheus, Excel was Transdev’s tool of choice but individual edits to files made data management slow and the figures unreliable. The entire decision-making process was compromised.
Stage #2 – Introducing Power BI
After regulating Transdev’s different systems through a data warehouse, the next step was to output such a large amount of information. Given its integration with SQL Server, Power BI was the logical choice for the task. Rui Romano is a well-known advocate of Power BI’s virtues and demoing it was enough for Transdev to realize how interactive reports and dashboards could dramatically change several areas of their operation. The company currently has 30 active Power BI Pro users and generates 10 different reports, ranging from ticketing to fleet consumption.



Prometheus is updated every day so Transdev technicians can always count on a fresh batch of trustworthy data in the morning when they arrive at the office. Real-time analytics is not necessary and because the entire process requires a lot of computing resources, updating outside working hours makes the process seamless.