Using Azure Analysis Services with Azure Data Lake Storage

%3CLINGO-SUB%20id%3D%22lingo-sub-105647%22%20slang%3D%22en-US%22%3EUsing%20Azure%20Analysis%20Services%20with%20Azure%20Data%20Lake%20Storage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-105647%22%20slang%3D%22en-US%22%3E%3CP%3ESupport%20for%20Azure%20Data%20Lake%20Store%20(ADLS)%20is%20now%20available%20in%20Azure%20Analysis%20Services%20and%20in%20SQL%20Server%20Data%20Tools%20(SSDT).%20Now%20you%20can%20augment%20your%20big%20data%20analytics%20workloads%20with%20rich%20interactive%20analysis%20for%20selected%20data%20subsets%20at%20the%20speed%20of%20thought!%20Business%20users%20can%20consume%20Azure%20Analysis%20Services%20models%20in%20Microsoft%20Power%20BI%2C%20Microsoft%20Office%20Excel%2C%20and%20Microsoft%20SQL%20Server%20Reporting%20Services.%20Azure%20Data%20Lake%20Analytics%20(ADLA)%20can%20be%20used%20to%20run%20U-SQL%20batch%20jobs%20directly%20against%20the%20source%20data%2C%20such%20as%20to%20generate%20targeted%20output%20files%20that%20Azure%20Analysis%20Services%20can%20import%20with%20less%20overhead.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAzure%20Data%20Lake%20Analytics%20(ADLA)%20can%20process%20massive%20volumes%20of%20data%20extremely%20quickly.%20Exporting%20approximately%202.8%20billion%20rows%20of%20TPC-DS%20store%20sales%20data%20(~500%20GB)%20into%20a%20CSV%20file%20took%20less%20than%207%20minutes%20and%20importing%20the%20full%201%20TB%20set%20of%20source%20data%20into%20Azure%20Analysis%20Services%20by%20using%20the%20Azure%20Data%20Lake%20connector%20took%20less%20than%206%20hours.%20These%20results%20highlight%20Azure%20Data%20Lake%20as%20an%20attractive%20big-data%20backend%20for%20Azure%20Analysis%20Services.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%225ed7c10e-c6d5-4620-9e24-d0c542658d28.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F19997i5048763D28B4F775%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%225ed7c10e-c6d5-4620-9e24-d0c542658d28.png%22%20alt%3D%225ed7c10e-c6d5-4620-9e24-d0c542658d28.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERead%20about%20it%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fusing-azure-analysis-services-with-azure-data-lake-storage%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20blog%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-105647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20%26amp%3B%20Storage%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Lake%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Community Manager

Support for Azure Data Lake Store (ADLS) is now available in Azure Analysis Services and in SQL Server Data Tools (SSDT). Now you can augment your big data analytics workloads with rich interactive analysis for selected data subsets at the speed of thought! Business users can consume Azure Analysis Services models in Microsoft Power BI, Microsoft Office Excel, and Microsoft SQL Server Reporting Services. Azure Data Lake Analytics (ADLA) can be used to run U-SQL batch jobs directly against the source data, such as to generate targeted output files that Azure Analysis Services can import with less overhead.

 

Azure Data Lake Analytics (ADLA) can process massive volumes of data extremely quickly. Exporting approximately 2.8 billion rows of TPC-DS store sales data (~500 GB) into a CSV file took less than 7 minutes and importing the full 1 TB set of source data into Azure Analysis Services by using the Azure Data Lake connector took less than 6 hours. These results highlight Azure Data Lake as an attractive big-data backend for Azure Analysis Services.

 

5ed7c10e-c6d5-4620-9e24-d0c542658d28.png

 

Read about it in the Azure blog.

 

 

0 Replies