Course Structure

The course is split into 5 modules each module is further divided into three sessions.

Each Session is 2 Hours a
total of 30 Hours

5 Weekend of Core Practicals


Register Now

Master Class

"hR Data Analytics"

MICROSOFT Power-BI

PL 300 DATA ANALYTICS



MODULE ONE

About us

WHY POWER-BI

Power BI gives you real time visibility into your data allowing you to generate greater insights into your Human Resources Key Performance indicators. You build dashboards that are easy to adopt and use.

What you will learn;
  • Learn how to aggregate and combine Human resources data in power BI
  • Learn how to Connect transnational data in Power BI
  • Learn how to build relationships between related data sources in power BI
  • Learn how create comprehensive reports and interactive dashboards with Power BI
  • Lean to easily create a wide range of visualization by just dragging and dropping

In this course, dummy datasets have been provided to enable you learn and practice.

MODULE ONE

Session 1: Introduction to HR Analytics

1.Concept, Evolution of HR Analytics & Role of Analytics in HR
2. Case studies of HR Analytics – Machine Learning and AI in HR
3. Types of HR Analytics and Maturity Level of HR Analytics 

Session 2: Introduction to Power BI

1. What is Power BI?
2. The Power BI Architecture:
a. Desktop
b. Service
c. Report Server
3. Features of Power BI
4. How Power BI matches your role
5. The flow of work in Power BI

Session 3: Getting Started with Power BI Desktop 

1. What is Power BI Desktop
2. Set up Power BI Desktop
a. Download Power BI Desktop
b. Install as an app from the Microsoft Store
c. Configure Power BI
3. Navigating Power BI
4. Data sources in Power BI Desktop
a. Connecting to a Data Source

MODULE TWO

Session 1: Shaping and Combining Data

1. The Query Editor
2. The Advanced Editor
3. Shaping Data
4. Formatting Data
5. Transforming Data
6. Combining Data
7. Merging Data
8. Saving your work

Session 2: Building the Data Model

1. What are the Relationships?
2. Viewing Relationships
3. Building Relationships
a. Create a relationship by using AutoDetect
b. Creating a new relationship manually
c. Editing relationships
4. Create and manage relationships in Power BI Desktop
5. AutoDetect during load
6. Cross filter direction
7. Make this relationship active
8. Understanding relationships
9. Data View in Power BI Desktop 

Session 3: Data Visualization

1. Introduction to Visualization
2. Clustered Column Graphs
3. Stacked Graphs
4. Histograms
5. Trend Analysis Graphs
6. Area Graphs
7. Ribbon Graphs
8. Scatterplots and Bubble plots
9. Multiple visualizations

MODULE 3:HR analytics using Excel

Session 1: Human Resources KPIs

1. Human Resources KPIs
2. Characteristics of good HR KPIs
3. Essential MS Excel formulas for Calculating HR metrics
4. Creating an HR KPI scorecard: A real-life business case

Session 2: Data Transformation and summarization

1. Shaping Data
2. Formatting Data
3. Transforming Data
4. Pivot tables

Session 3: Visualization using ExceL

1.Bar & Column charts
2. Histograms & Pareto charts
3. Line charts & trend lines
4. Area charts
5. Pies & Donuts
6. Scatter plots & Bubble charts
7. Box & Whisker charts

MODULE 4: Creating reports and Dashboard

Session 1: Creating an Interactive Business Intelligence Report

1. Build reports
2. Navigating between reports
3. Hide report pages
4. Measures in Power BI Desktop
5. Understanding measures

Session 2: Getting Started with Power BI Service

1. Sign up for Power BI service
2. What is Power BI service?
3. Share your work

Session 3: Creating Dashboards with Power BI Service 

1. Intro to dashboards for Power BI designers
2. Dashboard basics
3. Advantages of dashboards
4. Create a Power BI dashboard from a report
5. Who can create a dashboard?
6. Open the report and pin some tiles to a dashboard
7. Share a dashboard or report

MODULE FIVE - Real life application

Session 1: HR analytics Mini-Project 1: 3hours
 


SESSION 2: HR ANALYTICS MINI-PROJECT 2: 3HOURS


facilitators

ABOUT GAFM 

ACCREDITING TRAINING PROVIDER FOR QUALITY RESULTS

The GAFM/ AAFM/ AAPM ® is the regulatory body for the much sought after GAFM/ AAFM/ AAPM™. Designations and Credentials. The GAFM/ AAFM/ AAPM ™ Executive Designation Programs provide the assurance that the holder has met the suggested Criteria for graduate credentials set out in the Ibanez US Supreme Court Decision and Dicta.  Further, the GAFM/ AAFM/ AAPM board certification requires meeting 6 different levels of global criteria including ethics and our global body of standards which are the 1st Standards specifically based on the Methodology used by global government agencies and departments.

Acceptance into the GAFM/ AAFM/ AAPM is a high distinction and requires the holder to possess a graduate level portfolio of skills and knowledge. Acceptance statistics are not high, and the designation when achieved is a high honor strictly for accredited degree and graduate education holders or individuals with superior and equivalent backgrounds who have received government sanctioned, offered, and/or germane training.

TRAINING IS PROVIDED BY ABMC INTERNATIONAL LTD

OUR TRAINING PROGRAMS ARE ACCREDITED AND SUPPORTED BY LEADING HR INSTITUTIONS LISTED BELOW

PRICING | REGISTRATION

Please fill in the form below to register .

CRM form will load here

Contact Us

ABMC International Ltd group is an accredited training service provider offering training and conference learning solutions for the last 8 years and its head office based in Nairobi, Kenya and with offices in Kampala, Uganda and Dar salaam, Tanzania.

We are accredited as a training and conference learning service provider in Kenya and in Africa by various international accrediting partners:

1. National Industrial Training Authority – NITA/TRN/870 2020 – 2021

2. Institute of Human Resources Management of Kenya – IHRM

3. HR Certification Institute in USA

4. Global Academy of Finance and Management in USA

The current pandemic has led to reinforcement of new approach to learning and development, which we fortunately developed over the past years with our international accrediting bodies and we offered full scholarship to the public for over 10 e-learning courses during this pandemic (to any individual at no cost during the month of April 2020) as caution to organization during these period of pandemic and trained over 2000 courses up to date.



Address NGARA ROAD, OFF MURANGA ROAD, KENYA POLICE SACCO PLAZA, 5TH FLOOR.
Opening time Mon-Fri: 08.00 -18.00

CONTACTS

OUR CONTACTS

We use cookies
Cookie preferences
Below you may find information about the purposes for which we and our partners use cookies and process data. You can exercise your preferences for processing, and/or see details on our partners' websites.
Analytical cookies Disable all
Functional cookies
Other cookies
We use cookies to personalize content and ads, to provide social media features and to analyze our traffic. Learn more about our cookie policy.
I understand Details
Cookies