"Worldwide Express is a global logistics company based in Dallas that has handled millions of package and freight shipments for 30,000 small and midsize business customers. With more than 150 franchises across the country, Worldwide Express is one of the largest authorized resellers of express shipping for United Parcel Service (UPS). More than 10,000 customers trust Worldwide Express with freight shipments through 30 carriers."
Before Zoho Reports, Worldwide Express was using a combination of a proprietary system and Microsoft Access for all its reporting needs. The system started showing strains, as the data kept on growing closer to 100 million rows. Also, using this system meant the Business Analytics department of Worldwide Express needed lots of development hours to generate the reports each month. Making these reports reach the intended users (evergrowing Worldwide Express employees and clients) in a user-friendly fashion was a big challenge too, as there was no easy way to share the reports, other than generating user-specific reports and emailing them as attachments.
Says Amy Milligan, VP of Marketing & Business Analytics, "We use our proprietary systems as well as Microsoft Access, for our reporting needs. Our proprietary systems are very complex and require development hours for reporting. Our intention is to get more data to our users in a user-friendly environment for filtering, etc. We have simply outgrown this system (the reporting we conduct on Microsoft Access, in conjunction with our proprietary system) both for transaction level, as well as the number of employees who need to be engaged in reporting."
Milligan started collecting recommendations from others and researched online for alternative solutions to their current reporting environment. That is when she discovered Zoho Reports. She chose Zoho Reports because of the interface and the robust features it offered, for handling the huge volumes of data quickly and efficiently. Zoho Reports also allowed her to carry out quick and efficient changes of data and reports, through the GUI.
Worldwide Express is currently using Zoho Reports for its financial partners who need user-friendly access to large volumes of data. It now has around 100 million rows of data in Zoho Reports, and the number of rows are growing every month. And Milligan says she is "building out the infrastructure needed to support more robust weekly, monthly, quarterly, and annual reporting, as well as ad hoc reporting for our corporate level analysis, sales contests, and our franchise system reporting as a whole."
The Business - Worldwide Express
Find a reporting tool that scales well and will report on big data (over 100 million rows)
The reporting tool should be user-friendly
The reporting tool should reach as many end users as possible
The Solution - Zoho Reports
A reporting solution that handles over 100 million rows with acceptable latency
The solution being web-based, is accessible by end users anytime, anywhere
The solution is user-friendly and reaches more end users than before
Milligan adds, "While the process has involved challenges, I have found the Zoho team so very helpful. I can tell that Zoho has taken measures to accomplish our goals – building out their systems and processes to accommodate us as their customer. And, most importantly, that Zoho views those measures as an investment, not only in partnership with us, but also as an investment for their systems and for their entire customer base. For that approach and the level of service, we are very grateful."
Benefits & Results
By going with Zoho Reports, Worldwide Express now enjoys the below benefits:
- Scalable system to easily analyze & report on over 100 million (and growing) rows of realtime data
- Quick and effortless deployment of the reporting solution
- Fast access times for any type of report or filtered data
- Easy sharing of data and reports to its employees and customers, over the web
- Increased user adoption as the end users can now easily click on a URL and view a report, anytime, anywhere
- Easy quality control and review of data
- Soft dollar savings as of now, with projections indicating high actual dollar savings going forward
Milligan has envisioned a larger plan for Zoho Reports usage, and has been engaged in using Zoho Reports for several months on a initial scoped data set before expanding it further. "To see our project and infrastructure coming to fruition with live data is very exciting for us. We are a few key steps away before completely transitioning away from Microsoft Access to Zoho Reports", she concludes.