Integration of financial and operational data aids all teams in monitoring specific KPIs

Johnstone Supply – Kenilworth Group finds greater flexibility, visibility and support in Phocas

Having a pulse on everything that is going on across sales, inventory, accounting and warehousing is critical to a growing and connected company. The ability to use data to answer questions about virtually every aspect of operations helps maintain a big picture view of the business and eliminates the gut feel out of decision-making.

Before BI: cumbersome, rigid and limited

Johnstone values its business data and has done a lot of reporting using its Epicor Eclipse ERP system. 

The company ran into challenges, however, with its old business intelligence (BI) software because of how cumbersome it was to find and pull information.

The dashboards were rigid, the drill downs the company could use already limited Johnstone, and drilling into company data required the creation of multiple reports.

“The biggest issues were the tool was not user friendly, not flexible enough to respond to our users’ needs and the data was not actionable. We wanted to dig into our information in a certain way, but we were limited by what we could see and how deep we could go said Timothy Janes, operations specialist for Johnstone Supply NJ ” 

Janes also struggled with the previous BI’s customer and product support.

“Either they would get back to us quickly with a less than optimal solution, or they simply would not follow through,” added Janes. “Sometimes we would present a great idea, and they would say that we’ll work on that, but we would never see anything develop. ” 

After reviewing other BI solutions, Janes replaced the old BI software with Phocas, an intuitive data analytics solution that integrates seamlessly with Eclipse.

Showing the value of BI

Since deploying Phocas, Johnstone has integrated sales, inventory, accounting and warehousing information into Phocas, which now serves as a single source of truth for operations and other departments.

“Operations has its hands in most parts of the business, so we need a big picture view,” said Janes. “Phocas offers that, and it’s so intuitive that it has driven adoption for reporting and dashboards for other areas of our business, which allows our non-technical users to slice and dice any which way they want to see exactly what they want. With Phocas, we can easily show the real value of business intelligence.”

Greater visibility into customer data

Phocas is helping departments develop their own scorecards and dashboards, while providing more visibility into customers’ businesses so sales can see how to best offer Johnstone’s solutions to help them succeed.

Additionally on the warehousing side, Johnstone’s operations team can now track efficiency metrics they didn’t have visibility into prior. This allows them to track the performance of their warehouses while performing all essential functions.

“Phocas allows us to slice and dice at will. The ability to focus on one entity, product or customer with a single click, and then watch the entire dashboard update is huge for us.”

“As an everyday user, I can do a million things with Phocas, and also share dashboards and reports quickly and easily by sending external links to branch managers, outside sales teams, sales support or managers. All of these team members have visibility into things that their customers are doing that they couldn’t see prior to Phocas,” said Janes.