Microsoft isn't great at prognosticating.. here is an interesting tidbit on when we might see the next release of PowerView. 2014??? I sure hope not....as much as I love this technology, there are several glaring holes in it that have to be addressed ASAP if Microsoft were to lead the Business Intelligence quadrant again like … Continue reading Next release of PowerView
Month: April 2012
How to increase processing speed of Microsoft Analysis Services cubes
great tip on how to process your analysis services cubes faster by running the processing in more threads http://geekswithblogs.net/ManicArchitect/archive/2010/11/02/142558.aspx
Microsoft SQL Azure labs – interesting new technology for the cloud
There are several interesting concepts that Microsoft is working on available here. I am currently taking a deep dive into the Microsoft Data Explorer. However, any B2C company should definitely take a look at the Social Analytics. Data Hub is looking pretty interesting as well...
Columnstore index vs MOLAP
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
xVelocity and Columnstore Indexes review
Today I decided to take xVelocity and columnstore indexes for a spin and see whether this technology lives up to all the hype. I tested it on a 2Gb fact table with about 21M rows. First I wrote a query that joined the fact table with a Customer dimension and returned the total revenue grouped … Continue reading xVelocity and Columnstore Indexes review
How to expose Master Data Services in SharePoint
I have been hacking around this for a while trying to expose MDS web application in SharePoint. Apparently, the trick to remove the non-functional UI elements is to use hosted=true query parameter as in http://MDSWebAPP:PortNumber/MDS/Explorer/AttributeSL.aspx?MID=10&VID=23&EID=44&hosted=true#/ExplorerEntity?MID=10&VID=23&EID=44&hosted=true you can find more details on how to do it here
Using Reporting Services Charts with PerformancePoint reports in a SharePoint Dashboard
One of the greatest strengths of SharePoint as it pertains to the world of Microsoft Business Intelligence is its ability to bring together various components of the Microsoft BI stack into a seemless user experience. When it works, it works great, however, when it does not quite work, it gets very annoying.. Recently, I was … Continue reading Using Reporting Services Charts with PerformancePoint reports in a SharePoint Dashboard
Choosing between PerformancePoint, PowerView, Excel Services and Reporting Services for your data visualizations
Even though PowerView is the only Microsoft Data Visualization tool that is new on that list, it appears that there is some confusion as to how these four options compare with each other. The topic is pretty big, so it will probably take me a few tries to get it done right, but here is the first … Continue reading Choosing between PerformancePoint, PowerView, Excel Services and Reporting Services for your data visualizations
business intelligist 