Power BI #1

Automate your data preparation with Power Query

Learn how to clean, connect, and transform your data automatically with Power Query, a free tool in Excel and Power BI

Best course materials ever

60-min personalized coaching

Automated workflows

$1,580

About this course

Over 50% of the work in data is collecting and cleaning it. But that’s only true if you don’t use the right tool for it.

In this course, you’ll learn how to work with Power Query, a free tool within Excel and Power BI that lets you:

  • connect to multiple data sources for easy updating

  • add the latest data to existing data with just a click

  • combine multiple data sources without VLOOKUP(), INDEX() or MATCH()

  • clean, shape, and transform raw data into outputs exactly the way you want them 

  • and repeat these steps automatically each time

You’ll be mad at how easy it can be.

Who this is for





If you check any of these boxes, this course is for you.

Skills you’ll gain

  • update and connect data with one click

  • combine and transform data without formulas

  • create custom workflows for reuse

Syllabus

    • Learn what Power Query can do

    • Learn how to use it by asking the right questions

    • Use "Why-What-then-How" framework to translate business needs to concepts, and then to specific implementation steps

    • Connect to data sources

    • Load data to destinations based on use cases

    • Consolidate data from different .csv and .xlsx files

    • Extract date from filename and add to data

    • Append new data to existing data with just a click

    • Bring in only data that you need

    • Transform it into tables for easy manipulation

    • Future-proof your data cleaning steps

    • Join data tables together

    • Summarise data at an aggregate level suitable to reporting

    • Categorise data conditionally

    • Understand the basics of M language

    • Learn best practices to keep queries organised for easy reference and access

    • Read and edit M language

    • Turn a set of data preparation steps into a function for reuse

    • Debug custom function

    • Automatically generate date table from transaction data with M language

    • Date table to be subsequently used with DAX formula in Power BI #2 to automate calculation of year-on-year changes

Download a detailed copy of the syllabus here.

Our approach

Save hours in self study

No fluff, no filler. We’ve been through the data trenches before, and our training is carefully crafted to empower you with what you need.

Gain not just a tool, but a tool box

Anyone can give you tips and tricks; we’re interested in giving you the conceptual understanding you need, because that’s what true learning is.

Surprisingly engaging

It’s useful, it’s challenging, and it’s fun. We know, it’s not what comes to mind when it comes to training. But we’re certain we can change your mind.

Join us in our next training session

Date:

Time:

Location:

Fees:

[FULL] 1 & 2 August 2024 (Thursday & Friday)

[OPEN] 12 & 13 September 2024 (Thursday & Friday)

9.30am - 5.30pm (1 hour lunch break)

Frasers Tower

SGD $1,580

Course options

If you’re looking to truly level up your data skills, we’ve got you covered.

Each of our courses is targeted at a specific phase of your analytics workflow. With our Power BI Duo or Trio options, you’ll be able to tackle any problem you encounter.

  • Duo Package

    Power BI #1 and #2

    $3,160

      For junior or mid-level analysts focused on setting up and maintaining data processes, as well as cleaning and analyzing data for ongoing reporting

    • Power Query, Power Pivot, and DAX
    • Automated workflows
    • Best course materials
    • 2 x 2-day live training
    • 120 minutes personalized coaching

  • Trio Package

    Power BI #1, 2, and 3

    $4,540 (save $200!)

      For senior analysts and managers who want to deepen their analytical skills to bridge the gap between data and strategy

    • Everything in Duo package, plus:
    • Advanced dashboards
    • Visual design principles
    • 3 x 2-day live training
    • 180 minutes personalized coaching

    • Course options

    If you’re looking to truly level up your data skills, we’ve got you covered.

    Each of our courses is targeted at a specific phase of your analytics workflow. With our Power BI Duo or Trio options, you’ll be able to tackle any problem you encounter.

    Power BI Single

    $1,580

    Choose between Power BI #1, or #2, or #3

  • ✔    Automated workflows
  • ✔    Best course materials
  • ✔    1 x 2-day live training
  • ✔    60 minutes personalized coaching

    • Register

    Power BI Duo

    $3,160

    Power BI #1 and 2

  • ✔    Everything in Power BI Single, plus:
  • ✔    Power Query, Power Pivot, and DAX
  • ✔    2 x 2-day live training
  • ✔    120 minutes personalized coaching

    • Register

    Power BI Trio

    $4,540

    Power BI #1, 2,and 3

  • ✔    Everything in Power BI Duo, plus:
  • ✔    Dashboards and visual design
  • ✔    3 x 2-day live training
  • ✔    180 minutes personalized coaching

    • Register

    FAQ

    • Power Query is a tool within the Power BI platform that can significantly cut down the time and effort you spend on consolidating and cleaning data.

      It does so by automating all the steps that you take to prepare, clean, re-shape, and consolidate your raw data via a user-friendly interface.

      90% of typical data cleaning work can be done using the user interface. They include the tasks such as

      • setting data types

      • removing trailing and leading spaces

      • filtering, replacing values

      • extracting specific parts of the data

      • removing unnecessary columns and rows

      • split text to columns

      • creating additional calculated or conditional columns

      Appending new data is a drag-and-drop, and the workflow, once set up, can be repeated - just click to refresh. It’s that easy.

    • Think of Power Query as a tool within a toolbox. The toolbox itself is Power BI, which has tools (such as Power Query, Power Pivot, and visualisation) suited for different types of data tasks.

      Power Query is also available as a free add-in in Excel.

      Check out our blog for a more in-depth understanding on Power Query, Power Pivot, DAX, and Power BI.

    • Do you spend a lot of time copying and pasting raw data from other files into a single consolidated file?

      Do you go through data cell by cell to standardise them?

      Do you apply filters and do more copying and pasting with those selected data?

      Or perhaps you write long formulas with vlookup(), index(), and match() to summarise data?

      These are simple data cleaning and preparation tasks that can be easily handled by Power Query.

      Check out this article for a better understanding of the different data tasks that an analyst does and which course can help you most.