The HR Analytics and Reporting using Excel and Power BI Training program is designed to empower HR and business professionals with the tools and techniques needed to analyze, visualize, and report HR data effectively.

You will gain hands-on experience with Excel, Power BI Desktop, and Power BI Online. Learning how to import, model, and present HR data in a way that drives better decisions across your 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

Course Outline

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

Course Booking

Please use the “book now” or “inquire” buttons on this page to either book your space or make further enquiries.