Transcript www.sqlbi.com [email protected] OLTP System(s) Data Mart OLAP Data Mart Client Data Warehouse OLAP OLTP System(s) Data Mart OLAP Data Mart Client Data Warehouse OLAP Self Service BI.

www.sqlbi.com
[email protected]
OLTP System(s)
Data Mart
OLAP
Data Mart
Client
Data
Warehouse
OLAP
OLTP System(s)
Data Mart
OLAP
Data Mart
Client
Data
Warehouse
OLAP
Self Service BI
OLTP System(s)
Data Mart
OLAP
OLTP
Data Mart
OLTP
OLTP
Client
Data
Warehouse
Power
Pivot
OLAP
External
Sources
OLTP System(s)
Data Mart
OLAP
OLTP
Data Mart
OLTP
OLTP
Client
Data
Warehouse
Power
Pivot
OLAP
External
Sources
•
•
•
•
Power BI Cloud
Services
(1) Using Power Query Anna
connects to OData feed
(2) Redirect to gateway
Power Query
Data Management
Gateway
(5) Returns OData feed
(4) Returns Result
(3) The Data Management
Gateway connects to SQL
Server using either Windows
account or Database
account setup by IT when
creating the feed
http://office.microsoft.com/en-us/publish-ssis-packages-as-odata-feed-sources-HA104079177.aspx
Data Streaming
Destination
OLE DB
Provider
for SSIS
Linked
Server
Data Source
SQL
Query
Excel Workbook in
Sharepoint Online
(1) Data refresh is
triggered from
Power BI Sites
(2) Connects to Gateway
Cloud Service
(8) Returns data to
Excel Workbook
(3) Checks whether
user is authorized to
perform a refresh
(4) Sends command
(SQL statement,
connection string) to
on-premise Gateway
(5) Sends SQL to
SQL Server
Gateway
Cloud Service
(7) Compress,
chunk and return
the data
Data Management
Gateway
(6) Return Results
Session code
Title
Time
[DBI-B410]
Deep Dive into Power Query Formula Language
Tuesday May 13th 3.15-4.30 PM
[DBI-B324]
Microsoft Power Query for Excel: Discover and
Refine Your Data
Monday 3.00 PM–4.15 PM
[DBI-B212]
BI Power Hour
Tuesday May 13th 5PM-6.15 PM
[DBI-B211]
All You Need to Know about Microsoft Power BI
for Office 365
Monday 1.15 PM-2.30 PM
[DBI-B320]
Interactive Data Visualization with Power View
Tuesday May13th 8.30-9.45 AM
http://www.trySQLSever.com
http://www.powerbi.com
http://microsoft.com/bigdata
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn