You searched "BISM"
        Page 4 of 95 results
blog post –

Slowly Changing Dimensions handling in PowerPivot (and BISM?)

During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes  Read more

blog post –

The Microsoft BI Roadmap: BISM, UDM and Beyond

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it  Read more

video –

BISM Introduction

BISM (BI Semantic Model) is the new engine that will be available in Analysis Services “Denali”. Explore the capabilities of this new model, that will be an alternative to UDM in Analysis Services and will use the new Vertipaq engine…  Watch now

book –

Tabular Modeling in SQL Server Analysis Services (2nd Edition)

With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new projects. In this book, two world-renowned experts in Microsoft data modeling and…  Read more

article –

Data Model Size with VertiPaq Analyzer

Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.  Read more

blog post –

The state of Multidimensional and Tabular adoption

SQL Server Analysis Services is a product that does not have its own product code, being sold as part of SQL Server. I think that also Microsoft does not know (and cannot know) the exact number of users. For this reason, it’s also more difficult to analyze  Read more

white paper –

SSAS Tabular as Analytical Engine

This article describes pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it.  Read more