Global electronics & automation corporation adds automated processes & analytics

How could an automated data solution improve your business processes?


A global industrial automation and electronics components corporation asked One Six Solutions to build an analytics solution for their POS system data.
Being able to combine the client’s POS data with their actual customers’ POS data would allow greater visibility into sales, and inventory management, and allow for more accurate forecasting.  There were also several manual reports being created on a monthly basis that would exchange several hands before they hit their end-state.
OneSix introduced an automated data solution, with potential manual intervention, that would save time for company resources and improve accuracy across the organization.



Our solution

Improved Reporting and Data Analytics
The OneSix team built out an enterprise analytics solution for the client’s POS data that allowed ad-hoc capabilities and additional insights.  This included an automated process from start to end, thorough data cleansing processes, and an analytics solution consisting of multiple reports and dashboards based on the needs of the business.
SSIS ETL packages were built with auditing processes, automated executions, and calling several API’s for data cleansing and data supplementation processes.  Reporting and analytics were accomplished using IBM Cognos interactive reports and dashboards.

Technologies implemented


With this enterprise solution, the business is now able to do reporting and analytics with a single source of truth offering insights to the business that were not available before.

This automated solution also dramatically reduced monthly manual processes, added data accuracy, and saved several business resources time for other responsibilities.


My experience was fantastic with OneSix. They listen to your query carefully and then are able to solve your issues within the correct time frame and reasonable price. Super knowledgeable team!

Ayush J.
SEP 28 2022

One of my favorite things about One Six is their willingness to work with us on whatever we need. Early on in the project, we determined we needed an additional tactical resource instead of an advisory one, and One Six happily switched out resources for us, ensuring we had what we needed to complete the project.

Pamela E.
NOV 8 2021

They dig in and help understand the problem, how to think about it, provide the best technical options of how to solve it, then execute as quickly as possible. This is by far the best way to help me make sure we're successful, and that I know what's being done and how to support it once they're finished.

Brandon H.
OCT 20 2020

Transform your data org

Schedule a free consultation with the team.