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
Getting Started with Power Query
- Overview of the Power Query interface
- Conceptual understanding of queries and applied steps
- Exploring integrations with Power BI and Excel
Establishing Data Connections
- Importing data from Excel, CSV, and text files
- Managing folder structures and organized datasets
- Linking to online services and database sources
Essential Data Cleaning Techniques
- Eliminating errors and duplicate entries
- Applying filters, sorting, and reshaping data structures
- Handling missing or null values effectively
Data Transformation and Structuring
- Splitting and merging columns for optimal analysis
- Utilizing pivot and unpivot operations
- Grouping and aggregating data points
Query Integration
- Differentiating between appending and merging queries
- Selecting appropriate join types and considering data structures
- Constructing models from multiple data sources
Introductory M Language Concepts
- Deciphering M formulas
- Modifying queries via the Advanced Editor
- Developing custom transformation scripts
Automation and Refresh Management
- Designing reusable transformation processes
- Setting up automated refresh schedules
- Overseeing dependencies and optimizing query performance
Advanced Methodologies
- Implementing parameters within queries
- Applying functions in M language
- Adhering to best practices for scalable transformation pipelines
Recap and Future Directions
Requirements
- A foundational grasp of spreadsheet-based data operations
- Hands-on experience with fundamental data analysis tasks
- Knowledge of standard file formats including CSV and Excel
Target Audience
- Data specialists requiring efficient methods for cleaning and preparing datasets
- Business analysts managing recurring data processing workflows
- Individuals involved in data reporting and operational automation
Testimonials (1)
Power Automate can reduce human error and save time