Using Data Management to Solve Real-World Challenges

You may know some basics about data management, but do you realize the transformational results data-management-done-right can produce? This paper explains core data management capabilities, then describes how a solid data management foundation can help you get more out of your data. From getting fast, easy access to trustworthy data to making better decisions and becoming a data-driven business, you’ll learn why good data management is essential to success. Multiple real-world examples illustrate how SAS customers have used data management to improve customer experience, boost revenue, remain compliant and become more efficient.

Using Data Management to Solve Real-World Challenges
Using Data Management to Solve Real-World Challenges

Do you trust your data? Is it easy to access, clean, integrate and monitor?

Do your business users have self-service access to the data they need to make better decisions and take required action?

Today, organizations collect an increasing amount of data and having a solid data management foundation can help you to make sense of it, allowing you to make better decisions and become data-driven.

Read on this article for examples of organizations using data management to improve customer experience, boost revenue, remain compliant and become more efficient.

Content Summary

Data Management at a Glance
The Benefits of Definitive Data Management
Get Data on Demand
Make Data Decisions You Can Trust
Understanding Action Starts With Data
Build a Data-Driven Business
See Data Management in Action
Case in Point: Florida Department of Education
Results With SAS Solutions
Benefits
How SAS Helps You Get More Out of Your Data
Where to Begin? SAS Data Management Methodology
Plan
Act
Monitor
What’s the State of Data Management at Your Organization?

Let’s say you’re working to improve the customer experience through a Know Your Customer initiative. Maybe you’re meeting regulatory requirements like BCBS 239 or GDPR in Europe to avoid fines. Or you might be cutting costs by removing duplicates from your monthly prospecting list.

No matter what your initiative, having accurate data is the first step if you want to make the best possible decisions. There’s certainly no lack of data. But simply having lots of data won’t necessarily help you answer big questions, understand problems or make faster, better decisions. To achieve a competitive advantage, maintain profitability or satisfy customers, you must be able to act on what the data tells you.

Unfortunately, many of us are overwhelmed by our data despite recent advances in data management technology and tools. Massive volumes of it are often spread across departments, teams, and locations, like the cloud, in different formats and systems, hindering reporting and analysis. And if there are disparities among different systems or reports, you probably spend too much time finding and cleansing data − time that could be better spent analyzing, communicating or responding. Even after the data is fixed during a monthly fire drill, you haven’t necessarily changed the systemic issues or root causes of your data quality challenges.

How do you capture the lessons you’ve learned and automatically apply them to the data – so next month you won’t have to waste time blending and cleansing data the same way all over again?

Consider a simple example where several systems contain different versions (and names) for the same person.

Figure 1: Customer details stored and referenced differently in each operational application.
Figure 1: Customer details stored and referenced differently in each operational application.

Any system can store this information and provide it to a user. But how would you know that these records are all related to the same customer? You could reconcile them manually. Imagine the challenges of fixing hundreds or thousands of records like this. Do you have the time and resources to do it?

Effective data management enables you to integrate, clean and maintain your data. But what exactly does that entail? Why should you prioritize investment in data management solutions, and what do they support?

This paper answers these questions and explores how SAS® Data Management solutions can help you overcome common barriers to seize the value in the wealth of data available to you.

Data Management at a Glance

Beyond the many data enthusiasts and professionals who love data, organizations don’t do data management because they enjoy it. They do data management because there’s always a business reason tied to it.

Organizations use data management to improve customer experience, increase revenue, reduce costs through operational efficiency, or meet compliance or regulatory mandates. These regulatory directives include federal or state-mandated reporting or adhering to risk, fraud or privacy regulations like the General Data Protection Regulation (GDPR).

To obtain the clean, complete and current data required for accurate reporting and analytics or other operational use cases, you must have a comprehensive data management foundation. All the activities your organization engages in to understand, cleanse, integrate, govern, master and monitor data as a strategic asset are essential to your data management platform.

