Big Data with Power Query & PowerPivot

Big Data with Power Query & PowerPivot Training Course Big Data with Power Query & PowerPivot
By TED Integrated
Business Intelligence:

Manipulating Big Data Using Microsoft Excel Power Query & PowerPivot

“Learn how to turn your organization's Big Data into profitable business insights with Power Query and PowerPivot.”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Manipulating Big Data Using Microsoft Excel Power Query & PowerPivot
Training Category:
Information Technology
Target Audience:
Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.
Duration:
2 Days
Public Training Events
Jun 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 26 Jun 2019 - Thu 27 Jun 2019
9:00AM - 5:00PM

Fee Per Person:
RM2,120.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Jul 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 15 Jul 2019 - Tue 16 Jul 2019
9:00AM - 5:00PM

Fee Per Person:
RM2,120.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Aug 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 19 Aug 2019 - Tue 20 Aug 2019
9:00AM - 5:00PM

Fee Per Person:
RM2,120.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Sep 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 12 Sep 2019 - Fri 13 Sep 2019
9:00AM - 5:00PM

Fee Per Person:
RM2,120.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Oct 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Wed 09 Oct 2019 - Thu 10 Oct 2019
9:00AM - 5:00PM

Fee Per Person:
RM2,120.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Nov 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Mon 18 Nov 2019 - Tue 19 Nov 2019
9:00AM - 5:00PM

Fee Per Person:
RM2,120.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Dec 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 12 Dec 2019 - Fri 13 Dec 2019
9:00AM - 5:00PM

Fee Per Person:
RM2,120.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Workshop
  • Computer Lab Work
  • Case Studies
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

Big Data is a term that has been widely used in the modern days to describe large and complex data sets that require analysis to ease decision making and optimize business performance. As big data in company is growing, the challenge of IT personnel, Business Intelligence, Business Analyst and Data Analysts is to analyze big data which is so complex and convert to meaningful information for better decision making. This two days training program helps you to gain insights out of the Big Data using Power Query and PowerPivot 2010/2013.

Power Query is an ideal data transformation and manipulation tool for Microsoft Excel. If you frequently use Excel to transform, enrich, append or merge data in your daily work, then this tool is right for you.

PowerPivot is an add-on for Microsoft Excel 2010 and 2013. It enables you to import your big data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, calculated columns and measures using formulas, build Pivot Tables and Pivot Charts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance

Course Objectives ›

During the training, you will use Power Query to

  1. Extract data from different sources and databases
  2. Automate the data transformation and data cleansing processes
  3. Integrate data from multiple sources into a single source
  4. Merging data without the need for VLOOKUP, INDEX & MATCH.
  5. Perform calculation to aggregate data.

Besides that you also use PowerPivot to:

  1. Create relationships between multiple tables.
  2. Perform calculations in PowerPivot.
  3. Create Pivot tables and Pivot charts
  4. Discover to Data Analysis Expression Language

Prerequisites ›

Delegates should be proficient users of Excel and be experienced in creating Excel Pivot Tables and Pivot Charts.

Course Outline ›

DAY 1

Using Power Query

  • Introduction to Power Query
  • Appending data
  • Merging Table
  • Transforming Data
  • Power Query Formulas
  • Cleaning Dirty Data
  • Databases as sources
  • Exchange as a data Source
DAY 1

Using PowerPivot

  • Import external data from multiple sources.
    • Client database
    • Excel tables
    • CSV files
  • Handling massive data from multiple sheets.
  • Create relationships between multiple tables.
  • How to create a user friendly models
  • Perform calculations in PowerPivot
    • Calculated columns.
    • Measures (Calculated fields)
  • Create Pivot Tables and Pivot Charts.
  • Introduction to Data Analysis Expression language (DAX)

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,
Contact Us

"Hi, I'm your Contact Assistant! I'll help you to reach the right party for the right information. Click me to get started!"

Contact Assistant