Overview
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.
Course Content
- Datasets
- Business Requirement (4:06)
- Dataset walkthrough (3:41)
- Data connection and cleaning (4:26)
- 1. # of Male and Female Staff (10:04)
- 2. % of Males and Females Staff (7:15)
- 3. Staff promoted in 2020 vs 2021 (2:38)
- 4. % of Staff promoted in 2020 vs 2021 (3:37)
- 5. % of Male and Female promoted in 2020 vs 2021 (11:37)
- 6. Staff promoted from Managers to Senior Manager in 2021 (3:58)
- 7. % of directors promoted in 2021 (4:53)
- 8. Directors who resigned in 2020 (4:10)
- 9. # of males and females who resigned in 2020 (2:52)
- 10. Turnover rate in 2020? (1:33)
- 11. Impact of new Salary Review (8:55)
- 12. Impact of new Salary Review (2:57)
- Business Requirement (1:54)
- Dashboard Design strategy (4:58)
- Case Study approach (3:22)
- Dashboard Preview (1:23)
- Average Salary Measure (1:37)
- Customize Report theme (3:30)
- Report Header (3:23)
- Key performance Indicators (4:47)
- Average Performance rating by Gender (7:41)
- 2020 Promotions by Gender (2:53)
- Turonver rate by Gender (5:16)
- Promotions in 2020 vs 2021 (4:59)
- 2021 Promotions by Gender (6:17)
- Performance rating insights (2:36)
- 2020 Promotions insights (3:37)
- Turnover by Gender insights (3:09)
- 2020 vs 2021 Promotions insights (3:53)
- 2021 Promotions insights (5:32)
- Adding Icons to Dashboard (2:56)