Logo-black

Delivering timely financial and labor insights for a food manufacturer

  • Manufacturing

Delivering timely financial and labor insights for a food manufacturer

OneSix delivered a scalable cloud data platform for a fine food manufacturer, enabling reliable, timely insights into financial and labor metrics, streamlining reporting, and supporting data-driven decision-making across the organization.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Power BI

Overview

Creating a reliable, scalable data platform for accurate, timely insights

A single source of truth with accurate and timely data insights across the company is critical for manufacturers. Our client, a fine food manufacturer that provides protein and meal solutions for customers ranging from national restaurants to food service providers was utilizing a legacy data platform that relied on a difficult-to-maintain database and business intelligence solutions requiring heavy technical coding skills.

The existing process was very manual and prone to errors, sometimes delaying turnaround time in responding to customers’ data requests. This process impeded the client’s ability to create new reports or aggregate reports across multiple programs for each customer. The current reporting could represent a point in time but did not easily allow for trending over time.

Our Solution

Implementing a modern cloud data architecture for reporting

OneSix presented a case for a modern cloud data architecture that would reduce maintenance overhead as well as the ability to scale in size and volume as their data needs continue to grow. As a decision was solidified, an end-to-end data lake and data warehouse solution was created with an initial set of analytics reporting that provided full visibility into the P&L and Balance Sheet for the finance executive team as well as a visual view of their labor data for operations leadership.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable, and flexible data lake and data warehouse environment.
  • Fivetran provided flexible data pipelines loading data into the data lake, saving time and money on data engineering development.
  • Matillion was the core data transformation technology used to integrate and cleanse the data in preparation for visual analytics.
  • Power BI provided reports to the operations and executive leadership teams for actionable insights and trends.

Results

Empowering decision-making with a single source of truth

With this solution and knowledge transfer, the organization is able to leverage the analytics output from our project as a template for building future reporting. A single source of truth from the cloud data warehouse allows the business to look at the numbers with confidence for decision-making.

Key financial metrics are available to view by snapshot, trends, as well as drill-down to more granular components in a visual, easy-to-digest method. The labor reporting has already yielded insight into better management of overtime for the workforce.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Driving ROI and data-driven decisions with self-service reporting for regenerative medicine

  • Healthcare & Life Sciences

Driving ROI and data-driven decisions with self-service reporting for regenerative medicine

OneSix implemented a secure, self-service Power BI reporting solution, enabling a regenerative medicine company to gain immediate ROI from their new CRM/ERP system and drive data-informed decisions across sales and finance.
Data Analytics
Microsoft Azure
Power BI

Overview

Leveraging new CRM/ERP data for actionable insights

A regenerative medicine company specializing in placental-derived products was in the process of a technology transition. The company implemented Dynamics 365 Business Central as its new CRM and ERP platform to track sales and accounts receivable.

Their new platform unlocked troves of new data that opened a new future for their business, one that is rooted in analytical insights and data-driven decision-making. But, in order to get a valuable ROI for their system upgrade, they needed a self-service reporting platform to take advantage of their newfound data assets.

Our Solution

Building a Power BI reporting suite for self-service access

OneSix developed a suite of reporting tools within Power BI to equip the company with the data it needed to improve its bottom line.

  • Sales: A collection of sales-related data visualizations provides insight into performance at a salesperson, region, product, and customer level.
  • Finance: Accounts receivable could now be tracked at an enterprise level, quickly pointing out customers with high levels of aging invoices.

Self-service data enablement was built in, enabling access to clean, curated datasets and reporting insights to all team members, from any device. Row-level security settings open the door to insights beyond the C-Suite, allowing individual salespeople to securely log in and see their own revenue growth, identify cross-sell opportunities at a product level, or profile important customers.

Technologies Implemented
  • Dynamics 365 Business Central CRM/ERP platform brought new data streams previously unavailable to C-suite leadership and front-line sales teams.
  • Azure Active Directory was utilized as a direct channel for granting access and establishing secure, row-level data security settings.
  • Power BI reports enable insights into key revenue growth strategies and streamlines operations.

Results

Empowering data-driven decision-making across teams

With this highly interactive, foundational reporting structure, the client is now primed to create a culture of data-driven decision-making.

The sales team can see their performance and drill down into a variety of different data points to help set strategy. The accounting team has a one-stop shop for both tracking their accounts receivable at a high level and accessing line item-level datasets that can be integrated into existing workflows without disrupting operations.

The new reporting structure will allow the company to yield immediate ROI on their system upgrade by having reporting live immediately as they transition to their new CRM/ERP system.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Doubling recurring revenue with embedded analytics for a B2B SaaS provider

  • Technology

Doubling recurring revenue with embedded analytics for a B2B SaaS provider

