Skip to content

About

A collection of interactive Power BI dashboards built using real-world datasets, showcasing data cleaning, ETL, DAX, data modeling, KPI development, and business intelligence insights.

Topics

Resources

Stars

1 star

Watchers

0 watching

Forks

Latest commit

 

History

22 Commits

Folders and files

Repository files navigation

📊 Power BI Dashboard Portfolio

Welcome to my Power BI Dashboard Portfolio. This repository contains practical Power BI projects built with real-world datasets to demonstrate data cleaning, transformation, data modeling, DAX, interactive reporting, visualization, and business storytelling.


🚀 Dashboards

📌 Project 1 — Data Jobs Dashboard

Project 1 Dashboard

📖 Overview

This dashboard is designed for Job Seekers, Career Transitioners, and Data Professionals to explore the 2024 Data Job Market.

The dashboard provides insights into:

  • Job demand
  • Median salaries
  • Hiring locations
  • Job titles
  • Work-from-home opportunities

✨ Skills Demonstrated

  • Power Query (ETL)
  • Data Cleaning & Transformation
  • Data Modeling
  • DAX Measures
  • KPI Cards
  • Column & Bar Charts
  • Area Charts
  • Map Visualizations
  • Drill Through
  • Buttons & Bookmarks
  • Interactive Slicers

📂 Project Folder

➡️ Data_Jobs_V1

🌐 Interactive Dashboard

Open Data Jobs Dashboard


📌 Project 2 — Data Jobs Dashboard 2.0

📖 Overview

Data Jobs Dashboard 2.0 is an enhanced version of the first dashboard, focused on deeper analysis of the Data Job Market.

The dashboard enables users to:

  • Compare salaries
  • Analyze skill demand
  • Explore country-wise opportunities
  • Discover high-paying data careers
  • Filter data dynamically using interactive slicers

✨ Skills Demonstrated

  • Power BI
  • Power Query
  • Data Modeling
  • Star Schema
  • DAX
  • Calculated Measures
  • Calculated Columns
  • KPI Cards
  • Interactive Buttons
  • Navigation
  • Tables
  • Dynamic Filtering
  • Dashboard Design

📂 Project Folder

➡️ Data_Jobs_V2

🌐 Interactive Dashboard

Open Data Jobs Dashboard 2.0


📱 Project 3 — Mobile Sales Dashboard

Mobile Sales Dashboard

📖 Overview

An interactive Power BI dashboard designed to analyze mobile phone sales performance across brands, models, cities, payment methods, customer ratings, months, and days of the week.

🎯 Project Objective

The dashboard helps users understand:

  • Total Sales
  • Total Quantity Sold
  • Number of Transactions
  • Average Sales
  • Sales by City
  • Monthly Quantity Trends
  • Customer Ratings
  • Payment Methods
  • Brand Performance
  • Mobile Model Performance
  • Sales by Day of the Week

📌 Key KPIs

KPI Value
Total Sales 187M
Total Quantity 5K
Transactions 947
Average Sales 40K

🔎 Interactive Filters

  • Mobile Model
  • Payment Method
  • Brand
  • Day Name
  • Month

📈 Dashboard Visualizations

  • Sales by City
  • Total Quantity by Month
  • Customer Rating
  • Transactions by Payment Method
  • Brand-wise Sales
  • Mobile Model-wise Sales
  • Sales by Day Name

✨ Skills Demonstrated

  • Power BI
  • Power Query
  • Data Cleaning
  • Data Transformation
  • Data Modeling
  • DAX
  • KPI Development
  • Interactive Slicers
  • Data Visualization
  • Dashboard Design
  • Business Storytelling

📂 Project Folder

➡️ Mobile_Sales_Dashboard

🌐 Interactive Dashboard

Interactive Power BI link can be added here after publishing the dashboard to Power BI Service.


🛠 Technical Skills Used

  • Microsoft Power BI
  • Power Query
  • DAX
  • Data Modeling
  • ETL
  • Data Cleaning
  • Data Transformation
  • Star Schema
  • KPI Development
  • Interactive Reporting
  • Dashboard Design
  • Data Visualization
  • Business Intelligence
  • Data Storytelling

📊 Key Insights

The dashboards in this portfolio demonstrate how Power BI can be used to:

  • Analyze job-market and sales datasets
  • Compare performance across categories and locations
  • Track trends over time
  • Build interactive KPI-driven reports
  • Apply data modeling and DAX to generate business insights
  • Present complex datasets through intuitive visual storytelling

📁 Repository Structure

Data_Job_Dashboard
│
├── Data_Jobs_V1
│   ├── Data_job_dashboard.pbix
│   └── README.md
│
├── Data_Jobs_V2
│   ├── Data_Jobs_Dashboard_2.0.pbix
│   └── README.md
│
├── Mobile_Sales_Dashboard
│   ├── Mobile_sales_dashboard.pbix
│   ├── README.md
│   └── images
│       └── dashboard.png
│
├── images
│   ├── project1page1.png
│   └── project1page2.png
│
└── README.md

About

A collection of interactive Power BI dashboards built using real-world datasets, showcasing data cleaning, ETL, DAX, data modeling, KPI development, and business intelligence insights.

Topics

Resources

Stars

1 star

Watchers

0 watching

Forks

Releases

Packages

Contributors