All projects

Power BI reports and automated delivery

Preparing and validating business data, creating Power BI reports and automating their delivery.

Professional experienceDatalab and reporting

An assignment from my professional background. No internal or confidential data is disclosed.

Abstract illustration of the main data flow — no internal or confidential data is shown.

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.

Discuss your project