Get in Touch
 Duration 14 hours

Course Outline

Review and Data Model Design Principles

  • Comprehending the data modeling layer in Power BI
  • Concepts of star and snowflake schemas
  • Establishing and maintaining relationships between tables

Getting Started with DAX (Data Analysis Expressions)

  • DAX syntax and data types
  • Distinctions between calculated columns and measures
  • Key DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX and Business Logic

  • Time intelligence functions (YTD, MTD, QTD)
  • Conditional logic and dynamic calculations
  • Ranking, cumulative totals, and comparative metrics

Data Transformation and Optimization

  • Utilizing Power Query for complex transformations
  • Integrating multiple data sources efficiently
  • Enhancing performance via query folding and relationships

Advanced Visualizations and Interactivity

  • Custom visuals and marketplace extensions
  • Drill-downs, bookmarks, and what-if parameters
  • Developing paginated and dynamic reports

Performance and Governance in Power BI

  • Best practices for managing datasets
  • Optimizing refresh schedules and query performance
  • Implementing row-level security (RLS)

Practical Project: Developing a Sales Intelligence Dashboard

  • Creating KPIs using DAX measures
  • Designing a model-driven dashboard for business insights
  • Applying governance and sharing best practices

Wrap-up and Future Steps

Requirements

  • Knowledge of the Power BI interface and report development
  • Experience in constructing dashboards within Power BI
  • Fundamental familiarity with data relationships and filtering

Target Audience

  • Business intelligence specialists
  • Data analysts and reporting experts
  • Developers engaged in data visualization and analytics

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (4)

How to use relationships in Power BIand the differences between columns and measurements

LEUNG Chun Hei - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

The application of Data Modelling and DAX

Rachel KY Wong - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Emoji setting. SharePoint data source linkage. Concept of DAX in measure and column.

Lam Chit Wui (Ray) - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Calculate, Measure

TONY ZHOU CHEN - HAESL
Course - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

Upcoming Courses

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-11-23 09:30
14 hours
Ostrava
3000 EUR (Online)
3000 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-12-07 09:30
14 hours
Prague, Prague Castle
3000 EUR (Online)
3400 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2026-12-21 09:30
14 hours
Brno
3000 EUR (Online)
3000 EUR (Classroom)

Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics

2027-01-04 09:30
14 hours
Ostrava
3000 EUR (Online)
3000 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training in Czech Republic (online or onsite) is aimed at business analysts, data analysts, and developers who wish to use the advanced features and tools in Power BI to perform complex data analysis and create interactive visual reports.

By the end of this training, participants will be able to:

  • Install and configure Power BI and the necessary components.
  • Understand and explore the advanced features, components, and tools in Power BI.
  • Get valuable insights on advanced data analysis and strategy.
  • Apply advanced data modeling techniques.
  • Learn how to implement advanced formulas and calculations using DAX.
  • Know the tips and tricks on data handling, visualization, and presentation.
  • Make reports and dashboards interactive to enable collaboration within Power BI.
  • Learn and explore embedded analytics in Power BI.
Read more...

Data Analysis and Dashboarding with Power BI

 7 Hours
This live session in Czech Republic supports beginner and intermediate users in mastering data analysis via Power BI. Learners will gain the ability to process data, construct interactive dashboards, and distribute reports securely, thereby developing practical competencies essential for data-driven strategies in contemporary business environments.
Read more...

Data Analysis with Python, R, Power Query, and Power BI

 21 Hours

This instructor-led, live training in Czech Republic (online or onsite) is aimed at beginner-level professionals who wish to clean and analyze data, make statistical projections, and create insightful visualizations using these tools.

By the end of this training, participants will be able to:

  • Understand the basics of Python, R, Power Query, and Power BI for data analysis.
  • Clean and organize datasets using Python and Power Query.
  • Perform statistical analysis and projections with R.
  • Create professional dashboards and reports with Power BI.
  • Integrate and analyze data from multiple sources effectively.
Read more...

Excel to Power BI

 7 Hours

