The Challenge

Heller Tasty is a firm favourite across New Zealand dinner tables, producing up to 240 tonnes of sausages a week, along with ham, bacon and other small deli goods.  The sales task to get their products to our plates involves over 26,000 invoice transactions a week. Such large volumes compounded obvious failings with Heller Tasty's existing sales reporting systems.

Access to data was difficult through a number of disjointed and disparate reporting structures. Data took days to run. There was no centralised framework and very few tools to use the information meaningfully.

"We had a number of issues around reporting from performance to access. Too many systems, too single dimensional in what they could do, and a lack of flexibility within the many frameworks we were using meant we were getting very little business value out of the information. Our goal was to achieve a centralised and very rich reporting environment that could let us take our analysis to a much higher level." Trish Jenkins, IT Manager, Heller Tasty.

Slicing and Dicing Data like Never Before

SQL Server 2005 sets the benchmark for database analysis and could offer Heller Tasty considerable improvements in areas such as report design, analysis, processing and interactivity.

Using the SQL Server 2005 suite of products, Intergen was able to bring Heller's sales data to a centralised Reporting Server platform. It immediately opened up many dimensions within their reporting environment. Reports that took days now took minutes.

As a web interface the reporting server is easy to use, intuitive and interactive for general users to drill up and down, yet with the functionality for experienced users to adapt it for specialized adhoc reporting and analysis. Faster and more accurate retrieval of information means Heller Tasty can analyse brands, trends, regions, reps, down to the latest sales dollars and kilos.

The Business Difference

"It has bought a new dimension to our sales knowledge and that's simply good business, giving us better data to control our contribution margins, customer discounts and sales processes." Trish Jenkins

Heller Tasty sees a big future with extending their SQL Server solution across other areas of their business. They aim to bring historical sales data onto the platform, use it to extend into budgeting and purchasing areas and to enhance and manage customer requirements and relationships.

Heller Tasty say they have valued the way Intergen hasn't stopped at providing just a solution, but continues to help them find new opportunities to put their platform to work.

www.heller.co.nz