enterprise decision support - a commercial perspective pete catley supervisor, sales reporting...
TRANSCRIPT
![Page 1: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/1.jpg)
Enterprise Decision SupportEnterprise Decision Support- A Commercial Perspective- A Commercial Perspective
Pete Catley
Supervisor, Sales Reporting Systems,
Ford Europe
Thursday 18 November, 1999
SEM304 - Commercial Programming
![Page 2: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/2.jpg)
Agenda:Agenda:
Introduction Enterprise Decision Support Overview Case Study: Smarts
![Page 3: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/3.jpg)
Why Do BusinessesWhy Do BusinessesHave ITHave IT
Departments?Departments?
![Page 4: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/4.jpg)
Only Small BusinessesOnly Small BusinessesCan SurviveCan SurviveWithout ITWithout IT
![Page 5: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/5.jpg)
As Soon As You StartAs Soon As You Startto Scale up As anto Scale up As an
EnterpriseEnterpriseYou Begin to RecogniseYou Begin to Recognise
the Need for anthe Need for anIT DepartmentIT Department
![Page 6: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/6.jpg)
IT Departments HaveIT Departments HaveDeveloped Over the YearsDeveloped Over the Years
![Page 7: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/7.jpg)
Adding Machines
Business Systems Technical Systems
Ope
ratio
nal
Ana
lytic
al
Transaction Processing
Database Applications
Process Control
CAD / CAM / CAE
Reporting Applications
Analytical Applications
![Page 8: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/8.jpg)
Why Do We Analyse?Why Do We Analyse?
![Page 9: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/9.jpg)
Beware:Beware:ParalysisParalysis
ByByAnalysisAnalysis
![Page 10: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/10.jpg)
Business Reality:Business Reality:Difficult to TurnDifficult to Turn
“Data”“Data”IntoInto
“Information”“Information”
![Page 11: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/11.jpg)
Reporting
Decision Support
Actionable Intelligence
Everything That HappenedEverywhereAll The Time
Key Things That HappenedIn Important Locations
At Relevant Times
Some Things You Could DoTo Address The Issues
• Fixed Format• High Redundancy• High Effort To Interpret
• Dynamic Format• Focused Output• Low Effort To Interpret
• High Value Add• Very Rapid Response
![Page 12: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/12.jpg)
Imagine If Your CarImagine If Your CarHad NoHad No
Instrument Panel?Instrument Panel?
![Page 13: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/13.jpg)
Now Imagine You AreNow Imagine You AreA Captain Of IndustryA Captain Of IndustryAt The Helm Of TheAt The Helm Of The
SS “Shareholder Value”SS “Shareholder Value”
![Page 14: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/14.jpg)
So the Vision is:So the Vision is:Wouldn’t It Be NiceWouldn’t It Be NiceIf We Had A SystemIf We Had A System
Which Which Told UsTold UsWhere The Issues Were?Where The Issues Were?
![Page 15: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/15.jpg)
Vision EnablersVision Enablers
Reporting By Exception “Traffic Lighting” OLAP “Slice & Dice” Key Performance Indicators E-mail Notification Of Exceptional Events Use of “Push” Web Technology “What If” Analysis & Modelling Thematic Mapping
![Page 16: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/16.jpg)
What Do You NeedWhat Do You NeedTo Do To GainTo Do To Gain
Actionable Intelligence?Actionable Intelligence?
![Page 17: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/17.jpg)
Operational SystemsCapture
Data Warehouse
Staging AreasCleanse
Meta-Data Layer
Data Marts
Store
Aggregate
Interpret
OLAPDeliver Ad-Hoc Reports Executive Information
NormalisedRelational Model
De-Normalised“Star Schema”
MainframeData Sources
Simple RelationalTables
![Page 18: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/18.jpg)
That Looks Pretty StraightforwardThat Looks Pretty Straightforward
Let’s Do It!Let’s Do It!
![Page 19: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/19.jpg)
Case Study:Case Study:
SALES MANAGEMENT ANALYSIS & REPORTING TOOL SETsmartssmarts
![Page 20: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/20.jpg)
First:First:Sell The VisionSell The Vision
![Page 21: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/21.jpg)
““How Much Is All ThisHow Much Is All ThisGoing To Cost Me?”Going To Cost Me?”
![Page 22: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/22.jpg)
““Ouch!”Ouch!”
![Page 23: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/23.jpg)
Build A Cast-IronBuild A Cast-IronBusiness CaseBusiness Case
![Page 24: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/24.jpg)
Gain A PowerfulGain A PowerfulSponsorSponsor
![Page 25: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/25.jpg)
Who, In Their Right Mind,Who, In Their Right Mind,Would DevelopWould Develop
A Mainframe-basedA Mainframe-basedSpreadsheetSpreadsheetIn-House?In-House?
![Page 26: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/26.jpg)
Nobody -Nobody -They’d Buy Excel!They’d Buy Excel!
![Page 27: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/27.jpg)
Pick AnPick AnArchitectureArchitecture
MOLAPHigh PerformanceNo. DimensionsData Volume
ROLAPNo. DimensionsData VolumePerformance
HOLAPHigh PerformanceNo. DimensionsData VolumeDevt. Complexity
DOLAPCostDevt. ComplexityImplementation Ease
![Page 28: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/28.jpg)
Front-End ArchitectureFront-End Architecture
Buy OLAP Tools– Web-Based Ad-Hoc Query– Reporting– Web Publishing– Personal Web Portal Concept
![Page 29: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/29.jpg)
Back-End Architecture Back-End Architecture
Re-Use Existing Data Extract Build Staging Areas Build Data Transformations Build Data Warehouse Build Data Marts
![Page 30: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/30.jpg)
But:But:Choose The Right ToolsChoose The Right Tools
![Page 31: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/31.jpg)
Pick “Best-In-Class”Pick “Best-In-Class”
(But Teacher Chooses(But Teacher ChoosesWho’s In The Class!)Who’s In The Class!)
![Page 32: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/32.jpg)
Tool SelectionTool Selection
ATAD /FSIC Shortlist “Proof Of Concept” Workshops Tool Selection Matrix FSIC Architecture Review
![Page 33: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/33.jpg)
Pick A Good TeamPick A Good Teamandand
A Strong Project ManagerA Strong Project Manager
![Page 34: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/34.jpg)
MetricsMetrics
7 Months To Gain Funding Approval 6 Months To Deliver Phase 1 Team of 9 120 Gb Database Sun E4500, 10 x 337mhz CPUs, 4Gb $1.4m per annum Cost Saving Launched On Time (to the day!)
![Page 35: Enterprise Decision Support - A Commercial Perspective Pete Catley Supervisor, Sales Reporting Systems, Ford Europe Thursday 18 November, 1999 SEM304 -](https://reader035.vdocuments.us/reader035/viewer/2022070307/551ac642550346b2288b568b/html5/thumbnails/35.jpg)
But:But:Do The Users Like It?Do The Users Like It?