Course Info
Power Pivot is an add-in for Microsoft Excel 2010 and 2013 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyse the data so that you can make timely business decisions without requiring IT assistance.
What Will I Learn From This Course?
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 Power Pivot
- Calculated columns.
- Measures (Calculated field)
Create PivotTables and Pivot Charts.
Introduction to Data Analysis Expression language (DAX)
Target Audience
Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.
Pre-requisites
Delegates should be proficient users of Excel and be experienced in creating Excel PivotTables and Pivot Charts.
At Course Completion:
Upon successful completion of this course, the delegate should be proficient with PowerPivot and have the necessary skills to implement PowerPivot applications, manipulate data and perform data analysis.
Course Outline for This Programme
Module 1: Introduction to PowerPivot
a. What is Power Pivot
b. Limitation of the normal Pivot Table
c. The Power Pivot Interface
Module 2: Handling Data in Power Pivot
a. Importing Data
b. Creating Linked Tables
c. Managing Relationships
d. Creating Your Power Pivot Table
Module 3: Power Pivot at Work
a. Creating and customising reports that are user friendly
b. Formatting your Numbers
c. Customising your data model
d. Performing calculations with calculated columns
e. Performing calculations with calculated fields
f. Working with dates
g. Using slicers
Module 4: Introduction to DAXS
a. DAXS operators
b. Calculated Columns
c. Calculated Fields
d. Date calculations
Curriculum is empty