OneSix enabled the client to launch a scalable, self-service BI platform within six months, doubling ARR and empowering customers with advanced, on-demand analytics capabilities.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran

Overview

Empowering a SaaS provider with self-service analytics

Our client wanted to gain a competitive advantage with their SaaS application by offering feature-rich analytics embedded into the application. Their previous platform had some basic reporting capabilities for their customers, but new requests for dashboards or reports often required long lead times and were painfully slow to build for their reporting team. Simple enhancements like adding a field to a report required a clunky ticketing system.

Our client wanted to introduce a business intelligence (BI) solution that would empower their customers to self-serve many of their data needs and free up their internal reporting team to tackle higher-value tasks. And they wanted to accomplish this in a short time frame with minimal technical coding and wanted to be able to scale the final product out to all their customers.

Our Solution

Implementing a scalable, agile BI solution with enhanced data models

Utilizing an agile methodology process, OneSix designed, built, and implemented a modern data stack with an end-to-end data warehouse, data transformation capabilities, and data visualization technologies that created opportunities for insights that were previously impossible with their previous technology.

Data models were designed to expand reporting capabilities of the customer’s source data. Initial dashboards were created to give customers a jump-start with the new BI solution and immediately start generating insights.

OneSix also partnered and led training sessions with both client team members and customers of the client to create a high rate of knowledge transfer. We also presented a new strategy for creating an additional product to sell to their customers using their new infrastructure by enabling customers to connect to secure shares of the data warehouse.

Technologies Implemented
  • Snowflake was chosen as the data warehouse due to its favorable data storage, extremely fast performance, low query calculation costs and its industry leading scalability.
  • Fivetran provided flexible data pipelines loading data into the data lake, saving time and money on data engineering development.
  • Matillion ETL was chosen as the ELT tool for its user-friendly drag-and-drop development interface, built-in SQL Server read/write compatibility, and its ability to build pipelines entirely based on table metadata.
  • Sisense was leveraged for data visualization, seamlessly embedding a fully white-labeled product into the client’s existing platform.
  • ASP.NET Core framework was used along with AWS SQS messages to maintain the synchronization of accounts, security, and pipeline configurations.

Results

Doubling ARR, exceeding targets, and accelerating time-to-market

With the customer’s new modern data platform and knowledge transfer, they were able to exceed their expected conversion rate 2-fold within three months of the launch of the new platform and doubled sales Annual Recurring Revenue (ARR) from their customers.

Following an agile methodology process enabled the organization to launch the new platform to the market in less than six months from the start of development. The new market differentiator enabled customers to self-serve all their reporting needs and accomplish exponentially more than previously possible. The client also expects to be able to retire their old reporting platform thanks to the capabilities of the new product.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Establishing a competitive edge with embedded analytics for Chordline Health

  • Healthcare & Life Sciences

Establishing a competitive edge with embedded analytics for Chordline Health

OneSix empowered Chordline Health to gain a competitive edge by implementing a scalable, multi-tenant analytics solution that improved application performance, reduced operational costs, and delivered real-time insights directly within their SaaS platform.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran

Overview

Enhancing SaaS competitive edge with scalable, embedded analytics

Chordline Health, a healthcare software provider, wanted to gain a competitive advantage with their SaaS application by offering feature-rich analytics embedded into the application.

Existing analytics was driven off the single-tenant operational databases using complex SQL statements that could not be reused across customers due to the different data models per customer. Any needed changes were restricted by the legacy approach that required extensive labor and testing to enhance. The application experienced severe performance issues. A scalable solution was needed to expose the trove of data for customers that could be easily integrated into their application.

Our Solution

Implementing an automated data framework

OneSix designed an end-to-end automated framework to load multi-model databases per customer into a data lake and transformed that into a multi-tenant data warehouse addressing Cases, Authorizations, To-do lists, and Compliance threshold reporting.

All new tools and platforms were introduced that would help automate new customer loads by using a simple control table. A live connection to the data warehouse using the powerful Snowflake engine served embedded analytics using Sisense visualization. The complex security model was simplified via two security tables that allowed bi-directional integration between Sisense and the SaaS application.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable data lake and multi-tenant data warehouse environment.
  • Fivetran provided dynamic data pipelines per customer’s unique data model, loading data into the data lake, saving time and money on data engineering development​.
  • Matillion was the core data transformation technology used to integrate and cleanse single-tenant data to load in the multi-tenant data warehouse in preparation for visual analytics.
  • Sisense was leveraged for data visualization, seamlessly embedding a fully white-labeled product into the client’s existing platform.

Results

Boosted application performance and reduced labor costs

