This repository contains Power BI dashboards developed for three different business use cases: HR Analytics, Sales Performance, and Small Business Operations (PizzaRio). Each dashboard is designed to highlight key business insights and enable better data-driven decision-making through filters, KPIs, visual storytelling, and interactivity.
The objective of this project was to design and publish multiple business intelligence dashboards that showcase the transformation of raw datasets into powerful, insight-rich visual tools using Power BI.
- HR Dashboard – Explore job roles, salary trends, staff demographics
- Sales Dashboard – Analyze product category performance and sales reps efficiency
- PizzaRio (Small Business) – Visualize orders, inventory status, and staff metrics
- What is the distribution of employees across job roles?
- What are the age and gender distributions of our staff?
- Which roles have the highest salaries?
- How has staff count evolved over the past 5 years?
- How do qualifications correlate with salary?
- Which product categories and subcategories drive the most revenue?
- How do individual salespersons perform?
- What are the revenue trends over time?
- How does performance vary by subcategory under a selected category?
- What are the busiest order times in a day/week/month?
- Which items sell the most?
- How are ingredient stocks managed and when do we need to reorder?
- What is the cost contribution from chefs and delivery staff?
- What is the labor cost per pizza?
- Power BI / Tableau – Dashboard creation and visual analytics
- Excel / SQL – Data cleaning, transformation and database creation
| Dashboard | Source Website |
|---|---|
| HR Dashboard | chandoo.org |
| Sales Dashboard | Kaggle |
| PizzaRio Dashboard | LearnBI.online |
- Designing dashboards with end-user experience in mind increases usability
- Dynamic filtering and tooltips enhance dashboard interactivity
- KPI Cards help focus on key performance indicators
- Performance optimization is essential when working with large datasets
- Business questions should guide visual choice, not the other way around
You can:
- Download the
.pbixfiles (coming soon) - View screenshots of the dashboards in the
/assetsfolder - Read business case summaries in the documentation
You can also view this project on my personal portfolio website:
🔗 Wix Portfolio – Interactive BI Dashboards – Business Insights at a Glance
For any questions or feedback, feel free to reach out:
Mukesh Shirke
GitHub Profile
Wix Portfolio
LinkedIn Profile