SharePoint 2010 BI - Part 2: From Tabular Models to PowerView Reports

days
Training code

Upcoming sessions

Learning Goals

Self-service Business Intelligence is becoming very important: Usually the people who know what should be in a report or dashboard do not always have the technical skills to create these reports from scratch. Microsoft introduced PowerPivot, allowing power users to combine different data sources and build pivot tables on top of them in Excel.

However, to bring this from the personal BI to the corporate BI level, we need to take the data from a local Excel sheet to a central Analysis Server. Corporate reporting also requires reporting capabilities beyond the traditional pivot tables. In this course, we focus on building tabular models in Analysis Services 2012, extending these models with Data Analysis eXpressions (DAX), and delivering the data to end users with PowerView reports in SharePoint.

Prerequisites

Students taking this course should have a basic knowledge of the SQL Server relational database and be familiar with Microsoft Excel and SharePoint. This course is offered in combination with the USP10BI course for those not familiar with Excel and SharePoint BI.

Course outline

Module 1: Introduction PowerView

  • From personal BI to corporate BI
  • Introducing PowerView in SharePoint

Module 2: Building Tabular models

  • Importing PowerPivot databases
  • Creating databases from scratch
  • Linking tables
  • Building hierarchies

Module 3: Enhancing Tabular models with DAX

  • Why do we need DAX?
  • Deriving columns with DAX
  • Building DAX measures

Module 4: Deploying tabular models to SharePoint

  • SharePoint and SQL Server requirements
  • Deploying and processing models
  • Browsing available models in SharePoint

Module 5: Authoring PowerView reports

  • Create tables and charts
  • Interactive sorting, filtering and highlighting
  • Working with multi-view reports
  • Exporting to PowerPoint

Module 6: What's new in SharePoint 2013 Business Intelligence

  • PowerView in Excel and maps in PowerView
  • Improvements in Excel Service
  • What's new in Visio Services
  • PerformancePoint Services improvements
Course Calendar
Courses On Site
Course Agenda in PDF
Become a U2U trainer

Contact Me

Call me
Send U2U folder
Send more info

Favorites