Resource Utilization Data Collection Workflow – Case study
About the client
Client is same as the client in above example. An American Fast-food company having 37,855 restaurants located globally.
Requirements
Manage pre-activities for Demand The idea was to create workflow to collect data of their teams distributed in different geographies and it was needed to integrate it through a common workflow to generate the reports for resource utilization.
Challenges
Communicate with all the departments and access the statistical data stored at different locations. Data stored in different format as XLS, CSV, XML, etc.
Solution Provided
Collected data using various data sources as JDBC, XML, HTML, CSV, Excel, email attachments, etc. Create multiple custom tables. Create multiple custom work flows. Integrate the workflow and generate data. Create various reports.
Benefits
Creates on-demand reports in real time. Permit viewing of 100+ custom reports. Drastic reduction in time by generating automated reports than generating manual reports.