Looks like we only have a month or two before the next version of Microsoft Office (commonly known as Office 15) becomes available for beta testing. Not surprising, SharePoint, Visio and Project will be released in a beta form around the same time.
Choosing a Tabular or Multidimensional model in SQL Server 2012 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
Microsoft SQL Server 2012 Fast Track White Paper is now available
Microsoft has updated its excellent Fast Track ( Microsoft Data Warehouse reference architecture) white paper for latest versoin of SQL Server (2012). Whether you decide to follow this architecture or not (and there are good reasons for and against it given your budget and objectives), you will find a wealth of great and useful information that will help you … Continue reading Microsoft SQL Server 2012 Fast Track White Paper is now available
SharePoint on iPad
Microsoft has recently released a Cumulative Update 2011-12 for Microsoft SharePoint that enables consuming Microsoft BI data visualizations on Apple iPad running iOS 5 Safari browser. Not all visualizations are supported: Visualization Type Renders on iPad Dashboards (filters, linked elements) YES Excel Services (including PPS webpart) YES Reporting Services (including PPS webpart) NO PerformancePoint ScoreCards YES … Continue reading SharePoint on iPad
DirectQuery white paper is now available
Microsoft recently published a Using DirectQuery in the Tabular BI Semantic Model white paper. The white paper provides a great introduction for the DirectQuery technology, xVelocity and columnstore indexes. It also covers security, capacity planning and deployment best practices.
PowerView wish list
My PowerView wish list inludes the following: HTML5 Support (!) Multidimensial model support Hierarchies Drilldowns (at least in some way) Ability to insert images Ability to customize background PerformancePoint and/or SharePoint integration Improved touch response
Next release of PowerView
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
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
business intelligist 