Dr Greg Low
CEO & Principal Mentor
SQL Down Under
Large ecosystem
"Wide availability of skills is among the top reasons customers select Microsoft over competing vendors.”
Source: Gartner Magic Quadrant for BI Platforms, 2011
Highest rated infrastructure and development tools
“Microsoft customers rate its BI platform infrastructure and development tools among the highest
compared to other vendors, and a higher percentage of customers use them extensively.”
Source: Gartner Magic Quadrant for BI Platforms, 2011
Broad adoption
“Use of OLAP functionality by Microsoft customers is more than
double that for the rest of the survey respondents.”
Source: Gartner Magic Quadrant for BI Platforms, 2011
But it's all about
the compression!
0
0
0
1
1
John
Turner
Australian
Johnny
Smith
Australian
Johnson
Smith
Austrian
Jack
Smithy
Austrian
Johnny
Smithy
Austrian
4
0Turner
5alian
5
5alian
John
Turner
Australian
Johnny
Smith
Australian
Johnson
Smith
Austrian
4son
Jack
Smithy
Austrian
1ack
5
Johnny
Smithy
Austrian
Johnny
Smithy
Austrian
0Turner
0
5
0
5alian
4
4son
1ack
0Turner
5alian
5
5alian
5
4
4son
1ack
5
Comparison
140
120
100
80
60
40
20
0
Original
Row
Page
xVelocity
Feature
Comments
Perspectives
Easier to create in tabular
Security
Easier to create in tabular (can also create dynamic
security via USERNAME and LOOKUPVALUE
functions)
Scripting language
DAX is simpler to learn from scratch
ROLAP / Direct Query
Direct query applies to entire table, does not support
MDX queries, and limits DAX functions
Data types
Somewhat richer data type support in tabular
KPIs
Easier to create in tabular (but no trend)
Feature
Comments
Process dimension
Without processing associated measure groups
Partition dimension
Process one state's data separately?
Reporting properties
Greatly improves client interaction in tools such as
Power View
Feature
Comments
Translations
Named sets
Actions
Basic drill-through is OK
Custom assemblies
MDX scripting
ETL based options often better in many situations
Custom rollups
Writeback
Need to manage separate table and process
Missing key strategy
All missing keys mapped to a single missing value
YOUR OWN
QR CODE
GOES HERE
Develop & Test on cloud VMs at no additional cost!
Activate your MSDN Benefit & try it by 9/30
You could win* an Aston Martin V8 Vantage!
Redeem your benefit today!
http://bit.ly/140upRt
[email protected]
http://sqlblog.com/blogs/greg_low
http://www.sqldownunder.com
http://channel9.msdn.com/Events/TechEd/Australia/2013
http://www.microsoftvirtualacademy.com/
http://technet.microsoft.com/en-au/
http://msdn.microsoft.com/en-au/
http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx
www.windowsazure.com
http://www.windowsazure.com/en-us/documentation/services/hdinsight/?fb=en-us
www.powerbi.com
Descargar

DBI-202 TechEd Australia 2013