Business Scenario:
The database “Cellphones Information” contains details on
cell phone sales or transactions.

The data set we will be using for this exercise comprises of 6 tables:
--All these filese are also availabe--
 Dim_manufacturer
 Dim_model
 Dim_customer
 Dim_Location
 Fact_Transactions
 Dim_date

 There was no data format error so directly went for data analysis

 DATA ANALYSIS ACTIVITY
 1.all the states in which we have customers who have bought cellphones from 2005 till today.
 2.state in the US is buyingthe most 'Samsung' cell phones
 3.the number of transactions for each model per zip code per state.
 4.the cheapest cellphone
 5.the average price for each model in the top5 manufacturers in terms of sales quantity and order by average price.
 6.the names of the customers and the average amount spent in 2009,where the average is higher than 500
 7.if there is any model that was in the top 5 in terms of quantity,simultaneously in 2008, 2009 and 2010
 8.the manufacturer with the 2nd top sales in the year of 2009 and the manufacturer with the 2nd top sales in the year of 2010
 9.Show the manufacturers that sold cellphones in 2010 but did not in 2009.
 10.top 100 customers and their average spend, average quantity by each year.