The implementation of the Embedded Analytics solution brought about significant positive changes for the SaaS provider:

  • Improved SaaS Application Performance: By driving analytics from a separate database, the SaaS provider effectively segregated the workload. This separation reduced contention for resources on their main application, resulting in improved performance and responsiveness for end-users.
  • Reduced Labor Time and Costs: The adoption of a single warehouse and transformation architecture streamlined data management across various application versions. This unified approach significantly reduced the laborious task of managing multiple data repositories and schemas, leading to considerable time and cost savings.
  • Achieved Competitive Edge: By integrating feature-rich analytics directly into their SaaS application, the company gained a competitive advantage by providing real-time, insightful data to users without requiring external tools or platforms. This integration streamlined user experience and differentiated their offering in the market, enhancing user engagement and retention.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Creating a new revenue stream with embedded BI for a B2B SaaS platform

  • Technology

Creating a new revenue stream with embedded BI for a B2B SaaS platform

OneSix transformed a B2B SaaS provider’s reporting capabilities by implementing a modern data stack and embedding BI, enabling a new revenue stream, reducing tool costs, and enhancing client data access and insights.
Data & App Engineering
Data Analytics
Snowflake
AWS
Sigma

Overview

Transforming reporting capabilities for a streamlined client experience

Our client wanted to revamp their existing reporting and create a new advanced reporting revenue stream by embedding a BI solution into their web application.

Their previous platform was developed in-house and difficult to support. Additional requests for data and reports had to be supported with another tool and consumed much of the customer support team’s time. Our client wanted to retire both reporting tools and provide clients with better insights into their data by allowing direct database access to incorporate into existing workflows and reporting solutions.

Our Solution

Building a modern data stack with embedded BI

OneSix built new custom data pipelines to efficiently move the large volume of their production data into the cloud, in order to create a modern data stack that could be levered with their new technologies.

Sigma was seamlessly embedded within the existing web app, and existing reports were sunset to use the new reporting capabilities. New data sets were also created to increase accountability and decrease development time for new custom reporting requests in the future.

Data sharing within Snowflake was implemented to give clients direct access to their data without the need for reports to the ServiceCore team and the use of another tool. This enables their clients the full flexibility to use and manipulate the data as they see fit.

Technologies Implemented
  • Snowflake was chosen as the data warehouse due to its favorable data storage, extremely fast performance, low query calculation costs and its industry leading scalability.
  • AWS, Snowflake and Terraform were used to create an in-house ETL process to limit costs and provide a workflow that could fit into existing Dev/Ops procedures.
  • Sigma was leveraged for data visualization, seamlessly embedding a fully white-labeled product into the client’s existing platform

Results

New revenue stream, reduced tool overhead, and simplified reporting

With the customer’s new modern data platform, they were able to generate a new tiered revenue stream that fits the needs and market size of their clients with a handful of clients already using the direct database access.

The customer was able to retire existing tools and licensing fees and the reporting stack was simplified. The data stack created will continue to be further leveraged in the future for more internal business reporting needs.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Modernizing data architectures for efficiency and inventory planning in logistics

  • Logistics

Modernizing data architectures for efficiency and inventory planning in logistics

By consolidating data into a cloud-based data warehouse, OneSix empowered a 3PL provider to achieve real-time, accurate reporting, streamline inventory planning, and enhance operational efficiency.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Tableau

Overview

Eliminating data silos and delays in reporting

Our client, a third-party logistics (3PL) provider, focused on helping businesses handle their e-commerce order fulfillment and retail distribution, has fulfillment centers strategically located across the nation to reduce order transit time.

The client has multiple warehouse management systems (WMS) for inventory management and for monitoring warehouse activities such as receiving, putaway, picking, packing, and shipping. Multiple Warehouse Management systems from different vendors resulted in data silos and data inconsistencies creating delays in enterprise-wide reporting. They needed a solution that would consolidate their data, reduce maintenance overhead, and allow them to scale in size as their data needs continued to grow.

Our Solution

Creating a scalable data architecture for unified reporting

OneSix implemented a solution that utilizes modern cloud data architecture to reduce maintenance overhead as well as allow the client to scale in size as their data needs continued to grow.

The solution consisted of replicating all the data from various operational systems into a data lake. A data warehouse was designed to consolidate all data into a centralized location designed for easier access, analysis, and reporting.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable data lake and data warehouse environment.
  • Fivetran provided resilient data pipelines sourcing data from multiple WMS systems and loading data into the data lake, saving time and money on data engineering development​
  • Matillion was the transformation and orchestration engine for building the enterprise data model in the data warehouse.
  • Tableau provided executive dashboards and customer-facing reporting across the firm driving actionable insights and trends.

Results

Empowering data-driven decisions with strategic insights

