Get in Touch
 Duration 14 hours

Course Outline

Introduction to Power Query

  • Overview of the Power Query interface
  • Grasping the concept of queries and applied steps
  • Navigating the integrations with Power BI and Excel

Linking to Data Sources

  • Importing data from Excel, CSV, and text files
  • Handling folders and structured data sets
  • Connecting to online services and database sources

Fundamentals of Data Cleaning

  • Eliminating errors and duplicate records
  • Filtering, sorting, and reshaping data
  • Addressing missing values effectively

Data Transformation and Shaping

  • Splitting and merging columns
  • Executing pivots and unpivots
  • Grouping data and applying aggregations

Combining Multiple Queries

  • Distinguishing between appending and merging queries
  • Considerations regarding join types and data structure
  • Modeling datasets derived from multiple sources

Getting Started with the M Language

  • Understanding M language formulas
  • Modifying queries through the Advanced Editor
  • Developing custom transformation scripts

Automation and Data Refresh

  • Building reusable transformation workflows
  • Setting up refresh schedules
  • Managing dependencies and optimizing query performance

Advanced Methodologies

  • Implementing parameterized queries
  • Utilizing functions within the M language
  • Best practices for designing scalable transformation pipelines

Summary and Path Forward

Requirements

  • A solid grasp of spreadsheet-based data operations
  • Practical experience with fundamental data analysis activities
  • Familiarity with standard file formats, including CSV and Excel

Target Audience

  • Data professionals focused on cleaning and preparing data sets
  • Business analysts managing recurring data processes
  • Individuals involved in data reporting and process automation

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (2)

The most valuable takeaway was learning how to apply the concepts in real-world scenarios and understanding the tools and processes.

Marcel Tansae - DB Technology
Course - Microsoft Power Automate

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

Upcoming Courses

Power Query for Data Transformation and Automation

2026-11-23 09:30
14 hours
Cluj-Napoca, Pitești Street
495 EUR (Online)
895 EUR (Classroom)

Power Query for Data Transformation and Automation

2026-12-07 09:30
14 hours
Timisoara, Iosif Bulbuca Boulevard
495 EUR (Online)
895 EUR (Classroom)

Power Query for Data Transformation and Automation

2026-12-21 09:30
14 hours
Constanta, Mircea cel Batran Street
495 EUR (Online)
895 EUR (Classroom)

Power Query for Data Transformation and Automation

2027-01-04 09:30
14 hours
Iasi, City Center
495 EUR (Online)
895 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led, live training in Romania (online or onsite) is tailored for business analysts, data analysts, and developers who want to leverage advanced Power BI features and tools to conduct complex data analysis and create interactive visual reports.

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

  • Install and configure Power BI along with its necessary components.
  • Understand and explore the advanced features, components, and tools available in Power BI.
  • Gain valuable insights into advanced data analysis strategies.
  • 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 facilitate collaboration within Power BI.
  • Learn and explore embedded analytics capabilities in Power BI.
Read more...

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

 14 Hours
This instructor-led live training in Romania provides intermediate professionals with advanced Power BI competencies, encompassing complex data modeling, DAX computations, and interactive visualization methods to craft effective business intelligence solutions.
Read more...

Data Analysis and Dashboarding with Power BI

 7 Hours
This live training on Romania supports both beginner and intermediate users in mastering data analytics with Power BI. Participants will acquire the skills to prepare data, build interactive dashboards, and securely share reports, fostering practical capabilities for making 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 Romania (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 Romania (available online or onsite) is tailored for data analysts who wish to acquire techniques for preparing data in Excel and then visualizing it in Power BI.

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

  • Understand the core principles, objectives, and approaches of data analysis.
  • Apply DAX formulas in Power BI for complex calculations.
  • Create and utilize visualizations and charts for specific analytical cases.
  • Import data with Power View to transition from Excel-based Power BI to an independent Power BI setup.
Read more...

Power BI - Advanced

 14 Hours

Course Format

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

Customization Options for the Course

  • For requests regarding customized training for this course, please contact us to make arrangements.
Read more...

Power BI Dashboards

 14 Hours
Explore the methods for constructing interactive dashboards using Power BI. Acquire skills in data transformation, visual report generation, and sharing management within Romania. This course addresses core competencies, including data connectors, advanced filtering techniques, and best practices for robust business intelligence and enterprise-wide access.
Read more...

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

 7 Hours
Gear up for the Microsoft PL-300 certification through this instructor-led program in Romania. Tailored for financial analysts, it encompasses data preparation, modeling, KPI development, and dashboard visualization via Power BI. Build practical skills through interactive labs and exam-centric exercises.
Read more...

Power Apps

 21 Hours
This live, instructor-led session on Romania explores the fundamental concepts and practical techniques of Power Apps. It guides participants in constructing no-code applications utilizing templates, data connectors, and AI features to optimize daily business processes and workflows.
Read more...

Microsoft Power Automate

 14 Hours
Elevate your productivity by mastering Microsoft Power Automate in this practical, hands-on session held in Romania. You will learn to construct efficient no-code and low-code workflows using simple drag-and-drop actions, effectively streamlining repetitive tasks across Office 365 and hundreds of other integrated applications.
Read more...

Power BI

 14 Hours

This live, instructor-led session in Romania (delivered online or onsite) is specifically designed for data professionals and business analysts ranging from beginner to intermediate levels, aiming to proficiently utilize Power BI for data analysis and visualization.

Following this training, learners will be capable of:

  • Comprehending the structure of Power BI and its central elements.
  • Linking with various data sources and executing data transformations.
  • Producing efficient visualizations and interactive dashboards.
  • Enacting row-level security and administering data access.
Read more...

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

 21 Hours
This practical course in Romania explores Power BI and Power Apps for visualizing data and automating workflows. Participants will learn to integrate data sources, construct interactive dashboards, and design low-code applications that enhance operational efficiency without requiring deep coding knowledge.
Read more...

Power BI: Basics to Advanced

 35 Hours

This instructor-led, live training in Romania (online or onsite) is tailored for data professionals ranging from beginner to intermediate levels who seek to create impactful data visualizations and dashboards with Power BI.

By the conclusion 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 guided training in Romania supports users across all skill levels in developing Power BI dashboards. Through practical exercises utilizing real-world datasets, participants will master data transformation, DAX, and visualization techniques, enabling them to effectively share compelling and interactive business insights.
Read more...

Power BI for Cash Flow and Payroll Analysis

 14 Hours
This live Power BI training in Romania empowers finance and HR professionals to visualize cash flow and payroll data. Attendees will master building interactive dashboards, applying DAX for financial metrics, and automating reporting workflows to enhance decision-making capabilities.
Read more...

Related Categories

Power BI
Power BI