Get in Touch
 Duration 14 hours

Course Outline

Foundations of Data Modelling and Review

  • Exploring the data modelling layer within Power BI.
  • Concepts of star and snowflake schemas.
  • Establishing and managing relationships across tables.

Getting Started with DAX (Data Analysis Expressions)

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

Advanced DAX and Business Logic Implementation

  • Utilising time intelligence functions (YTD, MTD, QTD).
  • Implementing conditional logic and dynamic computations.
  • Calculating rankings, running totals, and comparative metrics.

Data Transformation and Performance Optimisation

  • Executing advanced transformations using Power Query.
  • Efficiently integrating multiple data sources.
  • Enhancing performance through query folding and relationship management.

Refined Visualisations and User Interactivity

  • Incorporating custom visuals and marketplace extensions.
  • Utilising drill-downs, bookmarks, and what-if parameters.
  • Generating paginated and dynamic reports.

Performance Management and Governance in Power BI

  • Best practices for managing datasets effectively.
  • Optimising refresh schedules and query execution performance.
  • Implementing row-level security (RLS) protocols.

Practical Project: Constructing a Sales Intelligence Dashboard

  • Formulating KPIs using DAX measures.
  • Designing a model-driven dashboard to drive business insights.
  • Applying governance standards and sharing best practices.

Conclusion and Future Pathways

Requirements

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

Target Audience

  • Business intelligence specialists.
  • Data analysts and reporting experts.
  • Developers engaged in data visualisation and analytical projects.

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-10 09:30
14 hours
Copenhagen, City Center
3472 EUR (Online)
3872 EUR (Classroom)

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

2026-11-24 09:30
14 hours
København, Copenhagen
3472 EUR (Online)
3872 EUR (Classroom)

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

2026-12-08 09:30
14 hours
Copenhagen, City Center
3472 EUR (Online)
3872 EUR (Classroom)

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

2026-12-22 09:30
14 hours
København, Copenhagen
3472 EUR (Online)
3872 EUR (Classroom)

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

2027-01-05 09:30
14 hours
Copenhagen, City Center
3472 EUR (Online)
3872 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training, offered in Denmark (online or onsite), is designed for business analysts, data analysts, and developers who aim to utilize the advanced features and tools in Power BI. The course focuses on performing complex data analysis and creating interactive visual reports.

Upon completion, participants will be able to:

  • Install and configure Power BI and its necessary components.
  • Explore and understand the advanced features, components, and tools in Power BI.
  • Gain valuable insights into advanced data analysis and strategy.
  • Apply advanced data modeling techniques.
  • Implement advanced formulas and calculations using DAX.
  • Apply tips and tricks for data handling, visualization, and presentation.
  • Make reports and dashboards interactive to support collaboration within Power BI.
  • Explore embedded analytics in Power BI.
Read more...

Data Analysis and Dashboarding with Power BI

 7 Hours
This live training session in Denmark guides beginner and intermediate users through the essentials of data analysis with Power BI. Learners will prepare data, design interactive dashboards, and share reports securely, acquiring the practical abilities needed to drive data-informed decisions within contemporary business environments.
Read more...

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

 21 Hours

This instructor-led live training in Denmark (offered online or onsite) targets entry-level professionals aiming to refine and analyze data, produce statistical predictions, and craft compelling visualizations with the mentioned tools.

Once this training concludes, participants will possess the ability to:

  • Acquire a solid understanding of Python, R, Power Query, and Power BI for data analysis.
  • Refine and organize datasets using Python and Power Query.
  • Execute statistical analysis and projections with R.
  • Develop high-quality dashboards and reports with Power BI.
  • Efficiently merge and analyze data from diverse sources.
Read more...

Excel to Power BI

 7 Hours

This instructor-led live training, available online or on-site in Denmark, is designed for data analysts looking to enhance their ability to prepare data in Excel and visualize it in Power BI.

By the end of the session, participants will have the capability to:

  • Comprehend the underlying principles, objectives, and approaches of data analysis.
  • Leverage DAX formulas in Power BI for advanced calculation tasks.
  • Develop and apply targeted visualizations and charts for specific analytical cases.
  • Use Power View to import data, enabling a shift from Excel-based Power BI to independent Power BI usage.
Read more...

Power BI - Advanced

 14 Hours

Course Delivery

  • Engaging lectures facilitated by dynamic discussions.
  • Extensive exercises and practical drills.
  • Real-world implementation within a live-lab environment.

Tailoring Options

  • If you require bespoke training for this module, please reach out to us to make the necessary arrangements.
Read more...

Power BI Dashboards

 14 Hours
Explore the process of creating interactive dashboards with Power BI. Master data transformation, visual report creation, and sharing management within Denmark. This program covers core competencies including data connectors, advanced filtering techniques, and best practices for robust business intelligence and seamless organizational access.
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 Denmark. Designed for financial analysts, it covers data preparation, modeling, KPI creation, and dashboard visualization using Power BI. Gain practical skills through hands-on labs and exam-focused exercises.
Read more...

Microsoft Power Automate

 14 Hours
Elevate your productivity by mastering Microsoft Power Automate in this hands-on session held in Denmark. You will learn to construct efficient no-code and low-code workflows using intuitive 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 training in Denmark (delivered either online or onsite) caters to data professionals and business analysts at beginner to intermediate levels who aim to harness Power BI for robust data analysis and visualization.

Upon completing this training, participants will possess the ability to:

  • Comprehend the architectural framework of Power BI and its fundamental components.
  • Establish connections to diverse data sources and execute data transformations.
  • Design impactful visualizations and interactive dashboards.
  • Enforce row-level security and oversee data access protocols.
Read more...

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

 21 Hours
This practical course in Denmark explores Power BI and Power Apps for data visualisation and workflow automation. You will learn to connect data sources, build interactive dashboards, and design low-code applications that enhance operational efficiency without requiring advanced coding skills.
Read more...

Power BI: Basics to Advanced

 35 Hours

This live, instructor-led training in Denmark (online or onsite) is tailored for data professionals at beginner to intermediate levels who are looking to craft compelling visualizations and dashboards with Power BI.

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

  • Import and transform data from diverse 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 training in Denmark supports users from novice to advanced levels in constructing Power BI dashboards. Through hands-on exercises utilizing real datasets, you will master data transformation, DAX, and visualization skills, enabling you to effectively share impactful, interactive business insights.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI training in Denmark empowers finance and HR professionals to effectively visualise cash flow and payroll data. Participants will learn to design interactive dashboards, apply DAX for complex financial metrics, and streamline reporting workflows to enhance decision-making capabilities.
Read more...

Power BI - Cash Flow and Payroll Analysis

 7 Hours
This instructor-led Power BI course in Denmark empowers financial and HR professionals to create sophisticated dashboards for cash flow and payroll. Discover how to implement DAX formulas, unify data sources, and visualize trends to enhance decision-making, supported by hands-on exercises and practical scenarios.
Read more...

Power BI DAX Fundamentals

 21 Hours

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

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

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

Related Categories

Power BI
Power BI