Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Introduction to 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
- Importing data from Excel, CSV, and text files
- Handling folders and structured datasets
- Linking to online and database sources
Basics of Data Cleaning
- Eliminating errors and duplicate entries
- Filtering, sorting, and reshaping data
- Addressing missing values
Data Transformations and Shaping
- Splitting and merging columns
- Executing pivots and unpivots
- Grouping and aggregating information
Query Integration
- Differentiating between appending and merging queries
- Considerations for join types and data structures
- Modeling datasets from multiple sources
Getting Started with M Language
- Comprehending M formulas
- Modifying queries via the Advanced Editor
- Developing custom transformations
Automation and Refresh Procedures
- Developing reusable transformation workflows
- Setting up refresh schedules
- Overseeing dependencies and query performance
Advanced Methodologies
- Implementing query parameters
- Utilizing functions within M
- Adopting best practices for scalable transformation pipelines
Recap and Future Directions
Requirements
- A foundational understanding of data work using spreadsheets
- Prior experience with basic data analysis tasks
- Familiarity with common 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
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
