- Log in to post comments
Moving from Excel Spreadsheets to QlikView Dynamic Analysis Saves an estimated 300 to 400 hours a Week in Reporting Time
Radnor, PA - 13 July 2010- By replacing dependence on Excel reporting with a QlikView-driven Business Analysis Portal, QlikTech customer Dynamex, a leading provider of same-day delivery and logistics services in the United States and Canada, has substantially increased its business visibility while eliminating an estimated 300 to 400 hours weekly in reporting tasks. The portal solution, which consists of seven dashboards for sales, operations and accounting, was deployed to more than 300 users in only three months, integrating and analyzing several million rows of data from the company’s Oracle E-Business and Siebel CRM systems and an internally developed operational system based on Java, JSP and Oracle.
Dynamex serves a large customer base with a transaction volume of more than 40,000 orders per day. Using QlikView, the company moved from basing business reporting and analysis on summarized Excel spreadsheets to near real-time graphical data views. Information that once took up to a week to compile can be accessed with one click, and provides more business answers with intuitive data associations and drilldowns.
“We chose QlikView over Oracle BIEE and SAP Business Objects because of the great reviews from other users, its competitive pricing and the fact that QlikView is geared for business analysts instead of IT developers,” said Andrew Pardue, VP of Information Services at Dynamex. “It’s great for my department because our business analysts can design their own applications on the fly in QlikView with little or no IT involvement.”
The QlikView-driven Dynamex Business Analysis Portal features seven dashboards:
Sales Territory Portfolio Dashboard: Assists with managing sales territories by comparing sales productivity against budget. It also provides a review of sales for invoiced periods and compares sales across multiple periods.
Sales Incentive Dashboard: Assists with calculating monthly eligible incentive program payments for Dynamex sales professionals based on their assigned portfolio accounts with a breakdown of components and account detail as backup.
Customer Analysis Dashboard: Provides senior and branch managers with a quick glance of their top 25 customers, including revenue composition details. Shows sales trending over time and points out top performing customers, attrition and growth.
Fuel Surcharge (FSC) Dashboard: Provides actual fuel charges that are billed and paid to drivers. Drilldowns to branch and customer levels can be used to find errors in FSC billing and for tracking margin percentages. Data can be displayed for any period of time, such as for a specific day, month or multiple months.
Revenue and Settlement Dashboard: Shows trending for revenue, payments and margins. Data can be viewed for any period of time (years, quarters, months, weeks, days) by region, branch, customer group, account, driver and service type with or without fuel surcharge.
Revenue Stream Dashboard: Assists with monitoring revenue increases and decreases. Shows daily revenue, order and yield trends over a two-year period.
Customer Aging Dashboard: Provides quick, easy access to Accounts Receivable daily balances and daily balances and user notes for customers that have been escalated. Data can be viewed by branch total, customer aging or invoice aging.
Among advantages of creating the Business Analysis Portal in QlikView was that it had no requirement to build a data warehouse and could use existing security structure in applications and Microsoft Active Directory. Dashboards are accessed through Microsoft SharePoint according to an end user’s security permissions. Development started with replacing Excel reports that required the most manual effort, which freed up time to accelerate development of additional QlikView dashboards.
About Dynamex
Dynamex Inc. is the leading provider of same-day delivery and logistics services in the United States and Canada. Through its network of business centers, the Company provides same-day, on-demand, door-to-door delivery services utilizing its ground couriers. For many of its inter-city deliveries, the Company uses third party air or motor carriers in conjunction with its ground couriers to provide same-day service. In addition to on-demand delivery services, the Company offers local and regional distribution services, which encompass recurring, often daily, point-to-point deliveries or multiple destination deliveries that often require intermediate handling. The Company also offers fleet outsourcing services and provides its customers a fleet of dedicated delivery vehicles at single or multiple customer sites. For more information, please visit www.dynamex.com.
About QlikTech
QlikTech’s powerful, accessible business intelligence solution enables organizations to make better and faster decisions. Its QlikView product delivers enterprise-class analytics and search with the simplicity and ease of use of office productivity software. The in-memory associative search technology it pioneered makes calculations in real-time enabling business professionals to gain insight through intuitive data exploration. Unlike traditional business intelligence products, QlikView can deliver value in days or weeks rather than months, years, or not at all. It can be deployed on premise, in the cloud, or on a laptop or mobile device—from a single user to large global enterprises. QlikTech is headquartered in Radnor, Pennsylvania, with offices around the world and a network of over 1,100 partners to serve more than 13,000 customers in over 100 countries worldwide.
