Data Analytics Platform for Large 3D Educational System

The client’s product captures the customer’s usage data using two ways:

• App data: includes click events, visit frequency, session activity, etc.
• Server-side data: includes license/purchase info, server-to-server notifications, and other transactional data.

The volume of gathered data was increasing and the existing solution couldn’t cover business needs. 

The client approached NIX for a solution from scratch that would provide actionable insights regarding sales and marketing performance—including in-app and email analytics—and point out ways for enhancements. The NIX data team was responsible for developing and integrating a data pipeline, creating and maintaining BI dashboards, and working on ad-hoc requests. 

The NIX team set up data storage and built a BI reporting solution on top of the AWS cloud using Snowflake as a data warehouse and Tableau as a visualization tool.

The solution has Infrastructure as Code (IaC) that decreases discrepancies, enables full traceability of each configuration’s changes, and makes the entire software development life cycle more efficient. Used services give options to process data on schedule when needed (ex. once a day) or have real-time analytics.

Based on the product backend database, third-party integrated systems, and email streaming data, we set up automatic processing of analytical data and output it on demand in a clear and easy-to-use way. 

All stages of data flow have a setup monitoring in place, which notifies the team in case of any issues. On top of that, we implemented data quality checks to track different anomalies.

The developed AWS-based data analytics solution on top of Snowflake and Tableau helped the client compose a holistic marketing strategy and empowered product managers with knowledge of which areas of the application were underutilized by users and where enhancements should be made. The new data solution improved the data processing and its quality as well as expanded the list of metrics for a more thorough analysis.

As a result of the constructed solution’s success, the customer opted to expand the data platform to connect data from more applications. New scalable architecture and a robust data pipeline developed by the NIX team make it possible due to reusable components that simplify maintenance and harmonize operations, along with a unique data gathering layer depending on the various types of data the product is creating for analytics.