Opens in a new tab
capital training power query training course

Mastering PowerQuery

COURSE

Course Preview

A six-hour course on Mastering Power Query — import, transform, merge and prepare data for analysis with confidence and best practices.

Audience

This six-hour course is for anyone preparing data with Power Query, including:
  • Data analysts and BI professionals

  • Finance and operations teams

  • Project managers and PMO

  • Anyone preparing data in Excel

    • Course Outline

      This course is structured into a series of focused sessions, each designed to build knowledge, develop practical skills and support effective application in the workplace.
    • PowerQuery Basics

      Role of Power Query and the interface.

    • Data Import and Connection

      Import from Excel, databases and web.

    • Basic Data Transformation

      Applied Steps, filtering and sorting.

    • Merging and Appending Queries

      Combine sources, files from folders and join kinds.

    • Aggregating and Grouping Data

      Analyse patterns and trends.

    • Introduction to Parameters

      Parameterised queries for flexibility.

    • Error Handling and Best Practices

      Troubleshoot issues and apply efficiency tips.

    Learning Outcomes

    • Understand the role of Power Query in data transformation
    • Import data from various sources including Excel, databases and web
    • Apply basic transformations such as filtering, sorting and cleaning
    • Work with Applied Steps to shape data for analysis
    • Merge and append queries to combine data from different sources
    • Combine files from a folder and apply different join kinds
    • Understand database relationships
    • Aggregate and group data using simple functions
    • Use parameters for flexible data transformations
    • Handle errors and troubleshoot common transformation issues
    • Apply best practices for efficient queries

    Enquire About This Course

    Tell us a little about your requirements and we’ll tailor the right solution for you.

    Speak to a Training Advisor

    Speak directly with a training advisor for quick guidance and recommendations.

  • CALL US   01428 741482
  • Trusted by organisations across the UK and Beyond

    Capital Training is an LPI Gold Standard Accredited Learning Provider, recognised for delivering high-quality, impactful training. With over 30 years’ experience, we support organisations across the UK and beyond with trusted, professional development solutions.

    LPI Accreditation 2024 logo

    Share This Course

    Know someone who would benefit from this course? Share it with your network or colleagues.

  • DOWNLOAD FULL OUTLINE

    Access the full course outline

    Just a few details and you’ll get instant access to the full course outline — completely free.

    Download the full course outline for detailed information on objectives, session content, and learning outcomes.