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 with 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
Data Cleaning Fundamentals
- Removing errors and duplicate entries
- 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
- Join types and considerations for data structure
- Modeling datasets from multiple sources
Introduction to M Language
- Understanding M formulas
- Editing queries via 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
- Familiarity with spreadsheet-based data work
- Experience performing basic data analysis tasks
- Knowledge of common file formats such as 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
14 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -
