I may be using the term Data Catalog somewhat liberally here, but since we don't have the official definition of this term yet, I hope I don't get myself in too much trouble here. As I have been experimenting with various features of Power BI, I have been creating and sharing queries in the Data Catalog; … Continue reading How to access Data Catalog in Power 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 HTML5 support In Power View and Power BI
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 How to configure on premise access in Power BI and use Power Query to load on premise data into Power Pivot
How to load Power Query directly into Power Pivot
I have to admit, I like Power Query more and more every day. Even though on one hand sometimes I feel that the tool will only appeal to a very specific type of power users, on the other hand, I can't help but feel that the tool is so good that I wonder if it … Continue reading How to load Power Query directly into Power Pivot
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 Microsoft self-service BI on premise vs cloud
Running Windows 8.1 on MacBook Pro 15 with Retina display
No, there is no mistakes here, my new official working machine is now a MacBook Pro 15 with Retina display running Microsoft Windows 8.1. I am very surprised myself with myself, but at this point, I totally understand why Microsoft decided to do what it did with its own line of hardware devices because offerings … Continue reading Running Windows 8.1 on MacBook Pro 15 with Retina display
Getting back in the game…
I have not been posting much on the site in the last few months. This lack of activity was attributed to predominantly two things: A) My summer got really busy with my primary revenue generating activities and B) There was really not whole lot going on in the MS BI space that I felt I … Continue reading Getting back in the game…
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 A quick rant on Power BI, #confused….
PowerView can now connect to multidimensional models
The cumulative update 4 for the SQL Server 2012 Service Pack 1 has now been released. This update enables PowerView to connect to Multidimensional models and also to have global filters across multiple views (pages) in a PowerView report. Please follow this link for more details http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/05/31/power-view-for-multidimensional-models-released.aspx
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 Modeling financial scenarios tutorial available from Microsoft
business intelligist 