catraining

 

Microsoft Partner
Microsoft Excel 2013 Power Pivot and Power View

Audience: This course is designed for experienced users of Excel Pivot Tables wishing to further their knowledge in Excel Power Pivot. Microsoft Power Pivot is a Microsoft Excel 2013 Add-in used for creating Business Intelligence (BI) reports based on large data sets inside the familiar environment of Excel Pivot Tables. Microsoft Power View creates visual reports from Excel data models. Both Power Pivot and Power View are only available in the Professional Plus editions of Microsoft Office.

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Excel Power Pivot training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

New Prices from 19th February 2018 All Vouchers now include a Retake Voucher

Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

View Scheduled Public Courses

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

 

reaining course

 

After completing this course, students will be able to:
    • Navigate the Power Pivot window
    • Specify source data for Power Pivot
    • Preparing data for analysis
    • Format data
    • Create Power Pivot Relationships
    • Enter Power Pivot Calculations using DAX
    • Create Key Performance Indicators (KPI's)
    • Visualise data using Power View
    • Create Power View Charts and Maps

  • Course Content
    print this page
    Module 1: Introduction to Power Pivot
    • Enabling the Power Pivot Add-in
    • Opening the Power Pivot window
    • Navigating the Power Pivot window
    • Exploring Power Pivot tabs and field list
    Module 2: Source data for Power Pivot
    • Data sources and types supported by Power Pivot workbooks
    • Importing data
    • Adding tables to a Power Pivot model
    • Linking to Excel Tables
    Module 3: Preparing data for analysis
    • Working with Tables and Columns
    • Filtering and Sorting Data
    • Creating Table Relationships
    • Creating calculations
    Module 4: Formatting Data
    • Creating and deleting a table
    • Renaming a Table or Column
    • Setting the Data Type of a Column
    • Hiding and Freezing Columns
    • Sorting and filtering table data
      Module 5: Power Pivot Relationships
      • Understanding Relationships
      • Creating Relationship between Tables
      • Viewing and Editing Relationships
      • Deleting Relationships
     
    Module 6: Power Pivot Calculations
    • The Data Analysis Expressions (DAX) language
    • Creating Formulas for calculated columns and fields
    • Using DAX operators
    • Review of DAX functions
    • Using relationships and lookups in formulas
    • Using aggregate functions
    • Using filters in aggregate functions
    • Recalculating Formulas
    Module 7: Key Performance Indicators (KPI's)
    • Defining a KPI
    • Creating the KPI calculation
    • Setting the icon style and threshold values
    • Editing a KPI
    Module 8: Visualising Data using Power View
    • Starting out with Power View
    • Creating Tables and Matrices
    • Creating Cards
    • Creating Tiles
    • Filtering Power View objects
    • Formatting Power View objects
    Module 9: Power View Charts and Maps
    • Different types of Power View charts
    • Creating Chart multiples
    • Creating Power View Maps
    • Creating maps with multi value series
     
      Microsoft

Call us now for further information Tel:08001601666