visualising the tabular model for power view upload
TRANSCRIPT
VISUALISING THE TABULAR MODEL In PowerView
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
A long time ago, in a galaxy far far away, someone decided to make Jen a SQL Server MVP when she proved that you don’t need a social life if you have data. Despite being a little short to be a Stormtrooper, she uses the Force as a knowledge and defence against the Phantom Menace - Pie Charts, believing they lead to the Dark Side.
This is her story.
Jen Stirrup
AGENDA
• What is the Tabular Model?• What is Power View?
• Tabular Model and Power View together
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
What is the Tabular Model?
Part 1
WHAT IS THE TABULAR MODEL?
• What?• When?• Why?• Who?• How?
OBJECTIVES
BI Semantic Model
Data model
Business logic and queries
Data access ROLAP MOLAP xVelocityDirectQuery
MDX DAX
Multi-dimensional
Tabular
Third-partyapplications
ReportingServices Excel PowerPivot
Databases LOB Applications Files OData Feeds Cloud Services
SharePointInsights
Power View
OBJECTIVES
BI Semantic ModelData model
Business logic and queries
Data access ROLAP MOLAP xVelocityDirectQuery
MDX DAX
Multi-dimensional
Tabular
Third-partyapplications
ReportingServices Excel PowerPivot
Databases LOB Applications Files OData Feeds Cloud Services
SharePointInsights
Power View
8
TABULAR MODEL
•Part of the BISM vision•xVelocity in-memory engine•Compression ratio of tables•Based on the relational data model
• Familiarity• Easier to learn and use
NEW BI SEMANTIC MODEL FEATURES
• Richer Models• KPIs• Descriptions• Persisted formatting• Advanced sorting • Distinct count• Drillthrough• Perspectives• Hierarchies• Multiple relationships
TABULAR FEATURES
• New Tabular Projects in BIDS• DirectQuery• Security• Deployment• Data management: Partitioning
• Management of Tabular Databases in SSMS
11
TABULAR MODEL
• DAX formula language• When compared with OLAP
• Faster due to in-memory engine• Easier to learn and use
SOME EXAMPLE DATA MARKETS
• Windows Azure Data Market• DataMarket.com• Factual.com• InfoChimps• The Guardian Data Store• London Data Store
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
The Value of DAX
Count & Distinct Count
Sum Min & Max Average
Included in Power View by Default
Addition and
SubtractionRatios
Time Intelligence Rank
Inventory Calculation
s
Standard Deviation &
Variance
Text Functions
Define Your Own
Context
Power View with DAX
Power View with DAX
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
What is Power View?
Part 2
15
REPORTING AND THE RED QUEEN
16
REPORTING AND THE RED QUEEN
17
WHY NOT JUST TABLES?
Zimbabwean inflation rates (official) since independence
Date Rate Date Rate Date Rate Date Rate Date Rate Date Rate
1980 7% 1981 14% 1982 15% 1983 19% 1984 10% 1985 10%
1986 15% 1987 10% 1988 8% 1989 14% 1990 17% 1991 48%
1992 40% 1993 20% 1994 25% 1995 28% 1996 16% 1997 20%
1998 48% 1999 56.9% 2000 55.22% 2001 112.1% 2002 198.93% 2003 598.75%
2004 132.75% 2005 585.84% 20061,281.11%
200766,212.3%
2008231,150,888.87% (July)
18
THINKING WITH YOUR EYES
19
CHARTJUNK EXAMPLE
WHAT IS POWER VIEW
Power View is an interactive data
exploration and visual presentation experience.
ARCHITECTURE
RS Shared Service
SharePoint Farm
Power View via Browser
App Server
Data sources
Analysis Services SP Integrated
PowerPivotSystem Service
AS Server
Web Front EndSSRS
Addin for SharePoin
t
PowerPivotWeb Service
Excel PowerPivot Model
SQL Server BIDSBISM Model
© 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Tabular Model and Power View - Together
Part 3
23
TABULAR MODEL AND POWER VIEW TOGETHER
• Business Question - setting context, what is the end user impression?
• Change Visualisations on the fly• Line Chart to a Scatter chart
• Go from SUM to Average• Sorting to assist comparison
24
TABULAR MODEL AND POWER VIEW TOGETHER
• Random sample of data• Table with default columns• Year – Sigma Sign• Refresh
• Refresh in PowerView - only refreshes the data• Refresh in the browser - refreshes the metadata
25
TABULAR MODEL AND POWER VIEW TOGETHER
• How does Power View know how to get the metadata?• We have a new discover command that is executed.• You can run a trace against the tabular model. This will show
you the DAX that is being created 'on the fly'.
26
TABULAR MODEL AND POWER VIEW TOGETHER
• Summary• Focus always on the user• Make things as easy for them, as possible• Power View – the user does not have responsibility, and
therefore does not have power
@jenstirrup
Jen Stirrup
www.jenstirrup.com
