PowerPivot : Showing the latest data
Show me the latest information that you have! This is a common requirement when you are building reports for users. Users do not always want to click on the selections or slicers (in case of a Excel workbook) in order to select the last day or last month. Just show the latest information.
For this blogpost, I've used an example for my data warehouse monitoring system, and this data warehouse monitoring systems monitors the SSIS packages that were executed. I have structured the SSIS packages into 3 levels: Environment, System and Package. For instance Sales is the environment, Staging and Mart are the systems and the SSIS ETL packages are at Package level. Now in order to know whether the data is correctly loaded for the different areas, the monitoring happens at Environment level.