Power BI Dashboard & Data Cleansing

I have a raw Excel file containing operational data that first needs to be put into shape and then visualised in Power BI. The dataset must be free of duplicate rows, any missing values handled intelligently, and every column arranged in a clear, analysis-ready structure. You are free to lean on Python with Pandas or stay inside Power Query—the only requirement is that the workflow be fully reproducible so I can retrace each step later.

Once the data is spotless, the next step is an interactive Power BI report that highlights my core KPIs. I’m especially interested in efficiency and quality metrics, along with any evolution-over-time insights you can surface. Filters and drill-downs should feel intuitive so stakeholders can answer their own questions quickly.

Deliverables
• A cleaned dataset in Excel or CSV
• The .pbix file with relationships, calculated columns, and DAX measures neatly organised

In your reply, outline the approach you’ll follow and how long you expect each stage to take—from cleaning through to final dashboard hand-off.