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
Category: Powerpivot
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
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
Web Application Analytics using IIS Logs & Powerview
I have been a big fan of Powerview for its adhoc reporting capability and visualizations since its release. With Excel 2013, Powerview integrated natively with excel makes Excel even more powerful giving it adhoc reporting and data exploration capability. Technically, we all need BI in some form or the other and hence we all perform… Continue reading Web Application Analytics using IIS Logs & Powerview
Analytics for Report Server Execution Log using PowerPivot
As we all know, Report Server Execution Log plays a significant role and is the first place to look into in order to analyse & optimize the Performance of Reporting Services. Hence in each version of SQL Server, the ExecutionLog view in Report Server database is enhanced to gather more and more information. If you… Continue reading Analytics for Report Server Execution Log using PowerPivot