Cognos Analytic Applications Celebrate
Success at KORBEL CHAMPAGNE CELLARS
Company Overview
Established in 1882, by Francis Korbel and his two
brothers, Korbel Champagne Cellars has been a part
of America’s great celebrations for more than 120
years. It has been the exclusive champagne the past
five presidential inaugurations and was the
champagne of choice for the Camelot years of the
Kennedy administration.
Korbel’s vineyards are located in Sonoma Valley,
California on lands that were purchased in the early
1870’s by the Korbel brothers. Some of the original
grapevines are still located on the property and
continue to produce grapes for select champagnes.
In 1954, the Korbel decendants decided to sell the
winery business to Adolf Heck, under the agreement
that the Korbel name would live forever and be
operated as a family business. The Heck family still
owns and operates the business.
The main product lines that are sold by Korbel are
champagnes, wines and brandies. These products are
sold both domestically and internationally.
The Korbel management generated sales reports in
Cognos from an in-house developed data mart created
from their legacy Enterprise Resource Planning (ERP) system. The process was not
efficient and lent itself to inaccuracies with many
data integrity issues. The confidence level that
management had in the data was very low. Managers
needed accurate figures to run the business
properly.
Challenges Faced
The Solution
In 2002, Korbel purchased the
Cognos Sales
Analytic Application and engaged
CD Group to assist
in the implementation. The first step was to conduct
a business requirements review to acquire a thorough
understanding of Korbel’s business process. CD Group
also analyzed the reports that the firm was
producing and the sources of this data. Korbel's Applications Manager was
instrumental in bringing the various segments
together.
Once a detailed view of the business and the key
metrics
that the business leaders needed had been
established, the team moved forward with setting up
the sales data mart and designing the cubes.
Benefits Realized
With the ability to view the data in a
pre-defined format with PowerPlay, Korbel is able to
spot data inconsistencies very quickly. Action is
taken quickly to correct the data. As a result, the
source ERP system has better data integrity.
Managers now have reliable data on a daily basis
and do not have to wait to make business decisions.
Click Here
to Download a PDF of this Success Story |
Terms
of Use
