Data Analysis _ Power Pivot – Gbt Solutions

Data Analysis _ Power Pivot

Professional Microsoft Training – Power Pivot

This Microsoft Excel – Power Pivot two days training course is design to equip delegates with advanced skills of data analysis using power Pivot business intelligence, connecting data from multiples data tables.

Getting started with PowerPivot

  • 1. Start Excel & launch the PowerPivot window
  • 2. Navigating the PowerPivot window
  • 3. Exploring the PowerPivot tab and field list in Excel

Adding data to PowerPivot

  • Data sources and types supported in PowerPivot workbooks
  • Importing data (from pre-prepared file)
  • Add Data by using Excel Linked Tables

Data; formatting and layout

  • Creating, deleting a table
  • Rename a Table or Column
  • Set the Data Type of a Column
  • Hide or Freeze Columns
  • Undo or Redo an Action
  • Sorting and filtering data in a table

Calculations in PowerPivot

  • Overview of Data Analysis Expressions (DAX) language
  • Building Formulas for Calculated Columns and Measures
  • Understanding the Use of Relationships and Lookups in Formulas
  • Understanding Aggregations in Formulas
  • Filtering Data in Formulas
  • Recalculating Formulas

Preparing data for analysis

  • Working with Tables and Columns
  • Filtering and Sorting Data
  • Creating Relationships Between Tables
  • Creating and Working with calculations

PowerPivot and relationships

  • Understanding Relationships
  • Create a Relationship Between Two Tables
  • View and Edit Relationships
  • Delete Relationships
  • Troubleshoot Relationships

Creating PivotTables, Charts & Reports

  • Create a PivotTable or PivotChart Report
  • Create a Reporting Services Report with PowerPivot Data
  • Create a Measure in a PivotTable or PivotChart
  • Create and Change the Field Layout in a PivotTable or PivotChart Report
  • Delete a PivotTable or PivotChart Report
  • Filter Data using Slicers
  • Work with Relationships in PivotTables
  • Change the Display Language

Overview of Key Performance Indicators (KPI's) in PowerPivot