Building job market
analysis dashboard
C A S E S T U DY : A N A LY Z I N G J O B M A R K E T D ATA I N P O W E R B I
Luke Barousse
Data Analyst & YouTuber
Data analytics pipeline
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Dashboard focus areas
Questions to ask:
1. Who is the audience?
2. What do they need?
3. How can a dashboard help?
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Dashboard focus areas
Answers to questions:
1. Who?
DataSearch recruiters
2. What?
Identify optimal opportunities
3. How?
Dashboard design with goal in-mind
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Dashboard components to include
What signi cant visualizations to include?
Is the most intuitive visual being used?
Are we sizing, positioning, & coloring visuals relative to their importance?
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Designing a dashboard
Less is more
Give numbers context
Label everything
Make interactive
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Our final deliverable
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Our final deliverable
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Let's practice!
C A S E S T U DY : A N A LY Z I N G J O B M A R K E T D ATA I N P O W E R B I
Case study wrap-up
C A S E S T U DY : A N A LY Z I N G J O B M A R K E T D ATA I N P O W E R B I
Luke Barousse
Data Analyst & YouTuber
Data analytics pipeline with Power BI
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Our final deliverable
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Sharing dashboards with Power BI Service
Power BI Service is the SaaS part of the Power BI o ering
This service allows you to share dashboards within an organization
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Power BI is a powerful tool
Power Query DAX
Data cleaning Calculated columns
Combining or spli ing columns
Calculated tables
...
Measures
CASE STUDY: ANALYZING JOB MARKET DATA IN POWER BI
Congratulations!
C A S E S T U DY : A N A LY Z I N G J O B M A R K E T D ATA I N P O W E R B I