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
- 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
- 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
Trainer
SENTHIVALU KRISHNASAMY
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.
Services
- Corporate Training
- Competency Assessment
- e-Learning
- Platform Development
Help
- Privacy Policy
- Contact Us
- News