Qlik > Case Studies > QlikView Transforms Avnet’s Sales Effort

QlikView Transforms Avnet’s Sales Effort

Company Size

1,000+

Region

Pacific

Country

Australia

Product

QlikView

Tech Stack

JIWA

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Productivity Improvements

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Electronics

Applicable Functions

Business Operation
Sales & Marketing

Use Cases

Predictive Maintenance
Supply Chain Visibility

Services

Data Science Services

About The Customer

Avnet Technology Solutions is an operating group of Avnet, Inc., representing US$17.95 billion in annual revenue for fiscal year 2008, with locations in more than 30 countries. As a global technology sales and marketing organisation, Avnet Technology Solutions has sales divisions focused on specific customer segments and a select line card strategy enabling an exceptional level of attention to the needs of its customers and suppliers. Avnet Technology Solutions Australia has 100 employees that work to deliver IT solutions and infrastructures that companies rely on, including designing, configuring, marketing and selling solutions that involve capabilities in storage, servers, monitors, networking, security, software and services. Avnet has global relationships with the world’s leading technology suppliers, including HP, IBM, Juniper, Websense and Avaya to name but a few. Within Australia, Avnet Technology Solutions serves over 700 business partners, and has industry leading relationships with 20 suppliers.

The Challenge

Avnet Technology Solutions, a global technology sales and marketing organisation, was struggling with the aggregation of transactional data from their ERP system. They needed greater insight into customer, sales, channel, inventory, supplier and delivery performance data. The IT department was overwhelmed with numerous sales report requests each week, which were time-consuming and resulted in duplication of effort. The company needed a management and sales focus on profitability and accountability of the numbers to operate dynamically.

The Solution

Avnet undertook a market review of business intelligence solutions to determine the best fit for their business. They chose QlikView due to its fast development cycle, easy to use interface and 'drop-in' deployment for initial rollout and future upgrades. QlikView was implemented without any formal training, testament to its ease of use. The solution was widely embraced by the organisation and immediately became a natural part of the business, now used by 64 employees across sales, marketing, operations and management teams. QlikView is used as the strategic sales analysis tool for the business to ensure key revenue and gross margin targets are achieved for individual suppliers, their products and by sales and brand teams. Management uses QlikView to keep on top of the numbers, for business forecasting and future strategy setting.

Operational Impact

QlikView provides Avnet with a greater depth of insight from its data to manage its business more efficiently, with a self-serve capability that highlights areas that require more focus and attention.
QlikView’s data model is easily configurable and maintainable. Incorporating any changes or new requests to management reporting can now be done in hours or minutes – rather than days, without incurring report rebuild times or overhead.
QlikView has also proved to be extremely useful to pre-empt order and inventory glitches by enabling 100% checks on all data. QlikView has reduced data entry errors almost 3 fold since its introduction.
QlikView captures changes in delivery and availability and provides an automated order process status, which helps customer service sort out any orders trapped in the system. Its ability to adapt to the needs of different users, with limitless filtering and complete visibility has proved invaluable.

Quantitative Benefit