Business Intelligence with PowerPivot

Business Intelligence with PowerPivot Business Intelligence with PowerPivot
By TED Integrated
Course Title:
Business Intelligence with Microsoft® Excel 2010 & PowerPivot – Level 2
Training Category:
Information Technology
Target Audience:
Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.
Duration:
1 Day

Course Introduction ›

This is a 1-day Level 2 Business Intelligence training program with Microsoft Excel 2010 and PowerPivot. Participants are encouraged to attend level 1 training if they do not have the basics covered in level 1. This level 2 Business Intelligence training will be covered more on Data Analysis Expressions (DAXS) Language and creating hierarchies in data model.

Course Objectives ›

During the training, you will use Power Pivot to:

  • Perform more advance calculations in Power Pivot using DAXs functions
  • Create a user friendly model
  • Create hierarchies
  • Build dashboard

Prerequisites ›

Delegates should be proficient users of Excel and experienced in creating Excel PivotTables & PivotCharts and also be familiar with Functions & Formulas.

Course Outline ›

DAY 1

Recap on PowerPivot

This module briefly goes through what is a power pivot is all about. How to pull data into Power Pivot whether it's an external source, text files, Excel data and other sources. It also shows you how to build relationships between tables which is vital to data analysis.

Data Analysis Expressions (DAXS) Language

The Data Analysis Expressions (DAX) language is a new PowerPivot formula language that allows users to define custom calculations in PowerPivot tables (calculated columns and measures / calculated fields). Delegates will be taught the following functions and more;

  • RELATED function
  • DIVIDE function
  • DISTINCTCOUNT function
  • FILTER function
  • SUM, SUMX function
  • COUNT, COUNTX function
  • CALCULATE function
  • ALL function
  • Time Intelligence function
  • Creating a date table

Creating Hierarchies in Data Model

Hierarchies make it easier for users to select and navigate common paths of data when creating reports and pivot tables.

Contact us now ›

Related Courses ›

Published by: ,