Excel/Power BI Inventory Report
Budget: ₹600 – ₹1,500 INR
I am putting together a comprehensive inventory-management report that draws on several different raw data sources and I need your help building it in Advance Excel, enhancing it with Macros/VBA automation, and visualising the results in Power BI.
Here is what I have in mind. Multiple CSV and spreadsheet feeds will be consolidated, cleaned and reshaped inside Excel. Macros or VBA routines should automate the refresh and mapping process so I can drop new files into a folder and have the workbook update itself without manual intervention. From there, the prepared tables need to flow into a Power BI model that produces an at-a-glance dashboard highlighting current stock levels, inbound and outbound movements, and any exceptions that require action. I will supply sample data so you can design against real-world layouts, then swap in live data once everything is proven.
Deliverables
• A master Excel file with clearly commented Macros/VBA that import, transform and normalise the raw data
• A connected Power BI report (.pbix) with interactive visuals and slicers for product, location and date
• Step-by-step hand-off notes so I can refresh data or extend the model myself
Acceptance criteria
– Workbook refresh completes without errors using new raw files
– All calculated balances match control totals I will provide
– Power BI visuals load in under five seconds on my machine
If this matches your skill set and you can turn it around quickly, let’s get started.
Here is what I have in mind. Multiple CSV and spreadsheet feeds will be consolidated, cleaned and reshaped inside Excel. Macros or VBA routines should automate the refresh and mapping process so I can drop new files into a folder and have the workbook update itself without manual intervention. From there, the prepared tables need to flow into a Power BI model that produces an at-a-glance dashboard highlighting current stock levels, inbound and outbound movements, and any exceptions that require action. I will supply sample data so you can design against real-world layouts, then swap in live data once everything is proven.
Deliverables
• A master Excel file with clearly commented Macros/VBA that import, transform and normalise the raw data
• A connected Power BI report (.pbix) with interactive visuals and slicers for product, location and date
• Step-by-step hand-off notes so I can refresh data or extend the model myself
Acceptance criteria
– Workbook refresh completes without errors using new raw files
– All calculated balances match control totals I will provide
– Power BI visuals load in under five seconds on my machine
If this matches your skill set and you can turn it around quickly, let’s get started.