Excel to Power BI Conversion -- 2
Budget: $250 – $750 USD
I have an existing Excel workbook that pulls data from local tables and sheets only, with no external connections. The requirement is to replicate the same Excel file in Power BI, including all sheets, formulas, measures, calculated columns, and equations. The results in Power BI must match the Excel output exactly.
Before starting, you must carefully review the provided Excel file to confirm you fully understand the structure, logic, formulas, and calculations. Only proceed if you are confident you can reproduce everything accurately to avoid delays or incomplete delivery.
Once the data model is rebuilt, create a clean and professional Power BI report with bar charts, line graphs, and pie charts that mirror the Excel visuals. Include a categorical slicer that allows users to filter by product group or the relevant category field in the dataset.
Deliverable: A fully functional .pbix file that opens without errors, produces identical figures to the Excel source file, and includes all required visuals and the category slicer, ready for publishing to Power BI Service.
Before starting, you must carefully review the provided Excel file to confirm you fully understand the structure, logic, formulas, and calculations. Only proceed if you are confident you can reproduce everything accurately to avoid delays or incomplete delivery.
Once the data model is rebuilt, create a clean and professional Power BI report with bar charts, line graphs, and pie charts that mirror the Excel visuals. Include a categorical slicer that allows users to filter by product group or the relevant category field in the dataset.
Deliverable: A fully functional .pbix file that opens without errors, produces identical figures to the Excel source file, and includes all required visuals and the category slicer, ready for publishing to Power BI Service.