great article about Column store indexes and best practices around them
I believe that Microsoft has delivered a very solid release with SQL Server 2012. I love MDS V2, I am giddy with excitement about columnstore indexes (still trying to hunt down any hints that would substantiate the claimed availability of this technology for Analysis Services), I think that PowerView will be a huge success, although … Continue reading Drillable charts in Mcrosoft Office 15
Microsoft is claiming that xVelocity technology will be available across SQL Server database engine, PowerPivot AND Analysis Services... This technology works great for the first two, however, I couldn't find anything on column store for the Analysis Services.... This would be a huge new improvement for SSAS...
Seems to get a lot of attention from Microsoft. Richard Chin who is leading the SQL Server businesses for Microsoft had a long talk about it at the launch event. With a host of great features coming out in this release (MDS, DQS, PowerView just to name a few) of SQL Server, it seems a little … Continue reading SQL Server 2012 and Hadoop
Microsoft is re-branding its Vertipaq in-memory engine that is currently used in PowerPivot and naming it xVelocity. That's hardly worth a blog entry per se.. Howerver, and this is big, xVelocity now is added to both Analysis Services AND Database engines... Supposedly, this technology incrases preformance of the existing relational queries by 10-100... I will … Continue reading xVelocity
Microsoft has posted 16 virtual labs online. The labs cover three major areas: Business Intelligence Mission Critical Operations Database Management Those of us who are trying to jump start Self Service BI in our organizations should checkout the following three: Creating a PowerPivot Model and Report in the Excel Client Defining DAX Calculations with Microsoft … Continue reading Microsoft SQL Server 2012 Virtual Labs
EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 Hierarchycal Data is an interesting way to implement Parent/Child or tree-like relationships... Microsoft has posted a great tutorial here on how to convert data into the Hierarchycal format.