Power BI for HR: Visualize HR data using Power BI

Focused View

Start-Tech Academy,Start-Tech Trainings

6:52:44

20 View

1. Getting Started with Power BI for HR

1. Introduction to Power BI for HR.mp4

03:20

2. Setting up Power BI Desktop.mp4

03:51

3. This is milestone!.mp4

03:31

4.1 Power BI for HR course resources.zip

4. Course resources.html

5. About the HR data used in this course.mp4

08:45

2. Connecting to different HR Data Sources

1. Getting Hiring Data from a CSV file into Power BI.mp4

07:14

2. Getting Hiring Data from an SQL database into Power BI.mp4

05:48

3. Getting Store data from multiple CSV files in a folder.mp4

04:10

4. Getting Employee data from a JSON file.mp4

03:16

3. Power Query for HR Data Manipulation

1. Introduction to Power Query Editor.mp4

05:53

2. Important checks before we transform data.mp4

11:11

3. Merging and Appending Queries - Theory.mp4

04:04

4. Appending queries in Power Query.mp4

07:52

5. Merging queries in Power Query.mp4

09:16

6. Manage table rows and columns.mp4

13:23

7. Split Column tool.mp4

06:20

8. Replace Values tool.mp4

03:20

9. Group By tool.mp4

05:02

10. Pivoting and unpivoting - Theory.mp4

02:16

11. Pivoting and unpivoting in Power Query.mp4

02:53

12. Extract tool.mp4

04:42

13. Format Text options.mp4

06:42

14. Number transformations.mp4

04:46

15. Date and Time transformations.mp4

06:26

4. Adding new columns using Power Query

1. Add column from examples.mp4

06:33

2. Add a custom column.mp4

05:02

3. Add conditional and Index column.mp4

06:02

5. HR Data Modeling and Relationships

1. Introduction to Model View.mp4

02:46

2. Creating and modifying relationships.mp4

06:27

3. Cardinality and cross filter direction.mp4

12:58

4. Fact and Dimension tables.mp4

02:05

5. Star and Snowflake schemas.mp4

02:59

6. Data Pane and the Properties Pane.mp4

06:57

6. Visualizing HR Data in Power BI

1. Bar chart and Column chart.mp4

05:41

2. Clustered Bar chart and Stacked Bar chart.mp4

10:14

3. Chart formatting options.mp4

13:30

4. General formatting options.mp4

09:56

5. Small multiples, Tooltips and Drill Through.mp4

11:35

6. Line chart and Area chart.mp4

07:50

7. Combination chart or a combo chart.mp4

05:45

8. Pie chart and Donut chart.mp4

05:23

9. Scatter chart and Bubble chart.mp4

07:01

10. Applying filters.mp4

13:36

11. Add Further Analysis tab.mp4

08:35

12. Table and Matrix Visuals.mp4

04:18

13. Card and Multi-row cards.mp4

04:24

14. Hierarchies in Power BI.mp4

06:39

15. Tree map.mp4

05:56

16. Map charts for showing geographical data.mp4

06:14

17. Conditional formatting of charts.mp4

04:17

7. DAX for Advanced HR Analytics

1. Introduction to DAX.mp4

06:19

2. DAX syntax and Row context vs Filter context.mp4

04:57

3. Types of operators and functions.mp4

09:15

4. Demonstration of new columns and new measures.mp4

12:12

5. Using explicit measures to create new measures.mp4

04:09

6. IF function with Logical operators.mp4

03:25

7. COUNT and DISTINCTCOUNT functions.mp4

03:23

8. RELATED function.mp4

02:20

9. CALCULATE function.mp4

05:02

10. Additional Chats using Calculate function.mp4

09:18

8. Crafting Interactive HR Reports in Power BI

1. Introduction to reports.mp4

05:20

2. Formatting report page and creating a template.mp4

11:09

3. Slicers on report page.mp4

04:56

4. Adding a page navigator.mp4

06:05

5. Adding Bookmarks to the report.mp4

06:37

6. The final milestone!.mp4

01:33

9. Congratulations and about your certificate

1. Bonus lecture.html

