From Raw Excel Files to a Fully Normalized SQL Database and Interactive Power BI Dashboards
This project presents a complete business analysis solution for a fictional pizza outlet, PizzaRio. The goal was to help the business owner streamline operations by improving visibility into orders, inventory, and staff management. The project follows the full data lifecycle — from understanding business requirements to designing a normalized SQL database and building insightful dashboards in Power BI.
The process involved:
- Gathering and structuring raw business data in Excel
- Normalizing the data and designing a relational schema
- Writing optimized SQL queries and creating views
- Connecting Power BI to SQL views via DirectQuery
- Creating interactive dashboards for decision-making
It is designed as a portfolio project to demonstrate core skills in data modeling, SQL querying, and Power BI reporting — suitable for real-world small business analytics.
The dataset used in this project was sourced from LearnBI.online, a paid course platform for Power BI and SQL learning. The data is used strictly for educational and portfolio purposes. Due to licensing restrictions, raw data files are not shared in this repository.
/SQL/ # SQL scripts for table creation, views, and queries /BI/ # Power BI .pbix file and dashboard screenshots /images/ # Sample visuals from dashboards README.md # Project documentation
- Clone this repository or download the
.pbixfile - Open the Power BI file using Power BI Desktop
- Review dashboard visuals and underlying data model
- (Optional) Rebuild SQL tables using scripts in the
/SQL/folder
- Line charts for hourly order trends
- Bar charts for top-selling items
- KPI cards showing total sales, average order value
- Filters for date, category, and order type (delivery/pickup)
- Pie charts for ingredient stock distribution
- Tables showing ingredient usage per pizza
- Visual alerts for low stock levels
- Supports inventory planning and cost tracking
- Bar charts showing hours worked per staff member
- KPI cards for total staff cost, labor cost per pizza
- Filters by role (chef/delivery) and date
- Helps monitor labor distribution and cost efficiency
- The importance of data normalization for relational database design
- Using SQL views to simplify and optimize Power BI reports
- Managing DirectQuery limitations through backend query logic
- Building a calendar table for consistent time-based analysis
- Creating user-friendly, insight-driven dashboards
You can also view this project on my personal portfolio website:
🔗 Wix Portfolio – PizzaRio Analytics: Building a Scalable Data System for a Small Business
Mukesh Shirke
GitHub Profile
Wix Portfolio
LinkedIn Profile
This project is for educational purposes only. The dataset was sourced from a paid course platform and is not included in this repository. All analysis and reports were independently developed.