Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Azure Data Architecture Guide – Blog #8: Data warehousing

In our eighth blog in this series, we'll continue to explore the Azure Data Architecture Guide. The previous entries for this blog series are:

  • Azure Data Architecture Guide – Blog #1: Introduction
  • Azure Data Architecture Guide – Blog #2: On-demand big data analytics
  • Azure Data Architecture Guide – Blog #3: Advanced analytics and deep learning
  • Azure Data Architecture Guide – Blog #4: Hybrid data architecture
  • Azure Data Architecture Guide – Blog #5: Clickstream analysis
  • Azure Data Architecture Guide – Blog #6: Business intelligence
  • Azure Data Architecture Guide – Blog #7: Intelligent applications 

Like the previous post, we'll work from a technology implementation seen directly in our customer engagements. The example can help lead you to the ADAG content to make the right technology choices for your business.

Data warehousing

Here we see store data coming from multiple sources into Azure Data Lake Store, in their native format. Azure SQL Data Warehouse directly queries against the data with a combination of external tables and schema on read capabilities through PolyBase. Use Azure Data Factory to store the data you need within your warehouse, and quickly analyze and visualize the combined data with Power BI.

Data warehousing

Highlighted services

  • Azure Data Lake Store
  • Azure SQL Data Warehouse
  • PolyBase
  • Azure Data Factory
  • Power BI

Related ADAG articles

  • Traditional RDBMS workloads
    • Traditional relational database solutions
    • Semantic modeling
    • Data warehousing and data marts
    • Online analytical processing (OLAP)
  • Cross-cutting concerns
    • Transferring data to and from Azure
  • Technology choices
    • Choosing a big data storage technology in Azure
    • Choosing a real-time message ingestion technology in Azure
    • Choosing a data pipeline orchestration technology in Azure
    • Choosing a data analytics technology in Azure

Please peruse ADAG to find a clear path for you to architect your data solution on Azure:

  • Read the Azure Data Architecture Guide

Azure CAT Guidance

"Hands-on solutions, with our heads in the Cloud!"

Share the post

Azure Data Architecture Guide – Blog #8: Data warehousing

×

Subscribe to Msdn Blogs | Get The Latest Information, Insights, Announcements, And News From Microsoft Experts And Developers In The Msdn Blogs.

Get updates delivered right to your inbox!

Thank you for your subscription

×