My primary goal was to build centralized Dashboards in MS Excel to generate business insights from the fragmented revenue data.o Saved ~50% time spent every month on building ad-hoc analyses to generate Business Insights.o Used MySQL to combine data from 700+ data tables to build a master table in one week.o Built a centralized dashboard in Excel with 6+ parameters to analyse the data.o Improved the quality of business insights generated by increasing the revenue visibility to a branch-level granularity.o Automated monthly summary reports giving insights on trends up to city & state level sales.