COMMANDperformance : Improving Corporate Performance

1. COMMANDperformance: Improving Corporate Performance Bob Berryhill bberryhill@commandalkon.com (205) 879-3282

2. Session Objective Understand how COMMANDperformancecan help people make better decisions using real time information. We will discuss how COMMANDperformance will: • Extract more value from your Integra or COMMANDseries application suite of products • Enhance your knowledge of corporate performance by way of extended reporting, trend analysis, and dashboards • Discuss implementation process MGT-007 COMMANDpeformance: Improving Corporate Performance

3. Intelligence or Analytics? MGT-007 COMMANDpeformance: Improving Corporate Performance

4. Or Just Reporting? The analysis of business information to support better decision making and improve business results is: (A) Business Intelligence (B) Business Analytics (C) Reporting (D) All of the Above … OR • COMMANDperformance MGT-007 COMMANDpeformance: Improving Corporate Performance

5. COMMANDperformance Key Questions for Business • Do you have access to the information you need when you need it? • Do you rely on analyst in IT for critical business information? • Do you trust the information you receive? • Is everyone working off the same numbers? MGT-007 COMMANDpeformance: Improving Corporate Performance

6. COMMANDperformance Key Questions for IT • Is it difficult to satisfy user requests for information? • Can business users author their own reports or do their own analysis? • Do business users require access to different data sources? • Is user adoption for the current reporting tools as high as expected? • Do users manipulate data and/or combine data from multiple applications? MGT-007 COMMANDpeformance: Improving Corporate Performance

7. COMMANDperformance Solution Overview A customizable information framework that spans the organization: • Information available via desktop, web or mobile • Information push to users – e-mail, dashboards • Summarized and Detailed Reporting • Information from multiple data sources Do you have access to the information you need when you need it? MGT-007 COMMANDpeformance: Improving Corporate Performance

8. COMMANDperformance Solution Overview A customizable information framework that spans the organization: • User Authoring and Analysis Tools in a Single Application • Query Studio • Analysis Studio • Workspace Advanced (new module) Do you rely on analyst in IT for critical business information? MGT-007 COMMANDpeformance: Improving Corporate Performance

9. COMMANDperformance Solution Overview A customizable information framework that spans the organization: • Data modeled in Business Terms • Data consolidated from multiple sources • One source of reporting • Eliminate effort required to assemble custom reports Do you trust the information you receive? Is everyone working off the same numbers? MGT-007 COMMANDpeformance: Improving Corporate Performance

10. COMMANDperformance Solution Components • Data Manager - runtime • Framework Manager - runtime • Transformer – runtime/designer • Cognos Connection • Reporting and Analysis • Report Studio, Query Studio, Analysis Studio, • Workspace Advanced, Active Reports MGT-007 COMMANDpeformance: Improving Corporate Performance

11. Data mart / Data Warehouse • Data Manager Module • Connects to Multiple Data Sources • Apply Business Rules to Data • Incremental Updates – Changed Records Only • Scheduled Updates to Support Business Needs • ¼ Hour, Hourly,Daily MGT-007 COMMANDpeformance: Improving Corporate Performance

12. Data Data Data + Integrated Data Marts x/y - Data mart / Data Warehouse • Data Manager Module Extract Load Transform CMDseries APEX Integra future CMDbatch ERP future Custom work Data Warehouse Spreadsheets Custom work Operational Data Sources MGT-007 COMMANDpeformance: Improving Corporate Performance

13. Data Data Data + Integrated Data Marts x/y - Data mart / Data Warehouse • Data Manager Module • Data Manager Module • Defined Measures by Product LineConcrete Revenue, Aggregate Qty etc. • Cancelled Ticket Quantities set to 0 • Status Time Intervals Calculated • Clock Time and Efficiency Metrics Calculated Extract Load Transform CMDseries APEX Integra future CMDbatch ERP future Custom work Data Warehouse Spreadsheets Custom work Operational Data Sources MGT-007 COMMANDpeformance: Improving Corporate Performance

