18 Jul IT: Report Reduction
The IT department in a large services company with over 5,500 employees was being inundated with requests for “ad hoc” reports. Each report required IT resources to develop and produce. It was taking 4.5 full-time equivalents to produce ad hoc reports for management across the firm.
eMRI trained and coached a Green Belt through the process of reducing ad hoc reporting. An analysis of past requests showed clear patterns in what data was requested in the ad hoc reports and by whom. It was also discovered that there were high degrees of redundancy in the ad hoc reporting requests. Using this information, the standard reports that were issued were modified to address a proportion of the issues covered in the ad hoc reporting. Then, the team worked with managers to standardize and consolidate some of the ad hoc requests so that a single report could serve multiple managers.
By working with those who requested the ad hoc reports, modifying the standard reports to meet their needs and removing the production of what were essentially redundant reports, ad hoc reporting was reduced by approximately 40%.