Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data Source: Connect all six data tables with eight relationships using one relationship for each foreign key. 1. Insert an image showing your completed Data

image text in transcribedimage text in transcribedimage text in transcribed
Data Source: Connect all six data tables with eight relationships using one relationship for each foreign key. 1. Insert an image showing your completed Data Source. Sheet 1: How many locations, how many employees, and how many projects for each department name? 2. Answer your SELECT statement here. 3. Insert an image showing the query result from the SQL Server Management Studio. 4. Answer using coupled horizontal bars plot on Tableau. Set the bar color to gold. Rename sheet name and title. Insert an image showing your completed Sheet 1. Sheet 2: What are the full name and whole address for each employee in the order of zip codes? 5. Answer your SELECT statement here. 6. Insert an image showing the query result from the SQL Server Management Studio. T. Answer using a US symbol map plot on Tableau. Use zip code as a geographic role. I(Hint: Columns = Longitude 3: Rows = Latitude] Insert employee name and address into tooltip. Rename sheet name and title. Insert an image showing your completed Sheet 2. Sheet 3: How many hours did each employee work on each project organized by each department in the order of employee full name, department name then project name? 8. Answer your SELECT statement here. 9. Insert an image showing the query result from the SQL Server Management Studio. 10. Answer using a highlight table on Tableau. Filter out no hours, if any. Set the palette color to red, and set the min in legend to 0.00. Rename sheet name and title. Insert an image showing your completed Sheet 3. Sheet 4: For each employee, what are the total hours worked on all projects and the hour worked on each project? 11. Answer your SELECT statement here. 12. Insert an image showing the query result from the SQL Server Management Studio. 13. Answer using a treemag plot on Tableau. Set the palette color to green, and set the min in legend to 0.00. Rename sheet name and title. Insert an image showing your completed Sheet 4. Dashboard 1: 14. Create a dashboard of single vertical layout panels. Insert Sheet 1 onto the top, and add two horizontal layout panels below. Insert Sheet 2 onto the left of the middle panel. Insert Sheets 3 and 4 onto the left and the right of the bottom panel. lvlove tow legends onto the right of the middle panel. Adjust dashboard and panel sizes to avoid any vertical or horizontal scrollbar inside any W paneL Rename dashboard name. Insert an image showing your completed Dashboard 1. Data Source: Remove the relationships that were not used. 15. Insert an image showing your completed Data Source

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Granularity Theory With Applications To Finance And Insurance

Authors: Patrick Gagliardini, Christian Gourieroux, Christian Gouriéroux

1st Edition

1316057135, 9781316057131

More Books

Students also viewed these Economics questions

Question

In problem solve the equations. 4x 3 + 4 = x + 1

Answered: 1 week ago

Question

Could this be a case of a classically conditioned phobia?

Answered: 1 week ago