Description

Learn to Transform HR Data into Insightful Visuals in Power BI | Data-Driven Human Resource Management using Power BI

What You'll Learn?

Discover how to set up Power BI Desktop for optimal HR data analysis.
Explore various methods to connect Power BI with different data sources, including CSV and SQL databases.
Manipulate HR data effectively using Power Query Editor, including merging, appending, and managing queries.
Master advanced data transformation techniques such as splitting columns, replacing values, and using the Group By tool.
Implement pivoting and unpivoting in Power Query for dynamic data analysis.
Create robust data models using relationships, understanding cardinality, and utilizing star and snowflake schemas.
Design insightful HR charts and visuals, including bar, line, pie, and scatter charts, with advanced formatting options.
Develop proficiency in Data Analysis Expressions (DAX) for creating powerful measures and calculated columns in Power BI.
Construct interactive and visually appealing HR reports, incorporating elements like slicers, bookmarks, and navigators.
Apply conditional formatting and advanced analytical techniques to enhance the interpretability and impact of HR reports in Power BI.

Who is this for?

HR Managers who want to leverage data analytics for strategic decision-making and workforce planning.

HR Analysts seeking to enhance their data visualization skills to communicate insights more effectively.

HR Coordinators aiming to transition into a more data-focused role within human resources.

Recruitment Specialists who want to use data analytics to improve hiring processes and candidate evaluations.

Payroll Officers looking to integrate data analytics for more efficient payroll management and reporting.

Training and Development Professionals aiming to use data to assess training needs and measure program effectiveness.

HR Consultants who wish to provide data-driven advice and solutions to their clients.

Small Business Owners who manage their own HR functions and want to use data to optimize employee management and organizational growth.

What You Need to Know?

A PC with a working internet connection and basic understanding of HR fundamentals

More details

Description
Are you an HR professional seeking to harness the power of data analytics? Do you struggle to make sense of the vast amount of HR data at your disposal? If the answer is yes, then "Power BI for HR: Visualize HR Data using Power BI" is tailor-made for you. This course is designed to transform the way you view and utilize HR data, equipping you with the skills to create impactful visualizations and make data-driven decisions in human resource management.
In this comprehensive course, you will dive deep into the world of Power BI and its application in the HR sector. You'll gain a unique blend of technical and strategic skills, learning to:
Develop advanced data visualization techniques specifically tailored for HR metrics.
Master the art of transforming complex HR data into clear, actionable insights.
Design and implement custom HR dashboards for real-time data monitoring.
Analyze trends and patterns in employee data to inform strategic decisions.
Understanding HR data is crucial in today's data-driven world. It empowers you to make informed decisions, predict employee trends, and ultimately, drive your organization's success. Throughout the course, you'll engage in hands-on projects, creating actual HR reports and dashboards that you can use in your professional role.
What sets this course apart is its focus on practical application. You're not just learning theories; you're applying what you learn directly to your work in HR. Instructors of the course have been teaching Data Analytics and Management concepts for over a decade. We are also the creators of some of the most popular online courses - with over 3,000,000 enrollments and thousands of 5-star reviews
Don't miss this opportunity to elevate your HR skills with the power of data analytics. Enroll now and start your journey towards becoming a data-savvy HR professional!
Who this course is for:
HR Managers who want to leverage data analytics for strategic decision-making and workforce planning.
HR Analysts seeking to enhance their data visualization skills to communicate insights more effectively.
HR Coordinators aiming to transition into a more data-focused role within human resources.
Recruitment Specialists who want to use data analytics to improve hiring processes and candidate evaluations.
Payroll Officers looking to integrate data analytics for more efficient payroll management and reporting.
Training and Development Professionals aiming to use data to assess training needs and measure program effectiveness.
HR Consultants who wish to provide data-driven advice and solutions to their clients.
Small Business Owners who manage their own HR functions and want to use data to optimize employee management and organizational growth.

User Reviews

Rating

average 0

Total votes0

Focused display

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. Founded by Abhishek Bansal and Pukhraj Parikh. Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Start-Tech Trainings

Instructor's Courses

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.