How We Helped an SME Restructure Operations Using Business Intelligence

There is a particular kind of frustration that many small and medium business owners know intimately. Your business is generating revenue. You have customers who keep coming back. Your team is working hard. But something is not adding up. The numbers at the end of each month are never quite what they should be given how much activity is happening inside the business. Costs seem higher than they ought to be. Some parts of the operation feel like they are running efficiently while others feel like they are constantly consuming resources without producing proportional results.

You know something is wrong but you cannot quite identify what it is or where it is coming from. And because you cannot identify it precisely, you cannot fix it.

This is the situation that brought a client we will call Sarah to Damisrael Solutions. Her story is not unique. It is, in many ways, the story of dozens of growing SMEs that are leaving significant value on the table not because they lack ambition or effort but because they lack the business intelligence infrastructure to see their business clearly enough to make the right decisions about it.

This case study documents what we found, what we did, and what changed as a result of applying business intelligence consulting to Sarah’s business operations.

Background — The Business and the Problem

Sarah is the founder and managing director of a mid-sized food production and distribution business based in the United States. The business produces a range of packaged food products sold through a combination of direct retail partnerships, an e-commerce channel, and a small but growing wholesale operation serving independent grocery stores and specialty food retailers.

By the time Sarah approached Damisrael Solutions, the business had been operating for six years and had grown to a team of twenty-two people across production, sales, and administration. Annual revenue was approximately one point eight million dollars and growing, but net profit margins had been declining steadily for three consecutive years despite consistent revenue growth.

Sarah had tried several approaches to address the margin compression. She had renegotiated supplier contracts. She had introduced a new production scheduling system. She had restructured her sales team. Each initiative produced some short-term improvement but the underlying trend of declining margins continued. She could not find the root cause because she was making operational decisions based on monthly financial summaries that were too aggregated to reveal where the real problems were.

When she came to Damisrael Solutions, her request was direct. She needed to understand exactly what was happening inside her business at a level of detail her current reporting did not provide. She needed business intelligence consulting that would give her the clarity to make decisions she could actually be confident in.

The Business Intelligence Consulting Engagement — What We Did

Our business intelligence consulting engagement with Sarah unfolded in four phases over a period of approximately three months.

Phase 1 — Data Audit and Infrastructure Assessment

Before any analysis could begin, we needed to understand what data the business was already collecting, where it lived, how reliable it was, and what gaps existed.

Over the first two weeks of the business intelligence consulting engagement, we conducted a comprehensive audit of every data source in the business. This included the accounting system, the production management records, the sales order history across all three channels, the inventory management logs, the customer database, the supplier invoicing records, and the staff time tracking system.

What we found at this stage was typical of many SMEs that have grown quickly without deliberately building a data infrastructure alongside their operational growth. The data existed but it was scattered, inconsistently formatted, and in many cases manually maintained in spreadsheets that different team members had built independently over time with no coordination or standardization between them.

There were three different spreadsheets tracking production output, none of which used the same date format or the same product naming convention. Sales data from the e-commerce channel and sales data from the wholesale channel were stored in completely different systems with no integration between them. Cost data in the accounting system was categorized differently from cost data in the production records, making it impossible to reconcile the two sources without significant manual effort.

The data audit confirmed that Sarah’s inability to see her business clearly was not a result of a lack of data. It was a result of data that had never been organized into a form that could support meaningful analysis. This is one of the most common findings in our business intelligence consulting work with SMEs.

Phase 2 — Data Organization and Integration

The second phase of the business intelligence consulting engagement was focused entirely on organizing, cleaning, and integrating the data sources we had identified in the audit.

We established a single, standardized data structure that could accommodate data from all of the business’s primary sources. We defined consistent naming conventions for products, customers, channels, and cost categories. We reconciled the historical data from the three production spreadsheets into a single unified production history going back four years. We integrated the e-commerce and wholesale sales data into a single sales database organized by product, channel, customer, date, revenue, and cost of goods sold.

This phase of the business intelligence consulting work was the least glamorous but the most foundational. Without clean, integrated, consistently structured data, no amount of analytical sophistication can produce reliable insight. The quality of your conclusions is always limited by the quality of your data.

