Challenge
Our client, a specialized department of an internationally operating automotive manufacturer, faced a complex challenge: The data science reporting landscape was highly fragmented and confusing. Reports were spread across various systems, making them difficult to find and manage. This lack of clarity impaired access to crucial information and the efficient use of data science resources. A central challenge was to integrate various types of reports, including PowerBI and web applications, into an appealing and unified platform.
Approach
Iterative Design Phase
Our team placed great emphasis on close collaboration with the client. The design phase was carried out iteratively to ensure that the app screen design met the requirements and expectations of the stakeholders. Through regular feedback loops, we were able to continuously involve the stakeholders and ensure that the final product met their needs.
Technological Framework
For the development of the platform, we relied on modern web technologies:
- Next.js and React enabled a powerful and user-friendly frontend development.
- TypeScript ensured a robust and scalable codebase.
- Next.js server-side capabilities were used for access management, enabling secure and efficient user management.
- PowerBI API and Iframes allowed seamless integration of various report types..
- Data- and API management
The configuration data of the reports and metadata, such as user favorites, were queried through a REST API developed with FastAPI and stored in a PostgreSQL database. This approach ensured that the data was managed securely and efficiently.
Results
With the platform, we created a central hub for data science reports, significantly facilitating the internal use of data.
Client Benefits at a Glance:
- Increased User Numbers: Through consolidated display and unified user management, the number of users was significantly increased.
- Intensive Internal Use: The platform is intensively used internally and enables the independent connection of new reports through self-service.
- Modular Design: Thanks to its modular design, the platform is easily expandable and can be flexibly adapted to future requirements.
- Modern User Experience: Features such as search functionality, adding favorites, and displaying metadata contribute to a modern and user-friendly experience, further increasing the platform’s acceptance.