Challenge: The customer, a leading Romanian startup in the car rental space developed an innovative online platform, enabling secure vehicle borrowing from local owners. While gaining traction, their data-driven decision-making was hampered by a lack of intuitive reporting mechanisms.
With disparate data points scattered across a MongoDB backend, extracting crucial business insights was complex and manual. This inhibited strategic growth and operational efficiency.
Understanding critical metrics such as reservation volumes, revenue, profit margins, fleet owner affiliations, customer data, reservation durations, and car availability was essential for their growth.
Their existing reporting process required labor-intensive queries, with no automated process for gathering or visualizing data. They needed an advanced yet user-friendly solution to harness their unstructured and denormalized data for smart business intelligence.
We engineered a comprehensive solution starting with the adoption of a Windows server-based environment to accommodate Python ETLs. These ETLs were tailored to refine and restructure raw MongoDB data into an analysis-ready format saved in a MariaDB database. Additionally, we established a PowerBI gateway, creating a bridge between the MariaDB database and the online PowerBI Services.
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.
Visual Enhancements
We developed PowerBI dashboards that brought newfound clarity to the startup’s data, including:
The PowerBI integration revolutionized how MasiniLaCheie.ro interacted with their data:
©2024 All rights reserved
