Category: Self Service BI

HTML5 support In Power View and Power BI

Now that Power BI is Generally Available (GA) I thought it would be useful to do a quick analysis of how Power View visualizations are supported in Power BI across the three media – Silverlight (default), HTML5 and Windows 8 App Please find a table below for a quick reference Feature Silverlight HTML5 Windows 8

Continue reading

How to configure on premise access in Power BI and use Power Query to load on premise data into Power Pivot

In this post I will walk you through all the steps necessary to expose your on premise enterprise data to your Power BI users of Power Query in Excel and also will demonstrate how to source that data into a Power Pivot workbook. I am not going to give you too much theory, rather, I

Continue reading

A quick rant on Power BI, #confused….

There are now scores of blogs and web articles available that do a great job of introducing Power BI (a good example can be found here) so there is little value in re-hashing it in this post. I do, however, want to reflect and pontificate a bit on this announcement. The most important piece of

Continue reading

Modeling financial scenarios tutorial available from Microsoft

Kasper de Jonge has recently posted a PowerPivot model, Access database with some financial data and a white paper that provides what I think is the absolutely best way to jump start a BI initiative focused on implementing financial metrics and KPIs. Please find the overview and the download link here. This is an absolute

Continue reading
2 comments

Unpivot data using Microsoft Data Explorer

I have been really impressed with Microsoft Data Explorer the minute I had a chance to play with it as I was able to turn formatted Excel reports into legitimate data sources available for analysis. Fairly recently, an update to the tool delivered an uber critical feature that makes a huge impact on the world

Continue reading

GeoFlow is going public

The public preview of GeoFlow is now available here http://office.microsoft.com/en-us/download-geoflow-for-excel-FX104036784.aspx I would definitely grab the “Data Explorer” plug in while I were there…(also available here http://office.microsoft.com/en-us/excel/download-data-explorer-for-excel-FX104018616.aspx) There are plenty of reviews and good tutorials of both products available elsewhere, but in the coming few days I will try to write about where I think these

Continue reading

SAP Visual Intelligence vs. Microsoft PowerPivot and PowerView

In this post I will review the latest version of SAP Visual Intelligence – 1.08 – and see how it stacks up against the Microsoft self-service BI tools, Excel, PowerPivot and PowerView. In the initial release, Visual Intelligence only supported SAP Hana, but in its latest iteration few other data sources are supported: CSV File

Continue reading

How to think strategic about Business Intelligence

Many people reach out to me asking for advice in helping them evaluate various BI platforms for their companies. In my mind I am obviously the wrong guy to ask as I am not shy to admit my fairly heavy bias towards Microsoft.  However, over the course of the last twenty years, I have been exposed

Continue reading

Forrester Releases “Self-Service Business Intelligence Platforms” report, Microsoft identified as leader

Well, a leader and not the leader, although Microsoft BI stack is definitely ranked very high by Forrester.  Please follow this link to read the report. This is probably a little bit of old news, since the report was release in June and updated in the middle of July, but I figured it be a

Continue reading

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