A professional Power BI portfolio showcasing a clear progression from foundational dashboards to advanced data modeling, time intelligence, and interactive analytical storytelling.
-
📁 Projects
-
📁 Datasets
An introductory dashboard designed to present café sales performance to management.
Key Highlights
- KPI cards: Sales, Profit, Cost, Quantity
- Interactive slicers (Branch, Product Category, Payment Method)
- Monthly sales trends
- High-level management overview
Preview
A deeper analytical project focused on data preparation and modeling best practices.
Key Highlights
- Data cleaning and normalization
- Star schema design (Fact & Dimension tables)
- Dedicated Calendar table
- Structured and well-organized DAX measures
- Foundational analytical dashboards
Previews
An advanced solution built on the same e-commerce dataset, emphasizing interactivity, UX, and deeper analytical insights.
Key Highlights
- Multi-page report (Home & Dashboard)
- KPI comparison vs previous year
- Advanced time intelligence (YOY, MOM, QOQ)
- Bookmarks and toggle buttons
- Multiple analytical views within the same visual space
- Retention, shipping, top products, and customer analysis
Previews
A multi-page analytical Power BI project built on the Superstore dataset, focusing on sales performance, pricing impact, product insights, customer behavior, and regional analysis.
Key Highlights
- Interactive home page with guided navigation
- Executive summary with KPI comparison vs previous year
- Pricing and discount impact analysis
- Product performance and profitability insights
- Customer purchase behavior analysis
- Regional performance breakdown with map visualization
- Structured data model with organized DAX display folders
Previews
Analytics & Modeling
- Power BI Desktop
- Data Modeling (Star Schema)
- KPI Design & Performance Comparison
Data Preparation
- Power Query (Data Cleaning & Transformation)
- Data Normalization
- Calendar Tables & Relationships
DAX & Time Intelligence
- DAX Measures
- YOY / MOM / QOQ Analysis
- Growth %, Profit Margin %, Retention Metrics
Dashboard Design & UX
- Interactive Dashboards
- Bookmarks & Toggle Buttons
- Page Navigation & Visual Storytelling
All projects are built using structured datasets available in the datasets folder.
- ☕ Café Sales Dataset – transactional sales data used for management-level reporting
- 🛒 E-Commerce Dataset – normalized sales data used for modeling, analysis, and advanced dashboards
- 📦 Superstore Dataset – transactional retail dataset used for sales analytics, customer behavior, discount analysis, and regional performance reporting
- This portfolio represents practical, hands-on analytical work
- Projects are designed to reflect real business scenarios
- Additional data analysis projects are currently in progress
- The repository will continue to evolve as new projects are completed
- Excel Business Projects
Hands-on Excel projects covering data cleaning, formulas, and business analysis.
👉 https://github.com/MohamedHajali95/excel-business-projects
Mohamed Hajali
Power BI & Data Analytics | Business Intelligence Enthusiast
🔗 GitHub: https://github.com/MohamedHajali95
🔗 Portfolio Repository: https://github.com/MohamedHajali95/powerbi-portfolio
🔗 LinkedIn: https://www.linkedin.com/in/mohamedhajali95/