Get in Touch
 Duration 14 hours

Course Outline

Getting Started with Power Query

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

Establishing Data Connections

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

Essentials of Data Cleaning

  • Eliminating errors and duplicate entries
  • Applying filters, sorting, and data shaping techniques
  • Addressing missing values effectively

Data Transformation and Shaping

  • Splitting and merging column data
  • Utilizing pivot and unpivot operations
  • Grouping and aggregating data sets

Integrating Multiple Queries

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

Overview of the M Language

  • Comprehending M formulas
  • Modifying queries via the Advanced Editor
  • Developing custom transformation logic

Automation and Refresh Mechanisms

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

Advanced Strategies

  • Implementing query parameters
  • Applying functions within M
  • Best practices for scalable transformation pipelines

Recap and Future Directions

Requirements

  • A foundational grasp of spreadsheet-based data operations
  • Experience performing basic data analysis tasks
  • Familiarity with standard file formats, including CSV and Excel

Target Audience

  • Data professionals tasked with cleaning and preparing datasets
  • Business analysts managing recurring data workflows
  • 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-19 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

Power Query for Data Transformation and Automation

2026-12-03 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

Power Query for Data Transformation and Automation

2026-12-17 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

Power Query for Data Transformation and Automation

2026-12-31 09:30
14 hours
Green Heart Complex
338 EUR (Online)
338 EUR (Classroom)

Related Courses

Advanced Power BI

 21 Hours

This instructor-led live training in Serbia (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 Serbia prepares intermediate professionals with advanced Power BI competencies, encompassing complex data modeling, DAX computations, and interactive visualization methods to construct effective business intelligence solutions.
Read more...

PL-300: Microsoft Power BI Data Analyst

 21 Hours
This instructor-led live training in Serbia covers the core concepts and hands-on fundamentals of Power BI data analysis. Participants will learn to model, visualize, and analyze data effectively. Build practical skills that apply directly to real-world business needs.
Read more...

Analyzing Data with Power BI

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

Data Analysis and Dashboarding with Power BI

 7 Hours
This live session on Serbia enables novice and intermediate users to master data analysis via Power BI. Learners will gain the skills to prepare data, design interactive dashboards, and securely share reports, equipping them with practical competencies 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 Serbia (online or onsite) targets beginner-level professionals who want 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 Serbia (online or onsite) targets data analysts who wish to learn techniques for preparing data in Excel and 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

Course Format

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

Course Customization Options

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

Power BI Dashboards

 14 Hours
Learn to construct interactive dashboards using Power BI. Master data transformation, visual report creation, and sharing management in Serbia. This course addresses core competencies such as data connectors, advanced filtering, and best practices for robust business intelligence and cross-organizational access.
Read more...

Power BI online

 14 Hours
This Serbia training focuses on Microsoft Power BI online, guiding you through report publishing, workspace management, and data security protocols. You will learn to utilize Dataverse, configure data gateways, and automate updates, enabling you to share insights effectively with colleagues in a cloud-based environment.
Read more...

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

 7 Hours
Prepare for the Microsoft PL-300 certification through this instructor-led training in Serbia. Specifically designed for financial analysts, the course encompasses data preparation, modeling, KPI development, and dashboard visualization using Power BI. Acquire practical proficiency through hands-on labs and exercises focused on exam success.
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 databases. Additionally, the course explores implementing robust security standards and policies across the Power BI ecosystem, covering datasets and groups. It also addresses the management and deployment of reports and dashboards for effective sharing and content distribution.

Read more...

Power Apps

 21 Hours
This live, instructor-led training in Serbia explores the core concepts and practical fundamentals of Power Apps. Participants will learn to build hands-on, no-code applications utilizing templates, data connectors, and AI elements to enhance everyday business processes and workflows.
Read more...

Microsoft Power Automate

 14 Hours
Enhance your productivity by mastering Microsoft Power Automate in this practical training held in Serbia. You will learn to design efficient no-code and low-code workflows using simple drag-and-drop actions, optimizing repetitive tasks across Office 365 and hundreds of other integrated applications.
Read more...

Power BI

 14 Hours

This instructor-led, live training in Serbia (online or onsite) is aimed at beginner-level to intermediate-level data professionals and business analysts who wish to effectively use Power BI for data analysis and visualization.

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

  • Understand Power BI's architecture and its core components.
  • Connect to various data sources and perform data transformations.
  • Create effective visualizations and interactive dashboards.
  • Implement row-level security and manage data access.
Read more...

Related Categories

Power BI
Power BI