BI and Big Data Management
()
About this ebook
Companies increasingly recognize that the analysis of business information (business intelligence) can generate decisive competitive advantages. In addition, the compliance guidelines BCBS 239, Basel II and III, SOX, and Solvency II have led to legal requirements for a minimum level of quality in reporting and planning data and processes. The establishment of enterprise-wide data management thus continues to be one of the major challenges for IT and management in the years to come.
Data quality is an integral success factor in the establishment of an optimal information infrastructure. A 2002 study from "The Data Warehousing Institutes" (TDWI) calculates that poor data quality in the US cost about $622 billion. Gartner market research stated in 2006: Poor data quality costs a typical organization 20% of revenue….
The worldwide financial and economic crisis after 2007 can retrospectively also be regarded as a data quality crisis. Despite far-reaching compliance requirements, many financial service companies have not been able to aggregate and prepare their risk data in a way to adequately control their risks, and they are still struggling in 2017.
In the era of Big Data, data is viewed as the new oil and the available data volume worldwide multiplies every year. The requirements for transparency and data stream quality continue to increase, because these are considered essential for partially or completely new applications in decision support and other areas.
But what use are larger data piles when quality and origin remain uncertain and when the costs for development and operation in data maintenance, integration, and analysis are proportional to the data volume?
"Data quality is not everything, but without quality of data, it is all nothing."
Metadata and metadata management are important aids for ensuring adequate data quality.
The goal of this book is to take the current concepts and trends and tune the minds of project managers, IT managers, IT architects, analysts, developers, and business leaders back to the topics of data quality management and integrated metadata management.
Related to BI and Big Data Management
Related ebooks
Big Data: Understanding How Data Powers Big Business Rating: 2 out of 5 stars2/5Big Data: Opportunities and challenges Rating: 0 out of 5 stars0 ratingsUnderstanding Big Data: A Beginners Guide to Data Science & the Business Applications Rating: 4 out of 5 stars4/5Modern Enterprise Business Intelligence and Data Management: A Roadmap for IT Directors, Managers, and Architects Rating: 0 out of 5 stars0 ratingsSpreadsheets To Cubes (Advanced Data Analytics for Small Medium Business): Data Science Rating: 0 out of 5 stars0 ratingsLearning Qlik® Sense: The Official Guide Rating: 0 out of 5 stars0 ratingsBuilding Big Data Applications Rating: 0 out of 5 stars0 ratingsBusiness Intelligence Guidebook: From Data Integration to Analytics Rating: 4 out of 5 stars4/5Architecting Big Data & Analytics Solutions - Integrated with IoT & Cloud Rating: 5 out of 5 stars5/5Smarter Data Science: Succeeding with Enterprise-Grade Data and AI Projects Rating: 0 out of 5 stars0 ratingsBig Data for Enterprise Architects Rating: 5 out of 5 stars5/5Business Intelligence: The Savvy Manager's Guide Rating: 4 out of 5 stars4/5Managing Data in Motion: Data Integration Best Practice Techniques and Technologies Rating: 0 out of 5 stars0 ratingsAnalytics in a Big Data World: The Essential Guide to Data Science and its Applications Rating: 0 out of 5 stars0 ratingsDeveloping Analytic Talent: Becoming a Data Scientist Rating: 3 out of 5 stars3/5Learning Qlik Sense®: The Official Guide - Second Edition Rating: 5 out of 5 stars5/5Business Value in an Ocean of Data: Data Mining from a User Perspective Rating: 0 out of 5 stars0 ratingsUnderstanding the Predictive Analytics Lifecycle Rating: 5 out of 5 stars5/5Analytics: The Agile Way Rating: 5 out of 5 stars5/5Making Big Data Work for Your Business: A guide to effective Big Data analytics Rating: 0 out of 5 stars0 ratingsBig Data, Big Analytics: Emerging Business Intelligence and Analytic Trends for Today's Businesses Rating: 0 out of 5 stars0 ratingsWhat Is Big Data Rating: 0 out of 5 stars0 ratingsSelling Information Governance to the Business: Best Practices by Industry and Job Function Rating: 0 out of 5 stars0 ratingsBuilding a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5A Practical Guide to Analytics for Governments: Using Big Data for Good Rating: 0 out of 5 stars0 ratingsIBM InfoSphere: A Platform for Big Data Governance and Process Data Governance Rating: 2 out of 5 stars2/5Enterprise Business Intelligence and Data Warehousing: Program Management Essentials Rating: 4 out of 5 stars4/5
Enterprise Applications For You
Bitcoin For Dummies Rating: 4 out of 5 stars4/5The Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratingsQuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Excel 2019 For Dummies Rating: 3 out of 5 stars3/5Systems Thinking: Managing Chaos and Complexity: A Platform for Designing Business Architecture Rating: 4 out of 5 stars4/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratingsThe New Email Revolution: Save Time, Make Money, and Write Emails People Actually Want to Read! Rating: 5 out of 5 stars5/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsExcel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsMrExcel XL: The 40 Greatest Excel Tips of All Time Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5Experts' Guide to OneNote Rating: 5 out of 5 stars5/5Mastering QuickBooks 2020: The ultimate guide to bookkeeping and QuickBooks Online Rating: 0 out of 5 stars0 ratingsMicrosoft Power Platform A Deep Dive: Dig into Power Apps, Power Automate, Power BI, and Power Virtual Agents (English Edition) Rating: 0 out of 5 stars0 ratingsQuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Excel 2016 For Dummies Rating: 4 out of 5 stars4/5Managing Humans: Biting and Humorous Tales of a Software Engineering Manager Rating: 4 out of 5 stars4/5101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5
Reviews for BI and Big Data Management
0 ratings0 reviews
Book preview
BI and Big Data Management - Ulrich Hambuch
BI and Big Data Management
Ulrich Hambuch
––––––––
Translated by Philipp Strazny
BI and Big Data Management
Written By Ulrich Hambuch
Copyright © 2017 Ulrich Hambuch
All rights reserved
Distributed by Babelcube, Inc.
www.babelcube.com
Translated by Philipp Strazny
Cover Design © 2017 Ulrich Hambuch
Babelcube Books
and Babelcube
are trademarks of Babelcube Inc.
Imprint
© / Copyright: 2017 Ulrich Hambuch
E-Mail: info@infogenesis.de
Web: http://www.infogenesis.de
First edition
English translation: Philipp Strazny
Cover, Illustrations: Ulrich Hambuch,
Cover image: http://www.pixabay.com
Images: http://www.pixabay.com and http://freeimages.com
Fig. 23 with permission from: ORAYLIS GmbH
This work and all its parts are subject to copyright. Any use outside of the confines of copyright is inadmissible without agreement of publisher and author. This applies in particular to electronic or other reproduction, translation, distribution, and publication.
Bibliographical data of the Deutsche Nationalbibliothek (German National Library):
Die Deutsche Nationalbibliothek lists this publication in the Deutsche Nationalbibliografie; detailed bibliographic information are available online under http://dnb.d-nb.de.
If you do not change direction, you may end up where you are heading.
Lao Tzu
MeYouWe
The magical App for improved cooperation and human development.
––––––––
Introduction
Companies increasingly recognize that the analysis of business information (business intelligence) can generate decisive competitive advantages.
Thus, there is more emphasis on looking for strategies and techniques to make valuable business process data visible, available, and interpretable.
In addition, the compliance guidelines BCBS 239, Basel II and III, SOX, and Solvency II have led to legal requirements for a minimum level of quality in reporting and planning data and processes. The establishment of enterprise-wide data management thus continues to be one of the major challenges for IT and management in the years to come.
Data quality is an integral success factor in the establishment of an optimal information infrastructure. A 2002 study from The Data Warehousing Institutes
(TDWI) calculates that poor data quality in the US cost about $622 billion.
A basic requirement for adequate data quality is standardized and integrated data and information management, and companies taking steps to reach this goal recognize the crucial role of metadata.
Metadata describe data. They abstract from specific applications and thus establish data neutrality. This allows data to be integrated and used in other contexts.
Many projects in the context of decision support information systems, in particular business intelligence systems (BI) or big data initiatives, fail due to insufficient data quality. Data quality deficiencies have ramifications ranging from the need for post hoc data correction over reduced acceptance of the BI system to suboptimal decisions and insufficient support of operative business processes.
Gartner market research stated in 2006: Poor data quality costs a typical organization 20% of revenue.... A 2011 study by the Würzburg researcher BARC determined that poor data quality has various negative effects. It causes workers to be less satisfied when they have to spend a lot of time on unnecessary data cleansing. 61% of the surveyed also report increasing costs from poor data quality. 47% noted a decrease in customer satisfaction.
The worldwide financial and economic crisis after 2007 can retrospectively also be regarded as a data quality crisis. Despite far-reaching compliance requirements, many financial service companies have not been able to aggregate and prepare their risk data in a way to adequately control their risks, and they are still struggling in 2017. Besides factors such as homogeneous conceptual understanding, a modernized process and system architecture, and data governance, adequate and comprehensive data quality management as well as a maximally integrated metadata management also play a crucial role in efficient and reliable data management.
In the era of Big Data, data is viewed as the new oil and the available data volume worldwide multiplies every year. The requirements for transparency and data stream quality continue to increase, because these are considered essential for partially or completely new applications in decision support and other areas.
Figure 1: Volume forecast for digital data generated per year from 2005 to 2020 worldwide (in exabyte). Source: Digital Universe study.
Metadata and metadata management are important aids for ensuring adequate data quality. Metadata fall into roughly two categories:
Table 1: Metadata categories
Data abstraction, i.e. the generation and use of appropriate metadata, could be a suitable tool for getting a handle on growing data volumes. However, enterprises and government institutions hesitate to invest in relevant projects and infrastructures for successful data management, because they generally focus primarily on data collection and