big data analytics - mscom.co.ilmscom.co.il › downloads › big data2014yossi.pdf · sql server...
TRANSCRIPT
![Page 2: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/2.jpg)
Session Objectives And Takeaways
1. Lets talk about Big Data!
2. Enable you to find opportunities for Big Data & Real-time analytics
and discover new insights.
3. Improve market/compete reaction by using Big Data processes.
![Page 3: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/3.jpg)
2012 2013 2014
MS BI Momentum…
![Page 4: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/4.jpg)
Data is Big? Is it the real world issue ?
![Page 5: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/5.jpg)
What is Big Data?
![Page 6: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/6.jpg)
What is Big Data?
![Page 7: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/7.jpg)
![Page 8: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/8.jpg)
BI Semantic Model
BI Semantic Model
DAX MDX
Deployment
Data Access – CachePassthrough
Business Logic
Development Tool
Design Type
Project Type PowerPivot Workbook Tabular Project Multidimensional Project
Excel 2010
DAX
In-MemoryN/A
SharePoint Library / Analysis Services
PowerPivot
Tabular
SQL Server Data Tools
DAX
In-MemoryDirectQuery
Analysis ServicesTabular
Tabular
SQL Server Data Tools
MDX
MOLAPROLAP
Analysis ServicesMultidimensional
Multidimensional
A Power Pivot workbook can be restored to a Tabular instance, or imported to create a Tabular Project
Third-Party
applications
Reporting
ServicesExcel Power Pivot
SharePoint
Insights
Power
View
Files OData
FeedsCloud
ServicesHDInsight
(Big Data)
Relational
Databases
Deployed
BI Semantic Model
![Page 9: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/9.jpg)
“Big Data Reality Framework…”
![Page 10: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/10.jpg)
So , who am I?
![Page 11: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/11.jpg)
![Page 12: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/12.jpg)
How to prepare to a Big Data Project ?
Developers – special to cloud and big data code engines (.Net , Python , JavaScript etc…).
Business Analysts , BI Developers , Information workers…
70%
30%
1 2
And what about analysts/IW ?
![Page 13: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/13.jpg)
Demo Selection…
בחירות
שם קודשם המהדורהשנהגרסה
11989SQL Server 1.0-
1.11991SQL Server 1.1-
4.211993SQL Server 4.21SQLNT
61995SQL Server 6.0SQL95
6.51996SQL Server 6.5Hydra
71998SQL Server 7.0Sphinx
71999SQL Server 7.0
Palato maniaOLAP Tools
82000SQL Server 2000Shiloh
82003SQL Server 2000
Liberty64-bit Edition
92005SQL Server 2005Yukon
102008SQL Server 2008Katmai
10.252010SQL Azure DBCloudDatabase
10.52010SQL Server 2008 R2Kilimanjaro (aka KJ)
112012SQL Server 2012Denali
122014SQL Server 2014Hekaton
![Page 14: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/14.jpg)
Demo – Business Case
1. Track and follow what happen now and today about our top 5
products.
2. React fast to market changes using social networks.
3. Finally , using analytics to understand better the trends.
![Page 15: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/15.jpg)
Ingredients1 StreamInsight Service
1 Client as Listener (.Net & HTML 5.0)
1 Twitter account + Dev Account
1 TweetFeel service
2 HDInsight (Hadoop on Azure Cluster)
1 TB of Azure BLOB storage
50 GB of Azure SQL DB
5-10 search keywords
1 HIVE ODBC
1 Excel & PowerPivot Model
2-3 Power View Reports
1 Power BI Site + 1 BI Search Service (Q&A)
Preparation
![Page 16: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/16.jpg)
Can we see the Demo please…
![Page 17: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/17.jpg)
Conceptual Design
![Page 18: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/18.jpg)
Natural Language Questions
Ask questions of your data in natural language
Share & Collaborate with Power BI for Office 365
Natural Language Querying Using Q&A
![Page 19: Big Data Analytics - mscom.co.ilmscom.co.il › Downloads › Big Data2014Yossi.pdf · SQL Server Data Tools MDX MOLAP ROLAP Multidimensional Multidimensional A Power Pivot workbook](https://reader033.vdocuments.us/reader033/viewer/2022060208/5f043ba07e708231d40cf75b/html5/thumbnails/19.jpg)
Call to action
Download SQL Server 2014
www.microsoft.com/sqlserver
Big Data Twitter Demo
http://twitterbigdata.codeplex.com/
Thank You!
© 2014 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.