Woolen Mill Company Uses Open Source BI Server Application

In an age dominated by data, even centuries-old industries like textile manufacturing are embracing modern analytics to drive efficiency, boost competitiveness, and gain deeper insights into operations. A prime example of this evolution can be found in Hearthloom Woollens, a mid-sized woollen mill based in the Scottish Highlands. Established in the early 1900s, Hearthloom built its reputation on craftsmanship and quality. But as global competition intensified and supply chains became more complex, the leadership team recognized that tradition alone wouldn't carry them forward.

The solution? A shift toward a data-driven culture — one powered by InetSoft's open source BI server, StyleBI. This article explores how the company implemented the StyleBI platform to overhaul its operations and how IT played a central role in driving this digital transformation.

The Case for BI in Traditional Manufacturing

At first glance, woollen mills might not appear to be prime candidates for business intelligence (BI) implementation. Their core activities — spinning, dyeing, weaving — are tactile, mechanical, and steeped in heritage. However, beneath the rustic charm lies a complex system of supply chain logistics, maintenance schedules, energy consumption metrics, production KPIs, and customer demand forecasting.

Hearthloom Woollens faced several challenges common to legacy manufacturers:

• Siloed Data: Production data was scattered across different spreadsheets, legacy databases, and manual logs.
• Lack of Real-Time Insights: Managers could only review operational reports weekly or monthly, leading to delayed responses.
• Manual Reporting: The finance and operations teams spent dozens of hours a month compiling static reports with limited interactivity.
• Inflexibility in Decision-Making: Without comprehensive dashboards, strategic decisions were often based on gut feeling rather than hard data.

Realizing the limitations of their legacy approach, Hearthloom sought a BI platform that was flexible, lightweight, and open source — a key factor given their modest IT budget.

Why InetSoft's StyleBI?

While exploring options, the IT leadership evaluated several proprietary BI tools like Tableau, Power BI, and Qlik Sense. Although feature-rich, these tools came with significant licensing costs and deployment overhead. InetSoft's Style Intelligence suite — particularly its open source BI server variant, StyleBI — stood out for several reasons:

1. Open Source and Cost-Effective: The freedom to deploy without licensing fees was a game-changer for a mid-sized business.
2. Web-Based Architecture: Enabled centralized deployment with browser-based access for users across the facility.
3. Flexible Data Mashup Engine: StyleBI's lightweight data mashup capabilities allowed the IT team to blend Excel spreadsheets, SQL Server databases, and CSV files without needing a complex data warehouse.
4. Customizable Dashboards and Visualizations: StyleBI supports a rich palette of interactive visual components that could be tailored to various users' needs — from the loom floor to the boardroom.
5. Lightweight Footprint: Its Java-based architecture allowed deployment on existing Linux servers with minimal hardware upgrades.

These advantages made StyleBI an ideal fit for Hearthloom's requirements. But the implementation wasn't plug-and-play — it involved a thoughtful rollout led by a small but capable IT team.

Laying the Foundation: The Implementation Strategy

The IT department, consisting of just five people, spearheaded the deployment over a 3-month period. The initial phase involved standard data infrastructure preparation:

• Data Inventory: The team cataloged over 40 data sources, including on-premise ERP systems, supplier records, energy usage logs, and quality control spreadsheets.
• Data Cleaning: Using custom Python scripts, they standardized naming conventions, cleaned corrupt entries, and ensured timestamp consistency.
• Data Federation: StyleBI's mashup engine was used to create virtual datasets by joining production logs (from SQL Server) with energy usage data (from CSV exports), making it easier to analyze output efficiency.

They adopted a phased rollout, starting with dashboards for:

1. Operations Monitoring
2. Supply Chain Analytics
3. Quality Control
4. Sales & Customer Trends

Once the dashboards were developed, they were exposed via a central web portal accessible from desktops, tablets, and factory-floor kiosks.

Key Dashboards and Use Cases

1. Operations Efficiency Dashboard

One of the earliest wins came from the live operations dashboard. This interface displayed metrics like:

• Loom runtime vs. downtime (with reason codes)
• Output per shift
• Real-time alerts for underperforming machines
• Maintenance logs with predictive failure analysis

Thanks to this visibility, the maintenance team reduced unscheduled downtime by 17% in the first quarter.

2. Energy Usage Analytics

Energy costs represented a significant part of Hearthloom's overhead. A mashup of power meter logs and production data allowed managers to visualize energy intensity per product line. They quickly discovered that one legacy dyeing machine consumed 38% more electricity per unit than newer equipment. This insight led to a capex decision to replace the machine, saving thousands annually.

3. Supply Chain Visibility

The purchasing team used StyleBI to track lead times, delivery performance, and material utilization. Anomalies in supplier performance — previously buried in spreadsheets — became immediately visible. As a result, Hearthloom renegotiated contracts and improved on-time delivery rates by 22%.

4. Sales & Market Trends

By integrating order data with Google Sheets-based CRM records and external market forecasts, the sales team gained better forecasting accuracy. They could identify which wool grades and patterns were trending, aligning production more closely with demand and reducing excess inventory by 15%.

The Role of IT: Empowering Without Overreaching

