A bookshop hired you as their data scientist and would like you to help them make better business decisions using data.

Here is the data file they provided to you.

Last week, you explored the data and came up with three important questions (or KPI - key performance indicators) that you think you can derive an answer from this data set.

This week, we will get the data ready for visualization.

Step 1 - Please choose three of the questions below. Questions listed in one-row count as one question.

1. What books are the most popular? The least popular? Is that based on sales, reviews, checkouts, or another metric?
2. Who was the youngest debut author? Who was the oldest?
3. Do some publishing houses seem to specialize in any way?
4. What was the longest time between editions of the same book?
5. Are there any seasonal trends for sales? What about checkouts? Does any titles or genres have seasonal fluctuations?
6. Are there any correlations between checkouts, print run size, book review ratings, and sales volume?
7. Do the authors who spend the most time writing have the most successful books? Do they have the highest page count?
8. When are most books published? Are there any anomalies?
9. Are there any trends for genre, format, and price?
10. What sort of distributions do the ratings have? Do those distributions vary by book? By genre? Do they seem to align with awards?
11. How would you calculate the sales price, given that there is sometimes?but not always?a discount given at the time of sale?
12. Do sales approximate the Pareto principle?
13. Are there any patterns in the discounts?

Step 2 - Please list all the tables required to answer each question you chose. And write down the table's connection type (relate, join, blend, union) in a Word Document.

Here is an example of the assignment format:

Question:What books are the most popular? The least popular? Is that based on sales, reviews, checkouts, or another metric?

Tables required: AAA, BBB, CCC, and DDD. These tables will help me determine the books' popularity based on sales.

Connection type: AAA will be related to table BBB. CCC will be unioned with DDD, and then the unioned table will be related to AAA.

Note to Expert: I'm not able to upload the complete data file for your reference. Hence, attaching few screenshots which has less rows and columns. Please refer to the screenshots and choose 3 questions accordingly to the data present in the screenshots.

