Information Management

Strategies for Gaining a Competitive Advantage with Data

William McKnight, William Mcknight

• Publisher: Morgan Kaufmann
• Year: 2013
• Print ISBN:
  9780124080560
• eBook ISBN:
  9780124095267
• Topic: Business
• Subtopic: Business Intelligence
• Index: Business

Information Management: Gaining a Competitive Advantage with Data is about making smart decisions to make the most of company information. Expert author William McKnight develops the value proposition for information in the enterprise and succinctly outlines the numerous forms of data storage. Information Management will enlighten you, challenge your preconceived notions, and help activate information in the enterprise. Get the big picture on managing data so that your team can make smart decisions by understanding how everything from workload allocation to data stores fits together. The practical, hands-on guidance in this book includes: - Part 1: The importance of information management and analytics to business, and how data warehouses are used - Part 2: The technologies and data that advance an organization, and extend data warehouses and related functionality - Part 3: Big Data and NoSQL, and how technologies like Hadoop enable management of new forms of data - Part 4: Pulls it all together, while addressing topics of agile development, modern business intelligence, and organizational change management Read the book cover-to-cover, or keep it within reach for a quick and useful resource. Either way, this book will enable you to master all of the possibilities for data or the broadest view across the enterprise. - Balances business and technology, with non-product-specific technical detail - Shows how to leverage data to deliver ROI for a business - Engaging and approachable, with practical advice on the pros and cons of each domain, so that you learn how information fits together into a complete architecture - Provides a path for the data warehouse professional into the new normal of heterogeneity, including NoSQL solutions

Chapter One

You’re in the Business of Information

An introductory chapter stressing the importance of information to any business and how good decisions are made based on data.

Keywords

business intelligence; data warehousing; information management; big data; information architecture; performance management; leadership

The most successful organizations are the ones with the most useful and actionable information.

The book is about managing bet-your-business data about customers, products, finances, suppliers, employees, vendors, etc. and all manner of transactions. The possibilities for exploiting this data have increased exponentially in the past decade. It used to be we would try to put everything in a data warehouse (discussed in the next chapter.) While those data warehouses still need attention, they’re not the only game in town for data.

Technologists of all stripes in organizations are hard hit by demands for data – all data. They are also struck by the many possibilities for what to do with it.

So if this data is growing enormously, what’s big and what isn’t? The whole notion of what is “big” and what isn’t is dealt with in Chapter 10. I believe the notion of big versus not big will go away soon. It’s all data, begging to be turned into information. This book is the blueprint for corporate information.

Information is data taken under management that can be utilized.

An Architecture for Information Success

The recipe for success begins with a good, well-rounded and complete architectural approach. Architecture is immensely important to information success. You can architect the environment in a way that encourages data use by making it well-performing, putting up the architecture/data quickly and having minimal impact on users and budgets for ongoing maintenance (because it was built well initially).

I have seen any or all of these factors very quickly send companies retreating to the safety of status quo information usage, instead of progressive uses of information. In the small windows most users have to engage with the data, they will reach a certain level of depth with the data. If the data is architected well, that analysis will be deep, potentially much deeper, insightful and profitable. That is the power of architecture.

This book will have case studies of architecture, but I predominately will talk about the possibilities drawing from development at dozens of companies. Every company is on the journey to information nirvana. Every step of the way in the right direction is worth it. There is no letting up.

Information Technology Disintermediation

There has been a vast disintermediation of Information Technology (IT) functions. No longer is a single IT organization in charge of everything technical. How can they be? Technology supporting information drives all aspects of the business. This makes virtually everyone part of it (lowercase IT). That’s why this book is not just for those working in a formal IT organization, it’s for everyone in the company pursuing their goals through technology.

Users of information are increasingly getting involved in information architecture. They are contributing to weighing the tradeoffs, assessing their workloads in deep ways, selecting methods of data movement and levels of redundancy, determining what constitutes data quality and selecting tools.

If IT is supporting an initiative – as clearly it will do for many – this book provides guideposts for that interaction. This book will provide clear guidance to formal IT as well. My point is it’s information everyone in an organization needs to know. It has to do with the crown jewels, the modern-day gold of the organization – information. It’s how your organization will compete.

At the same time, it also is the responsibility of those who are aware of the possibilities (through the C-suite of executives) for information in the organization to coach the organization in those possibilities and how to USE the information wisely. To whom much is given, much is required. Your capabilities grow with your wisdom about information use and management. Share the information and grow the use of information in your organization.

The Data Scientist

Are you a vaunted “data scientist” if you bring appropriate platforms under consideration or if you know how to use vast amounts of information quickly for high business gain? Yes and yes – and increasingly the answer is becoming both.

If you’re waiting for the current state of affairs to get more settled, know that is unlikely to happen. Someone will champion big data. Someone will champion data virtualization (Chapter 9), data stream processing (Chapter 8) and most of the other components in this book in an organization of any size. Learn how to do it appropriately and let it be you.

Turning Information into Business Success

Today, you need to analyze your business constantly and from multiple perspectives or dimensions. There are the perspectives of the customer, the products, services, locations and many other major dimensions of the business. The high value comes from analyzing them ALL at once. You cannot simply set up a storefront, declare you are open and begin to let the business run on auto-pilot from there. You must analyze the business. Information Architecture is the key to organizing information.

The Glue is Architecture

Information must come together in a meaningful fashion or there will be unneeded redundancy, waste and opportunities missed. Every measure of optimizing the information asset goes directly to the organization’s bottom line.

In reality, information management is nothing more than the continuous activity of architecture.

