charles verdon - samedi sql - futur de l'intelligence d'affaire
TRANSCRIPT
![Page 1: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/1.jpg)
Le futur de
l’intelligence
d’affaire c’est le
temps réel! Charles Verdon
Technology Solutions Professional
Email: [email protected]
Twitter: @chverdon
![Page 2: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/2.jpg)
![Page 3: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/3.jpg)
![Page 4: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/4.jpg)
Things!
30B30B
![Page 5: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/5.jpg)
Data Analytics
& Insights
Intelligent
Systems
Cloud & Infrastructure
Devices &
Assets
10101010011000110101010111010011010101010100110111011110111001010100001101010101110100110101010111010011101010101011010011010101010101001101100010101111010011101010101011011110100111
10101010011000110101010111010011010101010100110111011110111001010100001101010101110100110101010111010011101010101011010011010101010101001101100010101111010011101010101011011110100111
![Page 6: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/6.jpg)
Redefine
customer
service
Open new
business
opportunities
Build
competitive
edge
Gain insight
and agility
![Page 7: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/7.jpg)
It’s Big
So many devices and so much data…
It’s Noisy
So many opinions…
It’s Confusing
So many possible decisions…
Should we
wait?
How (where)
do we get
started?
Who can
really help
us?
Do we need
to start over?
What
technology
do we need?
B5075212
Microsoft Confidential
![Page 8: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/8.jpg)
The Internet of Things starts with
Your Things.
• Build on the infrastructure you already have.
• Add more devices to the ones you already own.
• Get more from the data that already exists.
Stop just running your business.
Start making it thrive. Start realizing the
potential of the Internet of Your Things.
![Page 9: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/9.jpg)
Microsoft Azure IoT services:
Enable
innovation
Improve
efficiency
Transform
your business
You have data…You have things…
![Page 10: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/10.jpg)
Generate new
insights to
create new
business value
Combine the
data you
already collect
Expand by adding new devices and assets, new services, new data
Utilize services
and the cloud
to jump-start
your efforts
Start by
connecting the
devices and LoB
Assets you
already have
![Page 11: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/11.jpg)
London Underground
![Page 12: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/12.jpg)
![Page 13: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/13.jpg)
Analytics Platform System
(APS)
Portal
O
p
e
r
a
t
i
o
n
a
l
SAP BW
JDE
BaaN
SAP
etc
Enterprise
Data
Warehouse
(EDW)
D
a
s
h
b
o
a
r
d
s
&
K
P
I
s
Data Mart
Data Mart
Operational
Data Store
(ODS)
E
T
L
E
S
B
E
T
L
E
T
L
Reports
Ad-hoc
Dashboard
Semi-structured
Unstructured
Streaming
OSI Soft, etc
Hadoop
OLAP
OLAP
![Page 14: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/14.jpg)
![Page 15: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/15.jpg)
![Page 16: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/16.jpg)
Where it starts…
![Page 17: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/17.jpg)
Protocol reach to devices and platforms
Windows
Azure Service Bus
• Queues
• Topics
• Event hubs
/azure-sdk-for-python/
/azure-sdk-for-php/
/azure-sdk-for-node/
/azure-sdk-for-java/
/azure-sdk-for-ruby/
HTTP(S)
https://github.com/windowsAzure/AMQP 1.0
Other platforms
AMQP
1.0
Embedded
![Page 18: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/18.jpg)
Quick Excursion: What is AMQP 1.0?• Advanced Message Queueing Protocol v1.0, ISO/IEC 19464:2014
• Bi-Directional, Reliable, Multiplexed Message Transfer
• Common Type System: structure like JSON, richer value types for scientific and business apps,
compact binary encoding
• Credit-based flow control model, delivery settlement
+5
![Page 19: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/19.jpg)
{cursor here}
{cursor here}
{cursor here}
![Page 20: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/20.jpg)
![Page 21: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/21.jpg)
Machine Learning
![Page 22: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/22.jpg)
I believe over the next decade computing will become even more ubiquitous and intelligence will become ambient This will be made possible by an ever-growing network of connected devices, incredible computing capacity from the cloud, insights from big data, and intelligence from machine learning
Satya Nadella, CEO
![Page 23: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/23.jpg)
SQL Server
enables data
mining of
databases
Computers
work on users
behalf, filtering
junk email
Microsoft
Kinect can
watch users
gestures
Microsoft
launches Azure
Machine
Learning,
making years
of innovation
available
Microsoft
search engine
built with
machine
learning
Bing Maps
ships with ML
traffic-
prediction
service
Successful,
real-time,
speech-to-
speech
translation
Microsoft & Machine Learning20 years of realizing innovation
John Platt, Distinguished scientist at
Microsoft Research
1999 201220082004 201420102005
Machine learning is pervasive throughout
Microsoft products.“
”
![Page 24: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/24.jpg)
![Page 25: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/25.jpg)
![Page 26: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/26.jpg)
Better Decisions with Data
Descriptive Diagnostic PrescriptivePredictive
BI Enablement Advanced Analytics
Enterprise Data Management
What happened? Why did it happen? What will happen? What should I do?
![Page 27: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/27.jpg)
![Page 28: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/28.jpg)
1 1 5 4 3
7 5 3 5 3
5 5 9 0 6
3 5 2 0 0
![Page 29: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/29.jpg)
Generalization is the essence of machine learning
DataAbstraction Generalization
![Page 30: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/30.jpg)
Machine Learning Applications Span
Industries and Scenarios
31
Web app optimization
Smart meter monitoring
Targeted Advertising
Life sciences research
Fraud detection
Healthcare outcomes
Weather forecasting
Natural resource exploration
Social network analysis
Telemetry Data Analysis
Buyer Propensity Models
Predictive Maintenance
Churn Analysis
Network Intrusion Detection
![Page 31: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/31.jpg)
ThyssenKrupp Elevator
![Page 32: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/32.jpg)
Data Science Process is All About Experimentation
Business Understanding
Data Understanding
Data Preparation
Modeling
Evaluation
Deployment and
Monitoring
Data
![Page 33: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/33.jpg)
![Page 34: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/34.jpg)
Machine Learning
Stream Analytics
![Page 35: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/35.jpg)
![Page 36: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/36.jpg)
![Page 37: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/37.jpg)
Developers uses declarative SQL commands
Some functions take several lines of code versus thousands from other solutions
3 lines of code in Stream Analytics
Thousand lines of code in other solutions
![Page 38: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/38.jpg)
![Page 39: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/39.jpg)
Stream Analytics, End-to-End Overview
Data Source
Collect Process
Consume
Deliver
Event Inputs- Event Hub- Azure Blob
Transform- Temporal joins- Filter- Aggregates- Projections- Windows- Etc.
Enrich
Correlate
Outputs- SQL Azure- Azure Blobs- Event Hub- Power BI
AzureStorage
• Temporal Semantics• Guaranteed delivery• Guaranteed up time
Azure Stream Analytics
Reference Data- Azure Blob
![Page 40: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/40.jpg)
Tumbling Windows
SELECT TollId, COUNT(*) FROM EntryStreamGROUP BY TollId, TumblingWindow(minute,5)
How many vehicles entered each toll both every 5 minutes?
![Page 41: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/41.jpg)
![Page 42: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/42.jpg)
![Page 43: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/43.jpg)
![Page 44: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/44.jpg)
Separation of Data & Presentation
![Page 45: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/45.jpg)
Connect live to on-premises dataLive Connectivity to SQL Server Analysis Services
Live Connectivity
![Page 46: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/46.jpg)
![Page 47: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/47.jpg)
![Page 48: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/48.jpg)
![Page 49: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/49.jpg)
Use the Power BI REST API to
push data directly from your
application into a dataset in
Power BI. Your dashboards will
be updated in real-time when
the data changes. No more
waiting or having to press the
Refresh button!
Real-time dashboards
Create a connector (using REST,
OData, ODBC or other APIs) that
allows Power BI users to connect
to your data source and retrieve
data. Your connector can also
provide custom data models,
reports and dashboards for quick
insights.
Connectors for your
data sources
Use the Power BI REST APIs to
create custom datasets, reports
and dashboards from your
application. Integrate rich
analytics into your application by
embedding Power BI
dashboards, tiles and reports.
Rich analytics in your
application
Uncover real-time insights from
devices, sensors and
applications. Process streaming
data and events using Azure
Stream Analytics and monitor
the results using Power BI.
Real time dashboards
with Stream Analytics
Power BI
REST API
![Page 50: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/50.jpg)
![Page 51: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/51.jpg)
Upcoming Data Platform Events
Microsoft Cloud Platform Day• Montreal February 26: link
Microsoft Canada Webcast Series• 12pm to 1pm: English
• 13h30 à 14h30: Français
• February 26: Analytics Platform System
• March 26: SQL Server In-Memory technologies
• April 30: Real-time BI
• May 28: Azure SQL
User Group SQL Saturdays• PASS Ottawa Saturday April 25: link
SQL Server 2005
End-of-Life:
15 Months!
![Page 52: Charles Verdon - Samedi SQL - Futur de l'intelligence d'affaire](https://reader033.vdocuments.us/reader033/viewer/2022042818/55b93e7ebb61ebad7d8b46f3/html5/thumbnails/52.jpg)
Charles [email protected]@chverdon
谢谢!
Merci!
Vielen Dank!
Спасибо!
Thank you!
!شكرا
¡Gracias!
ありがとう!