Logo

Power Query & Power Pivot

Overview

“Do we use Power Pivot or Power Query?” – I get this question all the time when teaching Power BI classes.
 
The answer to the question, of course is – You use both!
 
Use Power Query to get, clean, shape and transform your data
Use Power Pivot to model your huge data, define calculations and establish relationship between tables/ queries.
 
This online live 1 day training is an introductory course to Power Query and Power Pivot. 
You are somewhat expected to have intermediate MS-Excel expertise and this includes working knowledge of the Pivot Table. 
You will be introduced to the basics of the both the power tools, connecting to data sources, learning to cleanse and edit the data, reconnect broken relationships, remodel data and putting them into Excel worksheets for further analysis.

Learning Outcomes

By the end of the Power Query & Power Pivot live session, you will be able to:
  • grasp the basics of the both the power query and power pivot tools
  • connect to data source
  • cleanse and edit the data
  • reconnect broken relationships
  • remodel data
  • put data them into Excel worksheets for further analysis

 

 


 

Who Must Attend

Data miners, data analysts, project managers, revenue managers, finance managers, journalists & those who are performing roles related to Business Intelligence (BI) in Excel.
This includes all back-end employees performing reporting, analysis roles wishing to explore better tools in handling data.
 
This course is suited for participants who are regular users of Excel already familiar with intermediate Excel functions and those who are already familiar with the Pivot Table.
 
Required software: Excel 2016 or above.
 
Required add-in to be set up in Excel: Power Query. Participants need to ensure Power Query is in operational condition before training commences.
 
Internet connection for participants required.

Course Details

Module 1: Introduction
Big data components
Big data and small data
Sources of big data
Big data structure
Big data analysis
Tools and technology
 
Module 2: An introduction to Table
Function of the Table
Creating the Table
Advance Filtering
Slicers
 
Module 3: Excel Power Query
What is Power Query? 
Connecting to data source & importing data
Creating a new query
Merging & appending queries
Automating consolidation of files
Creating an index
Changing data types, data format & replacing values
Merging columns
Unpivoting & pivoting columns
Replacing values in columns
 
Module 4: Excel Power Pivot
Getting started with Power Pivot
Importing data into Power Pivot
Understanding Power Pivot & Relationships
Creating Relationships between Tables
KPIs
Hierarchies
Data Analysis Expressions (DAX) language- SUM, SUMX, CALCULATE, RELATED, &&, FILTER
Visualizing data from Power Pivot

Methodology

Intensive hands-on approach on real-life case-study data. You will be using big data and conventional Excel datasets. Completion of dashboard projects are required to complete this course successfully
 
SETUP REQUIREMENTS
Required software: Excel 2016 Professional, Silverlight 
Internet connection for participants required.

Course Leader

NEXAM MOKHTAR
Corporate IT Trainer
Bachelor of Design (Industrial Design) | UPM
Certification in Physical Science | KPM Matriculation College

Nizam is experienced in handling participants from the corporate as well as the public sector.
Nizam has been actively training for the past 8 years in training and 10 year of corporate work experience.

He has also worked through various age group of participant and have a lot of experience in handling versatile participants.