As shown in Figure 2 (on the next page), data management involves numerous capabilities:

  • Data access refers to your ability to locate and retrieve information wherever it’s stored. Certain technologies can make this step as easy and efficient as possible so you can spend more time using the data − not just trying to find it.
  • Data quality is the practice of making sure data is accurate and usable for its intended purpose. This starts from the moment data is accessed and continues through various integration points with other data − and even includes the point before it’s published or reported.
  • Data preparation, often in a self-service capacity, gives business users access to manipulate the data they need with minimal training and without burdening IT to provision and transform the data.
  • Data integration allows you to combine different types of data, usually overnight, in what is called extract, transform and load (ETL) jobs. Data virtualization is a subset of data integration that provides more agility than traditional ETL batch routines. It allows you to generate a dynamic view of the data (which is sometimes masked) – without moving it and without needing an intermediary data mart to store it.
  • Data governance is an ongoing set of rules and decisions for managing data to ensure that your organization’s data strategy and business strategy are aligned. It helps you adhere to business rules and stay in compliance with state and federal mandates.
Figure 2. The five aspects of definitive data management.
Figure 2. The five aspects of definitive data management.

The Benefits of Definitive Data Management

Modern data management solutions incorporate the five capabilities shown above as part of an end-to-end solution. With a comprehensive foundation like SAS Data Management in place, you can:

Get Data on Demand

  • Provide simple, straightforward and automated access to the data you need, when you need it.
  • Integrate all required data and correct inconsistencies and duplications.
  • Manage analytical data marts and data lakes to provide streamlined data access.
  • Make abstracted views of your data available to applications while you change the source of that data during a modernization effort.
  • Run data processes in your environment of choice.

Make Data Decisions You Can Trust

  • Profile and validate data to better understand it.
  • Establish business rules governing the content, quality and structure of data.
  • Perform sophisticated identity resolution to establish a single view of any domain and to reduce duplicate customer entries (helping to improve customer experience).
  • Enable departments to monitor data quality on an ongoing basis and call out exceptions before issues arise.
  • Provide real-time data services to stop data quality issues before they enter the system.

Understanding Action Starts With Data

Without action, decisions are meaningless. Action is what changes behavior and fixes broken business processes. And the action starts with data. With SAS Data Management, you get data on demand, helping you make decisions you can trust – so you can run a data-driven business. Let’s take a look at what this means.

Understanding Action Starts With Data
Understanding Action Starts With Data

Get data on demand. This relates to delivering the right data to the right people at the right time. Different users and situations require different levels of data latency. For example, to determine the risk associated with offering a new loan to a high-value customer, you would want real-time data within a few seconds. But you can run overnight batch updates to determine the loyalty points a credit card has accrued. It’s important to offer multiple avenues of access via differing latencies and related costs for a variety of situations.

Make data decisions you can trust. Now you’ve got access to the data you need in the time frame in which you need it. Is the data consistent and accurate? If it’s not, the decisions you make might be the wrong ones. To get to a decision you can trust, you need a consistent view of data across disparate silos or departments, which can be achieved by applying data quality processes like standardization or deduplication. You also need consistent naming and alignment between business and IT groups. And data quality processes must be applied at the source of the issues to ensure you don’t go through this process every time you need to create a report.

Build a data-driven business. Using a variety of processes and technologies, you can begin to prioritize IT projects according to the business value they generate. Business and IT start speaking the same language. Risk is reduced, and you comply with privacy and other policies. You make decisions and take action based on data instead of guesses. You’re running a data-driven business, and studies have shown that you’re likely to be more profitable because of it.

Build a Data-Driven Business

  • Ensure compliance and minimize risk by ensuring that data is timely, accurate and stored in the appropriate formats for reporting and audit trails.
  • Improve the way key data streams are organized to provide better visualization and decision making from your data.
  • Empower business professionals through the use of self-service data preparation tools that require less training.
  • Create a common vocabulary to bridge the gap between business and IT.
  • Align data management tasks with corporate goals so you can compete more effectively with data.

See Data Management in Action

