DATA | CASE STUDY
Establish a Collaborative Data Governance Strategy
COMPANY OVERVIEW
A medical professional liability insurance company with clients and services spanning the U.S. that specializes in underwriting policies for physicians, dentists, advanced practices, clinics, and hospitals.
BUSINESS NEED
The client recognized a need for Advanced Analytics and Business Intelligence capabilities to create an information edge over the competition. In order to enable these analytics teams to develop as quickly and efficiently as possible, the client sought to enhance their existing data governance process. This process would ensure that analytic data would be trustworthy, consistent, and accurate, which would allow the analytics teams to focus all of their energy on problem solving, not data cleansing.
SOLUTION
Ironside identified the aforementioned opportunities in a previous technology strategy engagement as being foundational prerequisites for the company to realize its analytics goals. Ironside recommended the formation of an enterprise data governance group. The group would consist of all claims data constituents from multiple subsidiaries and would be able to discuss the state of the data quality and implement improvements. The engagement was made up of the following phases:
Identify Who Will Govern
Identify What to Govern
Teach How to Govern
Establish Accountability
KEYS TO SUCCESS
With Ironside’s help, the client enjoyed many benefits, which enabled them to:
DATA | CASE STUDY
Build an Enterprise Data Warehouse for Self-Service Analytics
COMPANY OVERVIEW
A multinational personal care company operating in 120 countries and regions around the world, producing cosmetics, fragrances, and hair & skin care products.
BUSINESS NEED
With the existing architecture and multiple siloed data marts, the client was not able to provide complete, accurate and timely business insights to stakeholders across functional areas. They were also dealing with multiple reporting platforms inherited due to acquisitions, making it tough for the IT team to provide timely support. The client needed to design a high performing central data repository that would be open to future integrations and drive self-service analytics through an enterprise-level analytics platform.
SOLUTION
The Ironside Information Management team designed and implemented an enterprise data warehouse from multiple source systems to integrate cross functional and brand data across the Americas region. The solution included:
Assess the Architecture
Discovery & Analysis
Design & Develop
Mentor & Collaborate
KEYS TO SUCCESS
With the new data warehouse implementation, the client achieved the following benefits:
“We can easily write automated reports without any help from IT teams, and we trust the data too.”
“Earlier my month end report took over 3 hours, but with the new data warehouse it runs in under 15 minutes.”
DATA | CASE STUDY
Implement a Single View of the Customer
COMPANY OVERVIEW
A manufacturer of analog, mixed-signal and digital signal processing integrated circuits used to convert, condition and process real-world phenomena, such as light, sound, temperature, motion, and pressure into electrical signals.
BUSINESS NEED
The client wanted to move their externally managed customer master process to an in-house solution they could manage themselves. Their goal was to maintain their own single view of the customer solution mastering both account and contact entities and the relationship between the two. They needed greater control and flexibility around data quality, standardization and validation, along with the ability to better manage change and processing times. The client partnered with Ironside to develop the single view of the customer solution.
SOLUTION
Ironside’s Information Management practice was responsible for delivering the solution. The solution included building data cleansing, data standardization and data validation routines to prepare the data for matching and consolidation to ultimately master the data. This included validating and standardizing business and personal names, addresses, phone numbers, and email addresses. The data was enriched with different attributes to better define the address, and the account and contact entities.
Develop a Plan
Define the Data Sources
Formalize the Approach
Ensure Future Success
KEYS TO SUCCESS
By moving to an in-house master data management solution, the client is now able to:
About Pitney Bowes
Pitney Bowes (NYSE:PBI) is a global technology company powering billions of transactions – physical and digital – in the connected and borderless world of commerce. Clients around the world, including 90 percent of the Fortune 500, rely on products, solutions, services and data from Pitney Bowes in the areas of customer information management, location intelligence, customer engagement, shipping, mailing, and global ecommerce. And with the innovative Pitney Bowes Commerce Cloud, clients can access the broad range of Pitney Bowes solutions, analytics, and APIs to drive commerce.
DATA | CASE STUDY
Centralize End-to-End Enterprise Analytics for Fitness Club
COMPANY OVERVIEW
Major fitness club operator and franchisor that’s been expanding at high speed due to a strong business model and broad appeal—now with more than 1,200 locations and approximately 8.5 million members.
BUSINESS NEED
The company had low visibility into why their rapid growth was happening due to a siloed data infrastructure and informal, manual reporting processes. They needed to maximize the technologies they’d already invested in, build a strategy across all analytics focus areas, and free their Information Systems team to provide analytics value instead of administration.
SOLUTION
The Ironside Analytics Advisory team was asked to help. In doing so, we focused on the client’s core goal was of getting custody over their data and using the wealth of information available in order to make data-driven decisions company-wide. There were four steps to the process:
Define the Focal Points
Prepare the Data
Formalize the Approach
Implement Iteratively
KEYS TO SUCCESS
The client enjoyed many benefits, since Ironside enabled them to:
DATA | CASE STUDY
Modernize the Data Warehouse for Finance IT
COMPANY OVERVIEW
Leading investment advisory firm with more than 10,000 employees and greater than $1 billion in revenue—a major player in the financial services industry.
BUSINESS NEED
The client’s IT group struggled to keep their governance and planning efforts moving at the pace of business. They’d attempted to centralize their data sources and generate more actionable reporting, but their outdated infrastructure couldn’t meet increased information demands or integrate effectively with their BI reporting. To solve these issues, the client was tasked with moving their data warehouse to a more modern solution.
SOLUTION
The Ironside Information Management team worked hand-in-hand with the client’s database engineers to move the warehousing infrastructure out of the current obsolete environment to a more modern data warehouse. Our solution required us to:
Develop a Migration Plan
Document and Test
Consolidate
Reengineer
KEYS TO SUCCESS
The modernizing of the data warehouse has enabled the client to: