+233 54 123 9290
support@festman.io
Select a Language
.png)
What Will You Learn?
About This Course
Microsoft Power BI gives you a wide range of methods to analyze your data and generate insights to support business decisions.
In this guided project, you will play the role of a Data analyst for FestMan Consulting Group which is a global consulting firm that provides industry-leading audit, consulting, tax, and advisory services to many of the world's most admired brands.
In your role as a Data Analyst, you will work with a new HR business partner to help her get insights from HR data and make better decisions.
Through this project, you will have the opportunity to hone in your DAX skills and learn how to better analyze data to meet business requirements.
You will also learn how to design amazing Dashboards and tell story with Data.
Who should take this course
This course is perfect for all Power BI users who want to take their data analysis and visualization to the next level. It is recommended for both beginners and advanced Power BI users.
Requirements
Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence.
He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics.
At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.
Curriculum Overview
This course includes 3 modules, 47 lessons, and 0:08 hours of materials.
HR Analytics Case study
18 Parts | 0:06 Hours
Getting started
Exercise file
Study Duration
1 Minutes
Attachments
0
Download datasets and report template
Download the resources zip file and unzip it on your PC. The folder contains the dataset, the report template, the icon, and the completed Power BI file.
Volume
596.44 KB MB
Business requirement and background
Business requirement of this guided project
Study Duration
5 Minutes
Attachments
0
Introduction to Business requirement
Volume
12.54 MB
Dataset walkthrough
Free
Volume
31.39 MB
Data Connection and importing
Volume
48.66 MB
Q1 # of males and females in the firm
Q1 - Calculate the number of males and female employees in the firm using DAX.
Volume
51.67 MB
Q2 % of men and women in the firm
Calculate the percentage of staff who are males and females
Volume
31.48 MB
Q3 Staff promoted in 20 vs 21
Calculate the number of staff promoted in 2020 and 2021.
Volume
17.31 MB
Q4 % of staff promoted in 2020 vs 2021
Calculate the percentage of staff promoted in 2020 vs 2021
Volume
17.35 MB
Q5 % of men and women promoted in 20 vs 21
Calculate the percentage of men and women promoted in 2020 vs 2021.
Volume
51.40 MB
Q6 Managers promoted to Senior Mangers
Calculate the managers who were promoted to senior managers in 2021
Volume
19.32 MB
Q7 Directors promoted in 2021
Calculate the number of Directors promoted in 2021.
Volume
19.35 MB
Q8 Directors who resigned in 2020
Determine the Directors who resigned in 2020.
Volume
17.70 MB
Q9 Resignation by Gender
Calculate the number of males and females who resigned in 2020.
Volume
12.99 MB
Q10 Staff turnover rate
Calculate the staff turnover rate in 2020
Volume
8.84 MB
Q11 Impact of new Salary Review
Assess the impact of new proposed salary increase by management.
Volume
63.98 MB
Q12 Impact of new Salary Review
Volume
16.34 MB
Business Requirement 2
19 Parts
Business Requirement 2 Introduction
Introduction to the second business requirement
Volume
5.16 MB
Dashboard Design Process
Volume
10.41 MB
Case Study approach
Volume
9.74 MB
Dashboard Preview
View the sample dashboard we are going to develop together.
Volume
9.63 MB
Average Salary Measure
Volume
8.97 MB
Customize Report theme
The report theme file is part of the downloaded files.
Volume
20.52 MB
Designing the Report Header
Volume
16.80 MB
Key performance Indicators
Volume
26.72 MB
Average Performance rating by Gender
Volume
32.16 MB
2020 Promotions by Gender
Volume
19.20 MB
Turnover rate by Gender
Volume
23.65 MB
Promotions in 2020 vs 2021
Volume
20.39 MB
2021 Promotions by Gender
Volume
29.73 MB
Performance rating insights
Volume
14.33 MB
2020 Promotions insights
Volume
14.53 MB
Turnover by Gender insights
Volume
14.25 MB
2020 vs 2021 Promotions insights
Volume
18.11 MB
2021 Promotions insights
Volume
22.87 MB
Adding Icons to Dashboard
Volume
24.69 MB
Business requirement 3
10 Parts | 0:02 Hours
Business requirement
Volume
1.79 MB
Dashboard Layout
Volume
7.54 MB
Visual 1 : Number of staff by departments
Volume
24.65 MB
Visual 2: Number of staff by Job level
Volume
27.82 MB
Designing filters pane
Volume
54.00 MB
Adding Bookmarks
Volume
23.50 MB
Edit Visual Interactions
Volume
25.01 MB
Adding Report Page Tooltip
Volume
28.41 MB
Adding page Navigation
Volume
21.71 MB
Course review and certificate
Course review
Study Duration
2 Minutes
Attachments
0
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type
Course Certificate
0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
.png)
This Course Includes
Downloadable Content
Official Certificate
Instructor Support
Course Forum
Course Specifications
Sections
3
Lessons
47
Capacity
Unlimited
Duration
1:30 Hours
Students
59
Created Date
1 Apr 2023
Updated Date
31 May 2024
.png)
.png)
Send Course as Gift
Send as a gift to friends
You are viewing
Guided Project : HR Analytics with Power BI
Subscribe to Our Newsletter
Receive expert insights, course updates, and learning resources directly in your inbox and get notified
Contact Us
© 2025 FestMan Learning. All Rights Reserved. Empowering digital pioneers.
.png)
.png)
Reply to Comment