Tag: Self Service BI

What is Power BI?

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

Few thoughts on the SQL Server 2014 launch event in San Francisco

I just finished watching the hosted customer even in San Francisco where the Microsoft CEO Satya Nadella, COO Kevin Turner, CVP of Data Platform Group Quentin Clark and the SQL Server Product Marketing GM Eron Kelly officially introduced the new release of the SQL Server 2014. In this post I am not going to give

Continue reading

What is Power BI Gateway?

After I wrote the step by step guide on integrating on premise data with Power BI models I realized that I actually dispensed some bad advice. The basic premise of the post was to demonstrate how one may use Power Query to source data into a Power Pivot model in a very elegant way (at

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

Microsoft self-service BI on premise vs cloud

It appears that Satya Nadella has added an additional layer of context to the already ambitious Microsoft strategy of transforming itself into a “devices and services” company by declaring that “Going forward, it’s a mobile-first, cloud-first world”. I believe that it is safe to assume that in the near future, the roadmap of every Microsoft

Continue reading

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

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

Slew of important SQL Server announcements is expected at SQL Pass conference in Seattle this year

Microsoft is expected to make a number of very important announcements at the upcoming SQL Pass conference in Seattle… If you are on the fence about attending it this year, I would definitely recommend attending this event.

PowerView in Excel 2013 – Business Intelligence – Second Impression

Well, the more time passes, the more I like it… Somehow I have figured out, subconsciously, how not to make it crash quite as often and also how to work around things that don’t work very well. So, in no particular order, here are few more observations… Map – like it a lot. There is

Continue reading

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