Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the importance of SQL in retail industry, summarize the five major roles?

user-image
Question added by Deleted user
Date Posted: 2015/07/13
Sarmad Jari
by Sarmad Jari , Senior Cloud Solution Architect , Microsoft

there are many roles, most important once for retails are the once which are related to BI/DW

according to a publication by Matt Adams - "Predictive Analytics for the Retail Industry"

and SQL Server Technical Article by Microsoft which I find it very interesting (it does not have5 most points but it does explain allot that you can build upon)

  • Marketing Campaign Effectiveness
  • Market Segmentation
  • Shopping Basket Analysis
  • Demand Planning

 

source decoment

good luck.

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

Lot of importance:

1) storing inventory information

2) Getting Reports at the end of the day or starting of the day to have an idea of the stock

3) To have historical transactions - basically analysis purpose

4) To have proper accounting in the business

5) Details of each and every product. etc.

More Questions Like This