Power BI Training
Level
BeginnerDuration
32h / 4 daysDate
Individually arrangedPrice
Individually arrangedPower BI Training
This training is intended for people who work with processing and analyzing large amounts of data. The scope covers preparing data using PowerQuery and using it for visualization in Microsoft Power BI. The training also includes the use of the DAX library and topics related to storytelling with data.
What You Will Learn
- Efficiently acquire and process data for business decision-making
- Work with PowerQuery and data preparation techniques
- Learn the terminology and tools necessary to extract information from databases and present it in Power BI
- Use the DAX library for reporting and data analysis
- Tell stories with data using visualization techniques
Who is this training for?
Analysts, marketers, and everyone working with data-
People dealing with large-scale data processing and analysis
-
Anyone who wants to learn the DAX library
Training Program
-
Module 1: Introduction to Data Analysis with Power BI Desktop
- What is business intelligence?
- The 5 layers of a BI solution
- Power BI as a business intelligence tool
- Power BI Desktop – overview and user interface
-
Module 2: PowerQuery – Data Preparation Tool
-
Data Sources and Connectivity
- Using data connectors: Web, CSV, Excel, SQL
- Combining multiple data sources in a single report
-
ETL Processes
- Extract, Transform, Load (ETL) concepts
- Basic transformation functions
- Merging and appending queries
- Creating custom functions
-
PowerQuery Advanced Features
- Introduction to the M language
- Using the Advanced Editor
- Best practices in data preparation
- Dataflows – PowerQuery Online
- Query folding in PowerQuery
-
Module 3: Data Modeling in Power BI
- Star schema and snowflake schema
- Preparing fact and dimension tables with PowerQuery
- Building a calendar table
- Working with hierarchies in Power BI
- Best practices in data modeling
- Analyzing model performance
- Imported vs DirectQuery reports
-
Module 4: Data Analysis with DAX
- Introduction to DAX
- Calculated columns, calculated tables, measures, and queries
- Basic DAX functions
- Iterators in DAX
- Row context, evaluation context, and filter context
- Changing calculation context with CALCULATE()
- Advanced time intelligence functions
- Best practices for writing advanced DAX queries
-
Module 5: Storytelling with Data – Visualization Techniques
- Storytelling with data – concepts and principles
- Correct use of visualization types
- Working with visualizations in Power BI
- Filtering data at the visualization level
- Managing interactions between visualizations
- Advanced formatting of reports and visuals
- Drill-through functionality
- Using bookmarks in report building
- Working with field parameters
- Using tooltips for additional insights
- Best practices for visualization design
-
Module 6: Publishing and Sharing Reports
- Introduction to Power BI Service
- Publishing rules and best practices
- Data security: Row Level Security (RLS) and Object Level Security (OLS)
- Refreshing data in Power BI Service
- Using Power Automate to streamline workflows with Power BI