This instructor-led, live training in Czech Republic (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.

By the end of this training, participants will be able to:

  • Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
  • Use DAX formulas in Power BI for complex calculations.
  • Create and use visualizations and charts for particular analysis cases.
  • Import with Power View to move from Excel based Power BI to independent Power BI.
Read more...

Power BI Dashboards

 14 Hours
Explore the process of creating interactive dashboards using Power BI. You will learn to manipulate data, generate visual reports, and manage sharing protocols within Czech Republic. This course equips you with essential skills, including working with data connectors, applying advanced filters, and adopting best practices for robust business intelligence and enterprise-wide accessibility.
Read more...

Power BI for Financial Analysts: Exam Preparation (PL-300)

 7 Hours
Prepare for the Microsoft PL-300 certification with this instructor-led training in Czech Republic. Designed specifically for financial analysts, the course covers data preparation, modeling, KPI creation, and dashboard visualization using Power BI. Build practical skills through hands-on labs and exam-focused exercises.
Read more...

Power BI

 14 Hours

This live, instructor-led training on Czech Republic, available either online or on-site, is designed for data professionals and business analysts at beginner to intermediate levels who wish to proficiently utilize Power BI for data analysis and visualization.

By the conclusion of this program, participants will be able to:

  • Grasp Power BI’s architecture and its core components.
  • Connect to various data sources and execute data transformations.
  • Develop effective visualizations and interactive dashboards.
  • Implement row-level security and manage data access controls.
Read more...

Power BI and Power Apps for Data Visualization and Business Process Automation

 21 Hours
This practical course in Czech Republic explores the use of Power BI and Power Apps for data visualization and workflow automation. Participants will learn to link data sources, construct interactive dashboards, and design low-code applications that boost operational efficiency without requiring advanced coding skills.
Read more...

Power BI: Basics to Advanced

 35 Hours

This instructor-led live training in Czech Republic (online or onsite) is tailored for data professionals at the beginner to intermediate level who wish to create compelling data visualizations and dashboards with Power BI.

By the end of this training, participants will be able to:

  • Import and transform data from various sources.
  • Develop and optimize data models.
  • Create visually appealing and interactive reports and dashboards.
  • Apply best practices in data visualization and dashboard design.
  • Utilize advanced features of Power BI for in-depth data analysis.
Read more...

Power BI: Basic, Intermediate, and Advanced

 14 Hours
This instructor-led course in Czech Republic supports learners from beginner to advanced levels in crafting Power BI dashboards. Through hands-on exercises with real datasets, participants master data transformation, DAX, and visualization techniques, enabling them to communicate impactful, interactive business insights with confidence.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI training in Czech Republic empowers finance and HR specialists to visualize cash flow and payroll data. Learners will gain the skills to build interactive dashboards, leverage DAX for financial metrics, and automate reporting workflows to enhance strategic decision-making.
Read more...

Power BI - Cash Flow and Payroll Analysis

 7 Hours
This instructor-led Power BI course in Czech Republic empowers financial and HR professionals to construct resilient dashboards for cash flow and payroll. Participants will master DAX formula application, data source integration, and trend visualization to drive better decisions, all supported by hands-on exercises and realistic business scenarios.
Read more...

Power BI DAX Fundamentals

 21 Hours

This instructor-led live training in Czech Republic (online or onsite) is designed for beginner to intermediate business analysts, data analysts, and developers seeking to learn the fundamentals of DAX in Power BI.

By the end of this training, participants will be able to:

  • Develop a comprehensive understanding of Data Analysis Expressions (DAX) in Power BI.
  • Create custom calculations and expressions in Power BI for analyzing data and deriving insights.
  • Learn best practices to optimize DAX performance.
Read more...

Power BI for Data Integration, Analysis, and BIM

 21 Hours
This instructor-led, live training in Czech Republic focuses on leveraging Power BI for data integration, analysis, and BIM. Perfect for intermediate professionals, it empowers real-time data retrieval, AI-driven trend detection, and seamless BIM model integration, delivering actionable insights for technical and managerial decision-making.
Read more...

Power BI for Data Modeling and Dashboard Development

 35 Hours

This instructor-led, live training in Czech Republic (online or on-site) targets beginner to intermediate participants who wish to gain in-depth knowledge of Power BI, covering its working environment, data modeling, dashboard development, and publication.

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

  • Effectively navigate and utilize the Power BI working environment.
  • Model and transform data to facilitate meaningful analysis.
  • Apply fundamental functions and DAX measures to improve data calculations.
  • Design and customize interactive dashboards and reports.
  • Publish, share, and export reports for organizational use.
Read more...

Related Categories

Power BI
Power BI