business intelligence and reporting executive survey · business intelligence and reporting...
TRANSCRIPT
Business Intelligence and Reporting Executive SurveyConducted by KPMG Česká republika, s.r.o. in 2014-2015 based on respondents in Banking and Insurance sector.
Czech Republic, Hungary, Romania, Slovakia
3
TEXT3
2
TEXT2
1
TEXT1
ENTERPRISE REPORTING
Are you STILL reporting and analysing data using the MS Office Package?Everybody is.
90%
OF RESPONDENTSWERE NOT SURE
ABOUT THE AMOUNT OF REPORTS AND METRICS IN THEIR
ORGANISATION
12%
52%
12%
12%
41%
6%
6%
59%
42%
70%
59%
35%
53%
29%
47%
12%
12%
23%
24%
29%
53%
29%
17%
6%
6%
6%
12%
18%
18%
Reporting & analyses based on source systems
Reporting & analyses based on MS Excel, MS Access, alternatively MS PowerPoint
Reporting & analyses based on Business Intelligence reporting server
Reporting & analyses based on Data Marts environment
Reporting & analyses based on Data Warehouse environment
Reporting & analyses based on Online Analytical Processing tool
Reporting & analyses based on Visual Analysis tool
Portal-based reporting & analyses solution
Fully implemented In process Not implemented Don’t know
DATA OR METADATADICTIONARYwith business and technical description
4 OUT OF 10 ORGANISATIONS DO NOT HAVE A DATA QUALITY DASHBOARD IMPLEMENTED YET
KEY METRICS
The MOST deployed DQ tools among organisations are online controls and validation and data cleansing & enhancements.
76% OF RESPONDENTS USE DATA MANAGEMENT STANDARDSAND EVEN 88% HAVE IMPLEMENTEDDATA QUALITY CONTROLS
SYSTEM STANDARDS that specify all technologies and products used in BI environment
DATA MANAGEMENT
23%
Notimplemented
71%
23%
53%
23%
18%
71%
12%
Fullyimplemented
Inprocess
Fullyimplemented
Inprocess
Notimplemented
Fullyimplemented
Inprocess
Notimplemented
6%
SINGLE SOURCE OF INFORMATION
THE MAJORITY OF ORGANISATIONS DO REALISE THE POTENTIAL OF REPORTING TOOLS, BUT, ON AVERAGE, BARELY 1/4 ORGANISATIONS ACTIVELY ENHANCE THEIR BI ARCHITECTURE.
The most favoured approaches for the key metric specification in the organisations are brainstorming, prioritisation by executives and heads of business units, benchmarking against leaders in the industry. What about your organisation?
3/4 OF RESPONDENTS CLAIM, THAT THE KEY METRICS HAVE A HIGH OR VERY HIGH POSITIVE IMPACT ON BUSINESS RESULTS
In most casesMORE THAN
%80of metrics are calculated AUTOMATICALLY with roughly an EQUAL number of FINANCIAL and NON-FINANCIAL ones
Average amount of ALL REPORTS 771(45 key reports)
ONLY 4% OF RESPONDENTS ARE ABLE TO IDENTIFY RELATIONSHIPS BETWEEN KEY METRICS IN REPORTS/
DASHBOARDS AT A GLANCE
REPORT CATALOG CONTAINING SETOf all reports and relevant metadata
THE CURRENT LEVEL OF DQ TOOLS’ IMPLEMENTATION
29 29
18
6
1812
18
6
17 17
612
2936 35
4147
53 5359 59
65
82 82
2429 29
1823 23 23
12 12 126 6
18
6
18
35
12 126
23
126 6 0
Fully implemented
More+Less
Not implemented
Don’t know
ETL Tool Data Quality Tool
Reference Data Management
Data profiling Master DataManagement
Metadata repository
Data Quality dictionary
Workflow Data monitoring
Data qualityreporting
Online controls & validation
Data cleansing & enhancements
MOST FREQUENTLY 11–20% OF BUSINESS INTELLIGENCE BUDGET IS SPENT ON REPORTING
Average amount of ALL METRICS 434(93 key metrics)
%
REPORT/DASHBOARD VISUALISATION
Does it take ages to find the desired information in your dashboard?In 81% of cases it takes MORE than just a FEW SECONDS to get it. What about your organisation?
HOWEVER, THIS ABILITY HAS A POSITIVE IMPACT ON OVERALL CONTENTMENT
STATIC AND TEXTUAL ELEMENTS PREVAIL IN REPORTS/DASHBOARDS ON ALL LEVELS OF MANAGEMENT
23% OF RESPONDENTS HAVE NOT IMPLEMENTED UNIFORM GRAPHIC AND ERGONOMIC STANDARDS THAT ENSURE CONSISTENT AND MEANINGFUL DESIGN OF REPORTS AND DASHBOARDS; 76% ARE CURRENTLY IN THE PROCESS OF IMPLEMENTATION, AND NO ONE HAS FULLY ADOPTED THEM
(Key
Rep
orts
) All Metrics
27 (7) 62 (22)
83 (13) 129 (27)
RATIO OF REPORTS & METRICS
TOPFREQUENCIES
AVERAGE AMOUNTOF END USERS
All R
epor
ts
(Key Metrics)661 (25) 243 (44)
THOSE WHO ARE FURTHER IN IMPLEMENTATION ARE USUALLY ABLE TO IDENTIFY RELATIONSHIPS MORE EASILY
GRAPHICAL ELEMENTS ARE INCREASING CONTENTMENT ON A STRATEGIC LEVEL
COMPANIES WITH IMPLEMENTED DWH MOSTLY REPORTED HIGHER CONTENTMENT
OVERALCONTENTMENT
with reports/dashboards
29%
happy
55%
satisfied
16%
disappointed
30%
56%
16
17
50
50
14%
© 2015 K
PM
G C
entral & E
astern Europe Lim
ited, a limited liability com
pany and a mem
ber firm of the K
PM
G netw
ork of independent
mem
ber firms affiliated w
ith KP
MG
International Cooperative (“K
PM
G International”), a Sw
iss entity. All rights reserved.
Annualy
Quarterly
Fewerthan
3%
Monthly up to11%
Weekly More
86%
Daily
than
STRATEGIC
LEVEL
TACTICAL
LEVEL
OPERATIONAL
LEVEL
MUST HAVE COMPETITIVE ADVANTAGE TO BE AVOIDED
l Data Warehouse
l BI Reporting Server
l Catalogs & Dictionaries
l Advanced Analytics
l Visual Analysis tool
l Source Systems- based reporting
l Excessive MS Office-based reporting
MUST HAVE COMPETITIVE ADVANTAGE TO BE AVOIDED
l Clear definitions of metrics
l Balanced scorecard (BSC) adoption
l Unclear competencies during key metric definition process
MUST HAVE COMPETITIVE ADVANTAGE TO BE AVOIDED
l Data Management initiative
l Data Quality tool
l Data Quality Dashboard
l Online validation
l Data cleansing
l Unclear competencies within Data Management
MUST HAVE COMPETITIVE ADVANTAGE TO BE AVOIDED
l Graphic and ergonomic standards (Effective data visualisation)
l Identification of metric relationships at a glance
l Filters, Slice’n’ Dice and Drilling usage
l Key metric grouping
l Distracting elements
l Disorganised report/ dashboard layout
LESSONS LEARNED FROM THE BEST
ENTERPRISE REPORTING
KEY METRICS
DATA MANAGEMENT
REPORT/DASHBOARD VISUALISATION
© 2015 KPMG Central & Eastern Europe Limited, a limited liability company and a member firm of the KPMG network of independent member firms affiliated with
KPMG International Cooperative (“KPMG International”), a Swiss entity. All rights reserved.
The information contained herein is of a general nature and is not intended to address the circumstances of any particular individual or entity. Although we endeavour to provide accurate and timely information, there can be no guarantee that such information is accurate as of the date it is received or that it will continue to be accurate in the future. No one should act on such information without appropriate professional advice after a thorough examination of the particular situation.
The KPMG name, logo and “cutting through complexity” are registered trademarks or trademarks of KPMG International.
© 2015 KPMG Central & Eastern Europe Limited, a limited liability company and a member firm of the KPMG network of independent member firms affiliated with KPMG International Cooperative (“KPMG International”), a Swiss entity. All rights reserved.
For more information, please contact us:
David SlanskyMC Partner T: +420 222 123 111 E: [email protected] Tw: @D_Slansky
Ondrej KulhanekMC Associate Manager T: +420 222 123 379 E: [email protected] Tw: @OnKulhanek
KPMG in the Czech RepublicPobrezni 648/1a 18600 Praha 8 Czech Republic
kpmg.com/cee
KPMG Thought Leadership app