The glue that brings the components together is called architecture. Architecture is a high-level plan for the data stores, the applications that use the data and everything in-between. The “everything in-between” can be quite extensive as it relates to data transport, middleware and transformation. Architecture dictates the level of data redundancy, summarization and aggregation since data can be consolidated or distributed across numerous data stores optimized for parochial needs, broad-ranging needs and innumerable variations in between.

There must be a ‘true north’ for this enterprise information architecture and that is provided in this book. I do not provide a “one size fits all” reference architecture. Each company is going to be different. There are different starting points and different target interim ending points for architecture (it never really ends). Each company is at a different level of maturity and will wish to advance at a different pace. Many companies are not going to be able to move at the speed desired without new skills in place.

There needs to be a process in every organization to vet practices and ideas that accumulate in the industry and the enterprise and assess their applicability to the architecture. I highly advocate some company resources be allocated to “looking out and ahead” at unfulfilled, and often unspoken, information management requirements and, as importantly, at what the vendor marketplace is offering. This is a job without boundaries of budget and deadlines, yet still grounded in the reality that ultimately these factors will be in place. It’s a very important job for caretaking the information management asset of an organization. For titles, I’ll use Chief Information Architect.

Workload Success

Even organization leaders can take a tactical approach to the execution of the requirements. However, it does not necessarily take longer to satisfy information requirements in an architected fashion. If architecture principles and technology possibilities are not considered beforehand, the means to satisfy the current requirement may be inappropriately defaulted to the means to satisfy the last requirement. And so on.

The Chief Information Architect

The information architecture in place at any point in time is going to be a combination of a bottoms-up, needs- and workload-based approach and a top-down, longer-term thought out approach. Bottoms-up solves crises and advances tactical needs. Top-down – the job of the aforementioned Chief Information Architect among others – looks ahead. It still solves tactical issues, but does so with the strategic needs of the organization in mind. While no organization is run by either approach exclusively, can we please dial up some more top-down to avoid problems caused, essentially, by the lack of a true architecture?

The proposed approach of this book is to:

1. Have a ‘true north’ in mind for a 5-year information architecture, understanding that it is subject to change¹

2. Have a Chief Information Architect managing the 5-year plan and contributing to workload architecture

3. Organize new information requirements into workloads, which comprise functionality that is necessary to achieve with data, as well as the management of the data itself

4. Allocate those workloads to the most appropriate architectural construct for its success (defined below)

5. Perform all work with an eye towards delivering return on investment (ROI) to the business at the lowest total cost of ownership (TCO)

Ultimately, we are trying to deliver return on investment to the business. It’s a principle well worth following as you make decisions. ROI is [return/(return – investment)] and is always specified with a time period (i.e., 145% in 3 years). It requires the discipline of breaking down the workload into its projected cash flow. Whether you embrace the math or not, embrace the idea of delivering value to the business that could, ultimately deliver ROI. This can happen through short-term financial bottom-line impact or through information-borne innovation that yields ROI later. That is what information management should be all about – not speculation, fun exploration or a book standard. It’s about business.

By reducing fraud, a financial services provider showed a 74% 3-year ROI against the existing fraud loss trend and an insurer showed a 213% 3-year ROI through routing claims to the best provider for the service.

Once we have established, as a business, that a workload has high, positive ROI (relative to other possibilities for the investment), we establish the architecture for it that meets the performance, agile and scalability requirements with the lowest TCO. As such, most of this book is focused on conveying the capabilities of each platform to help you allocate workloads appropriately – with the lowest TCO! It is not designed to make you a “one percenter” in knowledge of any of the individual platforms in isolation.

Information Workloads

Allocation of workload to an architecture component is both an art and a science. There are user communities with a list of requirements upon a set of data. There are other user communities with their own list of requirements on the same data. Is this one workload? If ultimately it is best to store the data in one location and utilize the same tool(s) to satisfy the requirements, the practical answer is yes.

What Determines Workload Success

It is primarily the performance of the data access that constitutes the success of a workload². Performance can be engineered (and it always must be to some degree), but primarily we give performance a huge step forward with correct workload-platform allocation.

Secondly, we need to get the workload up and running quickly. Getting to that fast performance quickly is the second measure of the success of an information wo...

Table of contents

• Cover image
• Title page
• Table of Contents
• Copyright
• Foreword
• In praise of Information Management
• Preface
• Chapter One. You’re in the Business of Information
• Chapter Two. Relational Theory In Practice
• Chapter Three. You’re in the Business of Analytics
• Chapter Four. Data Quality: Passing the Standard
• Chapter Five. Columnar Databases
• Chapter Six. Data Warehouses and Appliances
• Chapter Seven. Master Data Management: One Chapter Here, but Ramifications Everywhere
• Chapter Eight. Data Stream Processing: When Storing the Data Happens Later
• Chapter Nine. Data Virtualization: The Perpetual Short-Term Solution
• Chapter Ten. Operational Big Data: Key-Value, Document, and Column Stores: Hash Tables Reborn
• Chapter Eleven. Analytical Big Data: Hadoop: Analytics at Scale
• Chapter Twelve. Graph Databases: When Relationships are the Data
• Chapter Thirteen. Cloud Computing: On-Demand Elasticity
• Chapter Fourteen. An Elegant Architecture Where Information Flows
• Chapter Fifteen. Modern Business Intelligence—Collaboration, Mobile, and Self-Service: Organizing the Discussion and Tethering the User to Information
• Chapter Sixteen. Agile Practices for Information Management
• Chapter Seventeen. Organizational Change Management: The Soft Stuff is the Hard Stuff
• Index