Get in Touch
 Duration 14 hours

Course Outline

Review and Principles of Data Model Design

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

Introduction to DAX (Data Analysis Expressions)

  • DAX syntax and data type definitions
  • Distinguishing between calculated columns and measures
  • Key DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX and Business Logic Implementation

  • Time intelligence functions (YTD, MTD, QTD)
  • Conditional logic and dynamic computation techniques
  • Ranking, running totals, and comparative metric analysis

Data Transformation and Performance Optimization

  • Utilizing Power Query for advanced data transformations
  • Efficiently integrating multiple data sources
  • Enhancing performance via query folding and relationship optimization

Advanced Visualizations and Interactive Features

  • Incorporating custom visuals and marketplace extensions
  • Utilizing drill-downs, bookmarks, and what-if parameters
  • Developing paginated and dynamic report formats

Performance Management and Governance in Power BI

  • Best practices for managing datasets
  • Optimizing refresh schedules and query execution speed
  • Deploying row-level security (RLS)

Practical Project: Constructing a Sales Intelligence Dashboard

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

Conclusion and Future Directions

Requirements

  • Familiarity with the Power BI interface and report generation
  • Practical experience in constructing dashboards within Power BI
  • Foundational knowledge of data relationships and filtering mechanisms

Target Audience

  • Business intelligence specialists
  • Data analysts and reporting experts
  • 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-23 09:30
14 hours
Mirobod
22,597,506 UZS (Online)
24,597,506 UZS (Classroom)

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

2026-12-07 09:30
14 hours
Mirobod
22,597,506 UZS (Online)
24,597,506 UZS (Classroom)

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

2026-12-21 09:30
14 hours
Mirobod
22,597,506 UZS (Online)
24,597,506 UZS (Classroom)

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

2027-01-04 09:30
14 hours
Mirobod
22,597,506 UZS (Online)
24,597,506 UZS (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training in Uzbekistan (online or on-site) is designed for 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 its necessary components.
  • Understand and explore the advanced features, components, and tools in Power BI.
  • Gain valuable insights into advanced data analysis and strategy.
  • Apply advanced data modeling techniques.
  • Learn how to implement advanced formulas and calculations using DAX.
  • Master tips and tricks for data handling, visualization, and presentation.
  • Create interactive reports and dashboards 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 on Uzbekistan covers the core concepts and practical fundamentals of Power BI data analysis. Participants will learn to effectively model, visualize, and analyze data. You will build practical skills that apply directly to real-world business needs.
Read more...

Analyzing Data with Power BI

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

Data Analysis and Dashboarding with Power BI

 7 Hours
This live training in Uzbekistan assists beginner and intermediate users in mastering data analysis with Power BI. Participants will learn to prepare data, build interactive dashboards, and share reports securely, acquiring the practical skills necessary 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 Uzbekistan (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 Uzbekistan (online or onsite) is designed for 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 - Advanced

 14 Hours

Format of the Course

  • Interactive lecture and discussion.
  • Extensive exercises and hands-on practice.
  • Real-world implementation in a live-lab environment.

Course Customization Options

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

Power BI Dashboards

 14 Hours
Explore techniques for constructing interactive dashboards using Power BI. Gain proficiency in data transformation, creating visual reports, and managing distribution within Uzbekistan. This program covers core competencies such as data integration, advanced filtering, and best practices for robust business intelligence and enterprise-wide accessibility.
Read more...

Power BI online

 14 Hours
This course on Uzbekistan dives into Microsoft Power BI online, guiding you through report publishing, workspace management, and data security. You will explore using Dataverse, configuring data gateways, and automating updates to effectively share insights with colleagues in a cloud-based environment.
Read more...

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

 7 Hours
Get ready for the Microsoft PL-300 certification with this instructor-led training in Uzbekistan. Tailored for financial analysts, the course covers data preparation, modeling, KPI creation, and dashboard visualization using Power BI. Build practical expertise through hands-on labs and exam-focused practice.
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 systems. The course also explores implementing appropriate security standards and policies across the Power BI ecosystem, covering datasets and groups. Additionally, it discusses managing and deploying reports and dashboards for effective sharing and content distribution.

Read more...

Power Apps

 21 Hours
This instructor-led, live training in Uzbekistan covers the core concepts and hands-on fundamentals of Power Apps, helping participants build practical no-code applications using templates, data connectors, and AI elements to streamline everyday business activities and workflows.
Read more...

Microsoft Power Automate

 14 Hours
Elevate your productivity by mastering Microsoft Power Automate in this practical training session held in Uzbekistan. You will learn to construct efficient no-code and low-code workflows using straightforward drag-and-drop actions, allowing you to streamline repetitive tasks across Office 365 and hundreds of other connected applications.
Read more...

Power BI

 14 Hours

This live, instructor-led course in Uzbekistan, delivered either online or on-site, is designed for beginner to intermediate-level data professionals and business analysts aiming to utilize Power BI effectively for data analysis and visualization.

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

  • Grasp the architecture of Power BI and its core elements.
  • Link to various data sources and carry out data transformations.
  • Build effective visualizations and interactive dashboards.
  • Establish 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 on Uzbekistan covers the use of Power BI and Power Apps for data visualization and workflow automation. Participants will learn to connect data sources, construct interactive dashboards, and design low-code apps that enhance operational efficiency without the need for extensive coding.
Read more...

Related Categories

Power BI
Power BI