14. Metadata Modelling • Framework Manager Module • Maps database schema to Business Terms • Apply Business Rules and Calculations • Pre-Define Filters • Publish Packages for Business Function • Sales Tickets, Driver Times, Accounting MGT-007 COMMANDpeformance: Improving Corporate Performance

15. Metadata Modelling • Framework Manager Module Dimensions, Hierarchies and Levels PreDefined Measures User Defined Plant Grouping MGT-007 COMMANDpeformance: Improving Corporate Performance

16. Product July Widgets sold inMontana in July Widgets 100 Time Montana Location Metadata Modelling • Transformer Module • Multi-Dimensional Cubes • Pre-Aggregate Data • Analyze Large Data Sets • Updated Nightly MGT-007 COMMANDpeformance: Improving Corporate Performance

17. Query / Authoring • Ad-Hoc Queries / Report Authoring • Query Studio – Transaction Details • Analysis Studio – Summarized Date • Workspace Advanced – Author Simple Reports • Report Studio – Full Report Authoring MGT-007 COMMANDpeformance: Improving Corporate Performance

18. System Requirements 2-Tier Server Architecture Windows 2003 Server • 2.0 GHz Processor(Dual Core) • 8GB RAM • Dual Drives • IIS MGT-007 COMMANDpeformance: Improving Corporate Performance

19. System Requirements N-Tier Server Architecture Windows 2003 Server • 2.0 GHz Processor(Dual Core) • 8GB RAM • Dual Drives • IIS MGT-007 COMMANDpeformance: Improving Corporate Performance

20. Implementation - Installation • Initial Installation Steps • Remote Installation • Install Software & Configure • Initialize Data Mart / Schedule Updates • Validate Data • Apply Security • One to Two Days MGT-007 COMMANDpeformance: Improving Corporate Performance

21. Implementation - Installation • Initial Installation Steps • Review Reports with Business • Align Reports with Business Roles • Assign Report Owners • Validate Data • Maintain Report Accuracy • Manage Related Business Processes MGT-007 COMMANDpeformance: Improving Corporate Performance

22. Implementation - Installation • Initial Installation Steps • End-User Training – few hours • Analysis Tools – 1 or more days • Report Authoring – 3 or more days • Training and Mentoring may take longer MGT-007 COMMANDpeformance: Improving Corporate Performance

23. Implementation - Installation • Initial Installation Steps • Role Based Reporting • Recommended Reports • Dispatch Office MGT-007 COMMANDpeformance: Improving Corporate Performance

24. Role Based Reports – Dispatch Office • “Driver Clock Time with Ticket Detail” • Valid Clock Times and Status Times are Essential • Usually Responsibility of Dispatch Office or Plant Managers MGT-007 COMMANDpeformance: Improving Corporate Performance

25. Role Based Reports – Dispatch Office • “Driver Clock Time with Ticket Detail” Clock times Utilization Exceptions MGT-007 COMMANDpeformance: Improving Corporate Performance

26. Role Based Reports – Dispatch Office • “Driver Clock Time with Ticket Detail” • Accurate Data is Essential • Have status equipment repaired • Enforce clock-in / out procedures • Check Daily as part of Business Process MGT-007 COMMANDpeformance: Improving Corporate Performance

27. Role Based Reports – Dispatch Office • “Driver Startup / Shutdown Details” End of Day In Service Missing Clock out MGT-007 COMMANDpeformance: Improving Corporate Performance

28. Role Based Reports – Dispatch Office • “Driver Task List” Exclude InSvc & OnLoad MGT-007 COMMANDpeformance: Improving Corporate Performance

29. Role Based Reports – Dispatch Office • “Startup Time and Tasks” MGT-007 COMMANDpeformance: Improving Corporate Performance

30. Role Based Reports – Dispatch Office • “Startup Time and Tasks” MGT-007 COMMANDpeformance: Improving Corporate Performance

