close

Se connecter

Se connecter avec OpenID

BI in the cloud, is it possible? Sure is with Azure!

IntégréTéléchargement
BI in the cloud, is it possible?
Sure is with Azure!
Rob Hawthorne
M352
Planning for the Cloud
Considerations for loading data
Overview and demo
Azure Data Factory
What, why and how
Overview and demo
Visualisation and Reporting
Power BI
Overview and demo
… data warehousing has reached the most
significant tipping point since its inception.
The biggest, possibly most elaborate data
management system in IT is changing.
– Gartner, “The State of Data Warehousing in 2012”
Data sources
2
1
Increasing
data volumes
3
Real-time
data
New data
sources & types
Data sourcesNon-Relational Data
4
Cloud-born
data
5
New-AzureDataFactory
New-AzureDataFactory
-Name “HaloTelemetry“
-Name “GameTelemetry“
-Location “West-US“
-Location “West-US“
New-AzureDataFactoryLinkedService
-Name "MyHDInsightCluster“
-DataFactory“GameTelemetry"
-File HDIResource.json
New-AzureDataFactoryLinkedService
-Name "MyStorageAccount"
-DataFactory“GameTelemetry"
-File BlobResource.json
“GeoCoded Game Usage” Table:
Pipeline Definition:
// Deploy Table
New-AzureDataFactoryTable
-DataFactory“GameTelemetry“
-File NewUserActivityPerRegion.json
// Deploy Pipeline
New-AzureDataFactoryPipeline
-DataFactory “GameTelemetry“
-File NewUserTelemetryPipeline.json
// Start Pipeline
Set-AzureDataFactoryPipelineActivePeriod
-Name “NewUserTelemetryPipeline“
-DataFactory “GameTelemetry“
-StartTime 10/29/2014 12:00:00
"availability": { "frequency": "Day", interval": 1 }
Activity: (e.g. Hive):
Hourly
12-1
1-2
2-3
GameUsage
Power BI Desktop
A freely downloadable 32/64bit
desktop companion optimized for
use with the Power BI Service.
Visual data exploration and
reporting tool complementary to
Excel.
Combines the power of Power
Query, Power Pivot & Power View.
Effortlessly publish and share
interactive visual reports to users of
Power BI
Power BI Desktop is a visual data
exploration and reporting tool
ADF Pricing Per Month
Automation & Management
Data Transformation & Movement
Low Frequency
High Frequency
$0.60
$1.00
$0.48
$0.80
0-100 activities 100+ activities
Cloud
$1.50
$2.50
$1.20
$2.00
0-100 activities
100+ activities
Automation/Coordination Layer
(Coordination, Scheduling, Management)
On Premises
Note: public preview = 50% discount on the rates shown above
Resources Used to Execute Activities in a Pipeline:
•
•
•
HDInsight (hrs)
Compute/VM (hrs)
Data Transfer (GB)
Execution Layer
(Data Storage & Processing)
1
Introduction to Microsoft
Hololens
5
Architecting the Internet of Things
NZ1 Fri 1:55pm
SKYCITY Theatre Thurs 4:30pm
2
Telling Stories with Data
3
Azure Machine Learning
4
Elastic for SQL
Marlborough Fri 9:00am
Marlborough Fri 10:40am
NZ3 Fri 11:55am
Find me later at…
 Hub Happy Hour Thu 5:30-6:30pm
 Closing drinks Fri 3:00-4:30pm
 And maybe the pub!
Free Online Learning
http://aka.ms/mva
Subscribe to our fortnightly newsletter
http://aka.ms/technetnz
http://aka.ms/msdnnz
Sessions on Demand
http://aka.ms/ch9nz
© 2015 Microsoft Corporation. All rights reserved.
Microsoft, Windows and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Auteur
Document
Catégorie
Uncategorized
Affichages
4
Taille du fichier
2 644 KB
Étiquettes
1/--Pages
signaler