Module 1: Introduction to Power BI

• Workflow in Power BI Desktop
• Creating an application wokspace
• The power BI Mobile experience
• Understanding the DAX functions
• Working with data, ie, connecting to data sources
• Cleaning up and transforming data

Module 2: Data Queries in Power BI

• Direct Queries and Analysis
• Loading data to a power query
• Design and filtering in power queries
• Working with metadata
• Working with unpivot
• Introduction to custom functions
• Merging queries and data cleansing

Module 3: Data Modeling in Power BI

• Creating, understanding and managing relationships in models
• Checking for problems in relationships in models
• Working with the relationship editor
• Know how to fix data quality
• Using Bridge Tables
• Working with Hierarchies

Module 4: Decision making and Risk Management using Power BI

• Identifying, evaluating, and managing Business risks
• Working with the Risk assurance platform in Power BI
• Working with Decision Trees
• Forecasting using power BI
• Understanding payroll management and ROI in Power BI

Module 5: Creating HR Dashboards and Reports in Power BI

• Introduction to data index and page layouts
• Work with predictive attrition and animated macro charts
• Understand the Vlookup and Hlookup analysis
• Learn BVG and leave analysis, FNF and Exit Analysis
• Learn how to group data and understand the Bradford Factor
• Develop operational dashboards including Business KPI’s
• Work with Turnover Dashboards and training efficiency dashboard,
• Work with the recruitment dashboard and Staff management dash board
• Use pivot tables and pivot charts to efficiently perform automated report writing and analysis