Data Strategy

50 %
50 %
Information about Data Strategy

Published on January 21, 2009

Author: MrBlockHaus

Source: slideshare.net

Description

Understanding what to build before you start to build your data warehouse.

Data Strategy What you have to build before you start building your data warehouse Jeff Block Capstone Consulting Monday, December 29, 2008 © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

What is Business Intelligence? BI is not about delivering access to a massive repository of data, often unconstrained and overwhelming. BI is about delivering highly relevant, highly valuable applications, reports, and dashboards, designed to maximize the user’s ability to gain specific, actionable knowledge from corporate data. Of course – and this can’t be overstated – this requires a culturally-relevant, well-supported governance model and a highly-specialized, flexible data architecture, both optimized for this purpose. © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

What is Business Intelligence? BI is not about delivering access to a massive repository of data, often unconstrained and overwhelming. BI is about delivering highly relevant, highly valuable applications, reports, and dashboards, designed to maximize the user’s ability to gain specific, actionable knowledge from corporate data. Of course – and this can’t be overstated – this requires a culturally-relevant, well-supported governance model and a highly-specialized, flexible data architecture, both optimized for this purpose. © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

What is Data Strategy? The development and maintenance of a single, unified, organization-wide plan for the use of corporate data as a vital asset for strategic and operational decision-making. Investing in a formal data strategy lends much needed intentionality around critical data related issues, such as data quality, metadata, performance, data distribution, organization, ownership, security, privacy, etc. © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

What is Data Strategy? The development and maintenance of a single, unified, organization-wide plan for the use of corporate data as a vital asset for strategic and operational decision-making. Investing in a formal data strategy lends much needed intentionality around critical data related issues, such as data quality, metadata, performance, data distribution, organization, ownership, security, privacy, etc. © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Effective Data Strategy  Build Strategic Alignment  A Single Unified Plan  Strategic and Operation Decisions  Critical Data Related Issues  Wrap-up © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Effective Data Strategy  Build Strategic Alignment  A Single Unified Plan  Strategic and Operation Decisions  Critical Data Related Issues  Wrap-up © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Vision … Critical and First Build Strategic Alignment • Ask yourself – What will the organization look like if we create and execute an intentional data strategy? • Or, ask yourself – What if we still haven’t done so 5-10 years from now? • Align vision with strategic values of the business – Give answers only in the language / currency the business cares about © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Strategic Alignment Process Build (1 of 2) Strategic Alignment 1. Identify the vision, mission, and strategic goals of the organization 2. Identify the organization’s key performance indicators (KPI’s) 3. Develop vision for your data  What will the world look like someday? 4. Develop mission for your data  What will we do (generally) to realize our vision? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Strategic Alignment Process Build (2 of 2) Strategic Alignment 5. Formulate your mission into strategic goals  What will we do (specifically) to realize our vision and fulfill our mission? 6. Develop quantifiable metrics (critical success factors) to identify and measure success  What, when, how will we measure? Does this process sound familiar? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

ACME Widget Company Build An Example Strategic Alignment • Vision: – #1 supplier of widgets in North America • Mission: – Increased penetration in medial, industrial and aerospace sectors • Strategic Goal: – Increase market share in medical vertical by 4% • Key Performance Indicator (KPI): – 7 new accounts closed per quarter per rep in the medical vertical in 2009 © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