With this single source of truth (the cloud data warehouse), the organization was able to generate comprehensive reporting on KPIs that allowed the business to look at these numbers with confidence to support strategic decision-making.
The operations team utilized these reports generated from the data warehouse for inventory planning to reduce the risk of stockouts and identify demand patterns. The facility managers utilized the reports to identify inefficiencies in warehouse activities to improve the order fulfillment turnaround time.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Optimizing warehouse operations and 3PL efficiency with near real-time data

  • Logistics

Optimizing warehouse operations and 3PL efficiency with near real-time data

By implementing a scalable data platform with near real-time reporting, OneSix enabled a 3PL client to optimize warehouse operations, enhance financial analysis, and streamline data-driven decision-making across departments.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Power BI

Overview

Enabling real-time visibility and scalability in a 3PL environment

In the fast-paced, hands-on, 3PL work environment, logistics companies require near real-time reporting on key metrics to track warehouse capacity as well as warehouse operation activities.

Our 3PL client is a long-standing logistics service provider based on the east coast. With a wide array of products across consumer-packaged goods, specialty foods, food ingredients, health and personal care products, and alcoholic beverages, the task of keeping track of every pallet and case is paramount to business success. They needed a solution that would consolidate their data, reduce maintenance overhead, and allow them to scale in size as their data needs continue to grow.

Our Solution

Automating data pipelines and building flexible data models

OneSix designed and developed automated data pipelines to easily move data from their legacy platform into a data lake. We created data models to handle the client’s current reporting needs and give them the flexibility to enhance them in the future. We worked with key stakeholders to develop reports that the enterprise can use for financial analysis, warehouse workload trends, and warehouse occupancy.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable data lake and multi-tenant data warehouse environment.
  • Fivetran provided dynamic data pipelines per customer’s unique data model, loading data into the data lake, saving time and money on data engineering development​.
  • Matillion was the core data transformation tech used to integrate and cleanse data and load it into the data warehouse in preparation for visual analytics.
  • Power BI provided reports to the operations and executive leadership teams for actionable insights and trends.

Results

Enhanced decision-making and operational efficiency

A modern data platform solution made near real-time data accessible to the different departments in the organization. The C-suite is able to view current and historic financial reporting, slicing and dicing the data by key business attributes to identify high-cost areas. 

The operational teams utilize the warehouse workload reporting to improve labor utilization, identifying and eliminating bottlenecks and prioritizing warehouse activities based on high-volume tasks and deadlines. The result is a modern, data-driven approach to tackling the complex problem-solving required in the 3PL industry.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Eliminating data silos to drive efficiency and growth in title insurance

  • Financial Services

Eliminating data silos to drive efficiency and growth in title insurance

By implementing a unified cloud data solution, OneSix helped a leading title insurance company eliminate data silos, improve data quality, and enable real-time insights for greater operational efficiency and growth.
Data & App Engineering
Data Analytics
Snowflake
Power BI

Overview

Breaking down data silos for streamlined operations

Our client is a title insurance company that provides title, escrow, settlement, and related products and services. They have been in business for over a century and have grown to become one of the largest title insurance companies in the United States. ​

Due to the scale of their business, growth due to M&A, and fast pace of the real estate industry, our client had multiple systems for title and escrow processing based across separate geographical locations. This resulted in a series of data silos and data inconsistencies and frequent delays in delivering enterprise-wide reporting and analytics. ​

Our Solution

Implementing a scalable cloud data architecture

OneSix implemented a solution that uses a modern cloud data architecture that would reduce maintenance overhead, improve data quality, integrate data, and allow our client to scale as their business and data needs change over time. ​

The solution consisted of replicating all the data from various source systems into a data lake. The transformation layer was used to apply business rules, and clean, and consolidate the data into a data warehouse model solution. The new platform provided a new standard across the organization for data storage and information access.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable data lake and multi-tenant data warehouse environment.
  • Rivery was utilized for acquiring data from various source types.
  • Informatica was the core data transformation tech used to integrate and cleanse an individual tenant's data, loading it into the multi-tenant data warehouse in preparation for visual analytics.
  • Power BI provided reports for actionable insights and trends.

Results

Unified data insights for efficiency, cost savings, and revenue growth

With the modern data solution, the client eliminated data silos, improved the data quality, streamlined workflows, improved efficiency, and increased their ability to make data-driven decisions. Using a single source of truth from the cloud data warehouse, the client generated consistent and accurate reporting across the organization. ​

The operations team created dashboards to identify trends and patterns in order volume which helped the client proactively plan for staffing and resource allocation. The revenue dashboards provided a near-real-time view of KPIs across various business units and geographical locations. The workflow dashboards and reports are being used to identify bottlenecks in the product workflow and improve turnaround time for client services.​ Together, these analytics tools have helped the organization improve efficiency, reduce costs, and increase revenue.​

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us