UEN No.: 198802365N

Power Query and Power Pivot

COURSE details

Course Duration

8 HRS

Course Reference Number

N.A

Mode of Training

Online

COURSE OVERVIEW

Enhance your skills with our Microsoft Excel Power Query and Power Pivot Course. This training is designed for individuals looking to master advanced data preparation and analysis techniques using Excel. Learn how to automate data tasks and employ powerful data modelling tools like Power Query, Power Pivot, and DAX (Data Analysis Expressions). This course is ideal for professionals eager to improve their decision-making skills through efficient large dataset analysis.

By the end of this course, learners will be able to:

  • Apply Power Query to connect and import data from various sources
  • Perform data cleaning and transformation tasks, preparing data effectively for analysis
  • Apply Power Pivot to enrich and calculate data using DAX (Data Analysis Expressions)
  • Create relationships between different data tables and integrate these into a comprehensive data model within Excel.

Learning Unit 1: About Power Query

Understand and Learn to use Power Query to automate data preparation tasks like:

  • Get Data from multiple sources such as Different Worksheets and/or Different Workbooks, Text File, Web Data, etc.
  • Combine Data into One Worksheet either by Appending data or Merging data.
  • Clean and transform data e.g handling missing values, merging columns, etc. so the data is suitable for analysis.

Learning Unit 2: About Power Pivot

Understand and Learn to use Power Pivot to better analyse data by creating :

  • Data Model & Table Relationship for Linking Excel Tables.
  • Pivot Report with Data Model that enables user to produce insightful summary
  • Report from multiple Excel Tables.
  • Powerful DAX Formula and KPI which are new methods of analysing data.

This training is relevant to learners who need to perform Data Preparation and Data Analysis using Excel’s sophisticated built-in tools

  • Learners must be able to read, write, speak and listen to English at
    secondary school level.
  • Learners must be able to operate a personal computer, use keyboard and
    mouse.
  • Learners should have a working knowledge of Microsoft Excel 2016 &
    above.
Course Outline

Download the PDF below for a summary of the course outline.

COURSE FEES

Company Sponsored / Self Sponsored

Full Fee GST Nett Fee Payable (incl. GST)
$380.00 $34.20 $414.20

REGISTER TODAY

Select a date below

Looking at in-house training or have an enquiry? Contact us!

Related Courses

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

IT

8 HRS

Non-Certifiable

GET IN TOUCH WITH US

Have an enquiry? Feel free to connect via any of the channels below.

enquiry form

Leave a message

WhatSAPP

Chat on WhatsApp at
+65 8767 0614

Training hotline

Give us a call at
+65 6737 5761

SHARE THIS COURSE
Main Category
IT COURSES
Generative AI Series
SOFT SKILLS COURSES
COURSE MONTH
Certification
COURSE LEVEL
Course Duration