Case Study 5

Perhaps A Fully Comprehensive Business Intelligence (BI) Solution Would Serve You Best.

What is business intelligence (BI)?

BI, or business analytics, refers to the wide variety of software applications designed to measure and analyse essential figures drawn from every aspect of your business.

Getting down to nitty gritty, ETL (Extract, Transform and Load) activities are used to transform raw data into a format which can then be loaded into more easily readable formats such as hierarchical tables, balanced scorecards and dashboards, each allowing the user to drill down into those valuable details.

Result? Pushing a few buttons on your computer allows clear identification of your firm’s strengths and weaknesses in key areas of sales, service, stock, staff performance, supplier cost, customer priority and marketing return

What business intelligence is NOT

BI is not reserved for the rich, the famous, the IT geeks and the major corporations with their large staff and customer base.

The software powering business metrics is now so advanced that even the smallest of SMEs can benefit from deep analysis of their figures and greater staff engagement in the business process.

What can business intelligence do for you?
“What gets measured gets improved.”
Peter Drucker

Business information systems can power up your company, firing its motor in areas which might have been dormant for years. If you measure it, you know how well your business is really doing. And if you automate it, you cut out a long, arduous string of old and faulty business processes which chew up your time, money and man-hours.

That’s what BI is all about. Don’t be blinded by tech-talk, and put off by systems you think you will never be able to understand.

Smoothstream Business Intelligence is here to do the hard yards so you can benefit from smart, intuitive and sophisticated business intelligence tools requiring only a basic knowledge of computer operation.

A bespoke SBI metrics solution is entirely self-contained.

It’s what you might call invisible beauty – a massive intelligence whirring away beneath the surface, taking care of all the systems, processes, calculations, valuations, formulas and configurations you and your staff used to have to work out manually – at much personal cost in terms of stress, errors and often having to do the whole darned thing again.

It’s all about strategy. SBI is aimed at revealing emerging trends in your business – promising ones to pounce on and ugly ones to knock on the head. Well implemented BI can:

  • Categorise client behaviour, aiding cross-selling and up-selling.
  • Identify key customer and product metrics enabling you to redistribute staff and resources.
  • Track performance by geographic area.
  • Monitor advertising and promotions performance so you know what’s working.
  • Apply and measure Distributor and Franchisees KPIs.
  • Determine employee strengths and weaknesses.
  • Allow unskilled workers to generate comprehensive reports at the touch of a button.
  • Help you make business decisions based on cold, hard fact rather than anecdote or assumption.

Many businesses have been radically transformed in terms of boosted revenue, profits and staff engagement through the introduction of clever business intelligence software.

Read on to find out what SBI can do for a struggling company.

Case Study


  • Problem:Much time and resources were wasted on targeting unmotivated clients and poor service areas, using staff whose performance was not being monitored.
  • Solution: SBIcustomised a system which allotted A, B or C rankings to clients, employees, geographic area and profitability.

    ‘A’ clients and staff were rewarded and encouraged. ‘B’ grades received extra attention and support, while ‘C’ grades were dropped, moved on or retrained. A, B or C rankings showed which geographic areas were the most productive.
  • Outcome: FTE head count was reduced by two. Three unprofitable services were dropped, and seven geographic areas were condensed into three. A 12-month review revealed profits up by 18.7% and greatly increased employee contribution.
Case Study


  • Problem: 62% of the produce of two retail bread and cake outlets ended up being given away or destroyed.
  • Solution: SBI extracted and analysed figures from newly computerised tills, and established a PC program quantifying sales of each individual product by price, product category, day of the week and calendar season. This enabled product to be tailored more closely to demand.
  • Outcome:After only eight months, average wastage was reduced to 46%, with future trends anticipated to reduce this figure further. Despite occasional missed custom due to lines being out of stock, business profitability overall was substantially increased.
Case Study


  • Problem:With many off-the-shelf software systems scattered throughout the company, there wasn’t sufficient data to support a solid market penetration strategy.
  • Solution: SBI designed a system to integrate the separate sales, inventory, finance and supply chain programs, along with customised software systems to measure internal KPIs.
  • Outcome: Within months, exciting new trends emerged leading to improved market penetration, revenue and profits. Personnel strengths and weaknesses became apparent, allowing staff training, incentive and reward strategies to be implemented.
Case Study


  • Problem:Profit monitoring of over 2,000 lines was virtually impossible due to scattergun software systems in use throughout the company, all requiring manual extraction and analysis.
  • Solution: SBI implemented a program consolidating every existing system, producing detailed, real-time analysis of individual line items regarding sales, profit, rebates by individual customers, supply chains and inventory.
  • Outcome: With pricing and rebate decision-making now so quick and accurate, management time was freed up for more profitable pursuits.
Case Study


  • Problem: A mass of data systems produced an equal mass of figures so complicated they could only be read by IT personnel. A one-size-fits-all monthly report was sent to all managers, leaving them to make their own interpretations from information which was heavily customer-based and light on production and inventory.
  • Solution: SBI designed a smart set of BI tools which quickly began producing comprehensive sales and profit report, giving precise and integrated detail at all levels of invoice, customer, supply chain, production and inventory analysis. All managers started to receive weekly, fully customised reports.
  • Outcome: A single source of accurate statistics ensured consistency throughout the company, freeing managers for other work and vastly improving inventory levels and supply chain pricing negotiations.
Case Study


  • Problem: Those businesses in service industries such as accounting, consultancy, health IT and professional services face unique challenges. Unlike the product-based manufacturing, retail and wholesale sectors, businesses in service industries offer their specialist skills in exchange for high prices. Clients constantly looking to save money threaten their business.
  • Solution: SBI can customise a business intelligence system designed to identify clients, service categories, geographic areas, resource utilisation, costs and performance with a view to managing costs and margins; retaining the most profitable clients; and enabling astute decision-making.
  • Outcome: Such a system can increase client engagement and accuracy of data through streamlined reports. It can reduce wasted time, admin/IT cost and risk, while identifying key business indicators and emerging trends.

So there you have it. A complete business intelligence solution is only a phone call or email away. Why not contact Smoothstream Business Intelligence today and find out more?

Contact us for a complimentary 2 hour consultation