Home
%3CLINGO-SUB%20id%3D%22lingo-sub-352865%22%20slang%3D%22en-US%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%238%3A%20Data%20warehousing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352865%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20our%20eighth%20blog%20in%20this%20series%2C%20we'll%20continue%20to%20explore%20the%20%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22http%3A%2F%2Faka.ms%2FADAG%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Architecture%20Guide%3C%2FA%3E.%26nbsp%3BThe%20previous%20entries%20for%20this%20blog%20series%20are%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-Blog-1-Introduction%2Fba-p%2F306477%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%231%3A%20Introduction%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-Blog-2-On-demand-big-data%2Fba-p%2F306505%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%232%3A%20On-demand%20big%20data%20analytics%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-8211-Blog-3-Advanced-analytics-and%2Fba-p%2F306556%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%233%3A%20Advanced%20analytics%20and%20deep%20learning%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-8211-Blog-4-Hybrid-data%2Fba-p%2F306579%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%234%3A%20Hybrid%20data%20architecture%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-8211-Blog-5-Clickstream-analysis%2Fba-p%2F306630%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%235%3A%20Clickstream%20analysis%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-8211-Blog-6-Business-intelligence%2Fba-p%2F306646%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%236%3A%20Business%20intelligence%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-8211-Blog-7-Intelligent%2Fba-p%2F306656%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%237%3A%20Intelligent%20applications%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3ELike%20the%20previous%20post%2C%20we'll%20work%20from%20a%20technology%20implementation%20seen%20directly%20in%20our%20customer%20engagements.%20The%20example%20can%20help%20lead%20you%20to%20the%20ADAG%20content%20to%20make%20the%20right%20technology%20choices%20for%20your%20business.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1677895367%22%20id%3D%22toc-hId-1703717278%22%3EData%20warehousing%3C%2FH2%3E%0A%3CP%3EHere%20we%20see%20store%20data%20coming%20from%20multiple%20sources%20into%20%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-lake-store%2Fdata-lake-store-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%3C%2FA%3E%2C%20in%20their%20native%20format.%20(%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fblobs%2Fdata-lake-storage-introduction%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%20Gen%202%3C%2FA%3E%20is%20recommended.)%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%22%3E%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-overview-what-is%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20Data%20Warehouse%3C%2FA%3E%3C%2FSPAN%3E%20directly%20queries%20against%20the%20data%20with%20a%20combination%20of%20external%20tables%20and%20schema%20on%20read%20capabilities%20through%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%22%3E%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fpolybase%2Fget-started-with-polybase%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPolyBase%3C%2FA%3E%3C%2FSPAN%3E.%20Use%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%22%3E%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Factory%3C%2FA%3E%3C%2FSPAN%3E%20to%20store%20the%20data%20you%20need%20within%20your%20warehouse%2C%20and%20quickly%20analyze%20and%20visualize%20the%20combined%20data%20with%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%22%3E%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPower%20BI%3C%2FA%3E%3C%2FSPAN%3E.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200px%200px%2010px%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2014px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20675px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F83511i7F2AD33EFBFE0542%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ADAG_DataWarehousing.png%22%20title%3D%22ADAG_DataWarehousing.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--874261594%22%20id%3D%22toc-hId--848439683%22%3EHighlighted%20services%3C%2FH2%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-lake-store%2Fdata-lake-store-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%20Gen%201%3C%2FA%3E%20(legacy)%3C%2FSPAN%3E%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fblobs%2Fdata-lake-storage-introduction%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%20Gen%202%3C%2FA%3E%20(recommended)%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-overview-what-is%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20Data%20Warehouse%3C%2FA%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fpolybase%2Fget-started-with-polybase%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPolyBase%3C%2FA%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Factory%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPower%20BI%3C%2FA%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-868548741%22%20id%3D%22toc-hId-894370652%22%3ERelated%20ADAG%20articles%3C%2FH2%3E%0A%3CUL%3E%0A%3CLI%3ETraditional%20RDBMS%20workloads%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Frelational-data%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETraditional%20relational%20database%20solutions%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Frelational-data%2Fonline-analytical-processing%23semantic-modeling%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESemantic%20modeling%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Frelational-data%2Fdata-warehousing%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EData%20warehousing%20and%20data%20marts%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Frelational-data%2Fonline-analytical-processing%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOnline%20analytical%20processing%20(OLAP)%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ECross-cutting%20concerns%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Fscenarios%2Fdata-transfer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETransferring%20data%20to%20and%20from%20Azure%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ETechnology%20choices%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Ftechnology-choices%2Fdata-storage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChoosing%20a%20big%20data%20storage%20technology%20in%20Azure%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Ftechnology-choices%2Freal-time-ingestion%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChoosing%20a%20real-time%20message%20ingestion%20technology%20in%20Azure%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Ftechnology-choices%2Fpipeline-orchestration-data-movement%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChoosing%20a%20data%20pipeline%20orchestration%20technology%20in%20Azure%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Farchitecture%2Fdata-guide%2Ftechnology-choices%2Fanalysis-visualizations-reporting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChoosing%20a%20data%20analytics%20technology%20in%20Azure%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1683608220%22%20id%3D%22toc-hId--1657786309%22%3ESee%20Also%3C%2FH2%3E%0A%3CP%3EThe%20Reference%20Architecture%2C%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Freference-architectures%2Fdata%2Fenterprise-bi-sqldw%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EEnterprise%20BI%20in%20Azure%20with%20SQL%20Data%20Warehouse%3C%2FA%3E%2C%26nbsp%3B%3CSPAN%3Eimplements%20an%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Fdata-guide%2Frelational-data%2Fetl%23extract-load-and-transform-elt%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eextract%2C%20load%2C%20and%20transform%20(ELT)%3C%2FA%3E%3CSPAN%3E%20pipeline%20that%20moves%20data%20from%20an%20on-premises%20SQL%20Server%20database%20into%20SQL%20Data%20Warehouse%20and%20transforms%20the%20data%20for%20analysis.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20Azure%20Architecture%20Center%20also%20features%20two%20related%20example%20scenarios%20that%20demonstrate%20solutions%20using%20these%20technologies%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Fexample-scenario%2Fdata%2Fdata-warehouse%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EData%20warehousing%20and%20analytics%20for%20sales%20and%20marketing%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Fexample-scenario%2Fdata%2Fhybrid-etl-with-adf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHybrid%20ETL%20with%20existing%20on-premises%20SSIS%20and%20Azure%20Data%20Factory%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EIn%20addition%2C%20the%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-gb%2Fsolutions%2Farchitecture%2Fmodern-data-warehouse%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EModern%20Data%20Warehouse%20solution%3C%2FA%3E%20ingests%20the%20data%20sources%20through%20Azure%20Data%20Factory%2C%20combining%20your%20data%20to%20Azure%20Blob%20Storage.%20It%20uses%20Azure%20Databricks%20to%20prep%20and%20train%20cleansed%20and%20transformed%20data%2C%20to%20be%20moved%20to%20Azure%20SQL%20Data%20Warehouse%20(which%20acts%20as%20the%20data%20hub).%20Like%20the%20Reference%20Architecture%20above%2C%20this%20solution%20leverages%20Azure%20Analysis%20Services%20for%20data%20modeling%20(then%20on%20to%20Power%20BI%20for%20your%20visualizations).%3C%2FP%3E%0A%3CP%3EFor%20more%20information%20about%20the%20data%20movement%2C%20see%20the%20following%20articles%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-load-from-azure-data-lake-store%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELoad%20data%20from%20Azure%20Data%20Lake%20Storage%20Gen1%20to%20SQL%20Data%20Warehouse%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-data-lake-store%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECopy%20data%20to%20or%20from%20Azure%20Data%20Lake%20Storage%20Gen1%20by%20using%20Azure%20Data%20Factory%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-data-lake-storage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECopy%20data%20to%20or%20from%20Azure%20Data%20Lake%20Storage%20Gen2%20Preview%20using%20Azure%20Data%20Factory%20(Preview)%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fconnector-azure-sql-data-warehouse%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECopy%20data%20to%20or%20from%20Azure%20SQL%20Data%20Warehouse%20by%20using%20Azure%20Data%20Factory%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-databricks%2Fdatabricks-extract-load-sql-data-warehouse%3Ftoc%3D%2Fazure%2Fsql-data-warehouse%2Ftoc.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETutorial%3A%20Extract%2C%20transform%2C%20and%20load%20data%20using%20Azure%20Databricks%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Fdata-guide%2Ftechnology-choices%2Fpipeline-orchestration-data-movement%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChoosing%20a%20data%20pipeline%20orchestration%20technology%20in%20Azure%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EFor%20more%20information%20about%20stream%20processing%20and%20Azure%20Data%20Bricks%2C%20see%20our%20reference%20architecture%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Freference-architectures%2Fdata%2Fstream-processing-databricks%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECreate%20a%20stream%20processing%20pipeline%20with%20Azure%20Databricks%3C%2FA%3E%2C%20and%20our%20ADAG%20article%2C%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Fdata-guide%2Ftechnology-choices%2Fstream-processing%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChoosing%20a%20stream%20processing%20technology%20in%20Azure%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3EFor%20more%20information%20about%20Azure%20Analysis%20Services%20and%20advanced%20analytics%2C%20see%20our%20last%20blog%20post%20in%20this%20blog%20series%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzureCAT%2FAzure-Data-Architecture-Guide-8211-Blog-6-Business-intelligence%2Fba-p%2F306646%22%20target%3D%22_self%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%236%3A%20Business%20intelligence%3C%2FA%3E%2C%20our%20ADAG%20article%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Fdata-guide%2Ftechnology-choices%2Fanalytical-data-stores%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EChoosing%20an%20analytical%20data%20store%20in%20Azure%3C%2FA%3E%2C%20our%20two%20Reference%20Architectures%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Freference-architectures%2Fdata%2Fenterprise-bi-sqldw%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EEnterprise%20BI%20in%20Azure%20with%20SQL%20Data%20Warehouse%3C%2FA%3E%20and%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Freference-architectures%2Fdata%2Fenterprise-bi-adf%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAutomated%20enterprise%20BI%20with%20SQL%20Data%20Warehouse%20and%20Azure%20Data%20Factory%3C%2FA%3E%2C%20our%20Example%20Scenario%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Farchitecture%2Fexample-scenario%2Fdata%2Fdata-warehouse%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EData%20warehousing%20and%20analytics%20for%20sales%20and%20marketing%3C%2FA%3E%2C%20and%20our%20two%20Solutions%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-gb%2Fsolutions%2Farchitecture%2Fadvanced-analytics-on-big-data%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAdvanced%20analytics%20on%20big%20data%3C%2FA%3E%20and%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-gb%2Fsolutions%2Farchitecture%2Freal-time-analytics%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EReal-time%20analytics%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20peruse%20ADAG%20to%20find%20a%20clear%20path%20for%20you%20to%20architect%20your%20data%20solution%20on%20Azure%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FADAG%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERead%20the%20Azure%20Data%20Architecture%20Guide%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%20style%3D%22margin%3A%200px%200px%2010px%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2014px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200px%200px%2010px%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2014px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20400%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200px%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%3CA%20style%3D%22outline%3A%200px%3B%20color%3A%20rgb(20%2C%20108%2C%20172)%3B%20text-decoration%3A%20underline%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22http%3A%2F%2Faka.ms%2FCAT%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CIMG%20width%3D%22134%22%20height%3D%22134%22%20class%3D%22alignleft%22%20style%3D%22border%3A%200px%20rgb(20%2C%20108%2C%20172)%3B%20border-image%3A%20none%3B%20height%3A%20134px%3B%20vertical-align%3A%20middle%3B%20display%3A%20block%3B%20max-width%3A%20910px%3B%20box-sizing%3A%20border-box%3B%22%20src%3D%22https%3A%2F%2Fmsdnshared.blob.core.windows.net%2Fmedia%2F2017%2F01%2FAzureCAT_Icon.jpg%22%20border%3D%220%22%20%2F%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200px%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%3CSTRONG%20style%3D%22font-weight%3A%20bold%3B%20box-sizing%3A%20border-box%3B%22%3EAzureCAT%20Guidance%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200px%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%22%3E%3CEM%20style%3D%22box-sizing%3A%20border-box%3B%22%3E%22Hands-on%20solutions%2C%20with%20our%20heads%20in%20the%20Cloud!%22%3C%2FEM%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-352865%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20style%3D%22font%3A%20300%2016px%2F27.42px%20%26quot%3BSegoeUI%26quot%3B%2C%20%26quot%3BLato%26quot%3B%2C%20%26quot%3BHelvetica%20Neue%26quot%3B%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20float%3A%20none%3B%20display%3A%20inline%20!important%3B%20white-space%3A%20normal%3B%20cursor%3A%20text%3B%20orphans%3A%202%3B%20font-size-adjust%3A%20none%3B%20font-stretch%3A%20normal%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3EHere%20we%20see%20store%20data%20coming%20from%20multiple%20sources%20into%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-lake-store%2Fdata-lake-store-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font%3A%20300%2016px%2F27.42px%20%26quot%3BSegoeUI%26quot%3B%2C%20%26quot%3BLato%26quot%3B%2C%20%26quot%3BHelvetica%20Neue%26quot%3B%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20float%3A%20none%3B%20display%3A%20inline%20!important%3B%20white-space%3A%20normal%3B%20cursor%3A%20text%3B%20orphans%3A%202%3B%20font-size-adjust%3A%20none%3B%20font-stretch%3A%20normal%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%2C%20in%20their%20native%20format.%20(%3C%2FSPAN%3E%3CA%20style%3D%22text-align%3A%20left%3B%20color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fblobs%2Fdata-lake-storage-introduction%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Data%20Lake%20Storage%20Gen%202%3C%2FA%3E%3CSPAN%20style%3D%22font%3A%20300%2016px%2F27.42px%20%26quot%3BSegoeUI%26quot%3B%2C%20%26quot%3BLato%26quot%3B%2C%20%26quot%3BHelvetica%20Neue%26quot%3B%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20float%3A%20none%3B%20display%3A%20inline%20!important%3B%20white-space%3A%20normal%3B%20cursor%3A%20text%3B%20orphans%3A%202%3B%20font-size-adjust%3A%20none%3B%20font-stretch%3A%20normal%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%20is%20recommended.)%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-overview-what-is%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20SQL%20Data%20Warehouse%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font%3A%20300%2016px%2F27.42px%20%26quot%3BSegoeUI%26quot%3B%2C%20%26quot%3BLato%26quot%3B%2C%20%26quot%3BHelvetica%20Neue%26quot%3B%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20float%3A%20none%3B%20display%3A%20inline%20!important%3B%20white-space%3A%20normal%3B%20cursor%3A%20text%3B%20orphans%3A%202%3B%20font-size-adjust%3A%20none%3B%20font-stretch%3A%20normal%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%20directly%20queries%20against%20the%20data%20with%20a%20combination%20of%20external%20tables%20and%20schema%20on%20read%20capabilities%20through%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20white-space%3A%20normal%3B%20box-sizing%3A%20border-box%3B%20orphans%3A%202%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E%3CA%20style%3D%22color%3A%20rgb(51%2C%20122%2C%20183)%3B%20text-decoration%3A%20none%3B%20box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fpolybase%2Fget-started-with-polybase%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPolyBase%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font%3A%20300%2016px%2F27.42px%20%26quot%3BSegoeUI%26quot%3B%2C%20%26quot%3BLato%26quot%3B%2C%20%26quot%3BHelvetica%20Neue%26quot%3B%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20text-align%3A%20left%3B%20color%3A%20rgb(51%2C%2051%2C%2051)%3B%20text-transform%3A%20none%3B%20text-indent%3A%200px%3B%20letter-spacing%3A%20normal%3B%20text-decoration%3A%20none%3B%20word-spacing%3A%200px%3B%20float%3A%20none%3B%20display%3A%20inline%20!important%3B%20white-space%3A%20normal%3B%20cursor%3A%20text%3B%20orphans%3A%202%3B%20font-size-adjust%3A%20none%3B%20font-stretch%3A%20normal%3B%20background-color%3A%20transparent%3B%20-webkit-text-stroke-width%3A%200px%3B%22%3E.%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

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:

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 Storage, in their native format. (Azure Data Lake Storage Gen 2 is recommended.) 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.

