Transcript Slide 1

www.pwc.com
Queens University
Business Intelligence
Real-world applications
PwC Insight & Analytics team (October 2014)
Contents
PwC
1.
Introduction
2.
Overview
3.
Insight
4.
Analytics
5.
Big Data
6.
Questions?
2
Lecture Introduction
This lecture will focus on the latest People, Process and Technologies which are found in an
organisation and how to resolve some of the key issues they face. We will focus on;
•
The emerging trends in BI
•
The new approaches businesses are taking to implementing BI to realise benefits
across the following areas…
Overview
• Key Messages
• Emerging
themes
• Implementation
PwC
Insight
• What is
“Insight”
• Procurement
Hub
Analytics
• Spend Analytics
• 2 Examples
• Dashboard
Demo
Big Data
• Prospects
• Videos
• UK Biobank
Study
• Challenges
3
Team Introduction
PwC
PHIL Dunn
MANUS
O’Donnell
FEARGHAL
Campbell
ALEX PorochineO’Neill
8 Years PwC,
Manager
4 Years PwC,
Manager
1 year PwC,
Associate
1 year PwC,
Associate
QUB
OU
QUB
QUB
4
Intro
The aim of this lecture, is to give you a non technical perspective of
how Business Intelligence (BI) is used in the real world…
1.
What is Business Intelligence?
The collective term for strategies, methods and tools that empower an organisation to unlock value from their data
2. Why do businesses need Business Intelligence?
Without it, businesses would make poor decisions based on gut instinct alone
3. Business challenges in implementing Business Intelligence
Objectives? Ownership? Sceptic? Skills? Data Quality? Cost?
4. Business Intelligence isn’t new, so what’s different?
Demand (competitive edge), Opportunity (Data Volumes), Accessibility (new software integration), Lowering Cost
PwC
5
Content
Introduction
Overview
Insight
Analytics
Big Data
Questions?
Data Analytics: The Art and Science of Decision
Making
https://www.youtube.com/watch?v=6naW6Kg23q4
PwC
September 2014
7
Overview - Key Messages
1. Business Intelligence, while always important, is now critical to enable businesses
to effectively;
Manage Risk
& Regulation
Operational
Efficiency
Enhance
Revenue
PwC
• Exposure to debtors
• Timely regulatory compliance
• Consistent global reporting
• Reduce complexity
• Focus employees on value add
• More agile by removing operational
burden
8
2. Helps businesses overcome the underlying technological complexity
e.g. integrates with source data (structured & unstructured)
3. Increasing volume of data requires businesses to have good underlying data
management
e.g. how do we effectively integrate growing volumes of data?
4. Businesses are likely to have different levels of ‘maturity’ in the skills and
abilities required to deliver good business intelligence
e.g. how does aspiration & vision relate to reality?
5. Implementing BI in a business is not easy and has a number of business, and
then, technology challenges
e.g. agreement of who “owns” data and who has the right data?
PwC
9
Overview - Emerging trends in BI – Data
A service (internal or external) that
provides DQ capabilities
Data Quality Bureau
A means by which to deliver
technology – renting rather than
owning (SaaS, IaaS)
Information Asset Management
Cloud Computing
Big Data
Utilise ever growing sources and
volumes of data to achieve new insight
Approach to treat Information as an
asset in the same way as £ or staff
Master Data Management
Operational Data warehouses
Ensuring trusted definition of key
information
Data sources containing specific
operational data e.g. HR, Finance
Connecting information across the
enterprise
Enterprise Information Integration
BI Competency Centres
Dedicated skills/business function
to support Business intelligence with
business and technology skills
PwC
10
Overview - Emerging trends in BI – Reporting & Analytics
Hardware Analytics
Having Analytics carried out by a 3rd
party using your Data.
On-demand Analytics
Prebuilt Servers and software
bundles, optimised for analytics
Data Visualisation
Combining and
presenting Data using
visually rich
techniques so as to
derive new insight
Drill-Down Reporting
Ability to ‘drill’ down from high level
report/figures to underlying detail
SaaS/PaaS
Software or Platform – as a service
PwC
11
PwC
Reporting &
Analytics
Layer
Economics
Finance
Document Exports
Operations
Operational
Reports
People
Strategy
Technology
Dashboards
GRC
Analytics
Business Intelligence Applications
Analytics Applications
Data Mart
Cubes
Operational
Data Store
Data Warehousing
Data
Management
Client Data
Data Quality
Data Profiling
Master Data
Management
ETL
CRM
Enterprise
Resource Platform
Transaction Data
Other Data
Business Intelligence Competency Centre
Analytical
Queries
Analytical Services
BI&A
Platform
Enterprise Information
Platform
Source
PwC NITSC Analytic Team
Output
Overview - How clients are implementing BI to realise value?
Content
Introduction
Overview
Insight
Analytics
Big Data
Questions?
Procurement Insight Hub
A comprehensive suite of analytics services to help build capability and
deliver actionable procurement insight
Are internal controls
effective? Have we any
internal fraud?
Can we effectively track
and manage risk, trends
and problem areas in our
supply chain?
Are our suppliers
delivering on time and in
full? Can we measure
poor performance?
Are we getting value from
our suppliers? Are our
contracts delivering
value?
PwC
What is the potential for
cost savings in
procurement?
How much of
procurement spend is
outside of compliance
rules or targets?
How can we pre-empt
issues before they arise ?
Can we procure better
through planning and
insight?
14
The Process of Procurement Analytics
PwC
Solution
Centre
Upload to
Cloud
Client
Create Data Cube
Industry
Expertise
Validation &
Feedback
Data Uploaded into Tableau
Procurement
Team
SFTP
Procurement Analytics
End User
Visualisation
An Insight & Analytics Solution
• Aggregate - Collect and assemble data from disparate IT systems in order to get completeness of procurement spend.
• Cleanse - cleanse multiple versions of vendors with separate unique ID’s, material descriptions and PO coverage.
• Enhance - improve your data through classification and application of CMG’s, utilising 3rd party data sources e.g. D&B.
• Analyse - conduct best practice procurement analytics, identifying risks and opportunities for improvements.
• Visualise – present the information in a visually rich way that assists you in understanding your procurement spend but
also identify and monitor the realisation of improvement opportunities over a longer period of time.
PwC
15
Spend Analysis – Global Technology Client
Situation
and
Approach
 Our client engaged PwC to support a 3rd Party Spend challenge in their EMEA business. The business
