SharePoint 2010 BI - Part 2: From Tabular Models to PowerView Reports
usp10bi-2
Organized by
0 days
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
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.
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.