David Walker, profile picture
Uploaded byDavid Walker
1,499 views

Oracle BI06 From Volume To Value - Presentation

The document discusses challenges with a European mobile telco's data warehouse that contains over 150 billion call detail records. It takes too long to get answers from the data warehouse and it is underutilized. The document recommends establishing quick service teams, performing data profiling and cleansing, integrating the data warehouse into business processes, using business information portals, and RSS feeds to address engagement, user, and technical issues. This will help users get timely, accurate information and increase adoption of the data warehouse.

Download to read offline
Data Management & Warehousing From Volume to Value: What Next Generation Telco Data Warehouses Must Do to Provide Value to the Business David M. Walker davidw@datamgmt.com © 2006 Data Management & Warehousing Oracle Business Intelligence Page 1 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
What do we have ? •! A European Mobile Telco: –! Data warehouse has over 150 Billion CDRs –! Over 2000 registered users •! But: –! It takes 20 minutes to get answers to even the most basic question which should only take seconds –! Less than 100 people use it every day and they all hate the reporting tools –! Operations and support costs are soaring –! Can’t get changes to the system through fast enough © 2006 Data Management & Warehousing Oracle Business Intelligence Page 2 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
What are the engagement issues ? •! It doesn’t have anything for my role –! Don’t let the data warehouse sit outside a business process •! Identify where a report changes/helps –! People don’t need to know that they are using the data warehouse •! Ensure that it is integrated in their daily activities –! Pro-actively educate people about what is available •! Most people see data warehouses as something remote •! I’ve already got a report that does this –! Normally the response from the spreadsheet jockey •! But how accurate is it and how long does it take to produce ? © 2006 Data Management & Warehousing Oracle Business Intelligence Page 3 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
What are the users issues ? •! I don’t know what information is available! –! Users are unwilling to search too hard for what is available –! Users are unable to comment quickly and easily on what is available –! Users ‘just’ want ‘the right report’ fed to them •! The report I got was wrong! –! Published data profiles tell users where the data issues are –! Helps users understand the requirement for data cleansing back into operational systems (GIGO) –! Nobody available to quickly modify a report to what the user actually wants © 2006 Data Management & Warehousing Oracle Business Intelligence Page 4 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
What are the users issues (cont.) ? •! I asked them for this new report and they told me it would be two months! –! Who helps users to understand what is already available ? –! Who is available develop a report quickly? •! I went on a training course for the reporting tool but that was six months ago and I can’t remember how to use it now! –! If users are going to use a tool they should be frequent users with someone to support them –! If not, then provide resource to do the work for them © 2006 Data Management & Warehousing Oracle Business Intelligence Page 5 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Five things that can help •! Exploitation/QuickService Teams •! Data Profiling & Data Cleansing •! Process Integration •! Business Information Portals •! RSS - Really Simple Syndication © 2006 Data Management & Warehousing Oracle Business Intelligence Page 6 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
© 2006 Data Management & Warehousing Oracle Business Intelligence Page 7 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Exploitation/QuickService Teams •! Have a (small) team that is ‘here to help’ –! Available via: •! Telephone •! Chat Room •! Web Conference •! Issue Tracking System –! Technology reduces costs of running a team and makes the data warehouse feel more accessible •! Will respond quickly to urgent requests –! Even if the answer is it will take sometime to fulfil the total requirement here’s what we can do now © 2006 Data Management & Warehousing Oracle Business Intelligence Page 8 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Exploitation/QuickService Teams (2) •! Look for heavy users and heavy queries and find ways to help them –! Cut out unused parts of the data warehouse –! Optimise response of major users –! Revise archiving strategy based on required data –! Ultimately reduces operational and support costs •! Visit frequent callers to the helpdesk –! Re-enforce training –! Gather new requirements –! Pre-empt the need to call the helpdesk •! But basically provide proactive support © 2006 Data Management & Warehousing Oracle Business Intelligence Page 9 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Direct Access to the Quick Service Team What’s related develops understanding Pre-empt FAQ’s Quick Service Team can monitor and respond © 2006 Data Management & Warehousing Oracle Business Intelligence Page 10 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Data Profiling •! Look at your source systems and understand what the data quality issues are –! Which required fields are not populated ? –! Which fields always have a default value ? –! Do all customers have sufficient contact details ? –! Etc. •! Detect and capture issues in the Data Warehouse –! Often related to issues of integration across systems •! Set up targets to improve the data quality –! Especially in the source system –! Publish the metrics and identify responsible owners © 2006 Data Management & Warehousing Oracle Business Intelligence Page 11 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Allow users to see related data quality © 2006 Data Management & Warehousing Oracle Business Intelligence Page 12 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
© 2006 Data Management & Warehousing Oracle Business Intelligence Page 13 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Data Cleansing •! Fix data in the source systems –! A data quality issue fixed in the source will have benefits for other areas and often highlight business process issues •! Embed a call to the cleaning tool in all ETL –! Rule based cleansers simple and easy to implement –! Add the call even if there is no current requirement –! Use a metadata driven tool so new rules can be added –! Track the success rate of the results –! BUT: Maintain copies of the original data © 2006 Data Management & Warehousing Oracle Business Intelligence Page 14 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Example Data Cleansing Issues •! Standardisation of text –! Prevents correct aggregation –! Multiple spellings •! e.g. Zürich, Zuerich, Zurich => Zurich, Rd => Road –! Spaces •! e.g. David_ _Walker is not the same as David_Walker –! Standardization of case •! E.g. David Walker => DAVID WALKER, Zurich => ZURICH •! Range validation if dates –! 13-Mar-0006 becomes 13-Mar-2006 © 2006 Data Management & Warehousing Oracle Business Intelligence Page 15 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
More Data Cleansing Issues •! Mapping of codes & translation –! 01 means ‘Fixed Line’ in one system and ‘Roaming’ in another –! A code meant one thing for a period of time and then it’s use was changed to mean another thing after a certain date •! Overcome System Defaults –! 80% or all customers are MALE •! Actually the default is MALE and most operators just tab over the field –! Date of Birth is nearly always empty •! Optional field in source system – change to mandatory –! Date of Birth is 01-01-1900 •! Mandatory field with no range checking and no option for declined © 2006 Data Management & Warehousing Oracle Business Intelligence Page 16 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Process Integration •! Put the data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans online •! But restrict price plans available based on profile –! Trigger on-line offers and customised content when customers log into the website –! Add web ‘popup’ pages to existing internal applications •! Call centre gets an ‘image’ of the person they are talking to © 2006 Data Management & Warehousing Oracle Business Intelligence Page 17 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Process Integration •! Put the data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans onlinePlan: Price Prepay 5 Stop Churn: No •!Last Bill (View): price £0.50 available based on profile But restrict plans –! Trigger on-line offers9776 911 Last Call (Detail): 0118 and customised content when Last Contact: 20-Mar-2006 customers log into the website Next Best Offer: Text pack 50 –! Add web ‘popup’ 3 ! Open Cases (View): Dropped Calls: pages to existing internal ! Teenager applications Network Quality: !! Handset Type: ! ‘image’ •! Call centre gets an Texter 100of the person they are talking to © 2006 Data Management & Warehousing Oracle Business Intelligence Page 18 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Process Integration •! Put the data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans online Plan: Price Domestic 100 Stop Churn: Yes •! Last Bill (View): But restrict price plans available based on profile £37.50 Last Call (Detail): 07990 594 372 –! Trigger on-line offers and customised content when Last Contact: 10-Jan-2003 customers log into Handset +£50 Next Best Offer: the website Open Cases (View): 0 –! Add web Calls: Dropped ‘popup’ pages to existing internal """ Single Working Female applications Network Quality: "" Handset Type: " Cheapo X79a •! Call centre gets an ‘image’ of the person they are talking to © 2006 Data Management & Warehousing Oracle Business Intelligence Page 19 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Process Integration •! Put the data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans online Price Plan: Business 350 •! But restrict priceYes Stop Churn: plans available based on profile Last Bill (View): £180 –! Trigger on-line offers 028 911 Last Call (Detail): 07050 and customised content when Last Contact: 15-Sep-2005 customers log into the +£0 Next Best Offer: Handset website –! Add web ‘popup’None Open Cases (View): pages to existing internal Dropped Calls: !! Business User applications Network Quality: # •! Call centre gets ! Executive 3030 person they are talking to Handset Type: an ‘image’ of the © 2006 Data Management & Warehousing Oracle Business Intelligence Page 20 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Business Information Portals •! Single touch point –! The delivery mechanism for all business information services. •! Collaboration –! Allows users to communicate •! Synchronously (through chat & messaging) •! Asynchronously (through threaded discussion & email digests) •! Integration –! The connection of functions and data from multiple systems into new components © 2006 Data Management & Warehousing Oracle Business Intelligence Page 21 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Business Information Portals (2) •! Content and document management –! Services that support the full life cycle of document creation and provide mechanisms for authoring, approval, version control, scheduled publishing, indexing and searching. –! Consider a Wiki: a user editable webpage •! Personalization –! Allows users to subscribe (or be subscribed) to specific types of content and services. –! Users can also customize the look and feel of their environment. © 2006 Data Management & Warehousing Oracle Business Intelligence Page 22 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
RSS - Really Simple Syndication •! If I could offer you only one tip for the future, RSS would be it. –! Already an inbuilt technology in most web browsers and mail clients –! Very cheap to modify existing reports to work with it –! Allows publish/subscribe to ‘news feeds’ •! These feeds would be reports by subject area –! An established technology already widely in use •! e.g. BBC, most newspapers, etc. & Podcasts –! Can easily be integrated with textual content © 2006 Data Management & Warehousing Oracle Business Intelligence Page 23 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
RSS - Really Simple Syndication •! If I could offer you only one tip for the future, <?xml version="1.0" ?> - <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns=http://purl.org/rss/1.0/> RSS would be it. - <channel rdf:about="http://www.datamgmt.com/files/phpwsrssfeeds/backend3.php"> <title>Data Warehousing Knowledge Base</title> <link>http://www.datamgmt.com/</link> <description>The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build –! Already an inbuilt technology in most web browsers and implementation of data warehousing solutions that we as a company use and hope that you will also find useful.</description> <dc:date>2006-03-29T14:16:50+00:00</dc:date> and mail clients <image rdf:resource="http://www.datamgmt.com/images/phpwsrssfeeds/thumbs/logo_tn.gif" /> - <items> - <rdf:Seq> –! Very cheap to modify existing reports to work with it <rdf:li resource="http://www.datamgmt.com/index.php?module=article&view=news" /> </rdf:Seq> </items> –! Allows publish/subscribe to ‘news feeds’ </channel> - <image rdf:about="http://www.datamgmt.com/images/phpwsrssfeeds/thumbs/logo_tn.gif"> <title>Data Warehousing Knowledge Base</title> •! These feeds would be reports by subject area <link>http://www.datamgmt.com/</link> <url /> –! An established technology already widely in use </image> - <item rdf:about="http://www.datamgmt.com/index.php?module=article&view=76"> <title>Data Management & Warehousing White Papers</title> •! e.g. BBC, most newspapers, etc. <link>http://www.datamgmt.com/index.php?module=article&view=76</link> <description>Data Management & Warehousing is publishing a series of white papers on topics relating to data warehousing. –! Can easily be integrated with textual content This article lists each paper and provides a synopsis<br />Updated:</description> </item> … © 2006 Data Management & Warehousing Oracle Business Intelligence Page 24 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
RSS - Really Simple Syndication •! If I could offer you only one tip for the future, RSS would be it. –! Already an inbuilt technology in most web browsers and mail clients –! Very cheap to modify existing reports to work with it –! Allows publish/subscribe to ‘news feeds’ •! These feeds would be reports by subject area –! An established technology already widely in use •! e.g. BBC, most newspapers, etc. –! Can easily be integrated with textual content © 2006 Data Management & Warehousing Oracle Business Intelligence Page 25 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
RSS - Really Simple Syndication •! If I could offer you only one tip for the future, RSS would be it. –! Already an inbuilt technology in most web browsers and mail clients –! Very cheap to modify existing reports to work with it –! Allows publish/subscribe to ‘news feeds’ •! These feeds would be reports by subject area –! An established technology already widely in use •! e.g. BBC, most newspapers, etc. –! Can easily be integrated with textual content © 2006 Data Management & Warehousing Oracle Business Intelligence Page 26 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
What to use RSS for •! Publishing batch reports –! By subject area –! By user community •! Publishing requirements •! Publishing analysis •! Publishing data quality issues and reports •! Publishing merged feeds –! Reports & Data Quality issues together •! Podcasting © 2006 Data Management & Warehousing Oracle Business Intelligence Page 27 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
More than just reporting •! Some of the biggest benefits come from the process of building the data warehouse and integrating it into the business –! Builds a better understanding of what data is available –! What the data means to the organisation –! How it can be structured to make more sense across the whole organisation. –! Where information sits in the business process © 2006 Data Management & Warehousing Oracle Business Intelligence Page 28 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
What do we want to be ? •! A European Mobile Telco: –! Data warehouse has over 150 Billion CDRs –! Over 2000 registered users •! But: And: –! It takes 20where to get basic answers quickly and effective. –! Users know minutes to get data from to even the most –! basic question which shouldtake totakeunderstand the They know how long a report will only run, seconds data quality and can subscribe to have it delivered to them –! Less than 100 people use it every day and they all –! 100’s of people visiting the business information portal each day hatevery few directly using reporting tools, and 1000’s using the with the reporting tools –! Operationseven realising costs are soaring data without and support –! Can’t get changes to the system are targeted against the –! Operations, support costs and change through fast enough highest value returns © 2006 Data Management & Warehousing Oracle Business Intelligence Page 29 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
Data Management & Warehousing Thank you ! •! For more information: –! Visit our website at http://www.datamgmt.com –! Call us on 07050 028 911 –! E-mail davidw@datamgmt.com Winning Teams - Great Team Players Data Management & Warehousing are proud player sponsors for the 2005/06 season of Joe Worsley, utility back row with the English Rugby Premiership Champions London Wasps. Joe has helped London Wasps win the Zurich Premiership in 2002-03, 2003-04 and 2004-05 ©as wellManagement Heineken Cup in 2003-04. Joe was also a member of the England World Cup squad of 30 2006 Data as the & Warehousing Oracle Business Intelligence Page 30 Speaker: David M. Walker Thames Valley Park 30 March 2006 and was awarded an MBE by the Queen.

More Related Content

PDF
UKOUG06 - An Introduction To Process Neutral Data Modelling - Presentation
byDavid Walker
 
PDF
White Paper - How Data Works
byDavid Walker
 
PDF
Openworld04 - Information Delivery - The Change In Data Management At Network...
byDavid Walker
 
PDF
Big Data Week 2016 - Worldpay - Deploying Secure Clusters
byDavid Walker
 
PDF
Wallchart - Data Warehouse Documentation Roadmap
byDavid Walker
 
PDF
Data Works Summit Munich 2017 - Worldpay - Multi Tenancy Clusters
byDavid Walker
 
PDF
Storage Characteristics Of Call Data Records In Column Store Databases
byDavid Walker
 
PDF
The principles of the business data lake
byCapgemini
 
UKOUG06 - An Introduction To Process Neutral Data Modelling - Presentation
byDavid Walker
 
White Paper - How Data Works
byDavid Walker
 
Openworld04 - Information Delivery - The Change In Data Management At Network...
byDavid Walker
 
Big Data Week 2016 - Worldpay - Deploying Secure Clusters
byDavid Walker
 
Wallchart - Data Warehouse Documentation Roadmap
byDavid Walker
 
Data Works Summit Munich 2017 - Worldpay - Multi Tenancy Clusters
byDavid Walker
 
Storage Characteristics Of Call Data Records In Column Store Databases
byDavid Walker
 
The principles of the business data lake
byCapgemini
 

What's hot

DOCX
Microsoft SQL Azure - Scaling Out with SQL Azure Whitepaper
byMicrosoft Private Cloud
 
PPTX
Data Governance, Compliance and Security in Hadoop with Cloudera
byCaserta
 
PDF
Tera stream ETL
byNguyễn Nguyễn Mạnh Trung
 
PDF
The technology of the business data lake
byCapgemini
 
PPT
Data warehouse 101-fundamentals-
byAshishGuleria
 
PPTX
Core banking Closure bank day OSWA meetup 2018-Alexander Petrov Oslo
byAlexander Petrov
 
PDF
White paper making an-operational_data_store_(ods)_the_center_of_your_data_...
byEric Javier Espino Man
 
PPTX
Data Vault Overview
byEmpowered Holdings, LLC
 
PDF
Data Warehouse Tutorial For Beginners | Data Warehouse Concepts | Data Wareho...
byEdureka!
 
PDF
Flash session -streaming--ses1243-lon
byJeffrey T. Pollock
 
PDF
Teradata Overview
byTeradata
 
PDF
Logical Data Lakes: From Single Purpose to Multipurpose Data Lakes (APAC)
byDenodo
 
PDF
Rev_3 Components of a Data Warehouse
byRyan Andhavarapu
 
PDF
Data-Centric Infrastructure for Agile Development
byDATAVERSITY
 
PPTX
Teradata introduction
byRameejmd
 
DOCX
Data Vault: Data Warehouse Design Goes Agile
byDaniel Upton
 
PDF
Master Data Management (MDM) 101 & Oracle Trading Community Architecture (TCA...
byRhapsody Technologies, Inc.
 
PDF
Data-Ed Online Presents: Data Warehouse Strategies
byDATAVERSITY
 
PDF
Benefits of the Azure Cloud
byCaserta
 
PPTX
Data Vault and DW2.0
byEmpowered Holdings, LLC
 
Microsoft SQL Azure - Scaling Out with SQL Azure Whitepaper
byMicrosoft Private Cloud
 
Data Governance, Compliance and Security in Hadoop with Cloudera
byCaserta
 
Tera stream ETL
byNguyễn Nguyễn Mạnh Trung
 
The technology of the business data lake
byCapgemini
 
Data warehouse 101-fundamentals-
byAshishGuleria
 
Core banking Closure bank day OSWA meetup 2018-Alexander Petrov Oslo
byAlexander Petrov
 
White paper making an-operational_data_store_(ods)_the_center_of_your_data_...
byEric Javier Espino Man
 
Data Vault Overview
byEmpowered Holdings, LLC
 
Data Warehouse Tutorial For Beginners | Data Warehouse Concepts | Data Wareho...
byEdureka!
 
Flash session -streaming--ses1243-lon
byJeffrey T. Pollock
 
Teradata Overview
byTeradata
 
Logical Data Lakes: From Single Purpose to Multipurpose Data Lakes (APAC)
byDenodo
 
Rev_3 Components of a Data Warehouse
byRyan Andhavarapu
 
Data-Centric Infrastructure for Agile Development
byDATAVERSITY
 
Teradata introduction
byRameejmd
 
Data Vault: Data Warehouse Design Goes Agile
byDaniel Upton
 
Master Data Management (MDM) 101 & Oracle Trading Community Architecture (TCA...
byRhapsody Technologies, Inc.
 
Data-Ed Online Presents: Data Warehouse Strategies
byDATAVERSITY
 
Benefits of the Azure Cloud
byCaserta
 
Data Vault and DW2.0
byEmpowered Holdings, LLC
 

Viewers also liked

PDF
ETIS09 - Black Swans and White Elephants - Presentation
byDavid Walker
 
PDF
Data science - o co chodzi?
byPawel Jarosz
 
PDF
ETIS11 - Enterprise Metadata Management
byDavid Walker
 
PDF
19
byBakanaScans
 
PDF
IRM09 - What Can IT Really Deliver For BI and DW - Presentation
byDavid Walker
 
PPTX
Przyszłość IT. Marcin Wesołowski.
byEureka Technology Park / Eureka Hub
 
PDF
ETIS11 - Agile Business Intelligence - Presentation
byDavid Walker
 
PPTX
Zarządzanie energią
byEureka Technology Park / Eureka Hub
 
PDF
IOUG93 - Technical Architecture for the Data Warehouse - Presentation
byDavid Walker
 
PDF
Data Driven Insurance Underwriting (Dutch Language Version)
byDavid Walker
 
PDF
An introduction to social network data
byDavid Walker
 
PDF
Implementing Netezza Spatial
byDavid Walker
 
PDF
BI SaaS & Cloud Strategies for Telcos
byDavid Walker
 
PDF
ETIS10 - BI Governance Models & Strategies - Presentation
byDavid Walker
 
PDF
Big Data and Data Virtualization
byKenneth Peeples
 
PDF
ETIS09 - Data Quality: Common Problems & Checks - Presentation
byDavid Walker
 
PDF
Data Driven Insurance Underwriting
byDavid Walker
 
PDF
ETIS10 - BI Business Requirements - Presentation
byDavid Walker
 
PDF
An introduction to data virtualization in business intelligence
byDavid Walker
 
PDF
Gathering Business Requirements for Data Warehouses
byDavid Walker
 
ETIS09 - Black Swans and White Elephants - Presentation
byDavid Walker
 
Data science - o co chodzi?
byPawel Jarosz
 
ETIS11 - Enterprise Metadata Management
byDavid Walker
 
19
byBakanaScans
 
IRM09 - What Can IT Really Deliver For BI and DW - Presentation
byDavid Walker
 
Przyszłość IT. Marcin Wesołowski.
byEureka Technology Park / Eureka Hub
 
ETIS11 - Agile Business Intelligence - Presentation
byDavid Walker
 
Zarządzanie energią
byEureka Technology Park / Eureka Hub
 
IOUG93 - Technical Architecture for the Data Warehouse - Presentation
byDavid Walker
 
Data Driven Insurance Underwriting (Dutch Language Version)
byDavid Walker
 
An introduction to social network data
byDavid Walker
 
Implementing Netezza Spatial
byDavid Walker
 
BI SaaS & Cloud Strategies for Telcos
byDavid Walker
 
ETIS10 - BI Governance Models & Strategies - Presentation
byDavid Walker
 
Big Data and Data Virtualization
byKenneth Peeples
 
ETIS09 - Data Quality: Common Problems & Checks - Presentation
byDavid Walker
 
Data Driven Insurance Underwriting
byDavid Walker
 
ETIS10 - BI Business Requirements - Presentation
byDavid Walker
 
An introduction to data virtualization in business intelligence
byDavid Walker
 
Gathering Business Requirements for Data Warehouses
byDavid Walker
 

Similar to Oracle BI06 From Volume To Value - Presentation

PPTX
Clare Somerville Trish O’Kane Data in Databases
byFuture Perfect 2012
 
PDF
The Death of the Star Schema
byDATAVERSITY
 
PDF
Presentation by Ivan Schotsmans (DV Community) at the Data Vault Modelling an...
byPatrick Van Renterghem
 
PDF
A beginners guide to Cloudera Hadoop
byDavid Yahalom
 
PPTX
Data Mesh using Microsoft Fabric
byNathan Bijnens
 
PPT
Cliff Denhom, Stream Restoration Inc., "Datashed Overview and Q&A"
byMichael Hewitt, GISP
 
PDF
The Data Lake and Getting Buisnesses the Big Data Insights They Need
byDunn Solutions Group
 
PDF
Using Data Platforms That Are Fit-For-Purpose
byDATAVERSITY
 
PDF
Data Architecture Best Practices for Advanced Analytics
byDATAVERSITY
 
PDF
Advances And Research Directions In Data-Warehousing Technology
byKate Campbell
 
PDF
Unconstrained Analytics in the Age of Data – Delivering High-Performance Anal...
byXpand IT
 
DOCX
536855_Singh_Resume_Final_V2
byBhopal Singh
 
PPTX
Big data oracle_introduccion
byFran Navarro
 
PDF
Think Big - How to Design a Big Data Information Architecture
byInside Analysis
 
PDF
How Financial Institutions Are Leveraging Data Virtualization to Overcome the...
byDenodo
 
PDF
Citizens Bank: Data Lake Implementation – Selecting BigInsights ViON Spark/Ha...
bySeeling Cheung
 
PDF
Building a Logical Data Fabric using Data Virtualization (ASEAN)
byDenodo
 
PDF
ADV Slides: When and How Data Lakes Fit into a Modern Data Architecture
byDATAVERSITY
 
DOC
Dwdm unit 1-2016-Data ingarehousing
byDhilsath Fathima
 
PDF
Enterprise Data Management - Data Lake - A Perspective
bySaurav Mukherjee
 
Clare Somerville Trish O’Kane Data in Databases
byFuture Perfect 2012
 
The Death of the Star Schema
byDATAVERSITY
 
Presentation by Ivan Schotsmans (DV Community) at the Data Vault Modelling an...
byPatrick Van Renterghem
 
A beginners guide to Cloudera Hadoop
byDavid Yahalom
 
Data Mesh using Microsoft Fabric
byNathan Bijnens
 
Cliff Denhom, Stream Restoration Inc., "Datashed Overview and Q&A"
byMichael Hewitt, GISP
 
The Data Lake and Getting Buisnesses the Big Data Insights They Need
byDunn Solutions Group
 
Using Data Platforms That Are Fit-For-Purpose
byDATAVERSITY
 
Data Architecture Best Practices for Advanced Analytics
byDATAVERSITY
 
Advances And Research Directions In Data-Warehousing Technology
byKate Campbell
 
Unconstrained Analytics in the Age of Data – Delivering High-Performance Anal...
byXpand IT
 
536855_Singh_Resume_Final_V2
byBhopal Singh
 
Big data oracle_introduccion
byFran Navarro
 
Think Big - How to Design a Big Data Information Architecture
byInside Analysis
 
How Financial Institutions Are Leveraging Data Virtualization to Overcome the...
byDenodo
 
Citizens Bank: Data Lake Implementation – Selecting BigInsights ViON Spark/Ha...
bySeeling Cheung
 
Building a Logical Data Fabric using Data Virtualization (ASEAN)
byDenodo
 
ADV Slides: When and How Data Lakes Fit into a Modern Data Architecture
byDATAVERSITY
 
Dwdm unit 1-2016-Data ingarehousing
byDhilsath Fathima
 
Enterprise Data Management - Data Lake - A Perspective
bySaurav Mukherjee
 

More from David Walker

PDF
Moving To MicroServices
byDavid Walker
 
PDF
Data Works Berlin 2018 - Worldpay - PCI Compliance
byDavid Walker
 
PDF
Big Data Analytics 2017 - Worldpay - Empowering Payments
byDavid Walker
 
PDF
Building an analytical platform
byDavid Walker
 
PDF
Data warehousing change in a challenging environment
byDavid Walker
 
PDF
Building a data warehouse of call data records
byDavid Walker
 
PDF
Struggling with data management
byDavid Walker
 
PDF
A linux mac os x command line interface
byDavid Walker
 
PDF
Connections a life in the day of - david walker
byDavid Walker
 
PDF
Conspectus data warehousing appliances – fad or future
byDavid Walker
 
PDF
Using the right data model in a data mart
byDavid Walker
 
Moving To MicroServices
byDavid Walker
 
Data Works Berlin 2018 - Worldpay - PCI Compliance
byDavid Walker
 
Big Data Analytics 2017 - Worldpay - Empowering Payments
byDavid Walker
 
Building an analytical platform
byDavid Walker
 
Data warehousing change in a challenging environment
byDavid Walker
 
Building a data warehouse of call data records
byDavid Walker
 
Struggling with data management
byDavid Walker
 
A linux mac os x command line interface
byDavid Walker
 
Connections a life in the day of - david walker
byDavid Walker
 
Conspectus data warehousing appliances – fad or future
byDavid Walker
 
Using the right data model in a data mart
byDavid Walker
 

Recently uploaded

PDF
Ask Me Anything About AI Assist: Practical Answers for Real Workflows
bySafe Software
 
PDF
AGV PROTOCOL BRAND KIT COMPLETE VIEW.pdf
byfagbolade
 
PDF
Master Deck: GraphSummit Bengaluru (Oct 7)
byNeo4j
 
PDF
Starting a Customer Education Program: Taking Your Training to Them
byRustici Software
 
PDF
The Role of Human Experiences (HX) in GenAI Adoption
byDr. Tathagat Varma
 
PDF
Demystifying LLMs- How to Use GenAI Effectively.pdf
byAiko Klostermann
 
PPTX
This Could Have Been a Slack Message: Diagnosing and Treating Bad Meetings
byMike Clement
 
PPTX
⚡Level Up Your Slack Game: Workflows & Conditional Branching🎉
bySanjeetMishra29
 
PPTX
TechVerse Kent (Combining Tech, AI, Innovation and Creativity)
byKritarthDevli
 
PDF
AI assisted software — Cathedral or Bazaar?.pdf
byMindtrek
 
PPTX
Building Europe with Open LLMs - Manu Setälä.pptx
byMindtrek
 
PDF
Phishing for Answers: A Tech Filler Quiz.pdf
byConquiztadors- the Quiz Society of Sri Venkateswara College
 
PDF
Ethical Initiatives in AI and accountability.pdf
byShiwani Gupta
 
PDF
Session 1 - Agentic Automation Building the Enterprise Agent of Tomorrow
byDianaGray10
 
PDF
A SEA of Energy Efficiency Opportunities!
byMemoori
 
PDF
Unit 3 DS - Distributed Data Storage and Retrieval - PowerPoint Content.pdf
byayesha butalia
 
PDF
Artificial Intelligence and YOU - Thinking Thoughtfully about AI
byMicah Melling
 
PDF
Atlantix is an AI-first venture studio, building companies with AI at the core
byadmin625551
 
PDF
A Guide to Microsoft Azure's Scalable and Secure Cloud Solutions
byTeleglobal International
 
PPTX
Google Cloud Quest : An introductory training session on how to solve Google ...
byrajashreeborah705
 
Ask Me Anything About AI Assist: Practical Answers for Real Workflows
bySafe Software
 
AGV PROTOCOL BRAND KIT COMPLETE VIEW.pdf
byfagbolade
 
Master Deck: GraphSummit Bengaluru (Oct 7)
byNeo4j
 
Starting a Customer Education Program: Taking Your Training to Them
byRustici Software
 
The Role of Human Experiences (HX) in GenAI Adoption
byDr. Tathagat Varma
 
Demystifying LLMs- How to Use GenAI Effectively.pdf
byAiko Klostermann
 
This Could Have Been a Slack Message: Diagnosing and Treating Bad Meetings
byMike Clement
 
⚡Level Up Your Slack Game: Workflows & Conditional Branching🎉
bySanjeetMishra29
 
TechVerse Kent (Combining Tech, AI, Innovation and Creativity)
byKritarthDevli
 
AI assisted software — Cathedral or Bazaar?.pdf
byMindtrek
 
Building Europe with Open LLMs - Manu Setälä.pptx
byMindtrek
 
Phishing for Answers: A Tech Filler Quiz.pdf
byConquiztadors- the Quiz Society of Sri Venkateswara College
 
Ethical Initiatives in AI and accountability.pdf
byShiwani Gupta
 
Session 1 - Agentic Automation Building the Enterprise Agent of Tomorrow
byDianaGray10
 
A SEA of Energy Efficiency Opportunities!
byMemoori
 
Unit 3 DS - Distributed Data Storage and Retrieval - PowerPoint Content.pdf
byayesha butalia
 
Artificial Intelligence and YOU - Thinking Thoughtfully about AI
byMicah Melling
 
Atlantix is an AI-first venture studio, building companies with AI at the core
byadmin625551
 
A Guide to Microsoft Azure's Scalable and Secure Cloud Solutions
byTeleglobal International
 
Google Cloud Quest : An introductory training session on how to solve Google ...
byrajashreeborah705
 

Oracle BI06 From Volume To Value - Presentation

  • 1.
    Data Management &Warehousing From Volume to Value: What Next Generation Telco Data Warehouses Must Do to Provide Value to the Business David M. Walker davidw@datamgmt.com © 2006 Data Management & Warehousing Oracle Business Intelligence Page 1 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 2.
    What do wehave ? •! A European Mobile Telco: –! Data warehouse has over 150 Billion CDRs –! Over 2000 registered users •! But: –! It takes 20 minutes to get answers to even the most basic question which should only take seconds –! Less than 100 people use it every day and they all hate the reporting tools –! Operations and support costs are soaring –! Can’t get changes to the system through fast enough © 2006 Data Management & Warehousing Oracle Business Intelligence Page 2 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 3.
    What are theengagement issues ? •! It doesn’t have anything for my role –! Don’t let the data warehouse sit outside a business process •! Identify where a report changes/helps –! People don’t need to know that they are using the data warehouse •! Ensure that it is integrated in their daily activities –! Pro-actively educate people about what is available •! Most people see data warehouses as something remote •! I’ve already got a report that does this –! Normally the response from the spreadsheet jockey •! But how accurate is it and how long does it take to produce ? © 2006 Data Management & Warehousing Oracle Business Intelligence Page 3 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 4.
    What are theusers issues ? •! I don’t know what information is available! –! Users are unwilling to search too hard for what is available –! Users are unable to comment quickly and easily on what is available –! Users ‘just’ want ‘the right report’ fed to them •! The report I got was wrong! –! Published data profiles tell users where the data issues are –! Helps users understand the requirement for data cleansing back into operational systems (GIGO) –! Nobody available to quickly modify a report to what the user actually wants © 2006 Data Management & Warehousing Oracle Business Intelligence Page 4 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 5.
    What are theusers issues (cont.) ? •! I asked them for this new report and they told me it would be two months! –! Who helps users to understand what is already available ? –! Who is available develop a report quickly? •! I went on a training course for the reporting tool but that was six months ago and I can’t remember how to use it now! –! If users are going to use a tool they should be frequent users with someone to support them –! If not, then provide resource to do the work for them © 2006 Data Management & Warehousing Oracle Business Intelligence Page 5 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 6.
    Five things thatcan help •! Exploitation/QuickService Teams •! Data Profiling & Data Cleansing •! Process Integration •! Business Information Portals •! RSS - Really Simple Syndication © 2006 Data Management & Warehousing Oracle Business Intelligence Page 6 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 7.
    © 2006 DataManagement & Warehousing Oracle Business Intelligence Page 7 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 8.
    Exploitation/QuickService Teams •! Havea (small) team that is ‘here to help’ –! Available via: •! Telephone •! Chat Room •! Web Conference •! Issue Tracking System –! Technology reduces costs of running a team and makes the data warehouse feel more accessible •! Will respond quickly to urgent requests –! Even if the answer is it will take sometime to fulfil the total requirement here’s what we can do now © 2006 Data Management & Warehousing Oracle Business Intelligence Page 8 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 9.
    Exploitation/QuickService Teams (2) •!Look for heavy users and heavy queries and find ways to help them –! Cut out unused parts of the data warehouse –! Optimise response of major users –! Revise archiving strategy based on required data –! Ultimately reduces operational and support costs •! Visit frequent callers to the helpdesk –! Re-enforce training –! Gather new requirements –! Pre-empt the need to call the helpdesk •! But basically provide proactive support © 2006 Data Management & Warehousing Oracle Business Intelligence Page 9 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 10.
    Direct Access to the Quick Service Team What’s related develops understanding Pre-empt FAQ’s Quick Service Team can monitor and respond © 2006 Data Management & Warehousing Oracle Business Intelligence Page 10 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 11.
    Data Profiling •! Lookat your source systems and understand what the data quality issues are –! Which required fields are not populated ? –! Which fields always have a default value ? –! Do all customers have sufficient contact details ? –! Etc. •! Detect and capture issues in the Data Warehouse –! Often related to issues of integration across systems •! Set up targets to improve the data quality –! Especially in the source system –! Publish the metrics and identify responsible owners © 2006 Data Management & Warehousing Oracle Business Intelligence Page 11 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 12.
    Allow users to see related data quality © 2006 Data Management & Warehousing Oracle Business Intelligence Page 12 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 13.
    © 2006 DataManagement & Warehousing Oracle Business Intelligence Page 13 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 14.
    Data Cleansing •! Fixdata in the source systems –! A data quality issue fixed in the source will have benefits for other areas and often highlight business process issues •! Embed a call to the cleaning tool in all ETL –! Rule based cleansers simple and easy to implement –! Add the call even if there is no current requirement –! Use a metadata driven tool so new rules can be added –! Track the success rate of the results –! BUT: Maintain copies of the original data © 2006 Data Management & Warehousing Oracle Business Intelligence Page 14 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 15.
    Example Data CleansingIssues •! Standardisation of text –! Prevents correct aggregation –! Multiple spellings •! e.g. Zürich, Zuerich, Zurich => Zurich, Rd => Road –! Spaces •! e.g. David_ _Walker is not the same as David_Walker –! Standardization of case •! E.g. David Walker => DAVID WALKER, Zurich => ZURICH •! Range validation if dates –! 13-Mar-0006 becomes 13-Mar-2006 © 2006 Data Management & Warehousing Oracle Business Intelligence Page 15 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 16.
    More Data CleansingIssues •! Mapping of codes & translation –! 01 means ‘Fixed Line’ in one system and ‘Roaming’ in another –! A code meant one thing for a period of time and then it’s use was changed to mean another thing after a certain date •! Overcome System Defaults –! 80% or all customers are MALE •! Actually the default is MALE and most operators just tab over the field –! Date of Birth is nearly always empty •! Optional field in source system – change to mandatory –! Date of Birth is 01-01-1900 •! Mandatory field with no range checking and no option for declined © 2006 Data Management & Warehousing Oracle Business Intelligence Page 16 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 17.
    Process Integration •! Putthe data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans online •! But restrict price plans available based on profile –! Trigger on-line offers and customised content when customers log into the website –! Add web ‘popup’ pages to existing internal applications •! Call centre gets an ‘image’ of the person they are talking to © 2006 Data Management & Warehousing Oracle Business Intelligence Page 17 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 18.
    Process Integration •! Putthe data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans onlinePlan: Price Prepay 5 Stop Churn: No •!Last Bill (View): price £0.50 available based on profile But restrict plans –! Trigger on-line offers9776 911 Last Call (Detail): 0118 and customised content when Last Contact: 20-Mar-2006 customers log into the website Next Best Offer: Text pack 50 –! Add web ‘popup’ 3 ! Open Cases (View): Dropped Calls: pages to existing internal ! Teenager applications Network Quality: !! Handset Type: ! ‘image’ •! Call centre gets an Texter 100of the person they are talking to © 2006 Data Management & Warehousing Oracle Business Intelligence Page 18 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 19.
    Process Integration •! Putthe data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans online Plan: Price Domestic 100 Stop Churn: Yes •! Last Bill (View): But restrict price plans available based on profile £37.50 Last Call (Detail): 07990 594 372 –! Trigger on-line offers and customised content when Last Contact: 10-Jan-2003 customers log into Handset +£50 Next Best Offer: the website Open Cases (View): 0 –! Add web Calls: Dropped ‘popup’ pages to existing internal """ Single Working Female applications Network Quality: "" Handset Type: " Cheapo X79a •! Call centre gets an ‘image’ of the person they are talking to © 2006 Data Management & Warehousing Oracle Business Intelligence Page 19 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 20.
    Process Integration •! Putthe data warehouse into the process rather than sitting to one side –! Use it to allow customers to compare price plans online Price Plan: Business 350 •! But restrict priceYes Stop Churn: plans available based on profile Last Bill (View): £180 –! Trigger on-line offers 028 911 Last Call (Detail): 07050 and customised content when Last Contact: 15-Sep-2005 customers log into the +£0 Next Best Offer: Handset website –! Add web ‘popup’None Open Cases (View): pages to existing internal Dropped Calls: !! Business User applications Network Quality: # •! Call centre gets ! Executive 3030 person they are talking to Handset Type: an ‘image’ of the © 2006 Data Management & Warehousing Oracle Business Intelligence Page 20 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 21.
    Business Information Portals •!Single touch point –! The delivery mechanism for all business information services. •! Collaboration –! Allows users to communicate •! Synchronously (through chat & messaging) •! Asynchronously (through threaded discussion & email digests) •! Integration –! The connection of functions and data from multiple systems into new components © 2006 Data Management & Warehousing Oracle Business Intelligence Page 21 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 22.
    Business Information Portals(2) •! Content and document management –! Services that support the full life cycle of document creation and provide mechanisms for authoring, approval, version control, scheduled publishing, indexing and searching. –! Consider a Wiki: a user editable webpage •! Personalization –! Allows users to subscribe (or be subscribed) to specific types of content and services. –! Users can also customize the look and feel of their environment. © 2006 Data Management & Warehousing Oracle Business Intelligence Page 22 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 23.
    RSS - ReallySimple Syndication •! If I could offer you only one tip for the future, RSS would be it. –! Already an inbuilt technology in most web browsers and mail clients –! Very cheap to modify existing reports to work with it –! Allows publish/subscribe to ‘news feeds’ •! These feeds would be reports by subject area –! An established technology already widely in use •! e.g. BBC, most newspapers, etc. & Podcasts –! Can easily be integrated with textual content © 2006 Data Management & Warehousing Oracle Business Intelligence Page 23 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 24.
    RSS - ReallySimple Syndication •! If I could offer you only one tip for the future, <?xml version="1.0" ?> - <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns=http://purl.org/rss/1.0/> RSS would be it. - <channel rdf:about="http://www.datamgmt.com/files/phpwsrssfeeds/backend3.php"> <title>Data Warehousing Knowledge Base</title> <link>http://www.datamgmt.com/</link> <description>The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build –! Already an inbuilt technology in most web browsers and implementation of data warehousing solutions that we as a company use and hope that you will also find useful.</description> <dc:date>2006-03-29T14:16:50+00:00</dc:date> and mail clients <image rdf:resource="http://www.datamgmt.com/images/phpwsrssfeeds/thumbs/logo_tn.gif" /> - <items> - <rdf:Seq> –! Very cheap to modify existing reports to work with it <rdf:li resource="http://www.datamgmt.com/index.php?module=article&view=news" /> </rdf:Seq> </items> –! Allows publish/subscribe to ‘news feeds’ </channel> - <image rdf:about="http://www.datamgmt.com/images/phpwsrssfeeds/thumbs/logo_tn.gif"> <title>Data Warehousing Knowledge Base</title> •! These feeds would be reports by subject area <link>http://www.datamgmt.com/</link> <url /> –! An established technology already widely in use </image> - <item rdf:about="http://www.datamgmt.com/index.php?module=article&view=76"> <title>Data Management & Warehousing White Papers</title> •! e.g. BBC, most newspapers, etc. <link>http://www.datamgmt.com/index.php?module=article&view=76</link> <description>Data Management & Warehousing is publishing a series of white papers on topics relating to data warehousing. –! Can easily be integrated with textual content This article lists each paper and provides a synopsis<br />Updated:</description> </item> … © 2006 Data Management & Warehousing Oracle Business Intelligence Page 24 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 25.
    RSS - ReallySimple Syndication •! If I could offer you only one tip for the future, RSS would be it. –! Already an inbuilt technology in most web browsers and mail clients –! Very cheap to modify existing reports to work with it –! Allows publish/subscribe to ‘news feeds’ •! These feeds would be reports by subject area –! An established technology already widely in use •! e.g. BBC, most newspapers, etc. –! Can easily be integrated with textual content © 2006 Data Management & Warehousing Oracle Business Intelligence Page 25 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 26.
    RSS - ReallySimple Syndication •! If I could offer you only one tip for the future, RSS would be it. –! Already an inbuilt technology in most web browsers and mail clients –! Very cheap to modify existing reports to work with it –! Allows publish/subscribe to ‘news feeds’ •! These feeds would be reports by subject area –! An established technology already widely in use •! e.g. BBC, most newspapers, etc. –! Can easily be integrated with textual content © 2006 Data Management & Warehousing Oracle Business Intelligence Page 26 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 27.
    What to useRSS for •! Publishing batch reports –! By subject area –! By user community •! Publishing requirements •! Publishing analysis •! Publishing data quality issues and reports •! Publishing merged feeds –! Reports & Data Quality issues together •! Podcasting © 2006 Data Management & Warehousing Oracle Business Intelligence Page 27 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 28.
    More than justreporting •! Some of the biggest benefits come from the process of building the data warehouse and integrating it into the business –! Builds a better understanding of what data is available –! What the data means to the organisation –! How it can be structured to make more sense across the whole organisation. –! Where information sits in the business process © 2006 Data Management & Warehousing Oracle Business Intelligence Page 28 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 29.
    What do wewant to be ? •! A European Mobile Telco: –! Data warehouse has over 150 Billion CDRs –! Over 2000 registered users •! But: And: –! It takes 20where to get basic answers quickly and effective. –! Users know minutes to get data from to even the most –! basic question which shouldtake totakeunderstand the They know how long a report will only run, seconds data quality and can subscribe to have it delivered to them –! Less than 100 people use it every day and they all –! 100’s of people visiting the business information portal each day hatevery few directly using reporting tools, and 1000’s using the with the reporting tools –! Operationseven realising costs are soaring data without and support –! Can’t get changes to the system are targeted against the –! Operations, support costs and change through fast enough highest value returns © 2006 Data Management & Warehousing Oracle Business Intelligence Page 29 of 30 Speaker: David M. Walker Thames Valley Park 30 March 2006
  • 30.
    Data Management &Warehousing Thank you ! •! For more information: –! Visit our website at http://www.datamgmt.com –! Call us on 07050 028 911 –! E-mail davidw@datamgmt.com Winning Teams - Great Team Players Data Management & Warehousing are proud player sponsors for the 2005/06 season of Joe Worsley, utility back row with the English Rugby Premiership Champions London Wasps. Joe has helped London Wasps win the Zurich Premiership in 2002-03, 2003-04 and 2004-05 ©as wellManagement Heineken Cup in 2003-04. Joe was also a member of the England World Cup squad of 30 2006 Data as the & Warehousing Oracle Business Intelligence Page 30 Speaker: David M. Walker Thames Valley Park 30 March 2006 and was awarded an MBE by the Queen.