Create useful dashboards for each of the following databases Use appropriate charts and layouts (forexample, explain why you chose the elements of the dashboards and how a manager might use them ) a Presidents Inn ID Guest First Name Guest Last Name Room Room Type Arrival Date Departure Date No of Guests Daily Rate 1 Barry Lloyd Hayes Bay window 12 1 2014 12 4 2014 2 $150 00 2 Michael Lunsford Cleveland Ocean 12 1 2014 12 9 2014 3 $112 50 3 Kim Kyuong Coolidge Bay window 12 4 2014 12 7 2014 1 $150 00 4 Edward Holt Washington Ocean 12 1 2014 12 3 2014 4 $325 00 5 Thomas Collins Lincoln Ocean 12 9 2014 12 13 2014 2 $300 00 6 Paul Bodkin Coolidge Bay window 12 1 2014 12 3 2014 2 $150 00 7 Randall Battenburg Washington Ocean 12 4 2014 12 12 2014 2 $292 50 8 Calvin Nowotney Lincoln Ocean 12 2 2014 12 4 2014 1 $300 00 9 Homer Gonzalez Lincoln Ocean 12 5 2014 12 7 2014 5 $320 00 10 David Sanchez Jefferson Bay window 12 5 2014 12 7 2014 2 $175 00 11 Buster Whisler Jackson Ocean 12 5 2014 12 8 2014 2 $250 00 12 Julia Martines Reagan Bay window 12 10 2014 12 15 2014 1 $150 00 13 Samuel Kim Truman Side 12 20 2014 12 30 2014 3 $112 50 14 Arthur Gottfried Garfield Side 12 13 2014 12 15 2014 2 $125 00 15 Darlene Shore Arthur Ocean 12 24 2014 12 31 2014 5 $198 00 16 Carlyle Charleston Quincy Adams Bay window 12 3 2014 12 6 2014 2 $150 00 17 Albert Goldstone Johnson Ocean 12 5 2014 12 7 2014 3 $250 00 18 Charlene Tilson Van Buren Bay window 12 5 2014 12 7 2014 1 $150 00 19 Everett Chad Madison Ocean 12 10 2014 12 14 2014 2 $275 00 20 Gerald Pittsfield Roosevelt Ocean 12 5 2014 12 7 2014 2 $275 00 21 Jamal Smith Tyler Bay window 12 20 2014 12 23 2014 2 $150 00 22 Louis Paris Jackson Ocean 12 10 2014 12 14 2014 1 $250 00 23 Nigel Stratford Eisenhower Ocean 12 14 2014 12 16 2014 2 $200 00 24 Peter Willington Grant Ocean 12 19 2014 12 21 2014 1 $200 00 25 Ronald Cartier Jefferson Bay window 12 24 2014 12 28 2014 4 $175 00 26 Trista Leven Eisenhower Ocean 12 17 2014 12 20 2014 1 $200 00 27 Valerie Snell Adams Bay window 12 3 2014 12 6 2014 1 $150 00 28 Walter Acton Polk Side 12 24 2014 12 31 2014 6 $148 50 29 Xavier Trezza McKinley Side 12 14 2014 12 17 2014 2 $125 00 30 Zachary Miller Washington Ocean 12 13 2014 12 16 2014 2 $325 00

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 17, 2024

Create useful dashboards for each of the following databases. Use appropriate charts and layouts (forexample, explain why you chose the elements of the dashboards and

Create useful dashboards for each of the following databases. Use appropriate charts and layouts (forexample, explain why you chose the elements of the dashboards and how a manager might use them.) a. Presidents Inn

ID	Guest First Name	Guest Last Name	Room	Room Type	Arrival Date	Departure Date	No of Guests	Daily Rate
1	Barry	Lloyd	Hayes	Bay-window	12/1/2014	12/4/2014	2	$150.00
2	Michael	Lunsford	Cleveland	Ocean	12/1/2014	12/9/2014	3	$112.50
3	Kim	Kyuong	Coolidge	Bay-window	12/4/2014	12/7/2014	1	$150.00
4	Edward	Holt	Washington	Ocean	12/1/2014	12/3/2014	4	$325.00
5	Thomas	Collins	Lincoln	Ocean	12/9/2014	12/13/2014	2	$300.00
6	Paul	Bodkin	Coolidge	Bay-window	12/1/2014	12/3/2014	2	$150.00
7	Randall	Battenburg	Washington	Ocean	12/4/2014	12/12/2014	2	$292.50
8	Calvin	Nowotney	Lincoln	Ocean	12/2/2014	12/4/2014	1	$300.00
9	Homer	Gonzalez	Lincoln	Ocean	12/5/2014	12/7/2014	5	$320.00
10	David	Sanchez	Jefferson	Bay-window	12/5/2014	12/7/2014	2	$175.00
11	Buster	Whisler	Jackson	Ocean	12/5/2014	12/8/2014	2	$250.00
12	Julia	Martines	Reagan	Bay-window	12/10/2014	12/15/2014	1	$150.00
13	Samuel	Kim	Truman	Side	12/20/2014	12/30/2014	3	$112.50
14	Arthur	Gottfried	Garfield	Side	12/13/2014	12/15/2014	2	$125.00
15	Darlene	Shore	Arthur	Ocean	12/24/2014	12/31/2014	5	$198.00
16	Carlyle	Charleston	Quincy Adams	Bay-window	12/3/2014	12/6/2014	2	$150.00
17	Albert	Goldstone	Johnson	Ocean	12/5/2014	12/7/2014	3	$250.00
18	Charlene	Tilson	Van Buren	Bay-window	12/5/2014	12/7/2014	1	$150.00
19	Everett	Chad	Madison	Ocean	12/10/2014	12/14/2014	2	$275.00
20	Gerald	Pittsfield	Roosevelt	Ocean	12/5/2014	12/7/2014	2	$275.00
21	Jamal	Smith	Tyler	Bay-window	12/20/2014	12/23/2014	2	$150.00
22	Louis	Paris	Jackson	Ocean	12/10/2014	12/14/2014	1	$250.00
23	Nigel	Stratford	Eisenhower	Ocean	12/14/2014	12/16/2014	2	$200.00
24	Peter	Willington	Grant	Ocean	12/19/2014	12/21/2014	1	$200.00
25	Ronald	Cartier	Jefferson	Bay-window	12/24/2014	12/28/2014	4	$175.00
26	Trista	Leven	Eisenhower	Ocean	12/17/2014	12/20/2014	1	$200.00
27	Valerie	Snell	Adams	Bay-window	12/3/2014	12/6/2014	1	$150.00
28	Walter	Acton	Polk	Side	12/24/2014	12/31/2014	6	$148.50
29	Xavier	Trezza	McKinley	Side	12/14/2014	12/17/2014	2	$125.00
30	Zachary	Miller	Washington	Ocean	12/13/2014	12/16/2014	2	$325.00