Transcript Combine SQL Server, R and Cortana Intelligence Suite for

The information herein is for informational purposes only and represents the opinions and views of Project
Botticelli and/or Rafal Lukawiecki. The material presented is not certain and may vary based on several factors.
Project Botticelli Ltd and Microsoft make no warranties, express, implied or statutory, as to the information in this
presentation.
Copyright © 2016 Project Botticelli Ltd unless noted otherwise. Some slides contain quotations from copyrighted
materials by other authors, as individually attributed or as already covered by Project Botticelli Ltd or Microsoft
Copyright ownerships. 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 Project Botticelli Ltd as of the date of this
presentation. Because Project Botticelli & Microsoft must respond to changing market conditions, it should not be
interpreted to be a commitment on the part of Microsoft, and Microsoft and Project Botticelli cannot guarantee
the accuracy of any information provided after the date of this presentation. Project Botticelli makes no
warranties, express, implied or statutory, as to the information in this presentation. E&OE.
Study with
projectbotticelli.com
Online training
Data Science Data Mining
Introduction to BI & Big Data
Power BI DAX
Cube Design MDX
Excel BI
PPTs
projectbotticelli.com/ppt
Offer
$50 off annual memberships (exp 31 Oct 2016):
50IGNITE2016
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
technitrain.com/coursedetail.php?c=68
Chicago 7 Nov sqlskills.com/rafal
ch.atosconsulting.com/rafal
glasspaper.no/rafal
cornerstone.se/rafal
Why do my customers need
advanced analytics?
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Discover reason behind success, failure
Understand customers, products, patterns
Accurately plan future
Experiment before making decisions
Experiment with autonomous decision making (AI)
Advanced analytics,
or data science,
or artificial intelligence?
Advanced
analytics
Acquire
Explore,
visualise
Data
science
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Prepare
more than data engineering
Data
mining &
machine
learning
Big data
Statistics
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Data
science
Data wrangling
(munging), retrieval
+ storage
Artificial Intelligence
Business
change
Machine
learning
models
Autonomous,
“intelligent”
decisions
Domain
expert
Data
expert
Data
scientist
Can we reduce
readmissions?
What is
readmission?
Does enough
data show
examples of
readmission?
Are the predictable
patterns of
readmitting?
Chart from "2015 Data Science Salary
Survey” used with permission.
© 2016 O'Reilly Media
For more info, and great titles on data
science, visit oreilly.com
Chart from "2015 Data Science Salary
Survey” used with permission.
© 2016 O'Reilly Media
For more info, and great titles on data
science, visit oreilly.com
Easy, visual,
intuitive, Excel,
just works!
SQL Server
2016
R Services
Statistics,
7000+ packages,
enterprise scalable
Cortana
Intelligence
Suite: ML
Advanced
algorithms,
ready-to-use,
web services
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
SQL Server
2016
Data Mining
Open source:
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
and
Predicted
premium:
************************
T-SQL query
**********************
*********************
**********************
***********************
SQL Server
Name
DOB
State
Denny Usher 11/13/58
WA
Gina Burch
WA
04/29/76
Hadoop
$658.39
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Machine learning
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
visualisation
Demo
1. Finding pivotal products (MBA)
2. Customer lifetime value
Microsoft SQL Server 2016 Analysis Services
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Microsoft
Microsoft
Microsoft
Microsoft
Microsoft
in
Formerly Revolution Analytics
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Demo
Do elderly with dementia stay longer in
hospitals?
Microsoft R, RStudio
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Microsoft R Server can
Demo
Mortgage default risk factor modelling
Microsoft SQL Server 2016 R Services,
R Tools for Visual Studio
Joseph Sirosh, CVP
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
Suite (like Office) of Microsoft advanced analytics and
intelligence services
Simpler to buy
Service integration
One team
Storage
Analytics
Flow &
discovery
Exploration,
visualisation
Models:
Cognitive Services:
Bot Framework
Cortana Assistant Integration
Includes
consulting
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
SQL
Data Warehouse
Data Lake
Machine Learning, R, Python
HDInsight, Spark
Stream Analytics
Demo
Customer lifetime value
Cortana Intelligence Suite:
Azure Machine Learning + SQL Azure
On-prem starts all projects
Cloud is collaborative
Hybrid is powerful—and easy!
Copyright 2016 © Project Botticelli Ltd. All rights reserved.
It all works together very well
Demo
Financial forecasting
Microsoft SQL Server 2016, SQL Server 2016 R Services,
SQL Azure, Azure ML and Power BI
Chicago: 7 Nov sqlskills.com/rafal
projectbotticelli.com
BI video tutorials, PPTs, and articles
$50 off annual: 50IGNITE2016
projectbotticelli.com/courses
Follow: @rafaldotnet
Email: [email protected]
Discover: rafal.net
www.microsoft.com/itprocareercenter
www.microsoft.com/itprocloudessentials
www.microsoft.com/mechanics
https://techcommunity.microsoft.com
http://myignite.microsoft.com
https://aka.ms/ignite.mobileapp