Business Intelligence, Data Visualisation, Tableau

Dates in Tableau Calculations

ate formatting is a crucial aspect of many reports. Recently I found a useful trick in Tableau for formatting dates when using calculated fields. Using the DateTrunc formula, it is possible to aggregate the raw values up to a particular date in a time period. The DateTrunc calculation will take the values in the specified… Continue reading Dates in Tableau Calculations

Business Intelligence, PowerBI, Tableau

Preserving Tablixes on Export from SSRS 2008 to Excel

In Reporting Services 2008, it is possible to export to Excel using the Visual Studio interface and the Reporting Services browser. However, what about the case where you have a complex report with numerous tablixes, matrices and so on, and want to preserve these in the target Excel Workbook? Here is a nifty trick for… Continue reading Preserving Tablixes on Export from SSRS 2008 to Excel