Context
From March 2022 to July 2023, I worked through Apside within Harmonie Mutuelle’s Datalab on analysis, reporting and data quality.
- Business data integrated into the Datalab
- Datasets for analysis and reporting
- Indicators presented in Power BI reports
Challenge
Business needs called for structured datasets, resolved anomalies and reports whose delivery could be automated.
Objectives
- Integrate business data into a Datalab.
- Create datasets and improve their reliability.
- Design Power BI reports and dashboards.
- Automate report delivery.
Contribution
I worked from data preparation to Power BI reporting, correcting anomalies and automating report delivery. The assignment also included maintaining and updating a contract management robot.
- Preparing and integrating data in the Datalab.
- Structuring datasets, identifying and correcting anomalies.
- Creating reports and dashboards with Power BI, DAX and Power Query.
- Automating report delivery with Power Automate.
Work carried out
Structured datasets, corrected anomalies, Power BI reports and dashboards, with automated delivery through Power Automate.
Technologies
- Power BI
- DAX
- Power Query
- Power Automate
- SQL
- Python
A similar challenge?
Facing a similar challenge? Let’s talk.
Describe your data, processes and objectives to discuss an engagement suited to your needs.