Presentation Transcript

1. Taking the Next Step with TM1 to Cognos BI and SPSS

   Wayne Banks
2. Not Hair Straighteners
3. At a glance
4. “At GHD, we think beyond tomorrow to anticipate future challenges.”
5. Financial performance Statement of Revenue AUD Millions 2012 Revenue by Global Sector
6. Anatomy of a downturn
7. Business process professional services firm Get the work Get the people Do the work Bill the work Collect the cash Fund the company Run the company What are the right metrics? And how often? What is REALLY used to Run the company?
8. Finance strategy – People, Process, Technology Right people, Right roles, Right place Great Plains, BST, Cognos, TM1 Month End, Forecast, Budgets
9. Budget & Planning Process Multi year Monthly Annual Adaptive Planning Quarterly
10. Technology - TM1 Since 2002, bought as we went to NZ. TM1 used as corporate consolidated tool. CEO logs in. CEO can see acquisition within one month of transaction. Prolonged life of legacy system. Our business has changed shape significantly – Time to invest to get greater value. Cognos 10 BI TM1
11. Getting the right information to make the right decisions Are we suffering analysis paralysis with TOO many KPIs / metrics? Are our people wasting too much time hunting data? In tough times – keep focus on the basics (cash, profit, etc). Do you have the most important metrics available to run your business when you need them? Do we see them quickly and cleanly in a Dashboard? WE WILL SOON ……………. COGNOS WILL CHANGE THE WAY WE USE INFORMATION
12. The enterprise analytics challenge The Blind Men and the Elephant - John Godfrey Saxe (1816-1887)
13. How do my analysts spend their time? Data Analysis &Business Insight Increase Value Add Less time for preparation - more for interrogation, insight and engagement with business and operations to influence decisions. Reporters to analysts. Communicate For Results - focussed analytics quickly highlighting issues and opportunities to our business partners - less is more. Standardized suite of reports and tools - one version of the truth. Realizing this vision requires replacement of rather than addition to current reporting & analysis. ReduceWaste Data Prep &Reporting Future State Start State
14. How do financial analysts spend their time? Built once, used by many…………………………. MOVE TO VALUE ADD Guided Analysis Business Insight & Predictive Analytics Standardised Reports Top to Bottom Mine for Commercial Impact Data Prep & Reporting Understand Drivers BUSINESS INTELLIGENCE FOUNDATION Data Sources Reports Scorecards / Dashboards Predictive
15. Business Impact Functionality Key performance indicators provide business insight but without drill down to detail Multiple versions of the truth Delayed performance reporting Dashboard Layer Reports not Dashboards Ad Hoc Reporting on request Executive No Business user control over reporting Multiple report specs for reporting Single version of the truth Real time performance reporting Reporting Layer Financial Reporting with no drill down Management Reporting with no drill down Budget Reporting Comparative reporting Financial & Business Manager Application and Database Layer Management of Hierarchies Budgeting / Forecasting Financial Consolidation Foundation for Reporting Top down driven modeling Separate login to go to detail Multiple version of the truth Extensive training required Line Manager TM1 Source System Layer Transactional Data Hierarchies Mappings Job Manager
16. Software toolset
17. Business Impact Functionality Key performance indicators provide business insight with drill down to detail Single version of the truth Real time performance reporting Dashboard Layer Dashboards for Performance Dashboards Self-serve Reporting Portal Executive Business user control over reporting Shared report specs for reporting Single version of the truth Real time performance reporting Reporting Layer Financial Reporting with Drill Down Management Reporting with Drill Down Budget Reporting Comparative reporting Financial & Business Manager Modelling Contribution Analysis PredictiveAnalysis Top down driven modeling Separate login to go to detail Multiple version of the truth Extensive training required Application and Database Layer Management of Hierarchies Budgeting / Forecasting Financial Consolidation Foundation for Reporting Controller TM1 SPSS Analyst & Architect Department Manager Source System Layer Transactional Data Hierarchies Mappings
18. An End to End view of how the numbers flow
19. How does it all fit together? Budget Costing & Pricing Project Accounting Month End Forecasting Reporting & Analysis Process: Technology: Organisation: Review how we deliver our value proposition People: Data: Clear and consistent hierarchy Data: 19
20. GHD business intelligence project framework
21. SPSS Predictive Analytics
22. Assist with Volumes of data analytics that optimise decision-making “Gold Nuggets” Predictive analytics Customer Analytics Customer View Enable data and predictive modeling to guide front-line interaction (eg, Customer segmentation, profitability analysis – “tail”, “share of wallet”, etc). Operational Analysis Uncover unexpected patterns and associations from all data within your organization (eg, project overruns , project forecasting). Forecasts eg, Cashflow and Profit. Cost Leakage and Fraud Use across large volumes of data to get Audit coverage. – Payroll testing (allowances , Expenses outside policy, etc. Acquire Grow Retain Publish Automate Modeling Deployment Statistics Datacollection Protect Share
23. Your Business will always ask for More Think - People / Process / Technology “Not Just Technology” Invest Once and look to maximise Leverage Best of Luck
24. Thank You