Get in Touch

Course Outline

Review and Principles of Data Model Design

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

Foundations of DAX (Data Analysis Expressions)

  • DAX syntax and data typing
  • Differences between calculated columns and measures
  • Essential DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX and Business Logic Implementation

  • Time intelligence functions (YTD, MTD, QTD)
  • Conditional logic and dynamic calculation methods
  • Ranking systems, running totals, and comparative metrics

Data Transformation and Optimization Strategies

  • Utilizing Power Query for sophisticated transformations
  • Integrating multiple data sources with efficiency
  • Enhancing performance via query folding and relationship management

Advanced Visualizations and Interactivity Features

  • Custom visuals and marketplace extensions
  • Drill-down capabilities, bookmarks, and what-if parameters
  • Generating paginated and dynamic reports

Performance Management and Governance in Power BI

  • Best practices for dataset administration
  • Refining refresh schedules and query efficiency
  • Deploying row-level security (RLS)

Practical Project: Constructing a Sales Intelligence Dashboard

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

Conclusion and Future Directions

Requirements

  • A solid grasp of the Power BI interface and report generation
  • Practical experience in creating dashboards within Power BI
  • Fundamental understanding of data relationships and filtering mechanisms

Audience

  • Business intelligence specialists
  • Data analysts and reporting experts
  • Developers focused on data visualization and analytics
 14 Hours

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-10-26 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

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

2026-11-09 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

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

2026-11-23 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

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

2026-12-07 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

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

2026-12-21 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led live training in Serbia (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...

PL-300: Microsoft Power BI Data Analyst

 21 Hours
This instructor-led live training in Serbia covers the core concepts and hands-on fundamentals of Power BI data analysis. Participants will learn to model, visualize, and analyze data effectively. Build practical skills that apply directly to real-world business needs.
Read more...

Analyzing Data with Power BI

 28 Hours
This Serbia training covers Power BI data analytics, including data modeling, visualization, and analysis using DAX and AI visuals. You will learn to prepare, transform, and secure data from diverse sources while optimizing performance for enterprise-scale workloads and reporting.
Read more...

Data Analysis and Dashboarding with Power BI

 7 Hours
This live session on Serbia enables novice and intermediate users to master data analysis via Power BI. Learners will gain the skills to prepare data, design interactive dashboards, and securely share reports, equipping them with practical competencies 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 Serbia (online or onsite) targets beginner-level professionals who want 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 Serbia (online or onsite) targets data analysts who wish to learn techniques for preparing data in Excel and 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 - Advanced

 14 Hours

Course Format

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

Course Customization Options

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

Power BI Dashboards

 14 Hours
Learn to construct interactive dashboards using Power BI. Master data transformation, visual report creation, and sharing management in Serbia. This course addresses core competencies such as data connectors, advanced filtering, and best practices for robust business intelligence and cross-organizational access.
Read more...

Power BI online

 14 Hours
This Serbia training focuses on Microsoft Power BI online, guiding you through report publishing, workspace management, and data security protocols. You will learn to utilize Dataverse, configure data gateways, and automate updates, enabling you to share insights effectively with colleagues in a cloud-based environment.
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 Serbia. Specifically designed for financial analysts, the course encompasses data preparation, modeling, KPI development, and dashboard visualization using Power BI. Acquire practical proficiency through hands-on labs and exercises focused on exam success.
Read more...

PL-300T00: Microsoft Power BI Data Analyst

 21 Hours

This course covers various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It demonstrates how to access and process data from diverse sources, including both relational and non-relational databases. Additionally, the course explores implementing robust security standards and policies across the Power BI ecosystem, covering datasets and groups. It also addresses the management and deployment of reports and dashboards for effective sharing and content distribution.

Read more...

Power Apps

 21 Hours
This live, instructor-led training in Serbia explores the core concepts and practical fundamentals of Power Apps. Participants will learn to build hands-on, no-code applications utilizing templates, data connectors, and AI elements to enhance everyday business processes and workflows.
Read more...

Microsoft Power Automate

 14 Hours
Enhance your productivity by mastering Microsoft Power Automate in this practical training held in Serbia. You will learn to design efficient no-code and low-code workflows using simple drag-and-drop actions, optimizing repetitive tasks across Office 365 and hundreds of other integrated applications.
Read more...

Power BI

 14 Hours

This instructor-led, live training in Serbia (online or onsite) is aimed at beginner-level to intermediate-level data professionals and business analysts who wish to effectively use Power BI for data analysis and visualization.

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

  • Understand Power BI's architecture and its core components.
  • Connect to various data sources and perform data transformations.
  • Create effective visualizations and interactive dashboards.
  • Implement row-level security and manage data access.
Read more...

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

 21 Hours
This practical course in Serbia demystifies Power BI and Power Apps for data visualization and workflow automation. You will learn to integrate data sources, craft interactive dashboards, and design low-code applications that boost operational efficiency without the need for advanced coding skills.
Read more...

Related Categories

Power BI
Power BI