Data models within Azure Analysis Services and Power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-270579%22%20slang%3D%22en-US%22%3EData%20models%20within%20Azure%20Analysis%20Services%20and%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270579%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20a%20world%20where%20self-service%20and%20speed%20of%20delivery%20are%20key%20priorities%20in%20any%20reporting%20BI%20solution%2C%20the%20importance%20of%20creating%20a%20comprehensive%20and%20performant%20data%20semantic%20model%20layer%20is%20sometimes%20overlooked.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20have%20seen%20quite%20a%20few%20occurrences%20where%20the%20relational%20data%20store%20such%20as%20Azure%20SQL%20Database%20and%20Azure%20SQL%20Data%20Warehouse%20are%20well%20structured%2C%20the%20reporting%20tier%20is%20well%20presented%20whether%20that%20is%20SQL%20Server%20reporting%20services%20or%20Power%20BI%2C%20but%20still%2C%20the%20performance%20is%20not%20as%20expected.%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%20style%3D%22width%3A%20582px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56121i25FD17E6A28ABEB2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22b4ed4595-07a6-476e-92cf-ae7f01aa861e.png%22%20title%3D%22b4ed4595-07a6-476e-92cf-ae7f01aa861e.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%2Fdata-models-within-azure-analysis-services-and-power-bi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20blog%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-270579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Community Manager

In a world where self-service and speed of delivery are key priorities in any reporting BI solution, the importance of creating a comprehensive and performant data semantic model layer is sometimes overlooked.

 

We have seen quite a few occurrences where the relational data store such as Azure SQL Database and Azure SQL Data Warehouse are well structured, the reporting tier is well presented whether that is SQL Server reporting services or Power BI, but still, the performance is not as expected.

 

b4ed4595-07a6-476e-92cf-ae7f01aa861e.png

 

Read about it in the Azure blog.

0 Replies