1 / 19

Making the numbers talk: Achieving transparency through data visualisation

Making the numbers talk: Achieving transparency through data visualisation. 6th Annual Business Intelligence Summit. Agenda. Introductions Inventory Forecasting – the business problem The Solution – before Business Intelligence Business Intelligence – what it provided to Z

grover
Download Presentation

Making the numbers talk: Achieving transparency through data visualisation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Making the numbers talk:Achieving transparency throughdata visualisation 6th Annual Business Intelligence Summit

  2. Agenda • Introductions • Inventory Forecasting – the business problem • The Solution – before Business Intelligence • Business Intelligence – what it provided to Z • Added Value – extensions to the solution • Outcomes & Benefits – some unexpected results • The Start of a Journey - ZWise

  3. Clive Trott 1994 2002 1975 2011

  4. Inventory Forecasting The Business Problem

  5. Inventory Forecasting – refined products Yesterdays Inventory Todays Inventory Cargo Receipts Production Sales Iterativecalculation

  6. Inventory Forecasting – actual Data Regular 1st November 2012 Premium Diesel Actuals AVGAS JET 31st December 2012 BFO LFO Forecasts HFO 30th April 2013 Bitumen (45-55) Bitumen (180-200)

  7. The Solution Before Business Intelligence

  8. Excel and the Manual Process • Forecast data updates provided weekly (or more) • Multi tab Excel spreadsheet • Some ‘Excel smarts’ for data updates • Excel graphs built over data • Issues • People messing with formulae and data • No consistency in graphs • No ability to add value

  9. Excel WorkbookDemo

  10. Business Intelligence What it provided for Z

  11. The New Solution • Phase 1 • Automated retrieval of industry data • Automated loading of data into a new data warehouse • Provision of existing graphs • Phase 2 • Inclusion of Z specific data sources • Addition of further Inventory Forecasts • Addition of different visualisation

  12. NewInventory Forecasting SolutionDemo

  13. Added Value Extensions to the Solution

  14. More to the Stock story • Not just Refined Products • Intermediates • Crude • Predicting future voyages • Refined Products • Crude • Scenario Planning • What-if

  15. Inventory ForecastingSolution AdditionsDemo

  16. Outcomes & Benefits Some unexpected results

  17. Outcomes and Benefits • Consistent and unified view of Inventory data • Ability for all of Z to view Inventory data • Stocks team • CEO • Simplified Weekly Stocks meetings • Staff Optimisation • Cross Business Unit benefits • Treasury • ROI within 6 months

  18. The Start of a Journey ZWise

More Related