In this chapter, you’ll start by bringing all your data into Power BI and connecting your data model. Once your data is ready, you’ll start by rolling your sleeves up and doing some initial exploratory data analysis on general HR trends.

HR Analytics  in Power BI

Report Development Process 

Report development

Loading CSVs

Date dimension and relating tables

Exploring the data

Hiring trends over time

Analyzing departments and job roles

Data Modeling and EDA

This chapter is about using your Power BI skills to extract insights using DAX and learn how to build custom visuals that you can use throughout your report. Atlas Labs would like some answers on its employee demographics and performance. Luckily, they have you on their team as a Data Analyst to help them explore their data further. 

Taking a step back

Demographics: age and gender

Demographics: marital status and ethnicity

Performance Tracker: Part 1

Performance Tracker: Part 2

Insights on Estelle

Analyzing Demographics and Performance

It’s almost time to deliver your report to the key stakeholders at Atlas Labs. In this final chapter, you’ll be focusing on delivering insights on attrition and what factors affect employee retention. Finally, you’ll be cleaning up the overall layout of the report to create a user-friendly, clean, and branded experience.

Creating a cohesive report

Understanding attrition

Other factors that impact attrition

Insights on attrition

Layout design improvement

Theme formatting

Page navigation

Wrap-up

Bringing it all together 

Metadata sheet

DataCamp vs. Local Experience

Exercises and Datasets

In this Power BI case study, you will be exploring a dataset for a fictitious software company called Atlas Labs. This course focuses on helping you import, analyze and visualize Human Resources data in Power BI. Building on your existing knowledge of the platform, you'll learn how to effectively work with Power BI using example data.

You’ll carry out exploratory data analysis and will use DAX to help build powerful visualizations. You’ll finish your analysis by diving deeper into attrition and what factors impact attrition. This analysis will help the organization determine what action they will need to take to retain more employees.

We’ll finalize the case study by making design changes to our report that provides a clean, branded design.

<h2>Apply Your Skills with a Power BI Case Study</h2>
In this Power BI case study, you will be exploring a dataset for a fictitious software company called Atlas Labs. This course focuses on helping you import, analyze and visualize Human Resources data in Power BI. Building on your existing knowledge of the platform, you'll learn how to effectively work with Power BI using example data.
<br><br>
<h2>Carry Out Exploratory Data Analysis</h2>
You’ll carry out exploratory data analysis and will use DAX to help build powerful visualizations. You’ll finish your analysis by diving deeper into attrition and what factors impact attrition. This analysis will help the organization determine what action they will need to take to retain more employees.
<br><br>
<h2>Build Branded Power BI Reports</h2>
We’ll finalize the case study by making design changes to our report that provide a clean, branded design.


Data Modeling in Power BI

Introduction to DAX in Power BI

Apply your skills to import, analyze and visualize Human Resources (HR) data using Power BI.

Case Study: HR Analytics in Power BI

Data Analyst in Power BI

Report development

Case Study: HR Analytics in Power BI

Hands-on interactive exercise