Power BI Fundamentals
2 days 16 hours
Data integration from multiple sources
Excel files, folders, SharePoint lists, databases
Data transformation and processing in Power Query
data types, merging, appending, data transformations
Building a data model
table types, relationship types, filter flow settings
Key DAX functions
CALCULATE, aggregation functions, iterators, Time Intelligence
Creating interactive visualizations
charts, maps, tables, conditional formatting, interactions between visuals
Designing user-friendly reports and dashboards
UX/UI best practices, storytelling
Publishing and sharing reports with users
navigating the Power BI Service environment, assigning access
Power BI Advanced
2 days 16 hours
Automation and integration of various data sources
combining files from a folder / sheets from an Excel file, using parameters
Advanced data model building
building a calendar table, combining tables with different data granularities, creating bridge tables
Advanced DAX
advanced DAX functions, row and filter context, context transition
Advanced visualizations
custom visuals, drill-through, dynamic text, data labels, field parameters, scenario analysis based on parameters
Data security management
RLS (Row-Level Security)
Report and deployment management
apps and audiences in Power BI Service, Deployment Pipelines, version control
Power BI Copilot
1 day 8 hours
Fundamentals of Generative AI and Microsoft Copilot
large language models (LLMs), how Copilot works, licensing, comparison with other AI tools, and effective prompting
Designing Power BI Reports with Copilot
defining KPIs, selecting measures and filters, designing report page layouts, and choosing recommended visualizations that support business goals
Creating and Optimizing DAX Measures with AI Support
generating formulas from business requirements, working in DAX Query View, analyzing how code works, and improving the readability and performance of measures
Automating Data Preparation and Report Documentation
using Dataflow Gen2, applying Copilot support in the data preparation process, and creating report documentation with an overview of capabilities and limitations
Preparing a Semantic Model for Conversational Analytics
adapting the model for use with Copilot and Q&A, defining synonyms, verified answers, and descriptions of measures and KPIs
Self-Service BI and Report Analysis with Copilot
using Copilot in Power BI Service, apps, and reports, analyzing trends, generating summaries, and creating simple visualizations through conversation
Secure and Effective AI Adoption Across the Organization
key Copilot use cases in Power BI, an overview of AI tools, best practices, limitations, and implementation recommendations
Training Format
Our Power BI training consists of practical workshops led by an experienced trainer with extensive project background.
We offer two training formats:
Virtual Classrom
Online Training
On-site Training
at Your Office
You will learn to create and share Power BI, that streamline your team’s daily work!
Training Results
For Business Users
You will create your own reports and dashboards that make data analysis and daily work easier
For Managers
You will understand how Power BI can support decision-making and your team’s work
For IT / Developers
You will gain knowledge on how to build and maintain scalable data models and manage report security
After the training, you’ll not only have knowledge but also practical skills you can immediately apply at work!
Who Is This Training For?
For office employees and specialists who want to analyze data faster and create their own reports
For managers and decision-makers who need clear KPIs and consistent reports to make better decisions
For IT staff and developers who are responsible for building data models, ensuring security, and maintaining the reporting environment
Power BI Fundamentals Training is ideal for beginners – no prior experience is required.
Power BI Advanced Training structures and deepens the understanding of the tool.
