Get in Touch
 Duration 14 hours

Course Outline

Introduction to Power Query

  • Overview of the Power Query interface
  • Comprehending queries and applied steps
  • Exploring integrations with Power BI and Excel

Linking to Data Sources

  • Ingesting Excel, CSV, and text files
  • Handling folders and structured datasets
  • Establishing connections to online and database sources

Essentials of Data Cleansing

  • Eliminating errors and duplicate entries
  • Filtering, sorting, and restructuring data
  • Addressing missing values

Data Transformation and Shaping

  • Dividing and combining columns
  • Executing pivoting and unpivoting operations
  • Grouping and aggregating data points

Query Consolidation

  • Distinguishing between appending and merging queries
  • Understanding join types and structural considerations
  • Modelling datasets from multiple sources

Getting Started with M Language

  • Grasping M formulas
  • Modifying queries via the Advanced Editor
  • Developing custom transformation scripts

Automation and Refresh Mechanisms

  • Designing reusable transformation workflows
  • Setting up refresh schedules
  • Overseeing dependencies and optimising query performance

Advanced Methodologies

  • Implementing query parameters
  • Utilising M functions
  • Adopting best practices for scalable transformation pipelines

Recap and Future Steps

Requirements

  • Basic knowledge of spreadsheet-based data operations
  • Prior experience with fundamental data analysis activities
  • Familiarity with standard file formats like CSV and Excel

Target Audience

  • Data specialists required to cleanse and ready datasets
  • Business analysts managing recurring data processes
  • Individuals engaged in data reporting and process automation

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (2)

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

Method of training.

Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced

Upcoming Courses

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

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

Power Query for Data Transformation and Automation

2027-01-06 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...

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

 14 Hours
This instructor-led live training in Norway prepares intermediate professionals with advanced Power BI capabilities, covering complex data modeling, DAX calculations, and interactive visualization techniques to effectively create powerful business intelligence solutions.
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...

Related Categories

Power BI
Power BI