The value of effective data management is increasingly understood across industries, so it’s no surprise to see so many organizations investing in data management solutions. Examples include:

  • World Wildlife Fund (WWF) used SAS Analytics and SAS Data Management to maximize its marketing efforts. As a result, the US office of WWF has significantly increased revenue from donations while reducing acquisition costs. That means more funding to protect the planet.
  • 1-800-FLOWERS.COM relied on SAS Marketing Automation and SAS Data Management to collect, manage and analyze in-depth data about customers. This insight allows the company to communicate with customers effectively throughout their customer journey and has improved customer acquisition and retention.
  • Des Moines Community College employed a SAS data warehouse to ensure its data was properly managed and accurate. The warehouse feeds the self-service reporting and analytics solutions deployed across the college. Users can securely view data and reports without assistance.
  • The Orlando Magic – a professional sports team – used SAS Analytics and SAS Data Management to become among the top revenue earners in the NBA.
  • Interamerican, the largest private insurance company in Greece, used SAS for Personal Data Protection to safeguard its systems and comply with GDPR while building customer trust.
  • Ecclesiastical Insurance used SAS Data Management to improve its data quality as part of a data governance initiative. This helps strengthen decision making for underwriting, reinsurance and risk selection – and helps with regulatory compliance.
  • The University of North Texas used SAS Data Management, SAS Visual Analytics and SAS Visual Statistics to view trends in key indicators for student success, exposing patterns to investigate. The university changed policies and procedures, and as a result, retention rates rose, leading to better student outcomes and an estimated $450,000 in savings. Since implementing SAS, efficiencies afforded by analytics have reduced costs at the university by more than $1 million.
  • The North Carolina Office of Information Technology Services worked with SAS to develop the Criminal Justice Law Enforcement Automated Data Services (CJLEADS) application. This solution uses data integration technology from SAS to quickly blend data from many sources and help prevent crime – at a cost savings of $12 million annually.
  • Enerjisa used the data quality and data integration capabilities of SAS Data Management to reduce duplicates, cutting the number of total customer records by 25% and obtaining a single view across multiple sources. This consistent, reliable view of customers significantly increased the rate of successful customer contacts.

Case in Point: Florida Department of Education

To better understand how SAS can help, consider how the Florida Department of Education (FLDOE) – which gathers data from universities, colleges and K-12 schools for legislative reporting, educational effectiveness reporting, and research – is using SAS solutions.

FLDOE needed to deploy an enterprise-level data collection, processing, and data governance process to facilitate and provide access to statewide longitudinal education data to stakeholders, as well as:

  • Create a persistent unique identifier that tracks a student from K-12 to college and beyond.
  • Establish enterprise governance policies and processes.
  • Deliver a single view of students and personnel to internal users.
  • Facilitate and provide statewide education data to stakeholders.
  • Enable accurate reporting and integration across more than 67 sources.

At the same time, the solution had to meet statewide business requirements, improve data quality, support increasing reporting frequencies and employ shared metadata to boost efficiency. Equally important, it needed to integrate with and use FLDOE’s existing system investments.

Results With SAS Solutions

To meet these needs, FLDOE deployed SAS Data Management technologies so that FLDOE is now able to:

  • Uniquely identify each individual (students and staff) within the Florida educational system using a primary unique identifier (FLEID).
  • Properly identify individuals, which is a critical component of determining to fund across districts.
  • Create a secondary anonymous identifier for each individual with no recognizable correlation to the FLEID outside of the FLEID application. The secondary identifier is intended to protect an individual’s personally identifiable information when individual information is provided to organizations for purposes such as research.
  • Create an independent data repository to store both the latest and all historical identifying records on individuals.
  • Submit various survey files with information regarding students, staff and faculty on an established schedule running through a data quality system.
  • Support − and enable easy editing of − more than 1,600 business rules used to validate the contents and format of the data.

Benefits

The benefits of this solution have been significant. “SAS is helping us create a persistent statewide unique identifier and longitudinal view of students and staff across colleges, K-12, and other sources and systems,” says Andre Smith, Assistant Deputy Commissioner of Data Systems at FLDOE. “They uniquely provided the integrated suite of data management capabilities and consulting skills required to modernize our systems, increase reporting accuracy and improve stakeholder experience.”

How SAS Helps You Get More Out of Your Data

These organizations turned to SAS to become data-driven, the foundation of which is access to trusted, consistent and integrated data.

To achieve this from the SAS Platform, SAS offers fully integrated solutions for data management, data visualization, reporting and analytics that you can deploy as your needs or users evolve. For example, users may need to move to advanced, exploratory analytics, or may need to deploy data quality in real-time to applications or source systems. SAS solutions are unique because they support data processing at the source, include common metadata that spans data management and analytics, and provide data management for business users. And SAS software’s data management foundation is powered by built-in analytics.

With SAS Data Management − an industry-leading solution built on the SAS Platform − you can fully exploit, integrate and govern your data. SAS provides a unified environment of solutions, tools, methodologies and workflows for managing data as a core asset. You can access your data regardless of where it’s stored − including traditional systems and growing areas like the cloud. And because the software’s underlying technology is fully integrated, you’ve not forced to cobble together a solution. All the functionality − from data preparation to data quality − is part of the same architecture. So you can prepare your data for visualization, analytics or operational use while ensuring quality, transparency and accountability.

