![]() I'm going to write a little bit about my personal experiences and the reasoning behind some design decisions. This experience made me think, and I started to prepare a little slide deck, that helps to evangelize for a more sophisticated data model (at least to use a dedicated date table). Him: "Table relations, like in RDBMS? That's too complicated, can't we solve this in DAX?" Me: "Why did you not use a Calendar table?" In the last months I have seen a lot of complex DAX statements to create complex date related calculations, but without And that this power is used to compensate an insufficient data model.Īt a first glance that SSAS Tabular model seems simple: just relate tables. To much, reviewing some DAX code from customers or friends from the great community. Sometimes I'm thinking that this power is used Much is already said and written about DAX. Sometimes it seems to me that most of the time and effort is spent on creating powerful DAX statements. One of the most important aspects in finding answers to my analytical questions is to get my Tabular data model right. This will be found under the Process menu in its own chapter. One of the most powerful features of SSAS Tabular is the query language DAX. Here I will describe different modeling scenarios to provide optimal analytical performance and user experience, but also topics that have to be considered in more complex deployment environments Variant of SSAS Tabular very special is the ability to scale the service easily to the demands of different workloads. SSAS Tabular can be used to analyze large datasets with billions of rows using the on-premises variant available with MS SQL Server or as fully managed cloud service. The same version that runs in Power BI Desktop, can alsoīe used by the cloud based Power BI Service. Self-service Business Intelligence offering, but this is also due to a more frequent update cadence of Power BI. in comparison to Power Pivot one has to acknowledge, that the Power BI version is more up to date, due to the focus of Microsoft on their What makes this database special are its different flavors, it's known as Power Pivot as local variant that can be used from within Excel workbooks, more or less the same version is used by PowerīI Desktop, where it fuels the analytical reports. Some of these tools are MSFT Excel, MSFT Power BI, and Tableau, just to name a few. (a shorter name) is a column-oriented in-memory database.įrom a user perspective, it's valid to say that it's very close to the user, the data analyst, due to a great variety of frontend tools, that empower the user to analyse large amounts ofĭata in a self-service Business Intelligence approach. A certain aspect that describes this database from a technical point of view is: SSAS Tabular ![]() This database is currently one of my favorite databases to store data to answer analytical questions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |