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

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. 

BUSI 650 – Assignment 1

Weight: 10% of the final grade

This project should be done independently.

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.

,

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018

ORDERNUMBER QUANTITYORDERED PRICEEACH ORDERLINENUMBER SALES ORDERDATE STATUS QTR_ID MONTH_ID YEAR_ID PRODUCTLINE MSRP PRODUCTCODE CUSTOMERNAME PHONE ADDRESSLINE1 ADDRESSLINE2 CITY STATE POSTALCODE COUNTRY TERRITORY CONTACTLASTNAME CONTACTFIRSTNAME DEALSIZE
10107 30 95.7 2 2871 2/24/2003 0:00 Shipped 1 2 2003 Motorcycles 95 S10_1678 Land of Toys Inc. 2125557818 897 Long Airport Avenue NYC NY 10022 USA NA Yu Kwai Small
10121 34 81.35 5 2765.9 5/7/2003 0:00 Shipped 2 5 2003 Motorcycles 95 S10_1678 Reims Collectables 26.47.1555 59 rue de l'Abbaye Reims 51100 France EMEA Henriot Paul Small
10134 41 94.74 2 3884.34 7/1/2003 0:00 Shipped 3 7 2003 Motorcycles 95 S10_1678 Lyon Souveniers +33 1 46 62 7555 27 rue du Colonel Pierre Avia Paris 75508 France EMEA Da Cunha Daniel Medium
10145 45 83.26 6 3746.7 8/25/2003 0:00 Shipped 3 8 2003 Motorcycles 95 S10_1678 Toys4GrownUps.com 6265557265 78934 Hillside Dr. Pasadena CA 90003 USA NA Young Julie Medium
10159 49 100 14 5205.27 10/10/2003 0:00 Shipped 4 10 2003 Motorcycles 95 S10_1678 Corporate Gift Ideas Co. 6505551386 7734 Strong St. San Francisco CA USA NA Brown Julie Medium
10168 36 96.66 1 3479.76 10/28/2003 0:00 Shipped 4 10 2003 Motorcycles 95 S10_1678 Technics Stores Inc. 6505556809 9408 Furth Circle Burlingame CA 94217 USA NA Hirano Juri Medium
10180 29 86.13 9 2497.77 11/11/2003 0:00 Shipped 4 11 2003 Motorcycles 95 S10_1678 Daedalus Designs Imports 20.16.1555 184, chausse de Tournai Lille 59000 France EMEA Rance Martine Small
10188 48 100 1 5512.32 11/18/2003 0:00 Shipped 4 11 2003 Motorcycles 95 S10_1678 Herkku Gifts +47 2267 3215 Drammen 121, PR 744 Sentrum Bergen N 5804 Norway EMEA Oeztan Veysel Medium
10201 22 98.57 2 2168.54 12/1/2003 0:00 Shipped 4 12 2003 Motorcycles 95 S10_1678 Mini Wheels Co. 6505555787 5557 North Pendale Street San Francisco CA USA NA Murphy Julie Small
10211 41 100 14 4708.44 1/15/2004 0:00 Shipped 1 1 2004 Motorcycles 95 S10_1678 Auto Canal Petit (1) 47.55.6555 25, rue Lauriston Paris 75016 France EMEA Perrier Dominique Medium
10223 37 100 1 3965.66 2/20/2004 0:00 Shipped 1 2 2004 Motorcycles 95 S10_1678 Australian Collectors, Co. 03 9520 4555 636 St Kilda Road Level 3 Melbourne Victoria 3004 Australia APAC Ferguson Peter Medium
10237 23 100 7 2333.12 4/5/2004 0:00 Shipped 2 4 2004 Motorcycles 95 S10_1678 Vitachrome Inc. 2125551500 2678 Kingston Rd. Suite 101 NYC NY 10022 USA NA Frick Michael Small
10251 28 100 2 3188.64 5/18/2004 0:00 Shipped 2 5 2004 Motorcycles 95 S10_1678 Tekni Collectables Inc. 2015559350 7476 Moss Rd. Newark NJ 94019 USA NA Brown William Medium
10263 34 100 2 3676.76 6/28/2004 0:00 Shipped 2 6 2004 Motorcycles 95 S10_1678 Gift Depot Inc. 2035552570 25593 South Bay Ln. Bridgewater CT 97562 USA NA King Julie Medium
10275 45 92.83 1 4177.35 7/23/2004 0:00 Shipped 3 7 2004 Motorcycles 95 S10_1678 La Rochelle Gifts 40.67.8555 67, rue des Cinquante Otages Nantes 44000 France EMEA Labrune Janine Medium
10285 36 100 6 4099.68 8/27/2004 0:00 Shipped 3 8 2004 Motorcycles 95 S10_1678 Marta's Replicas Co. 6175558555 39323 Spinnaker Dr. Cambridge MA 51247 USA NA Hernandez Marta Medium
10299 23 100 9 2597.39 9/30/2004 0:00 Shipped 3 9 2004 Motorcycles 95 S10_1678 Toys of Finland, Co. 90-224 8555 Keskuskatu 45 Helsinki 21240 Finland EMEA Karttunen Matti Small
10309 41 100 5 4394.38 10/15/2004 0:00 Shipped 4 10 2004 Motorcycles 95 S10_1678 Baane Mini Imports 07-98 9555 Erling Skakkes gate 78 Stavern 4110 Norway EMEA Bergulfsen Jonas Medium
10318 46 94.74 1 4358.04 11/2/2004 0:00 Shipped 4 11 2004 Motorcycles 95 S10_1678 Diecast Classics Inc. 2155551555 7586 Pompton St. Allentown PA 70267 USA NA Yu Kyung Medium
10329 42 100 1 4396.14 11/15/2004 0:00 Shipped 4 11 2004 Motorcycles 95 S10_1678 Land of Toys Inc. 2125557818 897 Long Airport Avenue NYC NY 10022 USA NA Yu Kwai Medium
10341 41 100 9 7737.93 11/24/2004 0:00 Shipped 4 11 2004 Motorcycles 95 S10_1678 Salzburg Collectables 6562-9555 Geislweg 14 Salzburg 5020 Austria EMEA Pipps Georg Large
10361 20 72.55 13 1451 12/17/2004 0:00 Shipped 4 12 2004 Motorcycles 95 S10_1678 Souveniers And Things Co. +61 2 9495 8555 Monitor Money Building, 815 Pacific Hwy Level 6 Chatswood NSW 2067 Australia APAC Huxley Adrian Small
10375 21 34.91 12 733.11 2/3/2005 0:00 Shipped 1 2 2005 Motorcycles 95 S10_1678 La Rochelle Gifts 40.67.8555 67, rue des Cinquante Otages Nantes 44000 France EMEA Labrune Janine Small
10388 42 76.36 4 3207.12 3/3/2005 0:00 Shipped 1 3 2005 Motorcycles 95 S10_1678 FunGiftIdeas.com 5085552555 1785 First Street New Bedford MA 50553 USA NA Benitez Violeta Medium
10403 24 100 7 2434.56 4/8/2005 0:00 Shipped 2 4 2005 Motorcycles 95 S10_1678 UK Collectables, Ltd. (171) 555-2282 Berkeley Gardens 12 Brewery Liverpool WX1 6LT UK EMEA Devon Elizabeth Small
10417 66 100 2 7516.08 5/13/2005 0:00 Disputed 2 5 2005 Motorcycles 95 S10_1678 Euro Shopping Channel (91) 555 94 44 C/ Moralzarzal, 86 Madrid 28034 Spain EMEA Freyre Diego Large
10103 26 100 11 5404.62 1/29/2003 0:00 Shipped 1 1 2003 Classic Cars 214 S10_1949 Baane Mini Imports 07-98 9555 Erling Skakkes gate 78 Stavern 4110 Norway EMEA Bergulfsen Jonas Medium
10112 29 100 1 7209.11 3/24/2003 0:00 Shipped 1 3 2003 Classic Cars 214 S10_1949 Volvo Model Replicas, Co 0921-12 3555 Berguvsv�gen 8 Lule S-958 22 Sweden EMEA Berglund Christina Large
10126 38 100 11 7329.06 5/28/2003 0:00 Shipped 2 5 2003 Classic Cars 214 S10_1949 Corrida Auto Replicas, Ltd (91) 555 22 82 C/ Araquil, 67 Madrid 28023 Spain EMEA Sommer Mart¡n Large
10140 37 100 11 7374.1 7/24/2003 0:00 Shipped 3 7 2003 Classic Cars 214 S10_1949 Technics Stores Inc. 6505556809 9408 Furth Circle Burlingame CA 94217 USA NA Hirano Juri Large
10150 45 100 8 10993.5 9/19/2003 0:00 Shipped 3 9 2003 Classic Cars 214 S10_1949 Dragon Souveniers, Ltd. +65 221 7555 Bronz Sok., Bronz Apt. 3/6 Tesvikiye Singapore 79903 Singapore Japan Natividad Eric Large
10163 21 100 1 4860.24 10/20/2003 0:00 Shipped 4 10 2003 Classic Cars 214 S10_1949 Classic Legends Inc. 2125558493 5905 Pompton St. Suite 750 NYC NY 10022 USA NA Hernandez Maria Medium
10174 34 100 4 8014.82 11/6/2003 0:00 Shipped 4 11 2003 Classic Cars 214 S10_1949 Australian Gift Network, Co 61-7-3844-6555 31 Duncan St. West End South Brisbane Queensland 4101 Australia APAC Calaghan Tony Large
10183 23 100 8 5372.57 11/13/2003 0:00 Shipped