Day: February 26, 2014

Using BI360 and SSIS to Automate a Daily Flash Report

Have you ever had to link multiple spreadsheets together to generate a “readable” or “useable” report?  Back in a previous life/career, I was a Director of Finance at a casino, where I provided Daily Flash Reports to management.  The reports were quite detailed with slot, table games and restaurant sales data.  It would generate KPIs and a summary income statement for the day, month to date and year to date figures for current year, previous year and budget (screen shot below). 

Read More »