If you read the title of this post & were wondering, What the hell is that ? , Trust me I have no clue how I made this up but I felt it would be an appropriate title when someone wants to perform data analysis on their fb data to understand how much active they… Continue reading FUN – Self-Assessment of your social presence in fb using Power BI
Category: Power BI
Ungrouping Column using DAX in PowerPivot or SSAS Tabular
To start this blog post, let me first explain the problem. Consider a scenario where you receive an excel sheet or data in the following format Category SubCategory Bikes Mountain Bikes Road Bikes Touring Bikes Components Handlebars Bottom Brackets Brakes Chains Cranksets Derailleurs Forks Headsets Mountain Frames Pedals Road Frames Saddles Touring Frames Wheels Clothing… Continue reading Ungrouping Column using DAX in PowerPivot or SSAS Tabular
Sociometer Using Power BI
Recently I presented a demo on Power BI for the internal audience at Microsoft which was very received & appreciated by the audience. I thought it would be a good demonstration for external audience as well. Hope you all like the demo & Power BI !!! Parikshit Savjani Premier Field Engineer
Analyze SQL Database Table Space Usage using TreeMap Visualization in Excel 2013
One of fascinating features of Excel 2013 is “App for Office” option which exposes us to some of the great apps from Office store which you can download and install. One of such useful apps which I came across is TreeMap Data Visualization developed by Microsoft Research which allows you to represent hierarchical data of… Continue reading Analyze SQL Database Table Space Usage using TreeMap Visualization in Excel 2013
How to provision Power BI App to your Office 365 Enterprise portal
With an excellent passionate & energetic presentation on Power BI by Amir Netz in WPC, there has been a lot of excitement and buzz for power bi within the BI Community (In case you haven’t watched the video yet, you can find it here ). The community is now eagerly waiting to lay their hands… Continue reading How to provision Power BI App to your Office 365 Enterprise portal