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).