Data Analysis With Pivot Table

About Data Analysis With Pivot Table

Too much data on your excel sheet leaving you stressed and confused? Master Pivot Tables to help you make sense of your data. Data Analysis made easy.

Course Duration

2 Days

Who Should Attend This Course?

Advanced Excel users who are familiar with Pivot Table, Formulas, and Functions. The recommended version for MS Excel is 2013 or 2016

What Will You Learn?

At the completion of the training, candidates will be able to:
  • Create Pivot Tables
  • Create a Pivot Chart
  • Working with slicers
  • Work with Data Analysis Expressions (DAX)
  • Create Business Intelligence reports
  • Create a report using the PowerPivot interface
  • Create Dashboards using PowerPivot

Programme Outline

Module 1: Preparation Analysis of Data Source
  • List of data sources
  • Relational database
  • Multidimensional sources
  • Data feeds
  • Text files
  • Purpose of importing data from a variety of sources
  • Introducing Data Analysis Expressions (DAX)
  • Adding a data source in a single worksheet from a variety of data sources
  • E-commerce customer activity data importing
  • Importing data from the SQL Server
  • Importing data from a flat file
  • Sales analysis data importing
  • Importing data from the MS Access database
  • Importing data using a SQL query
  • Importing data based on copy and paste
  • Importing data using an Excel-linked table
  • Data refresh
  Module 2: Data Model
  • General overview of a data model
  • A data model in PowerPivot
  • Sales analysis data model design process
  • Creating a data relationship for the sales analysis data
  • Adding a new column using DAX for sales analysis data
  • Creating hierarchies for sales analysis data
  • Viewing the logical design data model of sales analysis
  • E-commerce data model design process
  • Splitting the User table for e-commerce data analysis
  • Creating relationships
  • Adding a new calculated column using DAX and creating hierarchies for e-commerce data
  • Viewing the logically designed data model for e-commerce data analysis
  Module 3: Dashboard and Reporting
  • A general overview of BI reports creation
  • The importance of reports
  • Dashboards
  • Business scorecards
  • Creating a report using the PowerPivot interface
  • Creating simple reports in PowerPivot
  • Creating a PivotTable
  • Creating a PivotChart
  • Creating a PivotTable with Slicers
  • Creating PivotChart with Slicers
  • PowerPivot Dashboards
  • Creating key performance indicators
  • Creating a KPI using a Perspective



Certified Assessor for Skills Training under “Jabatan Pembangunan Kemahiran” (JPK), Ministry of Human Resources, Malaysia

About Us

Elev8 Asia Sdn Bhd is a HRDF Certified Training Provider in Malaysia which founded in year 2015.



© Copyright 2020 Elev8 asia sdn bhd - All Rights Reserved