%3CLINGO-SUB%20id%3D%22lingo-sub-306646%22%20slang%3D%22en-US%22%3EAzure%20Data%20Architecture%20Guide%20-%20Blog%20%236%3A%20Business%20intelligence%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Nov%2029%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EIn%20this%20sixth%20blog%20entry%2C%20we'll%20continue%20to%20explore%20the%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FADAG%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Azure%20Data%20Architecture%20Guide%3C%2FA%3E.%26nbsp%3B%3CSPAN%3EThe%20entries%20for%20this%20blog%20series%26nbsp%3Bare%3A%3C%2FSPAN%3E%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%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%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%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%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%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%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%236%3A%20Business%20intelligence%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E(this%20one)%3C%2FSTRONG%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%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%237%3A%20Intelligent%20applications%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-8-Data-warehousing%2Fba-p%2F352865%22%20target%3D%22_blank%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%238%3A%20Data%20warehousing%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-9-Extract-transform-load-ETL%2Fba-p%2F317016%22%20target%3D%22_blank%22%3EAzure%20Data%20Architecture%20Guide%20%E2%80%93%20Blog%20%239%3A%20Extract%2C%20transform%2C%20load%20(ETL)%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CBR%20%2F%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-1760144500%22%20id%3D%22toc-hId-1760144500%22%3EBusiness%20intelligence%3C%2FH2%3E%0A%3CP%3EAzure%20offers%20a%20rich%20data%20and%20analytics%20platform%2C%20so%20you%20can%20build%20scalable%20BI%20and%20reporting%20solutions.%20Create%20rich%2C%20interactive%20reports%20with%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Power%20BI%3C%2FA%3E%20by%20having%20it%20connect%20to%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fanalysis-services%2Fanalysis-services-overview%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Azure%20Analysis%20Services%3C%2FA%3E%2C%20which%20uses%20a%20highly%20optimized%20in-memory%20engine%20to%20provide%20responses%20to%20queries%20against%20user-friendly%20semantic%20models%2C%20within%20a%20fraction%20of%20a%20second.%20The%20underlying%20data%20is%20provided%20by%20%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%20noreferrer%22%3E%20Azure%20SQL%20Data%20Warehouse%3C%2FA%3E%2C%20which%20acts%20as%20a%20central%20repository%20of%20integrated%20data%20from%20one%20or%20more%20disparate%20sources.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20564px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F64165i94FED364F6F53E1C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--792012461%22%20id%3D%22toc-hId--792012461%22%3EHighlighted%20services%3C%2FH2%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Power%20BI%20%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fanalysis-services%2Fanalysis-services-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Azure%20Analysis%20Services%20%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%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%20noreferrer%22%3E%20Azure%20SQL%20Data%20Warehouse%20%3C%2FA%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%20noreferrer%22%3E%20Azure%20Data%20Factory%20%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-950797874%22%20id%3D%22toc-hId-950797874%22%3ERelated%20ADAG%20articles%3C%2FH2%3E%0A%3CUL%3E%0A%3CLI%3ETraditional%20RDBMS%20workloads%20%3CBR%20%2F%3E%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%20noreferrer%22%3E%20Traditional%20relational%20database%20solutions%20%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%20noreferrer%22%3E%20Data%20warehousing%20and%20data%20marts%20%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%20noreferrer%22%3E%20Online%20analytical%20processing%20(OLAP)%20%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ETechnology%20choices%20%3CBR%20%2F%3E%3CUL%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%20noreferrer%22%3E%20Choosing%20a%20data%20pipeline%20orchestration%20technology%20in%20Azure%20%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%20noreferrer%22%3E%20Choosing%20a%20data%20analytics%20technology%20in%20Azure%20%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3ECross-cutting%20concerns%20%3CBR%20%2F%3E%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%20noreferrer%22%3E%20Transferring%20data%20to%20and%20from%20Azure%20%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%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%20noreferrer%22%3ERead%20the%20Azure%20Data%20Architecture%20Guide%20%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FCAT%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22AzureCAT_Icon.jpg%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F85023i552DD037E11B4FB9%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20title%3D%22AzureCAT_Icon.jpg%22%20alt%3D%22AzureCAT_Icon.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FA%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSTRONG%3E%20Azure%20CAT%20Guidance%26nbsp%3B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CEM%3E%20%22Hands-on%20solutions%2C%20with%20our%20heads%20in%20the%20Cloud!%22%20%3C%2FEM%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-306646%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20MSDN%20on%20Nov%2029%2C%202018%20In%20this%20sixth%20blog%20entry%2C%20we'll%20continue%20to%20explore%20the%20Azure%20Data%20Architecture%20Guide.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-306646%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

First published on MSDN on Nov 29, 2018
In this sixth blog entry, we'll continue to explore the Azure Data Architecture GuideThe 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.

 

Business intelligence

Azure offers a rich data and analytics platform, so you can build scalable BI and reporting solutions. Create rich, interactive reports with Power BI by having it connect to Azure Analysis Services, which uses a highly optimized in-memory engine to provide responses to queries against user-friendly semantic models, within a fraction of a second. The underlying data is provided by Azure SQL Data Warehouse, which acts as a central repository of integrated data from one or more disparate sources.

Highlighted services

 

Related ADAG articles




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




AzureCAT_Icon.jpg

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