Data Warehouse Consulting Services

A Fortune 500 industrial supply company

The client is an American industrial supply company. It offers over 1.6M quality in-stock products in such categories as safety, material handling, and metalworking. The company provides inventory management and technical support to more than 3M customers in North America.

Industry:
Business Supplies & Equipment
Location:
USA
Partnership period:
Feb 2019 - present
Team:
35+ people

The Challenge

The client needed to upgrade an existing on-premise data solution and move it to the cloud for better scalability, reliability, and cost reduction. We have helped to migrate from the on-premise Hadoop Hortonworks cluster to AWS and build a unified big data analytics platform on AWS with the help of Snowflake, Airflow, Terraform, Teradata, Tableau.

The Solution

We integrated more than 100 different data sources into a unified data platform, including daily data loads, along with a backfill of historical data. We compared Amazon Redshift with Snowflake and preferred Snowflake as it meets all the project requirements and provides multiple benefits. It allows the client to avoid vendor lock-in (Snowflake is a cloud-agnostic shared-data solution that is compatible with any cloud provider), achieve seamless scaling capability, have more automated maintenance than Redshift, reduce the costs, and improve performance.

Gogo is a leading provider of in-flight connectivity and entertainment with over 20 years of experience. The company’s superior technologies, best-in-class service, and global reach help planes fly smarter, airline partners perform better, and their passengers travel happier.

The Challenge

The company needed a qualified engineering team to undertake a complete transition of Gogo solutions to the cloud, as well as build a unified data platform, improve existing reports, and introduce new solutions in order to provide the best speed of the in-flight Internet.

The Solution

Our team has built the data warehouse system for storing and processing significant amounts of data. It helps the client to receive timely reports and provides the ground for operational processes. N-iX experts have also created an AWS-based data platform and built a data lake for collecting data from more than 20 different sources in one place. The data lake also has a separate layer that provides information for the company's data warehouse, improving the reporting process (while some business applications can connect directly to the data lake to extract information).

Lebara is one of Europe’s fastest-growing mobile virtual network operators (MVNO) with millions of active customers, employing over 62 nationalities worldwide in six countries.

The Challenge

At the first stage of our cooperation, Lebara had a legacy data warehouse and requested to rebuild it as it was not maintainable. The product was not renewed for a long time and had price-performance issues. For instance, the delay in monthly reports was 1-2 months. In time, the client decided to replace the classic data warehouse and change the tech stack to reduce the price, increase maintainability, and change the functionality.

The Solution

The N-iX team contributed to the development of a data warehouse for Lebara: we rebuilt the system architecture, data flows, and provided constant support. The data warehouse was built on-premises (MS SQL Server, SQL Server Integration Services, Microsoft Analysis Services, SQL Server Reporting Services). We used Tableau for data visualization. The data warehouse accepts the data from CRM, various accounting systems, and sim card information. To reduce the information processing delays, we created the process dependency tree and an orchestrating instrument, which was monitoring tasks and started new processes according to server load.

A global provider of managed cloud services

Our client is one of the leading managed service providers. They help businesses reduce management complexity and strain on IT resources with white-glove, personalized customer hosting solutions.

Industry:
Information Technology & Services
Location:
USA
Partnership period:
Nov 2020 - present
Team:
9 people

The Challenge

All of the company’s siloed data was managed on-premises that caused issues with data governance, storage, accessibility, scalability, and more. The client engaged the N-iX team to develop a unified data warehouse on GCP, data warehouse migration, and automation of various internal processes.

The Solution

Our experts have helped the client consolidate 74 operational data sources and migrate 4 data warehouses and 1 data lake to Google Cloud. We built a unified data warehouse in GCP, allowing the client to elevate data management across the business. It allows our client to:

Consolidate 74 operational data sources, 4 data warehouses, 1 data lake from on-premises to Google Cloud;
Decommission 20 servers, leading to more than 1 million dollars in savings on MS SQL Server licenses alone.

Also, our test engineers are responsible for data quality in the data warehouse.

A Fortune 500 industrial supply company

The client is an American industrial supply company. It offers over 1.6M quality in-stock products in such categories as safety, material handling, and metalworking. The company provides inventory management and technical support to more than 3M customers in North America.

Industry:
Business Supplies & Equipment
Location:
USA
Partnership period:
Feb 2019 - present
Team:
35+ people

The Challenge

The client needed to upgrade an existing on-premise data solution and move it to the cloud for better scalability, reliability, and cost reduction. We have helped to migrate from the on-premise Hadoop Hortonworks cluster to AWS and build a unified big data analytics platform on AWS with the help of Snowflake, Airflow, Terraform, Teradata, Tableau.

