This Power BI dashboard was built for Popular Flour Mill, a food manufacturing and distribution business selling Idly–Dosa Batter, Chapathi Packets, and Porotta Packets.
The objective was to analyze product performance, route-wise sales, buyer behavior, and profit trends to support day-to-day and monthly business decisions.
Live demo
- Which products sell the most?
- Which routes generate higher sales and profit?
- Who are the top buyers?
- What packet ratios and combinations are customers purchasing?
- How does profit vary daily and monthly?
- Total Sales
- Total Profit
- Profit by Day
- Profit by Month
- Top Selling Products
- Top Buyers
- Route-wise Sales & Profit
- Source: Daily sales data maintained in Excel files
- Data Cleaning & Transformation:
- Combined daily Excel files using Power Query
- Cleaned inconsistent product, buyer, and route names
- Standardized date formats and calculated profit
- Modeling & Visualization:
- Product-wise, route-wise, and buyer-wise analysis
- Time-based profit trends for operational tracking
- Identified high-performing products and routes
- Ranked top buyers contributing most to revenue
- Analyzed packet purchase ratios across buyers
- Monitored profit consistency and trends over time
- Working with real-world daily sales data
- Building repeatable data-cleaning pipelines in Power Query
- Designing dashboards driven by actual business needs
- Converting raw sales data into actionable insights
This dashboard enables Popular Flour Mill to track sales and profit performance, understand buyer behavior, and improve distribution decisions using clear, data-driven insights.