By the end of Phase 2, we had a clean, integrated dataset spanning four years of business activity that could be queried and analyzed with confidence for the first time in the company’s history.

Phase 3 — Analysis and Insight Generation

With a reliable data foundation in place, the third phase of the business intelligence consulting engagement moved into active analysis. We approached this phase by asking a series of specific questions about the business and using the integrated dataset to answer them with evidence.

Which products are actually most profitable?

The first and most important question we investigated was product-level profitability. Sarah had always known which products generated the most revenue. What she had never known was which products generated the most profit after accounting for all direct and allocated costs.

The analysis revealed a pattern that surprised Sarah significantly and that immediately reframed the direction of the entire engagement. The three products that generated the highest revenue were not the three most profitable products. In fact, two of them were among the least profitable in the entire range when fully-loaded production costs, packaging costs, and channel-specific selling costs were accounted for.

One product in particular, which represented approximately twenty-two percent of total revenue and which Sarah had always considered a flagship product, was generating a gross margin of only nine percent after all direct costs. Given that the business needed a minimum blended gross margin of around thirty-five percent to cover its overhead and generate adequate net profit, this product was systematically dragging down the profitability of the entire business every month it was sold.

The business intelligence consulting analysis identified four products with gross margins above fifty percent that were generating disproportionate profit relative to their revenue contribution but had never received the same marketing investment or operational focus as the high-revenue, low-margin products.

Which sales channel is most efficient?

The second major analysis examined the efficiency of each sales channel. We calculated the fully-loaded cost of serving each channel including sales team time, logistics costs, payment processing fees, returns and credit note rates, and customer service time, and compared it against the revenue and gross profit generated by each channel.

The business intelligence consulting analysis revealed that the wholesale channel, which represented the smallest share of Sarah’s revenue, was by a significant margin her most profitable channel on a per-dollar-of-revenue basis. The e-commerce channel was generating strong gross revenue but when the cost of customer acquisition through digital advertising, the return rate which was significantly higher than the other channels, and the packaging and shipping costs were accounted for, the net contribution from the e-commerce channel was considerably lower than it appeared from the top-line revenue figure.

The direct retail partnership channel sat between the two in terms of efficiency, with good margins on well-performing product lines but significant variation across the retail partner base, with some partners generating very attractive economics and others consuming disproportionate account management time relative to the revenue they produced.

Where are the operational inefficiencies hiding?

The third major area of analysis used the integrated production and cost data to identify operational inefficiencies that had been invisible in the aggregated monthly financial summaries.

The business intelligence consulting work at this stage identified three specific areas of significant inefficiency.

The first was production scheduling. By analyzing the relationship between production run sizes and per-unit production costs over four years of historical data, we identified that production runs below a certain minimum batch size were generating per-unit costs approximately thirty percent higher than runs at or above that threshold. Sarah’s team had been scheduling production runs based on sales order volume, which sometimes produced small, high-cost runs, without any visibility into the cost impact of batch size variation.

The second was supplier concentration and pricing inconsistency. The data revealed that for three key raw material inputs, the business was purchasing from multiple suppliers at prices that varied by as much as eighteen percent for identical or equivalent materials. The purchasing decisions had been made by different team members at different times without any centralized visibility into the pricing landscape.

The third was customer-level profitability variation within channels. Within the wholesale channel, our business intelligence consulting analysis revealed that twenty percent of the wholesale customers were generating sixty-eight percent of the channel’s total profit contribution. The remaining eighty percent of wholesale customers were being served at a level of account management attention that was not proportionate to their actual contribution to the business.

Phase 4 — Recommendations and Implementation Support

The fourth phase of the business intelligence consulting engagement translated the insights from Phase 3 into a specific set of operational recommendations and supported Sarah’s team in implementing the highest-priority changes.

The recommendations fell into four categories.

Product portfolio restructuring. We recommended that Sarah significantly reduce her investment in the two highest-revenue, lowest-margin products and reallocate that marketing and production focus toward the four high-margin products identified in the analysis. We also recommended a price review for the flagship low-margin product to assess whether the margin could be improved to acceptable levels before considering a full discontinuation.

