Ruter Ticket-Inspection Analytics
A short but very fruitful experience with Ruter Billettkontroll analytics concluded in building a reporting foundation for the Billekontroll department in Ruter. Our job was to understand how to create cost models that various suppliers have with Ruter. In order to get the full picture and be able to create completed models, we decided to add the cost factor that added and entirely new perspective to our results.
ETL: SAP BODS Data Services, SQL, t-sql
Analytics: MS Data Tools, SSAS, DAX
Reporting/Dashboards: Excel Pivot