ACME’s Data Strategy Build Strategic Alignment • Vision: – Highly-accurate, real-time visibility for sales reps into their accounts • Mission: – Dashboard, scorecard, competitive intelligence and predictive analytics tools in sales reps’ hands • Strategic Goal: – Core attributes of all accounts per sales rep visible in summary and detailed forms on a single screen • Critical Success Factor: – All dashboard data updated every 8 hours © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Effective Data Strategy  Build Strategic Alignment  A Single Unified Plan  Strategic and Operation Decisions  Critical Data Related Issues  Wrap-up © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Avoid the Chaos A Single Unified Plan Not having a data strategy is analogous to allowing each person within each department of your organization to develop their own chart of accounts and use their own numbering scheme. - Sid Adelman, Data Warehousing Expert © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Avoid the Chaos A Single Unified Plan • Must have a data strategy • Must be organization-wide – Multiple data strategies means conflict, unpredictability, and ultimately chaos – Cost of meeting business’ information needs increases exponentially with number of strategies • Whether formally defined strategies or not – No such thing as “no strategy” • Just means you have N strategies, where N is the number of data stakeholders in your org • Information requirements likely (literally) impossible to meet © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Effective Data Strategy  Build Strategic Alignment  A Single Unified Plan  Strategic and Operation Decisions  Critical Data Related Issues  Wrap-up © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Which decisions are you Strategic and supporting? (1 of 2) Operational Decision • What strategic decisions do we want data to help us make? – Strategic decisions = ongoing choices about the long-term vision, direction and health of the organization • What operational decisions do we want data to help us make? – Operational decisions = day-to-day tasks supporting the business function at hand © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Which decisions are you Strategic and supporting? (2 of 2) Operational Decision • All decisions identified should roll up into the strategic goals of the data strategy – By definition, they also roll up into organization’s strategic goals and KPI’s • Identifying these decisions is the beginning of requirements gathering – For data governance – For the data warehouse – For BI tools and applications © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Business Performance Strategic and Management Operational Decision • The purpose of Enterprise Information Management is to drive business performance • Your data strategy is your intentional plan for the use of data to serve this function • Make sure you trace back to your organizational KPI’s (Critical!) © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Universal Business Drivers Strategic and Operational Decision • Increase revenue and value • Reduce cost and complexity • Ensure survival by mitigating risk and enforcing constraints – E.g. – vulnerabilities, compliance, security, privacy, etc Every initiative, including data-related initiatives, must serve these fundamental drivers. © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Effective Data Strategy  Build Strategic Alignment  A Single Unified Plan  Strategic and Operation Decisions  Critical Data Related Issues  Wrap-up © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Let’s walk through a few… Critical Data Related Issues • Data Quality • Metadata • Performance • Data Distribution • Organization • Ownership • Security There are many more, • Privacy but this will get us started. © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Data Quality Critical Data Related Issues How will we… • Define “high” and “low” quality data objectively? • Raise management awareness and support for data quality? • Determine who is responsible for data quality? • Identify, evaluate and diagnose data quality problems? • Determine how timely or fresh must data be? What is “current” data? • Validate our ETL processes? • Determine which data to clean? What is our triage plan? • Evaluate the cost of cleansing data, and determine which efforts are worth it? • Prioritize cleansing efforts? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Metadata Critical Data Related Issues How will we… • Raise management awareness and support for metadata? • Determine which meta data to capture? • Assign responsibilities for capturing and maintaining metadata? • Define business metadata? • Define technical metadata? • Capture metadata? • Use metadata once we have it? • Identify the tools and systems which generate valuable metadata? • Choose software/tools to capture/maintain metadata? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Performance Critical Data Related Issues How will we… • Manage performance-related expectations and perception by management and users? • Address capacity planning of database servers and network infrastructure? • Define performance metrics? • Monitor, measure, and report on performance of data retrieval? • Define, monitor, manage, and expire SLAs? • Tune performance? • Determine roles and responsibilities for performance of data access? • Chose between proactive and reactive models for performance management? When is each appropriate? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Data Distribution Critical Data Related Issues How will we… • Determine users’ need for data? • Define standards for what data to distribute when, where, and to whom? • Monitor, measure, and report the cost to distribute data? • Assign responsibility for administration activities related to distributing data? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Organization Critical Data Related Issues Who will… (Data Governance Roles) • Provide strategic leadership? (DGO Chairman) • Market your data strategy? (Marketing Director) • Steward your organizations data? (Data Steward) • Be responsible for data quality? (Data Quality Director) • Educate users on your data strategy? (User Support and Education Director) • Handle security? (Security Director) • Architect data solutions? (Data Architect) • Administer databases? (DBA) • Administer data and the data warehouse? (Data Warehouse Manager) © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Ownership Critical Data Related Issues Who will… • Be subject to which access rights? – Create data? – View / access data? – Change data? – Delete data? – Copy / move data? • Determine requirements for performance? • Determine requirements for availability? • Determine requirements for maintenance of historic data? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Security and Privacy Critical Data Related Issues How will we… • Determine responsibility for security and privacy? • Create the mechanisms for establishing security and privacy procedures? • Audit our security policy? • Address regulatory issues? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Other Data Strategy Questions Critical Data (1 of 2) Related Issues • What tools and standards will we use for data modeling? • How will we use empirical data to test theories? • How will we achieve the data quality required to meet our goals? • How will we generate new data we need? • How will we merge silo’d data sources? • How will we digitize offline data to be made available for envisioned BI functions? • How will we maintain an accurate inventory of our data? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Other Data Strategy Questions Critical Data (2 of 2) Related Issues • How will we define standards for and incent data sharing? • What are our goals for BI initiatives and tools built on top of our data strategy? • How will we deal with disparate data strategies or violations of the data strategy as they arise? • What will our BI architecture look like? • What is our policy on redundant data? • What are our criteria for software selection? • Will we sell our data, and if so, why and how? • How will we measure data usage? © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Effective Data Strategy  Build Strategic Alignment  A Single Unified Plan  Strategic and Operation Decisions  Critical Data Related Issues  Wrap-up © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Wrap-up • Millions of questions to ask yourself • Allow ample time to ponder them – Work as a team – Don’t let one person dominate, no matter how bright • Don’t wait to get everything figured out to start • Bring in outside help – An expert is worth a thousand meetings • Don’t be intimidated. You can do it! © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