Bookshop (1) (1) .XLSX * @ File Edit View Insert Format Data Tools Help Last edit was 2 hours ago 100% S 60 .00 123- Default (Ca.. - 11 - BISA . B E. E. A AuthID B C G H 1 AuthID First Name Last Name Birthday Country of Residence Hrs Writing per Day 2 A5443 Abraham Stackhouse 7/1/2147 Norway 6 3 AW980 Amelia Wangerin, Jr. 3/26/2141 New Zealand 16 4 A1923 Inez 3/30/2148 New Zealand 11 Anastasia 5 Arthur McCrumb 3/13/2148 New Zealand 3 AM329 6 AH957 Arturo Hijuelos 1/9/2129 United Kingdom 7 BH149 Bernard Hopf 11/27/2122 United States 8 BT132 Bianca Thompson 1/28/2150 United States 9 BL857 Bravig Lewisohn 1/21/2238 United States 10 BM856 Burton Malamud 1/18/2145 Brazil 11 C$190 Carolyn Segal 9/24/2133 United States 12 CF829 Charles Fenimore 3/18/2120 Norway 109 13 CW626 Clifford Wolitzer 8/1/2143 United Kingdom 14 DF413 Darryl Fleischman 12/7/2131 Germany 16 15 DB605 David Beam 2/26/2157 United States 5.13 16 EH487 Elizabeth Herbach 1/22/2157 New Zealand 17 EK605 Elmer Komroff 7/11/2129 Norway 18 GG800 Gloria Green 9/19/2156 Hong Kong 19 GH671 Grace Harrison 4/8/2161 United States 20 HM751 Hamlin Myrer 1/29/2225 Brazil 21 HB302 Hillary Barnhardt 3/7/2154 New Zealand DO 22 JH502 Jill Hergesheimer 6/15/2156 Canada 23 JS525 John W. Spanogle 8/10/2149 United Kingdom 10 24 JK592 Jonathan Kotzwinkle 2/3/2151 Germany 25 KY296 Kathy Yglesias 4/3/2151 Brazil 26 KD840 Kenneth Douglas 9/24/2163 South Africa 27 KE397 Kris Elegant 8/26/2149 Hong Kong 28 LL585 Langston Lippman 10/2/2147 New Zealand 29 LN356 Leonard Nabokov 9/29/2169 United States 30 LK915 Lori Kaan 3/27/2147 China 31 CO LD375 Lynne Danticat 8/19/2155 New Zealand MW974 Malin Wolff 1/31/2141 Hong Kong 33 OL640 Oliver Lowry 8/29/2155 Netherlands 34 PH273 Patricia Hazzard 4/27/2146 Singapore 35 PA878 Philip Antrim 4/22/2148 Netherlands 36 PB147 Phoebe Brown 8/21/2149 Hong Kong 13 37 RL217 R.M. Larner 3/26/2130 China 38 RM781 Robert Milofsky 1/12/2157 United States 39 RP438 Robert Plimpton 11/11/2160 Canada 13 40 UK129 Ursula Karenine 2/25/2156 United Kingdom 41 Ward Haigh 10/7/2153 Brazil 42 WB149 Wendell Barton 10/25/2138 United States 43 Ratings Info Award Checkouts Edition Publisher Book AuthorBookshop (1) (1) .XLSX * G File Edit View Insert Format Data Tools Help Last edit was 2 hours ago 2 5 7 100% ~ $ % .0 .00 123- Default ( Ca .. + 11|- B I S A 9. B 3 3 - = - 1 - H . V- A1 - fx Title A B C D E F G H Title |Award Name Year Won 2 Post Alley Agatha Award 2179 3 Alanna Saves the Day Caldecott Medal 2186 4 Portmeirion Hugo Award 2188 5 Rystwyth Hugo Award 2193 6 The Mallemaroking Hugo Award 2179 7 No More Lightning Man Booker 2191 8 Nothing But Capers National Book Award 2179 9 Cimornul National Book Award 2189 10 The Spark and The Ashes National Book Award 2193 11 The Mallemaroking Nebula Award 2179 12 Heliotrope Pajamas Newberry Medal 2182 13 the life and times of an utterly inconsequential person PEN/Faulkner Award 2192 14 Inconvenient Confessions: a memoir Pulitzer 2190 15 We're Sisters and We Kinda Like Each Other Pulitzer 2183 16 Hashtag QuokkaSelfie Pulitzer 2179 17 Saint Esme RITA Award 2189 18 Ballinby Boys World Fantasy Award 2180 19 (im) Mortality Young Reader's Choice Award 2192 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Edition * Publisher Ratings Seri + Book Author Info Award Checkouts Type here to search OBookshop (1) (1) 20.8x 4 7 6 File Edit Vow Insert Format Dots Tools Help Lest actives 2 hour age 100% AT X BookID F Books - ITitle Acthill BB194 Ballinby Boys AM939 N(653 Nothing But Capers A5443 ADZZZ Alanna Saves the Day 8H149 PA169 Post Alley BMSSE ICTEE Thatch work Collage BMASS 21 703 Zero over Twelve BM856 Portmariron 87132 RR774 Rystwyth 87132 TM925 The Mallemaroking 87132 CH391 Can I Be Honest? CF829 NL209 No More Lightning CF829 NR695 9803 North Millworks Road C$190 TH 296 The Winchcombe Railway Museum Heist C5190 MM424 [im]Mortality CW626 TP887 the life and times of an utterly incomequential person D8605 LS176 Land Water Sky Space EH487 AY135 And I Said Yes EX605 LA439 Interrobangs for All EX605 20 KA663 Kalakalal Avenue EX605 25 BF889 Banana Slug and the Glass Half Full GG800 NB483 Not to Gossip, But GG800 T1225 The Thing Is GG800 CP573 Concerning Prophecy GH671 BC244 Banana Slug and the Lost Cow H8302 25 BE374 Banana Slug and Kyr Friends H8302 CC830 Cimernul JH502 QQ737 Quiddity and Quoddity JH502 THS56 The Startling End of Mr. Hidhoo JK592 SS603 Say it with Snap! 18525 TH143 The Elephant House JS525 AM124 A Horrible Human with the Habits of a Monster KD840 T1359 Turn Left Til You Get There KE39 DR914 Dust on the Rim KY 206 TC401 Tales of the Company KY 206 BS284 Burnished Silver LD375 27 DY800 Did You Hear? LD375 L8510 Lace and Brandy LD375 29 MW621 Muddy Waters LD375 SE35S Saint Eare LD875 TO365 The Scunt of Oranges LD375 42 TSP69 The Seawitch Sings LD375 WG715 Whither Thou Goest LD375 S$361 Some Eggs or Something? LK915 HS107 Hashtag QuokkaSelfie LLS&S 16460 It's Never Just a Glass LN356 47 BRB58 Banana Slug and the Messy Rock MW974 HP265 Heliotrope Pajamas MW974 IC739 Inconvenient Confessions: a memoir DL640 WK456 Who Did You Think You Were Kidding? PA878 NP937 Natural Pamplemousse P8147 WO506 We're Skaters and We Kinda Like Each Other PH273 DE571 Don't Check your Ego RL217 ST303 Soft, Pliable Truth RP438 ST862 She Ako Tottered RP438 [A182 The Spark and The Ashes UK129 11773 The Triscanipl UK125 AK934 Adventures of Kaya WH901 DG384 The Deep Grey RM781 Book Author tato Award Checkouts Edition Publisher Rating Type here to searchBookshop (1) (1) Ja.SX @ File Edit View Insert Format Data Tools Help Last edit was seconds ago K20 BookIDI BookiDZ Genre SeriesD Volume Number Staff Comment MM 424 Young Adult Would you want to live forever? Doesn't that depend on what sort of life you'd have-and who you'd spend it with? NR Mystery IR-ESP AM 124 Fiction "This graphic novel is better than years of marriage count AK 974 Youre Aduh 222 Chadrem Alanna didn't expect this Tuesday to be any different than the Turiday before, and the Tuesday before that. She was wrong. Can the make is to wednesday? AY 125 Fiction 194 Scifi/Fantasy What? Disaster Where ? The stars. When? Now. Who ? The Ballinay Boys How? You'll have to turn the page to find out.! RES B5-CHP 1 Glug glug glug. BANANA SLUGI 244 Children BS-CHP 2 Can Banana Skin find For Children BS-CHP 3Come play on a rainy day! Bad weather can't stop Banana Slug! BF 374 Children BS-CHP 284 Romance EL-SSC 7 Book Seven of Esme'S Ladies 391 Yours Adult 15 C 830 SciFi/Fantasy meone who hates prophecy, Lydan seems an unlikely gua someday save Yu ul from as doom. The Elders don't take such things lightly. But what, Lydan asks herself, does it mean lot sare CP 573 SciFi/Fantasy something? Especially when the cast in concerning. DY Fiction MT.ESP "The best beach-book i've ever read" 'Easy and fun withon 571 Non Fiction 914 SciFi/FarBaby .QuokkaSelfie took the in storm in the early 21s. These adorable marsupials quickly dubbed the happiest animal on earily became an internet sensaven when tourists started posting selfies with the smiling mammals. Rottnest island, once an Australian Aboriginal penal colony, transformed into an eco-tourism destination thanks to these picture perfect smiling crealines, But even beaming quokkas can't intape the darker side of intense human attention. Reports began circulating of quokkas being kicked liked foulballs. Instagram labeled aquokkaselfie as potentially violating animal welfare. Conservationnts decried lumpy jaw, a potentially fatal infection caused by bread fad in these herbivores from human hands In the - unimately hopeful-exploration of #QuokkaSelfie, Langston Lippman and colleagues Lake a desper look at the phantomerion of culebrating 107 Nonfiction nature to the brink of destroying it 2 HP 265 Children's Wilberforce isn't sure about bedtime in a new bid, in : new house, in a new town. But when his grandmother beavis him . pair of heliotrope pajamas, wilberforce finds out bedtime can be downright magical. Lowry's comedic genes stands through every moment of war man IC 739 ix wit, the ar unittic academics. The literarily-inclinded daughter of a physicist and an epi miologist, Lowty was forced to find her own way towant Memoir normal through an upbringing that was anything but. 23 IA 439 Fiction 460 Youre Aduh 13 KA 563 Fiction 510 Romance EL-SSC Book Five of Fame's Ladies 57 LS 176 Nonfiction 621 Romente ES.SSC Book Two of Esme's Ladies 937 205 Fiction Beloved author Charles Fenimore strikes but in a new direction with his first graphic novel in this devestating late of daring meenuity, and just a dash of luck, Ferimare dmon kahitning brings its Fiction MT-ESP own threats to her under-bos community stricken by wildfires. Will uchan's luck run out on the eve of the best balining storin to tweeton the sleepy town of Delano in decades? "I never thought I'd enjoy a trashy, light chick-hi series. But here I am, and Green is rapidly becoming my favorite author 652 Nonfelon When his wife set out to write her magnum opus cookbook, food critic Stackhouse thought the hardest part would be making sure he didn't outgrow his favorite slacks. He never expected that amidst the thyme and ro Tastefully seetoned with the recipes that brought them to the brink, "Nothing But Capers"follows the tumult that strained then saved lus marriage and his life. hip would be tried, tested, and ultimately perfected Scifi/Fantasy MM-ESP 2No one saw it coming. No one could escape the effects, No one to Fiesion that would come next. 737 Youre Aduk Debut novel from fill Hergesh 724 Son/Fantasy MM-ESP AS5 3 The Ifiumplant, tragic, unimaginable third installment in the Mall ELSSC 693 6 Book Six of Esme's Ladies Nonfiction Long winded talkers those who listen. When you have something to bey, get to this point, Say it with snap! Sch/Fantasy 461 Fiction 201 Scifi/Fanboy Nonfiction Scifi/Fantasy MM.ESP Romance EL-SSC 1 An svic on the scale of Game of Thrones and The Lord of the Rings. The Miller 4 Book four of Fame's Ladies moking is a book that cannot be defined, only exponented. Romance ELSSC Youre Aduh 1 Book One of Fame's Ladies 656 Fiction MT-ESP Mr. Hidoo, with his kind smile and perpetual silence, is easy to overlook. Until he turns up dead. 773 Scity/Fantasy "The thing is, The Thing is' is ssacaly what you need. Don't believe me? Give ka Wv." 296 Fickson AT-ESP SO6 Memor Romance EL-SSC "Only a sister knows the difference between Book Three of Fame's Ladies tranale and a hug? 456 Memor Antrim's ability to make you laugh through your tears has never been Mystery toward a death for too soon, the journey is what matters. Fiction am of a man twice his age. "Who Did You Think You Wore Kidding" reminds us that even on a sad path The most anticipated release of the coming year! + = BOOK AUCTION + Into Award Checkouts ~ Edition * Publisher " Ratings ~ Series - Sales Q1 - Sales Q2 + Sales 03 Y Sales Q4 Type here to searchEB Bookshop (1) (1) .XLSX * @ @ File Edit View Insert Format Data Tools Help Last edit was 2 hours ago 100% - $ % .0 .00 123- Default (Ca. + 11|- B IS A . . = = 1 - H; - 7 9 # Q Y A1 PubID C D E H J K L 1 PublD M Publishing House City State Country Year Establisharketing Spend 2 CHP Cedar House Publishers Friday Harbor Washington USA 2086 72,000 3 SSC Sound & Seas Co. Dunedin Otago New Zealand 2153 151,000 4 PP Palimpsest Printing Edinburgh Scotland UK 1982 48,000 5 ESP Etaoin Shrdlu Press Seattle Washington USA 2069 2,320,000 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 + Book Author Info Award Checkouts Edition Publisher Ratings Series Sales Q1 - Type here to search O Si OBookshop (1) (1) .XLSX * @ File Edit View Insert Format Data Tools Help Last edit was 2 hours ago 100% - $ % .0_.00 123 Default (Ca. 11 AT fx SeriesID E F G H J K L M SeriesID Series Name Planned Volumes Book Tour Events 2 BS-CHP Banana Slug 24 3 MT-ESP Meddler Trilogy 17 EL-SSC Esme's Ladies 15 5 MM-ESP The Mallemaroking Saga 32 6 IR-ESP Inspector Ryesiton 19 AT-ESP The Aspall Trilogy 5 8 9 10 11 12 13 14 15 16 31 32 39 Book - Author Info Award Checkouts . Edition - Publisher Ratings - Series Sales Q1 * Sa Type here to search O