ADAG_DataWarehousing.png

Highlighted services

 

Related ADAG articles

 

See Also

The Reference Architecture, Enterprise BI in Azure with SQL Data Warehouseimplements an extract, load, and transform (ELT) pipeline that moves data from an on-premises SQL Server database into SQL Data Warehouse and transforms the data for analysis.

The Azure Architecture Center also features two related example scenarios that demonstrate solutions using these technologies:

In addition, the Modern Data Warehouse solution ingests the data sources through Azure Data Factory, combining your data to Azure Blob Storage. It uses Azure Databricks to prep and train cleansed and transformed data, to be moved to Azure SQL Data Warehouse (which acts as the data hub). Like the Reference Architecture above, this solution leverages Azure Analysis Services for data modeling (then on to Power BI for your visualizations).

For more information about the data movement, see the following articles:

For more information about stream processing and Azure Data Bricks, see our reference architecture, Create a stream processing pipeline with Azure Databricks, and our ADAG article, Choosing a stream processing technology in Azure.

For more information about Azure Analysis Services and advanced analytics, see our last blog post in this blog series, Azure Data Architecture Guide – Blog #6: Business intelligence, our ADAG article, Choosing an analytical data store in Azure, our two Reference Architectures, Enterprise BI in Azure with SQL Data Warehouse and Automated enterprise BI with SQL Data Warehouse and Azure Data Factory, our Example Scenario Data warehousing and analytics for sales and marketing, and our two Solutions, Advanced analytics on big data and Real-time analytics.

 

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

 

 

AzureCAT Guidance

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