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

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