Get in Touch

Course Outline

Review and Data Model Design Fundamentals

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

Getting Started with DAX (Data Analysis Expressions)

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

Advanced DAX and Business Logic Implementation

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

Data Transformation and Optimization Strategies

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

Enhanced Visualizations and Interactive Features

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

Performance Management and Governance in Power BI

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

Practical Project: Developing a Sales Intelligence Dashboard

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

Summary and Future Directions

Requirements

  • Familiarity with the Power BI interface and report creation processes
  • Experience in constructing dashboards within Power BI
  • Foundational knowledge of data relationships and filtering mechanisms

Audience

  • Business intelligence professionals
  • Data analysts and reporting specialists
  • 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-16 09:30
14 hours
Oslo
3000 EUR (Online)
3400 EUR (Classroom)

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

2026-10-30 09:30
14 hours
Oslo
3000 EUR (Online)
3400 EUR (Classroom)

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

2026-11-13 09:30
14 hours
Oslo
3000 EUR (Online)
3400 EUR (Classroom)

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

2026-11-27 09:30
14 hours
Oslo
3000 EUR (Online)
3400 EUR (Classroom)

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

2026-12-11 09:30
14 hours
Oslo
3000 EUR (Online)
3400 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training in Norway (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 Norway supports beginners and intermediate users in mastering data analysis through Power BI. Participants will learn to process data, design interactive dashboards, and share reports securely, developing practical capabilities for data-informed decision-making in contemporary business environments.
Read more...

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

 21 Hours

This guided, live training in Norway (available online or at your location) targets professionals at the beginner level who want to learn how to clean and analyze data, forecast statistical trends, and generate meaningful visual representations using these tools.

Upon completing this training, attendees will be capable of:

  • Gaining foundational knowledge of Python, R, Power Query, and Power BI for data analysis.
  • Cleaning and organizing datasets using Python and Power Query.
  • Executing statistical analysis and forecasting with R.
  • Developing professional dashboards and reports using Power BI.
  • Effectively integrating and analyzing data from various sources.
Read more...

Excel to Power BI

 7 Hours

This instructor-led live training in Norway (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 creation of interactive dashboards using Power BI. Master the skills required to transform data, generate visual reports, and manage sharing within Norway. This course addresses key competencies such as utilizing data connectors, applying advanced filters, and implementing best practices for effective business intelligence and broad organizational access.
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 Norway. Specifically designed for financial analysts, the course covers data preparation, modeling, KPI creation, and dashboard visualization within Power BI. Develop practical competencies through hands-on labs and exam-focused exercises.
Read more...

Power BI

 14 Hours

Delivered live by an instructor either online or onsite, this training in Norway is designed for data professionals and business analysts at beginner to intermediate levels who wish to utilize Power BI effectively for data analysis and visualization.

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

  • Understand 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.
Read more...

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

 21 Hours
This practical course in Norway covers the use of Power BI and Power Apps for visualizing data and automating workflows. Participants will learn to link data sources, construct interactive dashboards, and design low-code applications that enhance operational efficiency without the need for significant coding.
Read more...

Power BI: Basics to Advanced

 35 Hours

This instructor-led, live training in Norway (online or on-site) is aimed at beginner-level to intermediate-level data professionals 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 training in Norway 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, empowering you to effectively share impactful and interactive business insights.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI training in Norway empowers finance and HR professionals to visualize cash flow and payroll data. Participants will learn to construct interactive dashboards, apply DAX for financial metrics, and automate reporting workflows to enhance decision-making.
Read more...

Power BI - Cash Flow and Payroll Analysis

 7 Hours
This live, instructor-led Power BI training in Norway empowers financial and HR professionals to construct comprehensive cash flow and payroll dashboards. Participants will learn to implement DAX formulas, integrate diverse data sources, and visualize trends for enhanced decision-making, supported by hands-on exercises and realistic business scenarios.
Read more...

Power BI DAX Fundamentals

 21 Hours

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

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

  • Gain a thorough understanding of Data Analysis Expressions (DAX) in Power BI.
  • Develop custom calculations and expressions in Power BI to analyze data and derive insights.
  • Acquire best practices for optimizing DAX performance.
Read more...

Power BI for Data Integration, Analysis, and BIM

 21 Hours
This live, instructor-led course in Norway focuses on leveraging Power BI for data integration, analytics, and BIM. Designed for mid-level professionals, it enables real-time data extraction, AI-powered trend identification, and the seamless incorporation of BIM models to drive practical technical and managerial decision-making.
Read more...

Power BI for Data Modeling and Dashboard Development

 35 Hours

This instructor-led, live training in Norway (online or on-site) is intended for beginner to intermediate-level participants who wish to acquire in-depth knowledge of Power BI, covering its work environment, data modeling, dashboard development, and publication.

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

  • Navigate and utilize the Power BI work environment effectively.
  • Model and transform data for meaningful analysis.
  • Apply basic functions and DAX measurements to enhance data calculations.
  • Create and customize interactive dashboards and reports.
  • Publish, share, and export reports for organizational use.
Read more...

Related Categories

Power BI
Power BI