I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?
The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security. In order to implement it, first we need the means of finding out the windows credentials of the user. That can be accomplished using the DAX function USERNAME(). Second, we need to map … Continue reading Dynamic security in a tabular model for analysis services
Many great discussions are taking place about the future of the Multidimensional mode for the Analysis Services. It is very clear where the majority of the investment went for the 2012 version (hint... think rows and columns and not multidimensional). At the same time, one might argue that the traditional or Multidimensional set of features is already … Continue reading Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services
I have been trying to wrap my brain around the various options that Microsoft offers around near real-time analytical experience for the end users. Clearly, a semantic model is needed to isolate the end from the complexity of SQL/Relational Data Warehouse. So I see three options to explore: traditional MOLAP model for Analysis Services New … Continue reading Columnstore index vs MOLAP
The book can be downloaded in PDF , mobi (Kindle) or epub (sony reader) formats... The book does a really good job introducing such new features of Microsoft SQL Server as Data Quality Services, Master Data Services, PowerView and BI Semantic Model.. and it's free, definitely a good idea to make it part of your technical library. If this sounds like too good of a … Continue reading Free technical book “Introducing Microsoft SQL Server 2012” is available for download
Not sure if anybody is using Microsoft Virtual Academy.. if you are not - you should... What's the compelling event? Well, 7 freshly minted modules have just been posted for our perusal: Developing and Managing a BI Semantic Model Configuring and Securing Complex BI Applications in SharePoint Enriching your BI Semantic Models with Data Analysis … Continue reading Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services