Get in Touch
 Duration 14 hours

Course Outline

Review and Foundational Principles of Data Model Design

  • Exploring the data modeling layer within Power BI
  • Concepts of star and snowflake schemas
  • Establishing and administering inter-table relationships

Fundamentals of DAX (Data Analysis Expressions)

  • DAX syntax and associated data types
  • Distinguishing between calculated columns and measures
  • Essential DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX Implementation and Business Logic

  • Utilizing time intelligence functions (YTD, MTD, QTD)
  • Applying conditional logic and dynamic computations
  • Implementing ranking, running totals, and comparative metrics

Data Transformation and Performance Optimization

  • Executing advanced transformations using Power Query
  • Efficiently integrating multiple data sources
  • Boosting performance via query folding and optimized relationships

Advanced Visualizations and Interactive Features

  • Integrating custom visuals and marketplace extensions
  • Utilizing drill-downs, bookmarks, and what-if parameters
  • Constructing paginated and dynamic reporting layouts

Performance Management and Governance in Power BI

  • Adhering to best practices for dataset administration
  • Optimizing refresh schedules and query execution efficiency
  • Configuring row-level security (RLS)

Practical Application: Developing a Sales Intelligence Dashboard

  • Creating KPIs through DAX measures
  • Architecting a model-centric dashboard for strategic insights
  • Applying governance standards and sharing protocols

Conclusion and Future Directions

Requirements

  • Proficiency in navigating the Power BI interface and generating reports
  • Practical experience in constructing dashboards within Power BI
  • Fundamental knowledge of data relationships and filtering mechanisms

Target Audience

  • Business intelligence experts
  • Data analysts and reporting specialists
  • Developers focused on 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-11 09:30
14 hours
Crystal Business Center
540 EUR (Online)
940 EUR (Classroom)

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

2026-11-25 09:30
14 hours
Central Point Varna
540 EUR (Online)
940 EUR (Classroom)

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

2026-12-09 09:30
14 hours
Business Center Plovdiv
540 EUR (Online)
2240 EUR (Classroom)

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

2026-12-23 09:30
14 hours
Crystal Business Center
540 EUR (Online)
940 EUR (Classroom)

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

2027-01-06 09:30
14 hours
Central Point Varna
540 EUR (Online)
940 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training in Bulgaria (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 training in Bulgaria assists beginner and intermediate users in mastering data analysis through Power BI. Learners will prepare data, build interactive dashboards, and securely share reports, thereby developing practical capabilities for data-driven decision-making in contemporary business environments.
Read more...

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

 21 Hours

This instructor-led, live training in Bulgaria (online or onsite) targets 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 Bulgaria (available online or onsite) is targeted at data analysts who wish to acquire skills for preparing data in Excel and visualizing it in Power BI.

By the conclusion of this training, participants will be capable of:

  • Understanding the principles, objectives, and approaches of data analysis.
  • Applying DAX formulas in Power BI for complex calculations.
  • Creating and utilizing visualizations and charts for specific analysis cases.
  • Using Power View to transition from Excel-based Power BI to independent Power BI.
Read more...

Power BI - Advanced

 14 Hours

Course Format

  • Interactive lectures and discussions.
  • Extensive exercises and practical application.
  • Hands-on implementation within a live-lab setting.

Customization Options

  • To arrange customized training for this course, please contact us.
Read more...

Power BI Dashboards

 14 Hours
Discover how to construct interactive dashboards using Power BI. Learn to transform data, generate visual reports, and manage sharing within Bulgaria. This course addresses essential competencies such as data connectors, advanced filtering, and best practices for effective business intelligence and organization-wide accessibility.
Read more...

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

 7 Hours
Prepare for the Microsoft PL-300 certification through this instructor-led training in Bulgaria. Specifically designed for financial analysts, the course covers data preparation, modeling, KPI development, and dashboard visualization within Power BI. Participants will build practical competencies via hands-on labs and exam-focused drills.
Read more...

Power Apps

 21 Hours
This instructor-led, live training in Bulgaria explores the core principles and practical fundamentals of Power Apps. Participants will learn to construct functional no-code applications using templates, data connectors, and AI components to optimize daily business activities and workflows.
Read more...

Microsoft Power Automate

 14 Hours
Enhance your productivity by mastering Microsoft Power Automate in this hands-on training session in Bulgaria. You will learn to construct efficient no-code and low-code workflows using simple drag-and-drop actions, effectively streamlining repetitive tasks across Office 365 and hundreds of other connected applications.
Read more...

Power BI

 14 Hours

This live, instructor-led course on Bulgaria (available online or onsite) is designed for beginner to intermediate data professionals and business analysts looking to utilize Power BI proficiently for data analysis and visualization.

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

  • Comprehend the Power BI architecture and its fundamental components.
  • Link to various data sources and carry out data transformations.
  • Develop efficient visualizations and interactive dashboards.
  • Deploy row-level security and control data access.
Read more...

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

 21 Hours
This practical course in Bulgaria explores Power BI and Power Apps to enhance data visualization and workflow automation. Discover how to link data sources, construct engaging dashboards, and build low-code applications that drive operational efficiency, all without the need for advanced programming skills.
Read more...

Power BI: Basics to Advanced

 35 Hours

This instructor-led, live training in Bulgaria (online or on-site) is designed for beginner to intermediate data professionals who aspire to create compelling data visualizations and dashboards using 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 professional training in Bulgaria supports users from novice to expert in developing Power BI dashboards. Through hands-on exercises with real-world datasets, participants master data transformation, DAX, and visualization, enabling them to effectively share impactful and interactive business insights.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI session in Bulgaria empowers finance and HR teams to visualize cash flow and payroll metrics. Learners will master the creation of interactive dashboards, apply DAX formulas for financial analysis, and automate reporting processes to support strategic decision-making.
Read more...

Power BI - Cash Flow and Payroll Analysis

 7 Hours
This instructor-led Power BI course in Bulgaria empowers financial and HR professionals to create comprehensive cash flow and payroll dashboards. Participants will learn to apply DAX formulas, integrate diverse data sources, and visualize trends to enhance decision-making, supported by hands-on exercises and real-world scenarios.
Read more...

Related Categories

Power BI
Power BI