Channel strategy reorientation. We recommended that Sarah actively grow her wholesale channel, which the data had demonstrated was her most profitable, and implement a more rigorous customer acquisition cost discipline in the e-commerce channel. Specifically, we recommended capping e-commerce marketing spend as a percentage of e-commerce revenue and redirecting any budget above that cap into wholesale channel development.

Production scheduling standards. We recommended implementing a minimum batch size policy for each product category based on the cost analysis, so that production runs below the efficient threshold would only be scheduled when a specific business justification existed, such as a contractual commitment to a retail partner.

Supplier consolidation and procurement discipline. We recommended consolidating purchasing for the three key raw material inputs to a maximum of two preferred suppliers per material and implementing a quarterly pricing review process to ensure the business was consistently receiving competitive rates.

We also built Sarah’s team a business intelligence dashboard in Google Looker Studio, connected to their integrated data sources, that gave them ongoing visibility into product-level profitability, channel performance, and production cost metrics on a weekly basis. This meant that the business intelligence consulting insights would not be a one-time intervention but an ongoing operational capability that the team could use to make data informed decisions continuously.

The Results — Twelve Months After the Engagement

Twelve months after the completion of the business intelligence consulting engagement, Sarah’s business had achieved the following measurable results.

Revenue grew by approximately forty percent. The reorientation of marketing and sales focus toward the high-margin products, combined with the active development of the wholesale channel, drove significant revenue growth even as the total product range was reduced.

Net profit margin improved from six percent to nineteen percent. This was the most significant outcome of the entire engagement and the one that most directly addressed the problem Sarah had brought to us. The combination of product portfolio restructuring, channel strategy reorientation, production cost efficiency, and supplier consolidation compounded to produce a margin improvement that transformed the financial health of the business.

Production costs per unit fell by an average of seventeen percent. The implementation of minimum batch size standards and the elimination of the smallest, most inefficient production runs reduced per-unit production costs across the product range.

The wholesale customer base was refined. Sarah’s team implemented a tiered account management model that concentrated service investment on the most profitable wholesale customers and adopted a lighter-touch service model for lower-contribution accounts, freeing significant sales team time for new customer development.

A permanent business intelligence function was established. Perhaps the most durable outcome of the business intelligence consulting engagement was the change in how Sarah’s team made decisions. The dashboard built during the engagement became a weekly operational tool, and the discipline of asking data-based questions before making significant operational or commercial decisions became embedded in the culture of the business.

What This Case Study Reveals About Business Intelligence Consulting for SMEs

Sarah’s experience illustrates several important truths about business intelligence consulting for small and medium businesses that are worth drawing out explicitly.

The data you need almost always already exists. One of the most common barriers SMEs cite to embracing business intelligence consulting is the belief that they do not have enough data or the right kind of data. In almost every engagement we conduct, the data needed to generate transformative insight is already present in the business. The gap is organization and analysis, not collection.

Aggregated reporting hides the problems that are costing you the most. Monthly financial summaries that show total revenue and total costs are useful for tracking overall performance but they are almost useless for identifying the specific drivers of underperformance. Business intelligence consulting works by disaggregating those summaries into their component parts and examining each part independently.

The most expensive problems in most SMEs are invisible without data. Sarah did not know her flagship product was generating a nine percent margin. She had no reason to suspect it because nothing in her existing reporting revealed it. The most costly inefficiency in her business had been hiding in plain sight for years, masked by aggregated numbers that appeared to tell a reassuring story about the business overall.

Business intelligence consulting creates compounding returns. The insights generated in a business intelligence consulting engagement do not just solve the immediate problems identified. They build an organizational capability for ongoing data-informed decision making that continues to generate value long after the initial engagement is complete.

Is Your SME Ready for Business Intelligence Consulting?

If your business is growing but your margins are not keeping pace, if you have tried multiple operational initiatives without finding the underlying source of the problem, or if you are making significant decisions about your products, your customers, or your operations based on intuition rather than evidence, business intelligence consulting may be exactly what your business needs.

At Damisrael Solutions, our business intelligence consulting engagements are designed specifically for small and medium businesses. We work with your existing data, your existing tools, and your existing team to build the clarity and the analytical capability that transforms how you understand and run your business.

Book a free consultation with the Damisrael Solutions team today and let us show you what your business data is telling you that you have not been able to hear yet.

Book Your Free Consultation