was approaching the savings target through a large number of bottom up initiatives driven by the
experience of the Regional leadership teams.
 PwC were engaged to provide increased visibility of current third party spend to a broader audience of
stakeholders and use this insight to drive additional savings opportunities.
 Specifically PwC were asked to:
 Develop a Spend Cube to allow the business to analyze and manage 3rd party spend
 Use the insight provided by the Spend Cube combined with our category and procurement
expertise to propose additional cost reduction activities
 Over a four week period, PwC processed 2.2million line items to build a spend cube which
delivered all of our client’s EMEA spend data in one place, bringing together key dimensions
from their ERP systems to deliver a flexible reporting layer.
Results
 Created general spend overview and additional customized views including:
 Spend by Legal Entity & Account, by PO Requestor Detail , Spend vs Number of Suppliers, Top
Suppliers by Category, Spend by Service Line, Capability & Customer Account, Spend by
Country (Physical) over Time
 PwC has also improved data quality using new categorization tables and data cleansing including:
 A cleansed view of 9,000 supplier names, allocating an additional $300m of spend to customer
accounts, and adding visibility of supplier details for additional $30m of spend
 PwC worked with the business to develop an approach to reduce the 3rd party spend with 4 focus
areas:
 A review of the top 100 suppliers to ES EMEA (67% of spend), and then the second 100
suppliers
 Focus on supplier consolidation by business unit and category to drive more strategic and
coherent sourcing
 A review of suppliers which only serve one region or country (34% of spend)
Standalone projects which focus on the aggregation of demand in specific categories or
capabilities
 PwC continues to support the focus areas above and provide ongoing support to the data cube for this
