Eric Kavanagh (EK): OK, and Byron, let’s drill into the underpinnings of this stuff because we talked earlier about APIs and third party data, and so forth, and ideally with a mashup, again, you want to enable these end users to mix and match data sets very easily. So how do you deal with that marshalling area of data. Do you, for example, are you just exposing a range of data feeds, and is that in your product, or do you leverage another product? How does that work?
Byron Igoe (BI): So specifically in our product, it’s all homegrown technology. The common context, so to speak, is as Jim would say, at the metadata, always. So it doesn’t really matter where the data is coming from, whether a relational database or other sources. As long as they are compatible types, you can still combine them, and in terms of enterprise mashups being used inside a company, you don’t have to limit yourself to these global contexts like geography. Within a particular firm, everybody knows what a customer is, and so they can combine information about that customer from different departments and get a total view of where they stand with a particular customer, and that is just one example. Products and many other subject areas are also common contexts for people to combine information.
EK: That’s a good point. One last question before we go to the break. I see that you guys also are offering a solution around Salesforce, and this it seems to me is a very interesting dynamic in the industry because you have this handful of companies that have done so extremely well, Salesforce being on of them. That you have all these software companies out there designing products just for the express purpose of working with Salesforce. What are you doing, and what is that all about?
BI: It’s essentially a targeted use of our application. Where normally it is a development tool people use to build something custom based on their environment. For Salesforce we have actually eaten our own dog food, so to speak, and we’re providing an application that comes with many default dashboards, analytic tools, and data mashup capability for the users to hit the ground running with things that work directly with their sales data and then also have the ability to bring in other sources and combine them with their Salesforce data.
Case Study of a Single Malt Whiskey Producer Using Data Mashup Software
Highland Spirits, a mid-sized producer of premium single malt whiskey, operates out of Scotland with a rich history of crafting whiskey using traditional methods. The company runs three distilleries across the Highlands, producing over 5 million liters annually. Known for its commitment to quality and craftsmanship, Highland Spirits has a strong domestic market and exports to over 20 countries worldwide. The company is at a pivotal stage of growth, aiming to expand its global reach while maintaining its reputation for premium whiskey.
The Challenge
As Highland Spirits sought to scale up operations and enter new markets, the company faced several challenges related to data management, operational efficiency, and market strategy:
-
Data Silos Across Departments: Highland Spirits had several departments - production, quality control, sales, marketing, and supply chain - working independently with little cross-departmental visibility. Each department used different software systems, and data was stored in silos, making it difficult to have a holistic view of the business.
-
Inconsistent Reporting: Reports were generated manually from multiple data sources (ERP systems, spreadsheets, and CRM tools), leading to inconsistencies, delays, and data accuracy issues. This made it hard for decision-makers to have a clear picture of sales trends, production efficiency, or market performance.
-
Inefficient Production Planning: Whiskey production is a complex process involving long maturation periods. Highland Spirits struggled to align production schedules with fluctuating market demand, leading to either overproduction (resulting in excessive stockpiling) or underproduction (causing stock shortages and missed sales opportunities).
-
Fragmented Market Insights: With plans to expand globally, Highland Spirits needed to better understand its international customers, competitors, and emerging trends. However, data from distributors, market research reports, and sales channels were fragmented, making it difficult to make informed decisions about where and how to allocate resources for market expansion.
The Solution
To address these challenges, Highland Spirits implemented a data mashup software solution from InetSoft, which allowed the company to integrate data from multiple sources, analyze it holistically, and gain actionable insights across the entire organization. The software could connect to a variety of systems - including ERP, CRM, sales platforms, supply chain management tools, and marketing analytics platforms - creating a unified data environment for seamless analysis.
The objectives of the data mashup solution were:
- Integrating data from multiple departments to provide a single source of truth.
- Enhancing production planning by aligning inventory, demand forecasts, and maturation schedules.
- Providing better visibility into global market trends, customer preferences, and competitor activities.
- Streamlining reporting to deliver consistent, real-time insights to key stakeholders.
Implementation Process
The data mashup solution was implemented in three main phases:
-
Data Integration and Centralization Highland Spirits used the data mashup software to aggregate data from multiple sources, including:
- ERP systems for tracking production volumes, inventory levels, and costs.
- CRM platforms for customer and distributor data, including sales, feedback, and relationships.
- Marketing platforms for analyzing campaign performance, website traffic, and customer engagement.
- Supply chain data to monitor raw material deliveries, bottling schedules, and distribution timelines. The integrated data was stored in a centralized data warehouse, providing a unified view of the company's operations.
-
Creating Dashboards and Reports Customized dashboards were developed for different roles within the company, from the production floor to the executive suite. These dashboards provided real-time insights into key performance indicators (KPIs) such as production efficiency, sales trends, and inventory turnover. Automated reports replaced manual reporting processes, giving stakeholders accurate, up-to-date information.
-
Predictive Analytics and Market Insights The data mashup solution enabled Highland Spirits to use predictive analytics for both production and market planning. By analyzing historical sales data, market trends, and customer behavior, the company could forecast demand for different whiskey variants, optimize production schedules, and tailor marketing campaigns to specific customer segments in new markets.
Results and Benefits
-
Improved Production Planning By integrating sales forecasts with production data, Highland Spirits was able to better align its whiskey maturation schedules with market demand. The company reduced stock shortages by 20%, ensuring that popular single malt variants were available when demand peaked. Overproduction of certain variants was also reduced by 15%, cutting down on excess inventory and storage costs.
-
Cross-Departmental Visibility The data mashup solution broke down data silos, allowing different departments to collaborate more effectively. For example, the production team could now access real-time sales data, helping them adjust production schedules based on actual demand. The marketing team could track the effectiveness of their campaigns and see how they directly impacted sales, allowing for more targeted promotions.
-
Streamlined Reporting and Decision-Making With automated reporting, Highland Spirits reduced the time spent on manual data collection and report generation by 40%. Decision-makers across the company had access to consistent, accurate data, allowing them to make informed decisions more quickly. This was particularly useful for the leadership team, which now had a clear overview of both operational performance and market expansion efforts in real time.
-
Enhanced Market Expansion Strategy The data mashup solution gave Highland Spirits the ability to analyze global market trends and customer preferences in greater detail. By combining sales data from different regions with external market research, the company could identify which markets had the highest potential for growth. For example, the analysis revealed that demand for premium single malts was increasing in Asia, prompting Highland Spirits to increase its marketing spend and distributor relationships in key Asian countries, resulting in a 12% increase in export sales in the first year.
-
Optimized Supply Chain Management By integrating supply chain data with production and sales data, Highland Spirits improved its raw material sourcing and distribution logistics. The company could now predict when barley and other ingredients would be needed based on production schedules and adjust its orders accordingly. This led to a 15% reduction in raw material lead times and improved relationships with suppliers.
-
Better Customer Insights The data mashup software enabled Highland Spirits to combine customer data from multiple sources, including CRM, sales, and social media platforms. This gave the company a 360-degree view of its customers, allowing for more personalized marketing efforts. For instance, by analyzing customer feedback and purchasing trends, Highland Spirits identified a growing interest in limited-edition, cask-strength whiskies, leading to the successful launch of a new product line that boosted sales by 10%.
Key Takeaways
- Holistic Data Integration is Critical: Highland Spirits' success was largely due to its ability to integrate data from disparate systems into a single, unified platform. This provided a clear, accurate view of the company's operations and market performance.
- Real-Time Insights Enhance Agility: With access to real-time data, Highland Spirits was able to respond more quickly to changes in demand, optimize production schedules, and improve decision-making across the organization.
- Predictive Analytics Drive Efficiency: The use of predictive analytics allowed the company to forecast demand more accurately, resulting in better production planning, reduced waste, and improved customer satisfaction.
- Market Expansion is Data-Driven: By combining internal sales data with external market research, Highland Spirits was able to make informed decisions about where to invest in new markets and how to tailor its product offerings to meet local preferences.