Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


PowerPivot & Power View - High-octane Self-service Reporting

No description

Sherri Turley

on 28 May 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of PowerPivot & Power View - High-octane Self-service Reporting

PowerPivot Model Design Steps
Prepare source data
Excel sources: name source tables
Create model
Import tables
Name tables
Define relationships
Name columns
Set data types
Set formats
Set field sort column
Hide utility fields
Add auto sums
Add calculated fields
Define hierarchies
Define KPIs
Set field categories
Set default field set
Define perspectives
Data Quality
3 months
Data Warehouse Design
ETL Development
3 months
Portal Development
2 months
Dashboard & Report Design
4 months
1 Year
Staging & Archival
Data Warehouse
Portals & Sites
Spreadsheet Analysis
Tabular, In-memory
Data Mart
Build a PowerPivot model for product manufacturing production & sales
Import tables
Define relationships
Add calculated fields
Set field sorting, data types & formats
Define calculated measures
Create a KPI
Create a hierarchy
Edit a large PowerPivot model
Define data categories for geographic attributes
Define image paths
Browse millions of rows
Analyze FFA model with Power View in Excel 2013
Note State fields type in StrikeReport table
Add a Power View report to workbook
View in map
Dollar damage per damage incident
Incident count
Slice by animal species
Group map by state
Filter all unknown & blank records
Power View & PowerPivot
High-octane Self-service Reporting
Paul Turley
Mentor, SQL Server MVP
PowerPivot in Excel 2010
Add-in for Excel 2010
Download from PowerPivot.com
Design models on your desktop
Analyze model data with Excel
Optionally deploy to SharePoint 2010 Enterprise
Visualize in Power View (in SharePoint)
2 GB storage limitation
IT can promote model to SSAS tabular storage for enterprise scale
PowerPivot in Excel 2013
Installed with Excel 2013
Optionally deploy to SharePoint 2010 Enterprise with SQL Server 2012 Service Pack 1
Visualize model data using Power View in Excel 2013 (SharePoint not required)
No file size limit in Excel
Still limited to 2GB per document in SharePoint
Power View version 1
Available in SharePoint 2010 Enterprise SP1 with SQL Server 2012 integration

Visualize only PowerPivot/SharePoint or Tabular models
Power View Now
Included with Excel 2013 (SharePoint not required)
Several new features including:
Themes & backgrounds
Integrated with SharePoint 2010 Enterprise with SQL Server 2012 Service Pack 1
Visualize data in PowerPivot, Tabular models or SSAS multidimensional cubes
(post SQL Server 2012 SP1)
Traditional BI Solutions:
DAX dáks (n): Native expression and query language of the BI Semantic Tabular model and PowerPivot. DAX expressions are used to define calculated columns and calculated measures in a table.
The core objects include Tables, Columns & Relationships.

DAX is also a query language used to return complete sets of results from a Tabular model or PowerPivot document.
Excuse Me, Do You Speak DAX?
Tabular Models are
Not a Replacement
for Data Quality Governance & ETL

Semantic Model Options
...but they can simplify the way we design a solution and analyze the information
Resources & Next Steps
Articles & Training:
Recommended books:
for Excel analysts & IT Pros
Full transcript