The Solution

We integrated more than 100 different data sources into a unified data platform, including daily data loads, along with a backfill of historical data. We compared Amazon Redshift with Snowflake and preferred Snowflake as it meets all the project requirements and provides multiple benefits. It allows the client to avoid vendor lock-in (Snowflake is a cloud-agnostic shared-data solution that is compatible with any cloud provider), achieve seamless scaling capability, have more automated maintenance than Redshift, reduce the costs, and improve performance.

Gogo is a leading provider of in-flight connectivity and entertainment with over 20 years of experience. The company’s superior technologies, best-in-class service, and global reach help planes fly smarter, airline partners perform better, and their passengers travel happier.

The Challenge

The company needed a qualified engineering team to undertake a complete transition of Gogo solutions to the cloud, as well as build a unified data platform, improve existing reports, and introduce new solutions in order to provide the best speed of the in-flight Internet.

The Solution

Our team has built the data warehouse system for storing and processing significant amounts of data. It helps the client to receive timely reports and provides the ground for operational processes. N-iX experts have also created an AWS-based data platform and built a data lake for collecting data from more than 20 different sources in one place. The data lake also has a separate layer that provides information for the company's data warehouse, improving the reporting process (while some business applications can connect directly to the data lake to extract information).

Lebara is one of Europe’s fastest-growing mobile virtual network operators (MVNO) with millions of active customers, employing over 62 nationalities worldwide in six countries.

The Challenge

At the first stage of our cooperation, Lebara had a legacy data warehouse and requested to rebuild it as it was not maintainable. The product was not renewed for a long time and had price-performance issues. For instance, the delay in monthly reports was 1-2 months. In time, the client decided to replace the classic data warehouse and change the tech stack to reduce the price, increase maintainability, and change the functionality.

The Solution

The N-iX team contributed to the development of a data warehouse for Lebara: we rebuilt the system architecture, data flows, and provided constant support. The data warehouse was built on-premises (MS SQL Server, SQL Server Integration Services, Microsoft Analysis Services, SQL Server Reporting Services). We used Tableau for data visualization. The data warehouse accepts the data from CRM, various accounting systems, and sim card information. To reduce the information processing delays, we created the process dependency tree and an orchestrating instrument, which was monitoring tasks and started new processes according to server load.

A global provider of managed cloud services

Our client is one of the leading managed service providers. They help businesses reduce management complexity and strain on IT resources with white-glove, personalized customer hosting solutions.

Industry:
Information Technology & Services
Location:
USA
Partnership period:
Nov 2020 - present
Team:
9 people

The Challenge

All of the company’s siloed data was managed on-premises that caused issues with data governance, storage, accessibility, scalability, and more. The client engaged the N-iX team to develop a unified data warehouse on GCP, data warehouse migration, and automation of various internal processes.

The Solution

Our experts have helped the client consolidate 74 operational data sources and migrate 4 data warehouses and 1 data lake to Google Cloud. We built a unified data warehouse in GCP, allowing the client to elevate data management across the business. It allows our client to:

Consolidate 74 operational data sources, 4 data warehouses, 1 data lake from on-premises to Google Cloud;
Decommission 20 servers, leading to more than 1 million dollars in savings on MS SQL Server licenses alone.

Also, our test engineers are responsible for data quality in the data warehouse.

A Fortune 500 industrial supply company

The client is an American industrial supply company. It offers over 1.6M quality in-stock products in such categories as safety, material handling, and metalworking. The company provides inventory management and technical support to more than 3M customers in North America.

Industry:
Business Supplies & Equipment
Location:
USA
Partnership period:
Feb 2019 - present
Team:
35+ people

The Challenge

The client needed to upgrade an existing on-premise data solution and move it to the cloud for better scalability, reliability, and cost reduction. We have helped to migrate from the on-premise Hadoop Hortonworks cluster to AWS and build a unified big data analytics platform on AWS with the help of Snowflake, Airflow, Terraform, Teradata, Tableau.

The Solution

We integrated more than 100 different data sources into a unified data platform, including daily data loads, along with a backfill of historical data. We compared Amazon Redshift with Snowflake and preferred Snowflake as it meets all the project requirements and provides multiple benefits. It allows the client to avoid vendor lock-in (Snowflake is a cloud-agnostic shared-data solution that is compatible with any cloud provider), achieve seamless scaling capability, have more automated maintenance than Redshift, reduce the costs, and improve performance.