1. List three questions that might be important to the project creator, the backer. For each question, briefly explain why answering it is important, and define the measures and dimensions in the dataset that can be used answer it.
Question:
Measures:
Dimensions:
2.Design a star schema that can be used to design a data warehouse which supports the data analyses for answering these questions.
A B C D 1 backers Number of people supported the project. N category Project category. country Project country. created at When the project was created. 5 creator id ID of the creator. 6 currency Currency 7 deadline When the project ends. 8 creator_name Name of the creator. 9 failed_at When the project was closed as failed. LO goal How much money the project targets to raise. 1 1 id ID of the project. 12 launched_at When the project was launched. .3 name Name of the project. 14 pledged Amount raised when the data were collected. .5 spotlight Whether the project has been featured in the spotlight section. 16 slug Keywords. 17 status Project status. 18 status_changed_at When the status of the project was changed. .9 static_usd_rate USD rate if the currency is not USD, usd_pledged Amount raised in USD. 21 staff_pick Whether the project has been featured as staff picked. 22 patented Whether the project has patents approved. patent_pending Whether the project has patent pending. video Whether the project has a video. 25 prototype Whether the project has a prototype. 6 location_name City name. 27 location_shortname City and state. 8 location_state State 29 location_type Location type. 30 creator_gender Gender of the creator. 31\f1 backe category count created_at creator_id currency deadline creator_name N 298 3D Printing US 5/19/15 2:35 1245051645 USD 12/2/16 21:00 Roy Cortes W 27 3D Printing HK 10/29/16 6:46 1037397144 HKD 12/9/16 19:14 SHIP 423 3D Printing US 9/29/16 5:07 1280877427 USD 11/30/16 9:59 TEAM OWL WORKS 8 3D Printing US 11/2/16 21:18 293721212 USD 1/14/17 16:21 John Lehman 149 3D Printing NL 10/11/16 10:36 1156557451 EUR 11/20/16 6:20 Lykle Schepers (Zesty Technology) 9 3D Printing US 9/14/16 4:26 1000642404 USD 12/3/16 23:34 Borlee 3D Printing 19 3D Printing IT 3/8/16 6:08 1460000621 EUR 11/27/16 15:00 Cross Lances 2 3D Printing CA 5/11/16 1:07 435460077 CAD 12/16/16 9:46 Matt Templeton 10 1 3D Printing IT 11/8/16 11:22 119281239 EUR 12/1/16 15:51 Ivan Perfetti 11 5 3D Printing US 10/15/16 21:38 529923889 USD 11/26/16 10:03 Y.N.G. LLC 12 21 3D Printing US 9/4/16 9:00 1566472343 USD 12/1/16 9:05 Aurora Smart Technologies 13 6 3D Printing US 10/19/16 21:20 1951946893 USD 12/19/16 9:40 Berret Adkins 14 5 3D Printing US 9/27/16 21:33 1224041680 USD 11/30/16 15:49 Ez 2c 3D Viewers and Video Equipment 15 75 3D Printing US 4/26/16 2:37 532181294 USD 11/16/16 10:08 MakeX 16 16538 3D Printing US 3/25/15 19:14 1056329519 USD 4/30/15 13:00 Tiko 3D 17 3147 3D Printing US 3/24/16 7:00 1403065126 USD 4/30/16 15:00 Kodama, Inc. 18 1525 3D Printing US 3/11/15 21:13 1964730400 USD 5/9/15 8:08 XMachines LLC 19 3698 3D Printing US 5/9/16 19:24 1096598548 USD 6/16/16 20:45 101Hero
