Mastering PowerQuery
Gain mastery over data transformation and preparation with our comprehensive 6-hour course, designed for data analysts, business intelligence professionals, and data enthusiasts. Whether face-to-face or virtual, learn to import, manipulate, and refine data efficiently using PowerQuery.
Audience
This course is designed for data analysts, business intelligence professionals, and anyone working with data who wants to enhance their skills in data transformation and preparation using PowerQuery.
Pe-requisites
Attendees should have a basic understanding of data concepts and be familiar with spreadsheet software like Microsoft Excel.
Duration
6 hoursDelivery Method
Face to face or VirtualCourse Objectives
By the end of this one-day workshop, participants will have mastered PowerQuery, enabling them to efficiently import, transform, and prepare data for analysis, improving their overall data manipulation capabilities.
Course Content
- PowerQuery Basics
- Understanding the role of PowerQuery in data transformation.
- Exploring the PowerQuery interface and basic functionalities.
- Data Import and Connection:
- Importing data from various sources, including Excel, databases, and web data.
- Establishing connections and managing queries.
- Basic Data Transformation Techniques:
- Applied Steps
- Cleaning and shaping data for analysis.
- Introduction to basic transformations such as filtering and sorting.
- Merging and Appending Queries:
- Combining data from different sources.
- Appending and merging queries for expanded datasets.
- Combining files from a Folder
- Join Kinds
- Understanding Database Relationships
- Aggregating data using simple functions.
- Grouping data to analyze patterns and trends.
- Introduction to Parameters:
- Understanding parameterized queries.
- Implementing basic parameters for flexible data transformations.
- Error Handling:
- Basic error handling techniques in PowerQuery.
- Troubleshooting common issues in data transformation.
- Best Practices for Efficiency.
Stakeholder Management: Influence, Engagement and Control
Develop advanced stakeholder management skills to navigate complex environments, influence without authority, and sustain effective engagement across the full project or change lifecycle.
Stakeholder Management Essentials
Build the skills to identify, analyse, and engage stakeholders effectively, driving better outcomes across projects, change initiatives, and operational delivery.
How to be Assertive
Develop the confidence to communicate clearly, set boundaries, and handle challenging interactions professionally while maintaining empathy and positive relationships.
Becoming an Effective Manager
Develop the skills, confidence and strategies needed to lead people, manage performance, and build a high-performing team in your organisation.
Finance for Non-Financial Managers
Gain the financial confidence to interpret accounts, manage budgets, and make informed decisions that drive profitability and organisational success.
Strategy for Advanced Senior Leaders
Strengthen strategic thinking and decision making using practical frameworks to evaluate options and drive organisational performance.
Influencing Tactics
Build practical influencing skills to gain buy in, strengthen relationships and shape thinking without relying on authority.
Introduction to Interview Skills (For Interviewers)
Build confidence and structure in interviewing through practical techniques for fair, consistent and effective candidate assessment.
Advanced Interview Skills
Develop fair, structured and inclusive interviewing skills to improve candidate experience and selection decisions.
From Policy to Practice: Implementing Menopause Support at Work
Turn menopause policies into practical, consistent workplace support through confident conversations and effective implementation.
