Supplier Intelligence for 360-degree visibility and Big Data in Cloud
September 27, 2021
Contract Life Cycle Management – SAP, DocuSign CLM
September 26, 2021
BUSINESS INTELLIGENCE

Transformed Market Basket Analysis (MBA) Metrics Reporting

Transformed Market Basket Analysis (MBA) Metrics Reporting
Technology transformation is inevitable for organizations to support big data analytics and to empower users with deeper & richer business intelligence.

Our client, a global retailer, was facing multiple challenges related to their legacy system for reporting and visualizing Market Basket Analysis (MBA) metrics. While the cost and effort of maintenance is high most of the current requirements of the business users are not met by the legacy system. Further, attempting to change the legacy system to incorporate new requirements is time consuming and not scalable.

Solution

Resolve Tech team worked as part of the client’s Business Intelligence and Data Analytics team to replace this legacy system with contemporary technology stack and scalable deisng & architecture for data capture, reports, and visualization. The solution was implemented with key technologies such as Azure Data Lake, Apache Spark, and PowerBI. Besides, the technology upgrade, the team implemented new requirements of various business groups.

Transformed Market Basket Analysis (MBA) Metrics Reporting

Solution Highlights

Transformed Market Basket Analysis (MBA) Metrics Reporting
DATA CLEANSING & RULES

Raw data from different stores across all the products and sales activities need to be cleansed (for standardized codes and acronyms, removing duplicates, filling default values etc.) and specific transformation rules many need to applied for specific data sets.

Transformed Market Basket Analysis (MBA) Metrics Reporting
DATA COVERAGE & QUALITY

Data for more products and stores are considered for better data quality across different time ranges (Year, week, month, and year-to-date etc.)

Transformed Market Basket Analysis (MBA) Metrics Reporting
DATA STORES & PIPELINES

Designed and implemented highly scalable data stores & pipelines leveraging open-source technologies and streamlined data pipelines that are highly optimized for large data sets thus ensuring high-throughput and low-latency operations.

Transformed Market Basket Analysis (MBA) Metrics Reporting
LEGACY & NEW REPORTS

Ensure that the calculations and rules applied in the legacy reports are transferred accurately into the new reports while also making sure new data & visualization requirements from different business groups are implemented.

Transformed Market Basket Analysis (MBA) Metrics Reporting
DATA AGGREGATION

Aggregation capabilities at different organization hierarchy levels and across different attributes of product hierarchy (Attributes such as item-name, business-unit etc.)

Transformed Market Basket Analysis (MBA) Metrics Reporting
DATA ANALYSIS

Provide data visualization in different forms from tabular reports to charts, bar graphs, stacked bar graphs etc. including the facility for the user to drill-down to multiple levels and download the underlying data to conduct off-line custom analysis.

Benefits

With this new system being realized, our client not only met the emerging business needs but also institutionalized a new technology stack and framework for BI requirements. A number of new requirements are planned to be implemented significantly expanding the scope of the system. Key benefits include:
  • Improved data quality and increased variety of data by including more products and stores as part of the data set
  • Enhanced quality of insights by considering different types of metrics that are visualized in different forms
  • Reduced time to insight by translating raw data across stores into meaningful analytics in a short time
  • Increased power to users with reports that can be drilled-down to various levels and the ability to download the underlying data for personalized analysis
Transformed Market Basket Analysis (MBA) Metrics Reporting