I am looking at a Teradata SQL Assistant/Web Edition that holds a lot of data. It has many tables and table sets. It is a data set for Dillards, and what I am trying to do is analyze the data tables for a presentation. I have been told it is very simple, and can be done in a matter of hours. Below are the specifics that I am trying to query from this data.
-Find the products that have been selling the most volumes and at which stores
This means identifying which products. Identify quantities for SKU. What SKU has the largest quantity and how that is sold through the given stores. Are they sold evenly? or sold more or less at different stores?
Total in SKU's (what sold the most). Total where (what stores sold the most)
I have access to a Teradata sql assistant database through my college. None of this is REAL information or sensitive, this is all for a class. It is due Wednesday.
The data will be used in a 2-3 slide power point to highlight some potential sales qualities that can be addressed. So please highlight some quality observations and point that would impact a potential sale.
If you understand Query's, SQL, and database analysis then this should be a walk in the park for you. If you accept the project then I will give you the website along with a username and password to access the data set.