Company’s Challenges Before Implementing Business Intelligence

By Johnny Nugent

A $30 million manufacturing enterprise customer providing systems and components to the telecommunications industry was struggling with analyzing its own effectiveness as a business.  The Company, through the implementation of key performance indicators (KPI’s), wanted to be able to measure its cash management and margins in two product areas.  Specifically, the Company was interested in low-volume and engineering-intensive project orders and high-volume, repetitive sales.

Challenges Faced by the Company:

  • Unclear cash flow
  • Absence of method to perform margin analysis
  • Financials on decentralized spreadsheets
  • Inconsistent/inaccurate reports
  • Delayed data reporting/data reported was static
  • Lost confidence in reports
  • Increased manpower to resolve reports

Visibility recommended that the company utilize key performance indicators to measure the health of their business. Implementing key performance indicators has the measurable benefits of streamlining operations, improving customer satisfaction, increasing revenues, and reducing costs to name a few. These measurements derive from the Company’s data and can be beneficial when that data can be easily accessed and presented in readable, user-friendly reports.

Too often, the information that companies believe to be indicative of their business health is contained in spreadsheets that reside with various individual users. Hence, the information system itself (or lack of such a system) is viewed as a barrier to uncovering and consolidating the wealth of information created and controlled by different users.   


Visibility’s Solutions to the Company’s Challenges

The strengths of Business Intelligence tools are their ease of use, flexibility, and ability to provide consolidated reports of data. Visibility’s data cubes in the areas of sales, accounts receivable, and accounts payable assisted the Company in measuring its key performance indicators (specifically, analyzing its cash flow and margin analysis for project orders and volume sales). 

Using data cubes to analyze data in the system revealed that the margin on project orders was far greater than that on the volume sales. Valuable monetary and human resources were being utilized to support a line of business that was costing the Company far more money than the margin could realistically support. had been the central repository for this data all along.

Connecting Visibility’s Business Intelligence data cubes to the information contained in the ERP system maximized the Company's return on investment by providing the Company’s management team with the reports and knowledge they needed to develop a strategy for advancing their highly profitable project orders line of business and modifying their low margin volume sales line of business.

Visibility Business Intelligence solutions for finance, sales, purchasing, projects, inventory, labor, and work-in-progress/capacity planning are currently available.

Interested in learning more about Visibility's ERP solution? Check out our site or contact us. You can reach us online or give us a call at 978-269-6500. 

Topics: Business Intelligence

Recent Posts

Preparing for a Winter of Prosperity and Positivity

read more

How to Connect with Customers During COVID-19

read more

The Impact of COVID-19 on SaaS

read more