ADVANCED MICROSOFT POWER BI & FINANCIAL REPORTING/ANALYTICAL TOOLS

Live-Online Training: N250,000
Classroom Training: N350,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount

(Available also for Customised Training by Duration, Venue & Fee)

(PARTICIPANTS SHOULD BRING THEIR LAPTOPS)

Program Description:

The  Advanced Level Microsoft Power BI Training Program for Data Analysts is designed to build upon existing  Power BI knowledge and equip participants with more advanced skills and techniques to effectively analyze data, create compelling visualizations, and generate actionable insights. This 5-day intensive program combines hands-on exercises, real-world case studies, and expert guidance to empower data analysts to harness the full potential of Power BI for data-driven decision-making.

Prerequisites:

Participants should have an intermediate understanding of Microsoft Power BI and basic data analysis concepts. Familiarity with Excel and SQL can be beneficial but is not required.

 Course Objectives:

Upon completion of this training program, participants will be able to:

• ​Develop complex data models and relationships in Power BI.
• Create advanced calculations using DAX (Data Analysis Expressions).
• ​Design interactive and insightful reports and dashboards.
• ​Leverage advanced visualization techniques for effective data storytelling.
• ​Automate data loading and transformation with Power Query.
• ​Collaborate and share Power BI reports securely with colleagues.
• ​Optimize performance and maintain Power BI solutions.

 Course Content

DAY ONE

Basic Facts on Data Analytics & Power BI

·          Data analysis overview

·          Roles in data

·          Functions of Data Analysts

·          Using Power BI

·          Building Blocks of Power BI

·          Power BI service

·          Installing Power BI desktop

·          Power BI service subscription types

·          Other data analysis tools

·          Power BI ecosystem.

 DAY TWO

Getting and Preparing Data for Analysis

·          Getting data from various sources

·          Getting data from No SQL database

·          Shape and simplify data structure

·          Merging and appending data tables

·          Data profiling

·          Evaluate and change column data types

·          The M code

·          The Power Query editor and interface

·          Basic data transformation and loading

·          Advanced data transformation and loading.

 DAY THREE

Data Modeling and DAX Language

·          Tables, dimensions and data granularity

·          Relationship and granularity

·          Introduction to the DAX language

·          Context and the calculation function

·          Time intelligence measures in DAX

·          Quick measures

·          Calculated column vs measures

·          Implicit and explicit measures.

  DAY FOUR

Visualizing Data

·          Choosing and adding visualization to reports

·          Design a report layout

·          Conditional formatting

·          Slicing and filtering reports

·          Dashboards and configurations

·          Exploring data with questions and answers

·          Working with Power BI service

·          Data schedule and refresh

·          Row level security

 DAY FIVE

Advanced Analytics and Power BI Service

·          Analytics and statistical summary

·          Identifying outliers with visuals

·          Clustering techniques, grouping and bins

·          Conducting time series analysis

·          Applying AI insights

·          Working with AI Visuals

·          Key influencers and decomposition AI visuals

·          Working with Power BI service

·          Data schedule and refresh

·          Row level security.