One of the standout features of the StyleBI platform is its low-code, self-service model. While the IT team established the infrastructure and created initial dashboards, they also conducted training workshops for end-users — supervisors, procurement staff, and analysts — enabling them to build their own views.

This empowerment had several benefits:

• Reduced IT Bottlenecks: Users could modify filters or add fields to dashboards without needing developers.
• Faster Iteration Cycles: Departments iterated on visualizations weekly, improving alignment with evolving KPIs.
• Data Literacy Culture: Adoption of the BI tool cultivated a culture where decisions were increasingly rooted in data rather than experience alone.

The IT department, for its part, maintained governance: managing user permissions, auditing data queries, and optimizing performance.

Challenges and Lessons Learned

Implementing any BI system — even an open source one — isn't without hurdles. Hearthloom's journey surfaced several lessons relevant to IT teams considering a similar move:

• Data Consistency is Crucial: StyleBI can work with multiple data formats, but inconsistent schemas and naming conventions created avoidable friction. Early investment in data governance paid dividends.
• Start Small, Expand Fast: Rather than attempting an all-encompassing dashboard from day one, the team focused on specific use cases with measurable impact. This built confidence and fueled momentum.
• Documentation Matters: With StyleBI's flexibility comes complexity. The team maintained internal documentation on mashup logic, dashboard templates, and best practices to ensure scalability.
• Community and Support: While open source, StyleBI is backed by InetSoft, and community forums provided quick resolutions to most technical queries.

Looking Ahead

Buoyed by their initial success, Hearthloom Woollens plans to expand their StyleBI implementation in several directions:

• Mobile Dashboards: Optimizing interfaces for mobile use by field sales representatives.
• AI-Driven Forecasting: Integrating StyleBI with machine learning models for advanced demand forecasting.
• Customer Portal: Creating a StyleBI-powered portal where B2B clients can track order statuses and view sustainability metrics in real-time.

The IT team is also exploring automated alerting based on StyleBI's scheduled query capabilities — for instance, notifying supervisors when loom efficiency drops below a threshold or when material stock levels hit a reorder point.

More Articles About BI Server Applications

BI and Social Media - The growth in Web and IVR/speech recognition and ATM/kiosk self-service, mostly at the expense of live-agent and retail interactions has created a need for companies to also deploy analytics across these channels to understand customers' behavior. The information obtained is being integrated with that pulled from contact centers and retail via BI to see and predict customers' actions...

BI Chart Gallery - Peruse dozens of advanced chart types rendered by InetSoft's visualization engine and charting API...

BI Companies - As an innovator in BI products since 1996, InetSoft's award-winning software has been deployed at thousands of organizations worldwide and integrated into dozens of other application providers' solutions serving vertical and horizontal markets of their own...

BI and Data Services - In terms of integrated BI and data services component management, increasingly, we are seeing that all rolled out in a service-oriented architecture context so you can essentially leverage all of the platform and the infrastructure and the middleware as you have within your agile system’s environment into BI and analytics projects. Where agile BI and agile data access stresses reuse, and that reuse is via service oriented architecture, there is a lot of REST, Representational State Transfer, for building out Web focused BI and data services capabilities through a matching of abstraction layers and similar virtualization schemes that essentially help you to hide or conceal a lot of the complexity of the source data models and schemas and formats and present a unified object model and way of accessing just for information sets in a way that’s fairly and relatively simple and visual in terms of the set of modeling tools...

BI Dashboard - Information for those researching BI dashboard solutions, why to evaluate InetSoft's flexibly-priced BI software for dashboards, reports & analytics. StyleBI is business intelligence software for dashboards,reporting,and analysis. It blends enterprise strength with a small,100% Java footprint. Unlike traditional BI platforms, Style Intelligence does not require specialized BI skills or consultants to implement or use. Patent pending Data Block technology is the foundation for StyleBI’s flexible and high performance data access. Technologists as well as end users can dynamically assemble, transform, and mash up data in a Lego-like fashion. Compressed,in-memory data representationensures efficient and rapid responses to user data requests...

BI Dashboard Pricing - For most of InetSoft's software products, StyleBI and its sub products StyleBI and Style Report Enterprise, pricing is based on server usage model. For higher volumes of users, typically more than 15 concurrent users, CPU-based pricing is offered. There are two options there, whichever is most cost-effective for and matches your hardware usage plan. You can either purchase licenses based on the number of CPU cores or based on the number of threads. These model aligns with your organization's actual usage. If there is not a lot of simultaneous usage, a single dual-core CPU license can support many dozens of occasional users. Multi-nationals with hundreds or thousands of users can start with a small number of CPU licenses for a multi-node cluster and add additional low-cost servers and licenses as performance requirements dictate...

BI Dashboard Software - Researching BI dashboard solutions for your organization's internal use or to embed in a commercial application? Deploy a small-footprint, easy-to-use Flash-based dashboard application from InetSoft. As an innovator in reporting software since 1996, InetSoft has pioneered the evolution from static reporting towards interactive visualization of data via dashboards...

Previous: BI Intelligence Information & Articles

Next: Discussions about InetSoft's Enterprise BI