Business Intelligence Consulting - Analysis Team, Inc.

For quick service restaurant chain Papa John’s International, speed to customer and overall customer satisfaction are imperative to success. Papa John’s consistent top ratings in product quality and customer satisfaction were key factors in their growing to nearly 3000 locations. Their legacy system, however, was not positioned to handle this growth.

Papa John’s needed the ability to process voluminous data to analyze store results quickly, with maximum flexibility and ease of use. Analysis Team developed a fully automated Business Intelligence Solution that:

on prior day’s operations from several hours to 15 minutes.

such as a 10% reduction in “out the door” time, and a significant improvement in order completeness.

with a user-friendly interface. This enabled a variety of users, from individual franchisees to corporate management, across several functional areas, to gain access to key performance metrics and easily customize reports to most effectively manage their business.

with no performance degradation.

as Analysis Team provided comprehensive knowledge transfer and training

For specialty retailer Restoration Hardware, changing trends and geographical variances in product preferences make timely access to sales and operational information key to doing business. Daily metrics shape management decisions that have a significant influence on the bottom line. However, Restoration Hardware had a very manual, time-consuming process to generate and deliver key reports to management. Supporting 104 stores in two countries and with continuous new store openings, their system could not keep up with the pace of business, significantly hindering timely decision making.

Restoration Hardware needed the ability to quickly generate “flash” (daily at-a-glance) reports with sales, customer traffic, order and inventory information, with maximum flexibility and ease of use. Analysis Team developed highly automated Business Intelligence solutions that:

from a manual process requiring up to four hours each business day for data gathering, formatting and distribution to an automatic 10-minute process resulting in an email delivered before managers arrive to work each day.

from a cumbersome process yielding data-poor reports weekly to an automated solution delivering data-rich reports daily.

such as saving 1000 man-hours annually for report generation.

that increase sales and reduce inventory and operating costs.

previously not available.

Allow Restoration Hardware’s IT staff to add and modify performance measures, given the solution’s extensible design and complete knowledge transfer provided by Analysis Team.

As the leading global manufacturer of hard disc drives, Seagate needed an effective strategy and formal system to assess and prioritize reporting and analysis needs. With nearly $10 billion in revenues from hard drives that support the full spectrum of computer and consumer electronics applications, Seagate has a complex operation with significant analysis requirements. Seagate’s Global Channel Sales and Corporate Marketing (GCS&CM) operates as multiple independent and geographically disperse departments, and comprises the principal users of this information. Global Planning and Operations (GPO), the group that provides analysis and reporting support to GCS&CM, was inundated with requests. Scattered employees worldwide and fragmented data sources crippled their ability to deliver business-critical information.

Seagate engaged Analysis Team to develop a strategy to address their reporting and analysis issues. Analysis Team employed a highly structured process to create a roadmap to evaluate and prioritize reporting and analysis needs on-going. The benefits have been substantial:

on top priority, high-impact projects.

of critical information projects.

based on a 75% reduction in man-hours required to pull data and produce reports.

in reports, due to the development of a single platform for sourcing data and defining reporting terminology.

to delivering vital reports and key metrics.

of the roadmap among GPO and its internal customers, generating organizational alignment.

due to alignment in prioritization methodology.

For Toyota Motor Sales USA, dealership performance analysis is critical to growing the bottom line, given fluctuating market forces, complex pricing models and significant movement of high-ticket inventory. An antiquated legacy system and labor-intensive, paper-heavy processes were greatly hindering access to data and reporting, however. With 1200 Toyota and 200 Lexus dealerships in the continental U.S. accounting for about two-thirds of Toyota Motor Corporation’s total worldwide revenue, implications were significant.

Analysis Team delivered a completely automated, robust Business Intelligence solution in less than half the time and for one-sixth of the cost originally projected internally by Toyota, delivering huge on-going benefits.

for all users to comprehensive dealer performance information and elimination of highly manual processes.

Mainframe printers used only for printing financial statements were retired.

Labor and administrative costs associated with headquarters staff
processing, printing and mailing ad hoc reports were virtually eliminated.

Time savings and productivity increase that enabled headcount redeployment of 2 full-time headquarters employees, and an estimated
savings of 2 person-days per month in each of 16 regional offices (approximately 1.5 “full-time equivalent” staff).

resulting from leveraging analytical capabilities of the application.

This fosters fact-based decision making company-wide and frees up staff to focus on driving growth, rather than collecting and re-keying information.

reducing time and errors.

(legacy mainframe system had continuous data reliability issues).

to meet evolving business needs.

by Toyota’s Information Systems department for maintenance.

With 20 massive retail stores selling more than 400,000 SKUs and handling over 7 million customer transactions annually, premier entertainment specialty retailer Virgin Megastore generates huge amounts of data. This creates an essential need for actionable, timely information in order to manage the business effectively. Nonetheless, Virgin was severely handicapped by a system that didn’t deliver.

Analysis Team developed a Data Warehouse and Business Intelligence solution that led to increases of $1.7 million in earnings and $500,000 in profit in the first four months, translating into annualized increases of $5 million in earnings and $1.5 million in profit. This sizable, quick return on investment was directly attributed to the new system: