Power BI Demand Planning Report
Budget: ₹600 – ₹1,500 INR
I’ve uploaded Coca-Cola’s demand-planning dataset—products, regions, months, forecast figures, actual sales, and current inventory—and I need it transformed into a clear, insight-rich Power BI report. The core story I want to surface is the trend between forecasted and actual demand; bar charts feel the most intuitive for side-by-side comparison, but you’re free to layer in other visuals where they strengthen the narrative.
Start by shaping a robust data model: sensible relationships, clean dimension tables, and calculated measures such as forecast accuracy %, absolute variance, and days-of-inventory-on-hand. From there, craft a dashboard that lets stakeholders instantly see where we are consistently over- or under-forecasting, how those gaps evolve month over month, and which regions or product lines drive the discrepancies. Useful complements—think inventory burn-down cards, quick regional filters, or dynamic drill-through to SKU level—are welcome if they enhance decision making.
Deliver a Power BI (.pbix) file plus a short write-up (one pager or slide) that walks me through your modeling logic, key DAX formulas, and the business insights you uncovered. The report should open error-free in the latest Power BI Desktop and refresh cleanly against the supplied data.
Start by shaping a robust data model: sensible relationships, clean dimension tables, and calculated measures such as forecast accuracy %, absolute variance, and days-of-inventory-on-hand. From there, craft a dashboard that lets stakeholders instantly see where we are consistently over- or under-forecasting, how those gaps evolve month over month, and which regions or product lines drive the discrepancies. Useful complements—think inventory burn-down cards, quick regional filters, or dynamic drill-through to SKU level—are welcome if they enhance decision making.
Deliver a Power BI (.pbix) file plus a short write-up (one pager or slide) that walks me through your modeling logic, key DAX formulas, and the business insights you uncovered. The report should open error-free in the latest Power BI Desktop and refresh cleanly against the supplied data.