Dataset

Attachment: Sales CSV file

Deliverables

1. Complete Project in word

Format: Word file, word limit: 400

Structure:

Objective:

Formulate a specific set of questions you want to answer, points you want to make, or issues you wish to explore through the data. Be as concrete as possible.

Methodology:

Knowing that you can look into the past or preview the future using analytics:

Add two sections: 

1- Descriptive Analytics and

2- Prescriptive Analytics 

and then answer the followings for each.

In a paragraph or two, explain:

·  What will you like to ask your data that will help you make your first decision in improving your business operation as CEO of the company? list 3 questions for both descriptive as well as prescriptive analytics

·  What kind of data (variables in the excel file) you think you will need to answer these questions? 

·  Explore relationships: Once you have identified the key variables, explore the relationships between them.

·  How do you think it will help you? Using graphs and charts, demosntrate how sales data might be used to answer your question! (You need to take a sceenshot of your excel file or copy/paste it to the word document)

Use at least 3 graphs/ metrics for each data analytics landscape. Please refrain from using the same variable for both descriptive and prescriptive analytics!

What To Turn In

1. Word Document

Your project should be in a word document named project1_Your name_your section number. Include clearly at the top of the document the name(s) and SUID(s) for the student submitting the project, then include project parts specified above. 

2. Data analysis Excel File (Please note to save your file as Excel and not CSV)

Your Excel file should include your charts, and tables. Name it as project1_Your name_your section number.xlsx or csv.