Business Intelligence with PowerPivot

Business Intelligence with PowerPivot Business Intelligence with PowerPivot
By TED Integrated
Business Intelligence:

Business Intelligence with Microsoft® Excel 2010 & PowerPivot – Level 2

“Take advantage of self-service business intelligence using Microsoft PowerPivot & Power Query for Excel!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
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
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Computer Lab Work
  • Case Studies
  • Certificate of Participation
*Terms & Conditions

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 ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,