Where to Begin? SAS Data Management Methodology

When you’re ready to put your data management strategy into action, get started by following the SAS Data Management methodology. This step-by-step process guides you in performing data management tasks, such as data quality, data integration, and data migration.

The methodology guides you through building a foundation that can help optimize revenue, control costs and mitigate risks. All the stages interact. So, for example, you can (and should) revisit your initial plans and operational designs when evaluating your progress in the monitoring stage. The methodology includes three stages:

  • Plan. Where you discover data and define processes and rules for managing it.
  • Act. Where you design and execute those defined processes.
  • Monitor. Where you evaluate the data and control it as it flows into and through your organization.
Figure 3. The three stages of the SAS Data Management methodology are plan, act and monitor.
Figure 3. The three stages of the SAS Data Management methodology are plan, act and monitor.

Plan

During the Plan phase, you define the people, processes and technologies that are part of your data management project. This phase gives you time to discover and categorize all of your data assets. To get started, ask questions like these:

  • People. Who is involved, and for what purpose? Who owns which data, applications or processes?
  • Road map. Where are we now, and where do we want to go? What obstacles do we face? What are our organizational goals?
  • Source systems. What data do we need, and where does it come from? Can we access it wherever it’s stored, including the cloud? What’s the quality of our data?
  • Security. Who should have access to what data? What audit requirements do we have to meet?
  • Business processes. Which business processes are affected? How can better data enhance how our organization operates?
  • Business terms, rules and data definitions. How do we define “customer”? How can we optimize procurement and spending? Do we have a centralized business glossary to store commonly used business terms, their owners and related technical metadata?

Act

During the Act phase, your team should design a system that can accommodate all of your data needs and execute your business processes. Take stock of all the different data structures, formats, sources and feeds you use. Then consolidate and coordinate data management activities by concentrating on:

  • Consistent rules. Your ultimate goal is to have one set of business rules that can be stored centrally but deployed across all data sources, applications and lines of business. This is where you take the rules you designed in the planning phase and create and deploy data processes that execute on the data to enrich or cleanse it.
  • Consistent data model. The data model is the single, definitive source for how your data maps to your business. A well-structured data model allows you to identify appropriate source systems and begin to reconcile multiple views.
  • Consistent business processes. Here, your goal is to provide consistency across all of the business processes involved in each of your data management tasks.
  • Consistent model deployment. Analytical models are at the heart of critical business decisions. Focus on data preparation, model development, model testing, deployment, monitoring, recalibration and back again – so you can automate as many decisions as possible, as quickly as possible.

Monitor

A healthy data life cycle requires a robust monitoring and reporting system that keeps pace with an evolving business – one that may often adopt new partners, new data, new initiatives, and new products. All of these changes need to be reflected in your data. To gain a consistent, validated view of the business, you must consistently monitor your data. At this stage, you should:

  • Monitor. Monitor and validate data as it enters your organization to verify that it adheres to your rules. At the same time, constantly monitor your rules to ensure they still meet the needs of your business.
  • Review. Consolidate your rules and requirements into a single environment.
  • Optimize. Centralize data management rules so you can immediately share changes across the organization, without duplicating efforts.
  • Visualize. Visualize the level of data health quickly and easily with bundled reports, and create new ones when needed.

What’s the State of Data Management at Your Organization?

Ask yourself these key questions:

  • Do you trust your data, and is it easy to access, clean, integrate and monitor?
  • Do you know which types of data are used by what people in your organization?
  • Is there a system in place for analyzing data as it flows into and through your organization?
  • Can your IT department keep up with the demands of the business?
  • Do your business users have self-service access to the data they need to make better decisions and take action?
  • Do you know how to use your data to help you compete?
  • Do you support corporate strategies, and can you glean more value from the data locked in your organization?
  • Can you bridge the gap in the skills required to manage data or make better decisions from it?

As your organization struggles with growing volumes and sources of data, increasingly complex regulatory requirements, and pressure to do more with fewer resources, SAS Data Management can help. How? Our solution helps you make sense of your data so you can make better decisions. Then you can take the right actions to improve customer experience, boost revenue, become more efficient and remain compliant.

Source: SAS