2 min read

Nisum Helps Increase Processing Capabilities by 33% with an Updated Tech Stack for BI Application

Nov 8, 2021 5:30:59 PM

Nisum enhanced data analytics by implementing an updated tech stack that increased data visibility and retention.

The retail client now has added capabilities and is able to retain data for 3+ years for analytics and reporting, leading to:

-23%
reduction in monthly costs on Azure database infrastructure
(with 1500DWU)

up to +70%
reduction in the cube refresh rate (with 1500DWU)

+50%
faster results for heavy user queries (2 quarters read with 1500DWU)

 

Business Challenge:

A Fortune 500 multi-brand apparel retail company’s supply chain BI users were unable to rollover their analytics and reporting year-over-year on the application they were using, leading to:

  • Limited analytics and reporting due to a data retention limit
  • Decreased application performance as data storage approached the 3.5TB out of 4TB limit (business-critical tier)
  • Unsustainability in peak 2020 due to only having a ~50GB daily incremental data application 
  • Limited visibility to raw data since data was only retained for 7 days 

 

Solution:

Nisum implemented a redesigned architecture with an upgraded tech stack that enhanced logging capabilities along with migrating the data from Azure SQL database to Azure Synapse (formally known as Azure Data Warehouse), resulting in:

  • Reduced monthly costs by adding the ability to scale the service tier (up or down) per workload requirements, which was not available previously
  • Increased processing capabilities by effectively distributing data to obtain better performance with Azure Synapse 
  • Faster results for heavy user queries due to eliminating the storage limit which allows additional raw data to be retained on the database in a queryable state
  • Reduced cube refresh rate due to the availability of raw data on the databases which eased operations to carry out root cause analysis and fixes for historical data

Feel free to contact us for more information on how Nisum can drive results for your company.

Ned Robinson

Written by Ned Robinson

Ned Robinson is a senior manager in Nisum’s Business Agility division. He is also a certified scrum master and a contributing author of Beautiful Teams: Inspiring and Cautionary Tales from Veteran Team Leaders. His chapter in the book talks about the struggles and triumphs of re-building his software development team after 9/11.

Featured

Post by Tags

See All