Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Power BI Dashboard Portfolio

A collection of Power BI dashboards showcasing data visualization and business intelligence skills. This repository demonstrates the transformation of raw data into clear, actionable insights through interactive dashboards.


Data Jobs Dashboard - Comprehensive Market Exploration

This dashboard provides a comprehensive two-page exploration of the data job market, designed for job seekers. It features a high-level summary page and a detailed drill-through page for specific job titles, offering insights into market trends and compensation.

Dashboard Preview

Dashboard Overview

Page 1 - Market Summary

Page 2 - Detailed Analysis


Dashboard Features

Page 1: Market Overview

  • High-level summary of the data job market
  • Key metrics and trends across job categories
  • Geographic distribution of opportunities
  • Salary insights by role and location

Page 2: Job Title Deep Dive

  • Drill-through functionality for detailed analysis
  • Specific role requirements and skills
  • Compensation breakdowns
  • Company and industry insights

Key Power BI Skills Demonstrated

  • Dashboard Layout & Design
  • Power Query (ETL & Data Shaping)
  • Basic Data Modeling (Table Relationships)
  • Implicit Measures & Standard Aggregations
  • Core Visualizations (Bar, Line, Area, Column Charts)
  • Map Visualizations for Geospatial Data
  • KPI Cards & Detailed Data Tables
  • Interactive Slicers for Filtering
  • Buttons & Bookmarks for Navigation
  • Drill-Through Functionality

Technical Implementation

Data Source

  • Format: CSV (raw data)
  • Location: ./data/
  • Description: Aggregated data job listings with salary, location, and requirements

Power Query Transformations

  • Data cleaning and standardization
  • Column transformations and type conversions
  • Filtering and removing duplicates
  • Creating calculated columns

Data Model

  • Fact table: Job listings
  • Dimension tables: Locations, Job titles, Companies
  • Relationships: Star schema design

Key Visualizations

  1. KPI Cards: Total jobs, average salary, top locations
  2. Bar Charts: Jobs by title, salary comparisons
  3. Line Charts: Trend analysis over time
  4. Map Visualization: Geographic distribution
  5. Tables: Detailed job listings with drill-through

Interactivity

  • Slicers for filtering by location, job title, and salary range
  • Bookmarks for navigation between pages
  • Drill-through from summary to detail page
  • Cross-filtering across visualizations

Repository Structure

powerbi-portfolio/
├── README.md
├── dashboard/
│   └── Data_Jobs_Dashboard.pbix
└── images/
    ├── Dashboard_Overview
    ├── Dashboard_Page1
    ├── Dashboard_Page2

Note: Raw data files are not included due to file size constraints. For access to the dataset, please reach out via email.

Getting Started

View the Dashboard

  1. Download: Clone this repository to access the .pbix file and raw data
  2. Requirements: Power BI Desktop (free) to open and modify the dashboard file

How to Use

  1. Download Data_Jobs_Dashboard.pbix from the dashboard folder
  2. Open with Power BI Desktop
  3. Explore the two-page dashboard
  4. Use slicers and filters to customize your view
  5. Click on job titles to drill through to detailed analysis

About This Project

This portfolio demonstrates proficiency in:

  • Data transformation and cleaning
  • Data modeling and relationships
  • DAX calculations and measures
  • Interactive dashboard design
  • Visual storytelling with data

Contact

For questions, collaboration opportunities, or to request access to the raw dataset, feel free to reach out.

Email: muhammadibrahimshoeb@gmail.com

About

Power BI Dashboard Portfolio - Data Jobs Analysis

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors