Technologies / Data & Analytics

MS PowerBI Desktop

The training is designed for data analysts, IT staff, managers and anyone who wants to gain a working knowledge of how to create reports and data analysis in PowerBI Desktop. Participants should have basic knowledge of working with spreadsheets and basic data operations.

Issues

Introduction to PowerBI
Downloading data
Data transformation
Data modeling
Report generation
Practical sessions

This training is part of the path:

Data Analyst Accountant / Finance Specialist

Who is this training for?

The training is designed for data analysts, IT staff, managers and anyone who wants to gain a working knowledge of how to create reports and data analysis in PowerBI Desktop

Participants should have basic knowledge of working with spreadsheets and basic data operations

Prerequisites

Basic knowledge of MS Excel and spreadsheets
Ability to use basic Excel functions
Basic knowledge of database concepts will be an added advantage

Training program

Introduction to Power BI — Power BI ecosystem (Desktop, Service, Mobile), Power BI Desktop role in data analysis, interface and workflow overview
Retrieving data from sources — web pages, MS Excel workbooks, text/CSV files, Access databases, connecting with SQL databases and other sources
Data transformation in Power Query — data aggregation, merging data from multiple tables, appending data to tables, connecting data from multiple files
Advanced Power Query operations — query management, creating custom functions, transformation step optimization
Data modeling — building model diagrams, managing relationships between tables, cardinality and filter direction
Introduction to DAX — DAX function syntax (Data Analysis eXpressions), action operators, calculated columns vs calculated measures

Most important DAX functions — SUM, SUMX, AVERAGE, COUNT, COUNTROWS, DISTINCTCOUNTNOBLANK, creating data calculations
Changing calculation context — CALCULATE, ALL, ALLSELECTED, ALLEXCEPT, understanding row context and filter context
Time intelligence in DAX — creating calendar tables, PARALLELPERIOD functions, DATEADD, TOTALYTD, TOTALQTD, TOTALMTD, quick measures
Visualizations and hierarchies — visualization types in Power BI, adding and modifying visualizations, interactions between elements, creating data hierarchies
Filters and slicers — filter types (report, page, visualization), slicer configuration, presenting hierarchical data
Publishing reports — report saving options, publishing to Power BI Service, sharing reports in the organization

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

What are the prerequisites for this training?

For MS PowerBI Desktop we recommend: Basic knowledge of MS Excel and spreadsheets; Ability to use basic Excel functions; Basic knowledge of database concepts will be an added advantage.

What is the format and duration of this training?

The training lasts 2 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.

Who is this training designed for?

This training is designed for: The training is designed for data analysts, IT staff, managers and anyone who wants to gain a working knowledge of how to create reports and data analysis in PowerBI Desktop; Participants should have basic knowledge of working with spreadsheets and basic data operations.