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%
|
-40%
|
+50%
|
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
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 data refresh delay during critical periods by scaling up to Azure Synapse
Added capability to address the business user's requests to modify transformations and restate data, as raw data is maintained on the database
Feel free to contact us for more information on how Nisum can drive results for your company.