16
client.
PwC
Content
Introduction
Overview
Insight
Analytics Examples
Big Data
Questions?
Large Global Airline - 6 week Project – Rapid Insight
15,000
Suppliers
216
Locations
6 Weeks
56
Currencies
18 Months
of Data
1+ Million
invoice
lines
5 Key
Data
Sources
PwC
£5 Billion
spend
We have created a
consolidated and
interactive spend
analytics tool
Global Brewer – 1.5 years - Sustainable Analytics
Reporting
• 100’s millions (Euro) annual savings
• 24 SAP systems
• 8 billion Euro total spend
Dashboard
Interactive
Report
Search
&
Explore
Analyze
Report
Master
Data Mgt
4
*
Data
Enrich
Validated Data
3
Location
hierarchy
D&B
PO
POC
Data Warehouse
AP
MD
2
Categorization
Transactional Data and Masterdata
CEE
Americas
AME
UK
France
Austria
Romania
Brazil
Egypt
Finland
Italy
Poland
Russia
Mexico
Nigeria
NL
Spain
Serbia
Hungary
HUSA
South
Africa
Belgium
Other
OpCos
Bulgaria
Other
OpCos
Other
OpCos
Other
OpCos
PwC
1
AP
Indonesia
Other
OpCos
Content
Introduction
Overview
Insight
Analytics
Big Data
Questions?
What’s Big Data?
“Big Data is all data that has
previously been ignored due to
technical limitations.”
Complex
Variety
Big Data
PwC
Large
Volume
Dynamic
Velocity
October 2013
21
What’s Big Data?
Variety
Unstructured
Semistructured
Photos
Sensor
data
Web logs
Inventory
records
Supplier
details
BIG
DATA
Customer
details
Climate
data
Satellite
images
Traffic
signs
Structured
Transactions
X-Ray scans
Video
Invoice
records
Audio
GPS
Employee
details
Product
details
Maps
RFID
Books &
articles
Text messages
& comments
Big Data
PwC
October 2013
22
What are the prospects of Big Data?
Customer
retention
Genome
analysis
Fraud and money
laundering detection
Crime prevention
Product usage
Machine failure
detection
Big Data
PwC
Cost
optimisation
Health
diagnosis
October 2013
23
Video – Example of Big Data usage
http://www.youtube.com/watch?v=wqhZl-av9r8
PwC
24
What are the prospects of Big Data? - PwC case study
Public Access
Search the
Information Resource
Restricted Access and
Researchers
Search and Analysis
Website &
Access Process
Brain and
Eye Scans
Genomic Data
Participant
Clinical
Visit Data
Proteomic
Data
HES, Cancer
and Death
Register data
Metabolomic
Data
Completed
Research Data
Big Data
PwC
BIOBANK VIDEO
Data from New
Study Areas
•Epigenetics
•RNA
October 2013
25
What are the challenges?
Protecting
private and
confidential data
Lack of skilled
resources
(Data Scientists)
Choosing a wrong
technology can be
very expensive
Ensuring quality
data
Big Data
PwC
Managing
metadata
October 2013
26
Content
Introduction
Overview
Insight
Analytics
Big Data
Questions?
Business Intelligence – The power to know…
Any Questions?
Business Intelligence – The power to know…
This publication has been prepared for general guidance on matters of interest only, and does
not constitute professional advice. You should not act upon the information contained in this
publication without obtaining specific professional advice. No representation or warranty
(express or implied) is given as to the accuracy or completeness of the information contained
in this publication, and, to the extent permitted by law, PricewaterhouseCoopers LLP, its
members, employees and agents do not accept or assume any liability, responsibility or duty of
care for any consequences of you or anyone else acting, or refraining to act, in reliance on the
information contained in this publication or for any decision based on it.
© 2011 PricewaterhouseCoopers LLP. All rights reserved. In this document, “PwC” refers to
PricewaterhouseCoopers LLP which is a member firm of PricewaterhouseCoopers
International Limited, each member firm of which is a separate legal entity.