Transcript Mater PowerPoint Template

Azure Data Catalog and Power BI
Agenda
1
Azure Data Catalog Overview
2
Publish a data set
3
Metadata
4
Extract and view
5
Q&A
About me
•
•
•
•
•
•
•
•
Solution Engineer for Oakwood Systems
Microsoft v-TSP
Working in IT for over 18 years
Data warehouses for over 13 years
Analysis Services since SQL Server 7.0
Consultant for over 8 years
Data Warehouse architect for over 5 years
Contact Info
•
•
[email protected]
Twitter - @fkearney
What is Azure Data Catalog
•
•
•
•
Fully managed cloud service that allows you to register and share data
sources for discovery
Formerly Data Catalog (Office 365/Power BI)
Still in preview
Need an Azure subscription to use
•
Free or Standard Edition
Supported data sources
•
•
•
•
•
•
•
•
•
•
•
•
SQL Server (Database and Analysis Services)
Reporting Services
Azure (Data Lake, Blob, HDFS, Hive)
Oracle
MySQL
DB2
HTTP
FTP
Odata
Salesforce
SAP Hana
SharePoint List
Let’s publish some stuff!
• Register data source through Web or App
• Web – easy interface that registers and creates the
connection to your data source
• App is a click to run application
6
Links
Documentation
• https://azure.microsoft.com/en-us/documentation/services/data-catalog/
FAQ
• https://azure.microsoft.com/en-us/documentation/articles/data-catalogfrequently-asked-questions/
API
• https://msdn.microsoft.com/library/azure/mt267595.aspx
7