Q&A Group Discussion © Copyright 2008 Capstone Consulting, Inc. Capstone Consulting, Inc

w w w. c a p s t o n e c . c o m © Copyright 2008 Capstone Consulting, Inc. 35 Capstone Consulting, Inc

Add a comment

Related presentations

Related pages

Home - Data Strategy

Data Strategy is, first and foremost, a Technology Advisor. Our clients can expect easy access to expert consulting for all datacenter needs. We deliver ...
Read more

Data Strategy - White Paper - High End Data Analytics

Your data strategy will review the information available across the organization and beyond and define the data to be incorporated and how this will be ...
Read more

5 Essential Components of a Data Strategy - Photo Gallery

Building a comprehensive data strategy for your organization can be a daunting task. Where do you start, and how do you put all the proper pieces in place ...
Read more

Data Strategy

Data Strategy has long specialised in delivering real world, practical products that combine software with hardware to provide safety solutions for the ...
Read more

The Data Strategy

The beginning. It was during that time that Big Data was an emerging field that the founders, Michal Krystyanczuk, senior data scientist and Florencio de ...
Read more

Data Strategy - Silicon Valley Data Science

Our approach to Data Strategy is a process that starts with your strategic business objectives and views them together with an analysis of your workflows ...
Read more

Data Strategy - Sid Adelman, Larissa Terpeluk Moss, Majid ...

Without a data strategy, the people within an organization have no guidelines for making decisions that are absolutely crucial to the success of the IT ...
Read more

Global Data Strategy | The Business of Data

Data-Driven Business Transformation In today's information economy, successful companies are transforming the way they do business through strategic use of ...
Read more

Raw Data Strategy | Database Marketing , Analysis ...

Why would you use Raw Data Strategy? Staff shortages / Lack of experience; Staff do not have the relevant skill sets; Skill transference; Maternity Cover ...
Read more

Data Strategy | InformIT

Data strategy is one of the most ubiquitous and misunderstood topics in the information technology (IT) industry. Most corporations' data strategy and IT ...
Read more