31. Role Based Reports – Dispatch Office • “Startup Time and Tasks” Drill to Plant Level MGT-007 COMMANDpeformance: Improving Corporate Performance

32. Role Based Reports – Dispatch Office • “Startup Time and Tasks” Drill to Driver & Day Level MGT-007 COMMANDpeformance: Improving Corporate Performance

33. Role Based Reports – Dispatch Office • “Driver Task List” MGT-007 COMMANDpeformance: Improving Corporate Performance

34. Role Based Reports – Dispatch Office • “Startup Time - Adjusted” MGT-007 COMMANDpeformance: Improving Corporate Performance

35. Role Based Reports – Dispatch Office • “Adjusted Startup with Task Time” MGT-007 COMMANDpeformance: Improving Corporate Performance

36. Role Based Reports – Dispatch Office • “Adjusted Startup with Task Time” • Accurate Clock Times • Accurate Driver In-Service Times • Accurate Task Assignments • Configuration for EOD Tasks MGT-007 COMMANDpeformance: Improving Corporate Performance

37. Role Based Reports – Dispatch Office • “Scheduled Quantity Variance” • Order Snapshot from Midnight • Analyze order accuracy • Customer Summary Option • Summary Graph Option (new) MGT-007 COMMANDpeformance: Improving Corporate Performance

38. Role Based Reports – Dispatch Office • “Scheduled Quantity Variance” MGT-007 COMMANDpeformance: Improving Corporate Performance

39. Role Based Reports – Dispatch Office • “Real-Time Dashboard” MGT-007 COMMANDpeformance: Improving Corporate Performance

40. Role Based Reports – Dispatch Office • “Real-Time Dashboard” • Monitor Metrics in “Real-Time” • Updated Hourly or More Frequently • Connect users with Metrics • Promote Quality Data and Processes MGT-007 COMMANDpeformance: Improving Corporate Performance

41. Implementation - Installation • Initial Installation Steps • Role Based Reporting • Recommended Reports • Operations – Plant Manager MGT-007 COMMANDpeformance: Improving Corporate Performance

42. Role Based Reports – Plant Manager • “Plant Loading Time” • Ticketed Status Queue Time • Load Time (with units per second) • Wash / Temper Time • Total Load Time • Ticket Detail / Graph options MGT-007 COMMANDpeformance: Improving Corporate Performance

43. Implementation - Installation • Initial Installation Steps • Role Based Reporting • Recommended Reports • Management MGT-007 COMMANDpeformance: Improving Corporate Performance

44. Role Based Reports – Operations Mgr • “Driver Utilization Analysis” Utilization Non Productive Time and the Cost Associated with itBased on Excessive time in each status. MGT-007 COMMANDpeformance: Improving Corporate Performance

45. Role Based Reports – Operations Mgr • “Material Cost Analysis” xxxxxxxxxx zzzzzzzzzzz zzzzzzzzzzz xxxxxxxxxx xxxxxxxxxx zzzzzzzzzzzz zzzzzzzzzzzz zzzzzzzzzzzz MGT-007 COMMANDpeformance: Improving Corporate Performance

46. Role Based Reports – Operations Mgr • “Report Card” MGT-007 COMMANDpeformance: Improving Corporate Performance

47. Role Based Reports – Operations Mgr • “Delivery Cycle” MGT-007 COMMANDpeformance: Improving Corporate Performance

48. Implementation • Keys to Success • The analysis of business information to support better decision making and improve business results is … • A Continuous Process Requiring Continued Commitment MGT-007 COMMANDpeformance: Improving Corporate Performance

49. Implementation • Keys to Success • Executive Support and Involvement • Commitment to performance metrics • Utilize executive reports • Integrate reporting into business process • Support required process change MGT-007 COMMANDpeformance: Improving Corporate Performance

50. Implementation • Keys to Success • Product Champions • Develop proficiency using application • Understand business processes and data flow • Share knowledge and skills with others • Strong emphasis on data accuracy • Commitment to continuous improvement MGT-007 COMMANDpeformance: Improving Corporate Performance