Admin

Customer Relationship Specialist

FREE CONSULTATION

CUSTOMER

Our Client has a well recognized Super market store has multiple products at multiple location and they wanted to predict their sales and market statistics which would allow their business to move on next level based on the analysis

CHALLENGE

Client has multiple stores on multiple locations, so he had a huge
volume of data and the maintenance of data set was quite complex. He
is indeed of analyzing tool to perform statistical analysis in depth and
came up with these insights,

  • Customer Retention rate
  • Revenue variations
  • Revenue by region
  • Month wise sales trend

SOLUTION

To ensure Response time and less RAM Consumption, we provide the
following solutions,

  • We used Incremental Load concept for incoming data, so that we got a proper data format for Analyzing.
  • Built an 3 tier architecture to load data from various Data sources such as Data base, Excel.
  • After that, we created application for different level of user (High level(CEO), Middle level (Managers), Report users(Sales Rep)

 

 

 

RESULTS

Created reports and visualization based on the metrics which helps the customer to know the reason for the Business lost customers, Point in time reporting (This year Vs previous Year) for the Total order based on the customer. Together with us, the customer planning to do Predictive analysis for Future prediction

TECHNOLOGIES AND TOOLS

MS SQL Server 2016
Spreadsheets, CSV Files
ODBC, OLDEB Connectors
QlikView 12

 

MORE CASE STUDIES

BI for Paper Manufacturing Company

One of our client has a Paper Manufacturing Firm which manufacture wrapping papers for retails stores.

View

BI for Paper Manufacturing Company

One of our client has a Paper Manufacturing Firm which manufacture wrapping papers for retails stores.

View

BI for Supermarket Store

Our Client has a well recognized Super market store has multiple products at multiple location and they wanted to predict their sales and market statistics which would allow their business to move on next level based on the analysis

View