de l’internet des objets à power bi en passant par azure - sharepoint saturday
TRANSCRIPT
![Page 1: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/1.jpg)
SharePoint Saturday Montréal#SPSMontreal
2 avril 2016
SharePoint Saturday Montréal
De l’Internet des Objets à PowerBI en passant par AzureGuy Barrettehttp://guy.cloud
![Page 2: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/2.jpg)
SharePoint Saturday Montréal#SPSMontreal
Plat
ine
Or Arge
nt
Merci à nos commanditaires !
Bron
ze
![Page 3: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/3.jpg)
SharePoint Saturday Montréal#SPSMontreal
Ce soir à 17h3971 Ontario
Est
![Page 4: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/4.jpg)
Guy BarretteFreelance architect/dev consultantMicrosoft Azure MVPMember of the Microsoft Regional Director Program
www.guybarrette.com@[email protected]
![Page 5: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/5.jpg)
Agenda
IoTAzureAzure servicesAzure IoT Hub Azure IoT Suite
Azure IoT
![Page 6: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/6.jpg)
Is IoT even a new thing?Command and control scenarios have much in common with some parts of IoT.
But falling hardware costs, cloud services and relatively ubiquitous communications do enable new approaches.
Depending on who you ask, IoT is either:
Nothing new
A unicorn
1
2
Magic, and will soon change everything.
We’ve been doing this for 40 years
![Page 7: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/7.jpg)
IoT is an Inflection Point
Hardware is cheap
Connectivity is pervasive
Development is easy
New Innovative Scenarios
Huge benefits fuel demand
![Page 8: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/8.jpg)
IoT 2010
Cell phone
VoIP phone
HVAC
Computer
Vending
Printer
Security
Media player
Oven
Automobile
Smart scale
Refrigerator
Television
Microwave
Coffee maker
Alarm clock
HOME HOMEWORKPLACE
![Page 9: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/9.jpg)
Sleep tracking
COMMUTE COMMUTE
Home security Home automation Leak detection
Smart appliances
Indoor navigation
Health monitoring
Smart lighting
Pet tracking
Information capture
Trip tracking and car health
Control
Child and eldermonitoring
Sports and fitness
Air conditioning and temperature control Environmental
sensors
Behavior modification
Garden, lawn and plant care
Food and nutrition tracking
Beacons and proximity
New devices and sensors
Object tracking
Identity Smart vending machines
Medication adherence
Bike ride stats and protection
Entertainment systems
Office equipment
IoT 2015
HOME HOMEWORKPLACE
![Page 10: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/10.jpg)
$1.7 trillionMarket for IoT by 2020 IDC 25 billion
Connected “things” by 2020 Gartner
![Page 11: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/11.jpg)
Azure
![Page 12: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/12.jpg)
Azure Data Centres28 Regions Worldwide, 22 ONLINE
Top 3 networks in the world 2.5x AWS, 7x Google DC Regions
OperationalAnnounced/Not Operational
Central US
Iowa
West USCaliforni
a
East USVirginia
US GovVirginia
North Central US
Illinois
US GovIowa
South Central US
Texas
Brazil SouthSao Paulo
State
West Europe
Netherlands
China North *
BeijingChina
South *Shanghai
Japan EastTokyo,
Saitama
Japan West
OsakaIndia South
Chennai East AsiaHong Kong
SE AsiaSingapo
re
Australia South East
Victoria
Australia EastNew South
Wales
* Operated by 21Vianet ** Operated by Deutsche Telekom
India CentralPune
Canada EastQuebec City
Canada CentralToronto
India West
Mumbai
Germany North East **
Magdeburg
Germany Central **Frankfurt
North EuropeIreland
East US 2
Virginia
United KingdomRegions
United KingdomRegions
![Page 13: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/13.jpg)
Platform Services
Infrastructure ServicesOS/Server Compute Storage
Datacenter Infrastructure (28 Regions, 22 Online)
Web and Mobile
Web Apps
MobileApps
APIManagement
API Apps
Logic Apps
Notification Hubs
Media & CDNContent DeliveryNetwork (CDN)
Media Services
IntegrationBizTalkServices
HybridConnections
Service Bus
StorageQueues
HybridOperations
Backup
StorSimple
Azure SiteRecovery
Import/Export
Networking
Data
SQL Database
DocumentDB
RedisCache Azure
SearchStorageTables
DataWarehouse Azure AD
Health Monitoring
Virtual Network
ExpressRouteBLOB
StorageAzureFiles
PremiumStorage
Virtual Machines
AD PrivilegedIdentity Management
Traffic Manager
AppGateway
OperationalAnalytics
Services ComputeCloud Services
Batch RemoteApp
ServiceFabric
Developer Services
Visual Studio
AppInsights
Azure SDK
VS Online
ContainerService
DNS VPN Gateway
Load Balancer
Domain Services
Analytics & IoT
HDInsight MachineLearning
StreamAnalytics
Data Factory
EventHubs
MobileEngagement
Data Lake
IoT Hub
Data Catalog
Security & Manageme
nt
Azure ActiveDirectory
Multi-FactorAuthentication
Automation
Portal
Key Vault
Store/Marketplace
VM Image Gallery& VM Depot
Azure ADB2C
Scheduler
![Page 14: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/14.jpg)
1 TrillionMessages delivered every
month with Event Hubs
~100,000
New Azure customer subscriptions/month
20 MillionSQL database hours
used every day
>5 TrillionStorage transactions
every month
60 BillionHits to Websites run on Azure Web App Service
425 MillionAzure Active
Directory Users
Azure momentum
57%Of Fortune 500
Companies use Microsoft Azure
>50 TrillionStorage objects
in Azure
![Page 15: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/15.jpg)
Azure IoT
![Page 16: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/16.jpg)
IoT HubCustom IoT Suite
The IoT paths to Azure
![Page 17: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/17.jpg)
![Page 18: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/18.jpg)
The custom path
![Page 19: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/19.jpg)
Azure Services making sense for IoTDevices Device Connectivity Storage Analytics Presentation &
Action
Event Hubs SQL Database Machine Learning App Service
Service Bus Table/Blob Storage
Stream Analytics Power BI
External Data Sources DocumentDB HDInsight Notification
Hubs
External Data Sources Data Factory Mobile
Services
BizTalk Services
{ }
![Page 20: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/20.jpg)
Azure
Using already available services
Event Hub
Storage blobs
Web/Mobile App
Stream Analytics
Logic AppsWeb Jobs
Power BI
Event Hub
devices
![Page 21: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/21.jpg)
Event IngestionAzure Event Hub
![Page 22: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/22.jpg)
Cloud-scale telemetry ingestion• Cloud-scale telemetry ingestion from websites, apps, and
devices• Compatible with more than a million publishers supporting
HTTP, AMQP and MQTT• Ingress millions of events per second • SAS based security, with unique token per publisher• Configurable data retention (1-30 days)• Low latency (<10 ms for volatile data)• Pluggable with other cloud services like Stream Analytics
![Page 23: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/23.jpg)
Event ProcessingAzure Stream Analytics
![Page 24: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/24.jpg)
Real time event processingHigh volumeAnalyze millions of data points per second
Highly scalableEnterprise grade, predictable solution.
Uncover real time insightsPerform real time analytics across multiple streams
Rapid DeploymentUse simple SQL syntax, auto distributed for scale
Mission critical reliabilityFully managed, low latency, high throughput
Create real time alertsFlag alerts and alarms for attention
![Page 25: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/25.jpg)
![Page 26: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/26.jpg)
![Page 27: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/27.jpg)
Data VisualizationPower BI
![Page 28: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/28.jpg)
Data visualization with PowerBIRich visualsStandard and custom graphing options
Custom dashboardsBuild heat maps and visually track data
External dataIntegrate external data feeds to add value to device data, or pull in external information such as weather or market information.
![Page 29: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/29.jpg)
Predictive AnalyticsAzure Machine Learning
![Page 30: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/30.jpg)
Cloud based predictive analyticsML API serviceModels available as URL, call from any endpoint
Use ML studio to createAccess and prepare data,Create, test and train models
Rapid deploymentSingle click deploy to production via API service
Drag and drop algorithms Simple UI for straightforward algorithm creation
Algorithm librariesUtilize library of preconfigured algorithm solutions
![Page 31: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/31.jpg)
AML - Drag & Drop + Best in Class Algorithms
![Page 32: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/32.jpg)
Demo
The custom path
http://guyb.ca/IoTAzureDemo
![Page 33: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/33.jpg)
Azure IoT Hub
![Page 34: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/34.jpg)
Azure IoT HubDesigned for IoTConnect up to 10 million devices
Service assisted communicationsSecure bi-directional communicationCommand and control
Cloud-scale messagingDevice-to-cloud and Cloud-to-deviceDurable messages (at least once semantics)
Cloud-facing telemetry ingestionDelivery receipts, expired messagesDevice communication errors
Per-device authenticationIndividual device identities and credentials
Connection multiplexingSingle device-cloud connection for all communications (C2D, D2C)
Multi-protocol supportNatively supports AMQP, HTTPDesigned for extensibility to custom protocols
Multi-platformDevice SDKs available for multiple platforms (e.g. RTOS, Linux, Windows)Multi-platform Service SDK.
![Page 35: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/35.jpg)
Event HubsIoT Hub IoT
goodness
IoT Hub is
![Page 36: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/36.jpg)
Connect your devices to Azure
Field gateway
Cloud protocolgateway
IP-c
apab
lePA
N-de
vice
s
Event processing and insight(e.g. hot and cold paths)
Device business logic,Connectivity monitoring
Applicationdevice provisioning and management
cloudfield
IoT Hub10 101 01
0 01
11
0
11
0
10
1
0 011
10 10
0
01
1
0 1
0
![Page 37: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/37.jpg)
Why use IoT Hub?
Device authentication & security
Service-facing device connectivity monitoring
Scale up to millions of simultaneously connected devices
IoT protocols, device resource optimization
Device-to-cloud messaging
Cloud-to-device messaging
![Page 38: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/38.jpg)
Azure IoT Suite SDKs
Device-facingFor devices and field gateway
PlatformsRTOS (FreeRTOS)Linux(Ubuntu, Debian, Fedora, Raspbian, Angstrom)Windows 7/8/10ARM mbedAndroidiOS
LanguagesC, Java, C#, Javascript
Service-facingFor back-ends and cloud gateway
Languages.NET C#JavaNode
![Page 39: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/39.jpg)
Manage IoT Hub in Azure portalSimple navigationManagement of devices, volume and scaling made easy through the IoT Hub settings in the Azure Management Portal
![Page 40: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/40.jpg)
A sample scenarioSimulated wind turbineEmits telemetry every secondState machine (StartingStartedStoppingStopped)
Provision device• Device registry to query devices and track
provisioning• Device identity and key stored in IoT hub
Device emits telemetry• Event processor receives telemetry and
updates portal visualization
Send commands• Portal sends commands to devices• Command lifecycle is stored in device registry
Event Processor
Device registr
y
Portal
Command store
IoT Hub
Device id
C2D queueendpoint
D2C send endpoint
Device …
Device …
Device …
D2C receive endpoint
C2D send endpoint
IoT Hub management
![Page 41: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/41.jpg)
Demo
Create an IoT Hub
Simulated wind turbine
![Page 42: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/42.jpg)
Azure IoT Suite
![Page 43: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/43.jpg)
Azure IoT Suite
Accelerate time to valueGet started quickly with preconfigured solutions for common IoT scenarios.
Rich partner networkLeverage a worldwide ecosystem of experienced IoT partners to tailor IoT solutions to your needs.
Azure IoT Suite
Comprehensive solution Connect millions of devices and integrate your business systems with new insights to transform your business.
![Page 44: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/44.jpg)
Devices
Azure IoT Suite Remote Monitoring
What you get with remote monitoring preconfigured solution
Back end systems and processes
C# simulatorEvent Hub
Storage blobs DocumentDB
Web/Mobile App
Stream Analytics Logic Apps
Azure Active Directory
IoT Hub Web Jobs
Power BI
![Page 45: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/45.jpg)
Tailor Azure IoT Suite to your needs using preconfigured solutions
Finish with your Internet of Things applicationStart quickly with preconfigured solutions
Modify existing rules and alerts
Fine-tuned to specific assets and processes
Integrate with back-end systems
Highly visual for your real-time operational data
Get started in minutes
Add your devices and begin tailor to your needs
![Page 46: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/46.jpg)
![Page 47: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/47.jpg)
![Page 48: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/48.jpg)
Demo
Create an IoT Suitehttps://www.azureiotsuite.com
![Page 49: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/49.jpg)
//Build 2016 AnnouncementsIoT Hub device management
Administrate, organize, software updates, firmware configuration, etc.
IoT Gateway SDKSource code to build your own gateway
![Page 50: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/50.jpg)
Azure is a platform for IoT solutions
![Page 51: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/51.jpg)
IoT HubCustom IoT Suite
![Page 52: De l’Internet des objets à Power BI en passant par Azure - SharePoint Saturday](https://reader036.vdocuments.us/reader036/viewer/2022062503/587667481a28abc5268b667f/html5/thumbnails/52.jpg)
© 2015 Microsoft Corporation. All rights reserved.