Course Details

HR Analytics and Reporting Using Excel and Power BI

INTRODUCTION

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.

DURATION

5days

COURSE 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.
•  
• Power BI Online.

TARGET AUDIENCE

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

COURSE CONTENT

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.
•  
•  

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.

CERTIFICATION

• Upon successful completion of this training, participants will be issued with Macskills Training and Development Institute Certificate

TRAINING VENUE

• Training will be held at Macskills Training Centre. We also tailor make the training upon request at different locations across the world.

AIRPORT PICK UP AND ACCOMMONDATION

• Airport pick up and accommodation is arranged upon request

TERMS OF PAYMENT

• Payment should be made to Macskills Development Institute bank account before the start of the training and receipts sent to info@macskillsdevelopment.com