Power BI for HR: Visualize HR data using Power BI

سرفصل های دوره

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

1. Getting Started with Power BI for HR

1. Introduction to Power BI for HR

2. Setting up Power BI Desktop

3. This is milestone!

4.1 Power BI for HR course resources.zip

4. Course resources.html

5. About the HR data used in this course

2. Connecting to different HR Data Sources

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

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

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

4. Getting Employee data from a JSON file

3. Power Query for HR Data Manipulation

1. Introduction to Power Query Editor

2. Important checks before we transform data

3. Merging and Appending Queries - Theory

4. Appending queries in Power Query

5. Merging queries in Power Query

6. Manage table rows and columns

7. Split Column tool

8. Replace Values tool

9. Group By tool

10. Pivoting and unpivoting - Theory

11. Pivoting and unpivoting in Power Query

12. Extract tool

13. Format Text options

14. Number transformations

15. Date and Time transformations

4. Adding new columns using Power Query

1. Add column from examples

2. Add a custom column

3. Add conditional and Index column

5. HR Data Modeling and Relationships

1. Introduction to Model View

2. Creating and modifying relationships

3. Cardinality and cross filter direction

4. Fact and Dimension tables

5. Star and Snowflake schemas

6. Data Pane and the Properties Pane

6. Visualizing HR Data in Power BI

1. Bar chart and Column chart

2. Clustered Bar chart and Stacked Bar chart

3. Chart formatting options

4. General formatting options

5. Small multiples, Tooltips and Drill Through

6. Line chart and Area chart

7. Combination chart or a combo chart

8. Pie chart and Donut chart

9. Scatter chart and Bubble chart

10. Applying filters

11. Add Further Analysis tab

12. Table and Matrix Visuals

13. Card and Multi-row cards

14. Hierarchies in Power BI

15. Tree map

16. Map charts for showing geographical data

17. Conditional formatting of charts

7. DAX for Advanced HR Analytics

1. Introduction to DAX

2. DAX syntax and Row context vs Filter context

3. Types of operators and functions

4. Demonstration of new columns and new measures

5. Using explicit measures to create new measures

6. IF function with Logical operators

7. COUNT and DISTINCTCOUNT functions

8. RELATED function

9. CALCULATE function

10. Additional Chats using Calculate function

8. Crafting Interactive HR Reports in Power BI

1. Introduction to reports

2. Formatting report page and creating a template

3. Slicers on report page

4. Adding a page navigator

5. Adding Bookmarks to the report

6. The final milestone!

9. Congratulations and about your certificate

1. Bonus lecture.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy