HR Analytics and Reporting using Excel and Power BI Training

HR Analytics and Reporting using Excel and Power BI Training

About the Program

Every Manager, Business Analyst, and key Decision Makers require Microsoft Power BI to gather and process data, analyze, and provide data driven insights to help in making informed decisions real time. This program will take the participants through the key features of Power BI, including data modelling, creating visualizations, and publishing reports. They will learn how to connect to various data sources, create stunning visualizations, and share insights with others in their organization.

Program Objectives

• Upon completing this program, participants will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned:
• Introduction Advanced to Excel
• Introduction to Power BI.
• Power BI Desktop & Excel
• Working with CSV, TXT, and Excel Worksheets.
• Connecting to Databases.
• Merging, Grouping, Summarizing, and Calculating Data.
• Reporting.
• Power BI Online.

Target Audience

• HR-Practitioners
• Business Intelligence Analysts.
• Data Scientists.
• Payroll Accountant
• Business Managers and Executives.
• IT Professionals.
• Database Administrators.

Training Period

• Classroom: 5 Days
• Online: 7 Days

Module 1: Introduction to Microsoft Power BI

• Visual analysis and visual analytics.
• Power BI Infrastructure.
• Loading Data.
• Introduction to Power BI Desktop.

Module 2: Using Power Query to clean, transform and load data

• Profiling your data.
• Resolve data quality issues.
• Apply user-friendly names to Queries, tables, and columns.
• Import data from an Excel formatted report.

Module 3: Model development in Power BI

• Understand the role of the Data Model in Power BI.
• Create table relationships.
• Understand Cardinality and Cross Filtering.
• Discuss Star and Snowflake schema.
• Create a Date Dimension.
• Build a Data Model from multiple Data sources.

Module 4:Working With CSV, TXT and Excel Worksheets

• Importing, Transforming, and Loading Data.
• Appending Operations.
• Working with Folders and Files.
• Using Pivot Tables.

Module 5: Connecting to Databases

• Working with Relational Data.
• Understanding Relationships.
• Importing from SQL Server Analysis Services Multidimensional and Tabular.

Module 6: Merging, Grouping, Summarizing, And Calculating Data

• Understanding the Issues with Merges.
• Performing Merges.
• Grouping Options.
• Summarizing.
• Calculating.

Module 7: Reporting

• Creating HR Reports.
• Utilizing the Matrix Visualization HR Data.
• Using the Map Visualization of HR Data
• Plying the Card Visualization.
• Utilizing the Chart Visualization.
• Using Slicers Compare with Excel
• Publishing to Power BI Online.

Module 8: Power BI Online

• Introduction to Power BI Online.
• Importing Data.
• Creating Reports.
• Configuring Dashboards.
• Sharing Reports and Dashboards.
• Exploring Power BI Mobile.

Delivery Method

This program is taught through a mix of practical activities, theory, group work and case studies. Training manuals and additional reference materials are provided to the participants.

CERTIFICATION

Upon successful completion of the training, participants will be awarded a certificate of course completion