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.
Course Outline
Introduction to Power Query
- Overview of the Power Query interface.
- Understanding queries and applied steps.
- Navigating integrations within Power BI and Excel.
Connecting to Data Sources
- Importing Excel, CSV, and text files.
- Working with folders and structured datasets.
- Connecting to online and database sources.
Fundamentals of Data Cleaning
- Identifying and removing errors and duplicates.
- Filtering, sorting, and shaping data.
- Handling missing values.
Transformations and Data Shaping
- Splitting and merging columns.
- Pivoting and unpivoting data.
- Grouping and aggregating data.
Combining Queries
- Distinguishing between appending and merging queries.
- Understanding join types and data structure considerations.
- Modeling multi-source datasets.
Introduction to M Language
- Understanding M formulas.
- Editing queries using the Advanced Editor.
- Writing custom transformations.
Automation and Refresh
- Creating reusable transformation workflows.
- Configuring refresh schedules.
- Managing dependencies and optimizing query performance.
Advanced Techniques
- Parameterizing queries.
- Utilizing functions in M.
- Best practices for scalable transformation pipelines.
Summary and Next Steps
Requirements
- A foundational understanding of spreadsheet-based data work.
- Prior experience with basic data analysis tasks.
- Familiarity with common file formats, such as CSV and Excel.
Target Audience
- Data professionals tasked with cleaning and preparing datasets.
- Business analysts managing recurring data workflows.
- Professionals involved in data reporting and process automation.
14 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
Useful and practical, the knowledge gained in training can be applied immediately.