Clients List

  • Pos Malaysia Berhad –MS Excel
  • Universiti Malaysia Pahang Holding –MS Excel,Word,Power Point
  • DRB Hicom-MS Excel,Word
  • Universiti Islam Antarabangsa-Custom Software
  • PLUS Berhad-MS Word,Power Point
  • OYL Manufacturing-MS Excel
  • FITEC-KD Max,InteriCAD
  • MTIB-AutoCAD
  • WISDEC-AutoCAD
  • Hitachi Transport-MS Excel
  • Trans Water-CADWorx
  • RMC-MS Word
  • F&N-MS Powerpoint
  • Penjom Gold Mine-MS Word
  • Proton-MS Power Point,Excel
  • ILSAS-MS Publisher
  • Politeknik Ibrahim Sultan-Adobe Photoshop,Illustrator,InDesign,Acrobat
  • Sime Darby-MS Power Point
  • BE Semiconductor Industry-MS Excel
  • Felda-MS Excel
  • Felcra-MS Excel
  • MINDEF-MS Excel
  • MiDF-MS Excel
  • Kuala Lumpur Airport Service-MS Word,Excel,Power Point
  • Jabatan Pertahanan Awam Malaysia-MS Publisher
  • Jabatan Alam Sekitar-MS Word
  • GE Manufacturing-Solidwork 2013
  • Epson Precision-MS Excel & MS Power Point
  • Celcom Axiata-MS Excel
  • Fabtronic-MS PowerPoint
  • Prolintass-MS Excel
  • Taylor’s College-MS Publisher
  • Petronas Gas Berhad-MS Excel
  • Institut Latihan Perindustrian Miri-Adobe Flash & Photoshop
  • Akzo Nobel-Microsoft Excel
  • Majlis Perbandaran Subang Jaya-Microsoft Word
  • Uchida MK-Kingsoft 2013
  • Jabatan Pengajian Kolej Komuniti-3D Studio Max 2010
  • UiTM Shah Alam-3D Studio Max2013
  • UiTM Machang-3D Studio Max2013
  • Central Cables Sdn Bhd-MS Excel
  • Walsin Precision Technologies Sdn Bhd-AuotCAD 2013
  • Dominant Opto Sdn Bhd-MS Excel
To contact Nexam, please feel free to email us at info@itrainingexpert.com or call +603 8074 9056 | +6012 6869 628

Testimonies

 “Vincent is an excellent trainer with excellent knowledge in the subject.” - Housekeeping Director, Westin Langkawi.
 
“Before this I never understood what Six Sigma was. Vincent crystalised it and cla so well rified it for me” - Manager, HSBC.
 
“I never knew Excel could do so much in forecasting.”

Investment

Normal fee
Sign up 1 pax
Pay before course starts
MYR 1,190.00
USD 350.00
Early Bird
Sign up 1 person
Pay 14 days before course starts
MYR 890.00 
USD 260.00
Group Fee
Sign up 3 pax or more
Pay 14 days before course starts
MYR 790.00 
USD 230.00

E-Certificate
Upon successful completion of this program, you will receive a e-Certificate of Achievement. 

Payment mode:

1. Online Payment by Credit card:  You can opt to register and pay online with our latest payment integration system through our website.

2. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.

Contact us: ITRAININGEXPERT GLOBAL PLT
Tel:+603 8074 9056 | +603 8082 3707
Mobile: +6012 6869 628 | +6018 2175 123
Email: info@itrainingexpert.com
Website: www.iTrainingExpert.com

 

Registration Details

Select Course

Select Registration Type



IN HOUSE ENQUIRY

Related Courses

  • Microsoft Power BI

    This is an in-depth 2-day course covering the important functions and tools of Microsoft Power BI, a business analytics tool for stunning visuals, extracting, transforming & analyzing data, collaborating & decision making.

    Read More

  • Microsoft Excel- Intermediate

    In today's fast- paced, technical business environment world, numbers meant everything. So it is of utmost importance that we the users, are able to manage the data - statistics, planning, reporting efficiently.

    Read More

  • Big Data Analytics & Visualization in Excel

    This Data Visualization and Business Intelligence with Excel course teaches participants how to manage their data using conventional methods and the latest Excel Power tools. Participants then use the art of story-telling to visualize their data on

    Read More

  • Financial Modelling For Forecasting, Budgeting & Financial Statements In Excel

    This 2 day financial modeling course offers you a sound understanding of both the principles of financial modeling and the practical application of these to real-world situations by using Excel to build financial models. Through this course, your w

    Read More

  • Record Excel Macro Like Pro

    This Record Excel Macro Like Pro course you'll learn how to record a macro, make changes in VBA, so that you can automate your routine tasks with a single mouse click. This training course is designed to equip you with core skill in reading Macro.

    Read More

  • Budgeting and Cash Flow Forecasting and Reporting

    Cash-Flow-Forecasting Course In Malaysia| Finance for Non Finance training program in Malaysia | Professional Finance Training courses in Malaysia | No 1 Finance for Non Financial Managers and Executives | best finance course | accounting short cours

    Read More

  • Business Analysis for Decision Making

    Business Analysis training Training in Malaysia Training In Asia Business Training Decision Making Training business analysis course analysis course business analysis Selangor Training

    Read More