Data visualization tool connects all pieces of the puzzle for Gibsons

3 mins to read

Gibsons is a 100-year-old manufacturer and distributor of more than 500 games, puzzles, cards and gifts. The company employs 20 people who support 1,500 brick and mortar retailers across the United Kingdom. Gibsons added Phocas, a data visualization tool to its tech stack and is reaping the benefits. Phocas has helped transform business processes, made it possible for non-technical people to review sales data and significantly decreased the time to produce reports.

Data visualization tool solves reporting challenges

According to independent research, Gibsons' products sell at nearly twice the rate of their key competitors, so identifying when, where and how to grow sales among its retail partners is critical to the company’s success. Gibsons has used AMSolve ERP software from Aspin Management Systems for over 20 years for order processing and stock control. To get data from the system, data was exported to Excel using a ‘difficult’ IQ report writer.

“We had big challenges on the reporting side with the standard reports and the report-writer that we were using,” says Geoff Lee, business development director at Gibsons. “Trying to find sales data that was spread out over different financial years or using the sales data to analyse customer performance of sales opportunities was not easy to do.”


Phocas works side by side with ERP system

After consulting with Aspin, Lee learned that Gibsons could add enhanced data analytics capabilities without implementing an entirely new ERP system.

“We consulted Aspin and they recommended Phocas Business Intelligence,” said Lee. “Rather than buying a whole big new system, we could add Phocas to the AMSolve package. With the two software systems working side-by-side, we get the best of both worlds. My first reaction when I saw it was ‘Amazing!’”

Implementing Phocas was completed by the end of August 2018. With a summertime year-end, one of the most significant tasks was to obtain calendar-year sales data which was spread across different financial years.

Lee added, “It was a complex job before we had Phocas, but now it is super-easy.”

Data visualization tool helps Gibsons transform business processes

Today, roughly half the company uses data visualization tool Phocas, including sales, accounts, operations and general management.

Phocas has helped transform business processes, made it possible for non-technical colleagues to review sales data and significantly decreased the time to produce reports.

“We used Phocas to transform our company budgeting methods, and improve our stock and sales forecasting system; two things that have really benefited us,” said Lee. “The salesforce also used to regularly request reports and sales data, but now it is all self-service. They can get anything they need when visiting customers without having to make requests of IT. Phocas pulls all the data from AMSolve and is easy to use for our entire team. In time alone, it’s been a big saving for us. It’s so easy to for our users, regardless of skill level to get the data they need to help them do their jobs and support our customers” said Lee.

The Gibsons team has especially appreciated the visual dashboard overviews, which makes it easy to identify missed sales opportunities, while the ability to import external data helps create a more complete picture of business operations.

“It doesn’t take long to recognize on the Phocas dashboards how many opportunities are being missed while pulling in external data such as retail sales which allows us to conduct more in-depth analysis of business-critical information,” said Lee.

Lee emphasized the relationship with Aspin and the ability to seamlessly integrate Phocas into its AMSolve software as keys to Gibsons' success with data analytics and visualizations. Lee highly recommends the software to others that are struggling to get access to their data and have bottlenecks in their reporting system.

“We are getting impossible data out of AMSolve because of Phocas,” said Lee. “We couldn’t do our budgeting or stock forecasting without Phocas, so would we recommend it to other companies? It’s a resounding yes from us.”

For more insight into the many uses of  data visualization tool,  Phocas you can download the mid-market executive KPIs eBook or click the button below.

Click here to download your Executive KPIs eBook



Top 7 KPIs and metrics for mid-market executives

Phocas Software

Download eBook

Fill out the form below to download the eBook.

Phocas Software

Let’s talk

Are you interested in becoming a Phocas partner?

Phocas Software

Contact us

Fill in the form below, and we will get back to you as soon as possible.

Phocas Software