This is the data warehousing assignment, please help me to deal with this

Sunducks Coffee has installed an IoT Environment scanning system to collect data on store and surrounding environment and to explore the impact of the environment on sales. The IoT Environment scanning system collects the following data and the data is recorded once per order and appended to the order data along with the order date-time stamp. On an average, 10,000 sales transactions (orders, not orderline item) are recorded across stores per day. The management wants this IoT data to be included in the data warehouse so the impact of the environment variables on sales can be analyzed.

Queue Length (Average que length at register, range 1- 50)

Temperature (Outside temperature, range -50.00 to 150.00 F, 2 decimal point precision)

Time Of Day (HH:MM:SS, 6:00:00AM to 1:00:00AM)

Humidity (Relative, percentage, 0.00 to 100.00, 2 decimal point precision)

Cloud Cover (Percentage, 0.00 to 100.00, 2 decimal point precision)

Weather condition (10 categories)

Pollen (1 to 10 rating)

Traffic Conditions (Score varying from -10,000 to +10,000)

Seating Availability (Percentage 0 to 100%, 0 decimal point precision)

Foot Traffic Score (Score 0 to 10000)

Indoor Noise level (0.00 to 140.00, 2 decimal point precision)

Outdoor Noise level (0.00 to 140.00, 2 decimal point precision)

Describe how this data can be included in the data warehouse for meaningful analysis. Include in your solution the schema for the appropriate dimension and/or fact table(s) that model the above data along with the attributes, data type and range (acceptable values) of the attribute. Include in your solution, the expected size of the fact and/or dimension tables for 90 days of transactions.

Deliverables

Schema (New Fact AND/OR Dimension tables) for capturing IoT data

Attribute descriptions including data type and range

Estimate of new table size for 90 days transactions

Describe two sample reports (Specificy Column, Rows, Filters and Cell values) that can be created using the new schema that addresses the following questions

How do sales vary across stores with varying cloud cover during the hours of 8:00am 4:00pm and Months of May Sep.

How do sales vary across products with varying temperatures during the hours of 12:00pm 5:00pm during the months of March Sep.

Sun Ducks coffee has coffee shops in multiple states. They sell coffee, snacks and related products. Their current dimensional model for Sales process is shown below. (Dimensional attributes not shown)