Key Highlights Of The Rl Polk Case Study
This year marks the 131st year of operation for R. L. Polk & Co., a premier provider of automotive information solution services to corporations worldwide. A privately held company founded in 1870, Polk is the oldest consumer marketing information company in America, and employs approximately 1,400 people in offices and production facilities throughout the world.
While Polk offers automotive information solutions that can be found nowhere else, innovations and technical proficiency before anyone else and diagnostic savvy that is unparalleled in the industry, perhaps the greatest benefit of operating as a global company is the experience that it affords – our clients reap the benefits of our global knowledge in the design of their automotive information systems. We are time-tested, knowledge rich and adept at delivering a world-class product on time, and within budget.
Accurate Market Information for Ford
Buying data as a product can be a hit-and-miss affair. In no other industry would a client purchase a commodity when it was unsure of the overall quality. After all, we’ve all been the victim of database mistakes, and many of us will have bought in sales or marketing data and found it to be substantially less than accurate.
But data is the basis upon which multi-million pound decisions are made: Do we open a factory in the Midlands? Will consumers buy this product? Is there a gap in the market? Should we make this acquisition? All of this needs evidence – but if this is unreliable, or only represents a partial view, then the potential for mistakes is greatly increased.
In the automotive industry, information is crucial. The market is highly competitive, so the failure to spot an opening, react to a trend or incorrect pricing a car can mean losing money, sales, and market share.
Put it in gear
Polk is the global leader in providing information to the automotive industry. Worldwide it deals essentially with all the major motor manufacturers. It provides management and geographical information systems to Putting Data in the driving seat ? Polk Head quarter in Detriot Case Study Polk Automotive Intelligence Headquarters: Southfield, Michigan, USA Core business: Polk is the global leader in providing information to the automotive industry. Worldwide it deals with all the major motor manufacturers Business need: the ability to add value to incoming customer information by verifying and validating data sets received from clients and linking disparate data together Technology solution: Ascential Software’s DataStage to move data around the corporate databases and store in one central repository, to allow easy processing of data from all European systems Results: Facility for more complex analysis for reporting High levels of data quality are maintained Maximizing use of all corporate and customer data Data sets from a variety of sources are constantly added to and updated, to maintain market share. The Ford Motor Company in 15 European countries, including Britain, France, Germany, Spain and Italy.
Polk has always maintained market share through the rigorous quality control it exercises on the information it provides. In order to create the information systems it offers, however, it is necessary to constantly update and add to the data sets it has access to. When you consider that up to twelve data sets need to be integrated for some clients, the potential compatibility and quality concerns become apparent.
Each incoming data set is essentially a ‘snapshot’ in time of a transaction database. In the UK, these operational data sets include, among others, The Society of Motor Manufacturer and Traders registration information, Driver Vehicle Licensing Agency data, territory data supplied by Ford and Ford sales data – and equivalent data sets are provided throughout Europe.
The information provided is mission critical to the organisations that subscribe to it. Ford would typically use it to support decisions such as how to plan forecourts, identify how and where to market vehicles, where to open showrooms etc. The increasing volume and number of information sources that Polk has to deal with, however, means that data quality is highly variable. Not only does it change between suppliers of equivalent data sets, but it also varies in time.
The problem that faced Polk essentially revolved around the company’s ability to add value to incoming data by verifying and validating all the records, and linking disparate data sets together to create a warehouse – which in turn would become the source for the GIS and MIS systems.
First off the block
Polk first attempted to solve this problem by focusing specifically on the Ford UK system requirements. Data management and migration specialist, DOT Group, was chosen as the implementation partner to develop a joint deployment strategy. DOT was chosen for its ability to ensure the project was delivered on time and on budget, as well as its commitment to working closely with Polk, as an integrated part of the team.
The first approach to solving the problem was to design a database to enable the evaluation of data integrity via the use of constraints and other relational tools. Normalizing the data in this way allows many potential errors to be highlighted directly by the database management system.
Once the schema was established, the next step was to build ‘wrapper programmes’. These are designed for two main purposes: the first is to effectively move the data into areas of the database that are optimized for pre-defined selects. The second to provide centralised controlled points where new business rules can be added as they are discovered.
The obvious area to look was in the Extract Transformation Load (ETL) arena. After evaluating several vendors’ products it was decided that DataStage, from Ascential Software, best met Polk and Ford’s requirements.
Using DataStage to provide the ‘wrapper’ around data movements enabled the bulk batch processes of Polk’s European systems to be automated. By developing the front-end in Java, all interfaces could be accessed from anywhere on the Polk intranet. This also provides the option to open up various functions and services to clients, if required in the future.
“The initial aim was to use DataStage to transform and load incoming data into our normalized databases, which it did very well,” said James Ricketts of Polk. “As the project progressed, however, more requirements began to appear which related to reporting on the data. In order to satisfy the growing demand for this type of information, we devised a data mart strategy centered on DataStage’s ability to extract, transform and load. This capability gave us the power and flexibility to build ever more complex analysis and presentation styles for our reporting – instantly creating what is now a rapidly expanding area of our business.”
There’s always a risk in integrating new technology into a business, but Polk’s relationship with DOT and Ascential proved adept at ensuring the smooth training, development and deployment of the system.
“The successful implementation of Ascential’s DataStage has enabled us to consider a whole new dimension in how to deploy and use our data,” Tony Ward- Polk IT Manager.
Quality techniques and tools help lower the costs of people-intensive service processes and improve customer satisfaction. A process approach enables service organizations to standardize the ways they work, achieving improved consistency, faster cycle times and fewer errors. And employees are empowered to provide individualized customer service when it counts most.
Innovating Social Media Marketing Strategy via TRIZ
Using TRIZ, a marketing team created a social media marketing strategy for electric folding bicycles. Their goal was to generate 100,000 social media followers. After defining the target, the team analyzed their system through a combination of the nine windows tool and TRIZ’s basic principles. This provided the team a detailed picture of the project and thus, following different standardized steps, to come up with several different innovative ideas for the social media strategy. Download Innovating Social Media Marketing Strategy via TRIZ (PDF). November 2017
Ideality: The Pinnacle of Quality and Competition
For any given contradiction, TRIZ has a solution for improving the process by making changes to a process step. Within TRIZ lies a concept called ideality, or the ideal state of a system where all functions are achieved without problem. In this case study, the author explains how ideality can be achieved using real-life examples. Read the online case study presentation or download Ideality: The Pinnacle of Quality and Competition (PDF). July 2016
Faster Lean and Six Sigma Project Completion via TRIZ
Lean Six Sigma (LSS) problem solving consumes a lot of effort in identifying the root cause and involves a trial and error method for confirming significant factors. For any given contradiction, TRIZ has a solution for improving the process by making changes to a process step. Combining TRIZ and LSS through a structured approach can help reduce the effort and duration of LSS projects by nearly 10 times. Read the online case study presentation or download Faster Lean and Six Sigma Project Completion via TRIZ (PDF). March 2016
YMCA Upgrades Day Camps Using Six Sigma
When a senior leader at the YMCA of the USA introduced Six Sigma to the youth development department, a new method for managing and tracking projects was ushered into the organization. Upon completing a Green Belt-level training course, a YMCA project team used Six Sigma tools to improve the culture of the organization’s summer day camp. As staff became more comfortable using Six Sigma, project work became more organized and data-driven, and the project team exceeded its first-year goals. Read the online case study presentation or download YMCA Upgrades Day Campus Using Six Sigma (PDF). January 2016
Indian 5-Star Hotel Front-Line Staff Find Happiness, Empowerment in Solving Attrition Problem
Muri, a Japanese term that means stress, exists throughout organizations, and the elimination of it plays a crucial role in its growth and sustainability. While the hotel industry is growing at a very fast rate in India and other parts of the world, attrition has become a very big problem, one of the primary reasons being work stress. This article discusses the techniques that were used to understand the root causes of stress, to quantify it, and arrive at solutions for a popular Indian hotel chain that will remain anonymous. Read the online case study presentation or download Indian 5-Star Hotel Front-Line Staff Find Happiness, Empowerment in Solving Attrition Problem (PDF). August 2015
Forensic Techniques Reveal Conclusive Evidence in West African Pipeline Construction Dispute
Forensic intelligence and forensic interviews can be used to assess the level of compliance and effectiveness of a project’s quality management system (QMS). In this case study, the extent of a contractor’s implementation of the project’s QMS, created for the engineering, procurement, and construction of a pipeline in West Africa, was disputed between the contractor and the project owner/client. To assess the effectiveness of the project’s QMS, data collection through forensic intelligence and forensic interviews was conducted to assist in resolving the dispute. October 2014
Six Sigma Optimization of Mystery Shopping
Mystery shopping (MS) can be a very valuable exercise for studying and evaluating service delivery performance within the banking industry. Using Six Sigma tools and hypothetical data, this case study tests the approach and results to gauge poor service from excellent service delivery. The MS approach is highly applicable as a balanced scorecard parameter to measure delivery within service centers. September 2014
Origami Lean Training Exercise
Providing hands-on experiences to students is essential for lean workshops. Origami, the Japanese art of paper folding, can be used to provide students with a hands-on experience for understanding process thinking and process steps. The activity can be effective at conveying quality tools and concepts for all age groups. August 2014
India-based Life Insurer Improves Customer Retention Through Six Sigma, Quality Tools
Recognizing the company’s customer retention rate dipped below acceptable levels, Max Life Insurance Company leaders initiated improvement project Unnati to reclaim deeply lapsed policyholders. Using Six Sigma and quality tools, team members identified more than one dozen possible opportunities for agents to improve customer relationships, tripling the retention rate and generating millions in revenue. May 2014
New Zealand Port Company Stems Tide of Overdue IT Tickets
The Ports of Auckland aimed to reduce the number of IT call tickets that are not completed within agreed-upon timeframes. The organization initiated a Six Sigma project using tools to improve customer service, communication, and prioritization. As a result, the project realized a 50 percent reduction in past-due IT tickets during a sustained period. See an executive summary of the case study, or download New Zealand Port Company Stems Tide of Overdue IT Tickets (PDF, 219 KB). January 2014
Lean Six Sigma Increases Efficiency for Financial Services Firm (PDF, 457 KB)
A fund services organization used a Lean Six Sigma approach that featured kaizen events to enhance process control and increase capacity. In just four months, nine quick-fix projects achieved savings of $220,000, paving the way for larger strategic improvements. April 2012
A Broader View of Quality Through Certification (PDF, 561 KB)
Nancy Garcia, a senior engineering support technician for InfinityQS, is an ASQ Certified Quality Engineer and Certified Software Quality Engineer. Not only did Garcia gain confidence from ASQ Certification, she also developed deeper insight into the quality field. September 2011
Supporting Customers and Driving Excellence Through Quality (PDF, 703 KB)
A Firstsource Solutions team used Six Sigma to improve its processes for handling inbound customer service calls for a client’s new business, lowering the repeat call rate from 15 percent to 9.6 percent. May 2011
Reducing Check Returns With Six Sigma (PDF, 681 KB)
A Firstsource Advantage cross-functional team used Six Sigma to reduce the check return rate for a top client by more than 20 percent over a six-month period. April 2011
Service Provider Improves Client's Metrics With Six Sigma (PDF, 480 KB)
Firstsource Solutions used Six Sigma to reduce a retail mortgage client's turnaround time to approve applications, boosting the client's revenue by 6.9 million pounds. April 2011
Solid Commitment to People Is Main Ingredient for Texas Restaurant Excellence (PDF, 275 KB)
In 2010, K&N Management became the second food service recipient of the Malcolm Baldrige National Quality Award and the first restaurant group ever to receive the Texas Award for Performance Excellence. March 2011
No Evil Lasts More Than 96 Hours (PDF, 342 KB)