Power Query & Power Pivot

Learn Excel Power Query and Power Pivot Course Singapore

Singapore Excel Power Query and Power Pivot Objectives

This in-depth two days Excel Power Query and Power Pivot training course introduces ways to create and work with Pivot Tables to look, organize and summarizes, your data in different ways. Discover how to perform different type of calculations with Pivot Table Data. Pivot Table – a powerful analysis tool in excel!

Who Should Attend This Microsoft Excel Power Query and Power Pivot Course?

Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using Power Pivot and Power Query.

Pre-requisite for Excel Power Query and Power Pivot Course:

To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables.

Data Analytics with Excel Power Query and Power Pivot Training Course Outline

Day 1: Power Query Training Course Outline

Lesson 1: Introduction To Power Query

• Introduction
• Installing Power Query

Lesson 2: Data Loading From Sources

• Working with CSV files, Text Files and Excel Files
• Working with other file types

Lesson 3: Working With Folders And Multiple Files

• Connecting to a Folder of Files
• Combining Data from Multiple Files

Lesson 4: Filtering And Managing The Columns

• AutoFiltering
• Removing Duplicate Values
• Moving, Removing, Splitting, Merging Columns

Lesson 5: Working With Tools

• Text-Specific Tools
• Number-Specific Tools
• Date-Specific Tools
• Adding index

Lesson 6: Table Transformations

• Unpivoting Columns to Rows
• Pivoting the values
• Transposing a Table

Lesson 7: Modifying Queries

• Appending Queries
• Workbook Queries
• Merging Queries

Day 2: Power Pivot Training Course Outline

Lesson 1: Getting Started With Power Pivot

• Enable and Navigate Power Pivot
• Manage Data Relationships

Lesson 2: Visualizing Power Pivot Data

• Create a Power Pivot Report
• Create Calculations in Power Pivot

Lesson 3: Working With Advanced Functionality In Power Pivot

• Create a Key Performance Indicator
• Work with Dates and Time in Power Pivot

Appendix A: Commonly Used DAX Functions

• Unpivoting Columns to Rows
• Pivoting the values
• Transposing a Table