[SOLVED] Tableau Refining - Computer Science

I need help for assignment in tableau Refining and i will give the dataset and just help me to refine with the dataset. Assignment deadline is in 5 hours.

Sprint 4: Modules 7-8 Artifact
Refining your insights summary from modules 5-6 (100 points)

Scenario – You receive this email after submitting findings from an exploratory analysis:

Dear Favorite Analyst,

Thank you for sending over the first iteration for your insights summary, I’m excited about the progress you

are making. We need to continue refining the visuals and story to make sure it’s ready distribution to the

Senior Leadership team. Unfortunately, we will not have the opportunity to present the findings in a live Q&A

session so all of your insights need to be included in an artifact that can be read and easily understood without

having to be there to explain things.

Unfortunately, simply taking screenshots from Tableau won’t give us the professional, camera-ready aesthetic

we need to communicate. Many, visuals will likely need to be rebuilt so we can have more control over the

final look. We’ll want to add text annotations to further explain what the visual is communicating, but without

making people digest whole paragraphs. As you can imagine, senior leaders have more demands on their time

and attention they have hours in the day, so we’ll need to make sure they have the most important

information served up in a simple, clean, and concise way. They need to be able to consume the insights in

less than 10 minutes, so we’ll need to be deliberate about what we highlight, what we deemphasize, and how

the insights flow together.

Since we don’t have actual business context behind why this dataset was originally pulled together, we may

have to make assumptions about what’s at stake and why.

As you refine the deck, please review the assignment objectives, requirements, and submission

expectations below.

Please send the updated slide deck (PowerPoint) by the end of week (11:59 pm CT on Sunday); late

assignments will not be accepted. PDFs will not be accepted.

Thank you again for your help!

Sincerely,

Lack of Context Leonard

Refined Insights Summary Artifact Assignment Objectives:

I. Demonstrate you can minimize unnecessary cognitive load by

a. using consistent formatting (punctuation yes or no, font size, color, annotation methods,

spacing, indentation, etc.)

b. eliminating clutter (chart borders, gridlines, data markers, clean-up axis labels, labeling data

directly instead of legends & matching color, non-strategic use of contrast, etc).

c. eliminate distractions (misalignments, blurry pictures, unnecessary complexity, wordy, etc.)

II. Demonstrate that you can focus your audience’s attention by

a. Creating a visual hierarchy to follow

b. Leveraging pre-attentive attributes in your graphics (orientation, shapes, line length, line width,

size, curvature, added marks, enclosure, hue, color intensity, special position, motion, etc.)

c. Leveraging pre-attentive attributes in your text (color, size, case, outline/enclosure, bold, i

vamsi krishna reddy_Gujjula_M2Practice_EDA.twb

0
[Rx]

Count
true

1
“A1:T8400:no:A1:T8400:0”
true
2

0
[Distribution]

Count
true

1
“A1:G8038:no:A1:G8038:0”
true
6

Order ID
130
[Order ID]
[Rx]
Order ID
0
string
Count
true

“WSTR”

[Rx_364BD0B048CA4AAFB763B88106E71EE4]

Order Date
7
[Order Date]
[Rx]
Order Date
1
date
Year
true

“DATE”

[Rx_364BD0B048CA4AAFB763B88106E71EE4]

Dispensed Pharmacy Rep
130
[Dispensed Pharmacy Rep]
[Rx]
Dispensed Pharmacy Rep
2
string
Count
true

“WSTR”

[Rx_364BD0B048CA4AAFB763B88106E71EE4]

Dispensed Region
130
[Dispensed Region]
[Rx]
Dispensed Region
3
string
Count
true

Vamsi_Krishna_Reddy_Gujjula_Bookshop.twb

0
[Book]

Count
true

0
“A1:C59:no:A1:C59:0”
true
2

0
[Author]

Count
true

0
“A1:E42:no:A1:E42:0”
true
6

0
[Award]

Count
true

0
“A1:C19:no:A1:C19:0”
true
6

0
[Checkouts]

Count
true

Order ID Order Date Dispensed Pharmacy Rep Dispensed Region Dispensed State Dispensed Zip Code Drug Dosage Form Drug Name Drug Route Drug Supplier Market Segment TableauCeuticalSales Market Penetration % Discount Product Base Margin Market Size Rx Dollars Rx Profit Rx Quantity Unit Price

290 1/1/07 0:00 Dorris Love South North Carolina 28717 Ointment Albalon Extended Release Competitor A Human – OTC 0.05 0.36 188.73 188.73 -32.48 24 7.64

59232 1/1/07 0:00 Robert Waldorf South Virginia 23018 Ointment Propranolol Hydrochloride Intensol Iv (Infusion) Competitor A Human – OTC 0 0.4 725.43 725.43 245.97 23 30.98

1028 1/1/07 0:00 Matt Collins Central Michigan 48001 Concentrate Amantadine Hydrochloride Iv (Infusion) TableauCeutical Animal 2,021.15 100% 0.01 0.59 2,021.15 2,021.15 -60.39 11 205.99

57253 1/1/07 0:00 Darren Budd Central Texas 73301 Concentrate Alimta Iv (Infusion) TableauCeutical Animal 2,750.11 100% 0.04 0.55 2,750.11 2,750.11 667.449 25 125.99

1028 1/1/07 0:00 Matt Collins Central Michigan 48001 Suppository Tavist-D Sublingual TableauCeutical Animal 165.75 100% 0.03 0.4 165.75 165.75 -28.46 6 28.48

57253 1/1/07 0:00 Darren Budd Central Texas 73301 Syrup Cu-7 Delayed Release TableauCeutical Human – OTC 12,635.75 100% 0.07 0.8 12,635.75 12,635.75 -335.24 48 279.48

57253 1/1/07 0:00 Darren Budd Central Texas 73301 Lotion Claritin-D Extended Release TableauCeutical Human – OTC 78.08 100% 0.08 0.52 78.08 78.08 1.74 43 1.81

57253 1/1/07 0:00 Darren Budd Central Texas 73301 Syrup Corzide Intramuscular TableauCeutical Human – OTC 653.54 100% 0.06 0.78 653.54 653.54 -1,358.90 29 20.98

57253 1/1/07 0:00 Darren Budd Central Texas 73301 Tablet Caffeine Citrate Iv (Infusion) TableauCeutical Human – OTC 240.3 100% 0.08 0.36 240.3 240.3 -154.6175 49 4.91

32418 1/1/07 0:00 Marina Lichtenstein Central Michigan 49642 Capsule Piperacillin And Tazobactam Intramuscular TableauCeutical Human – Rx 1,244.19 100% 0.08 0.55 1,244.19 1,244.19 -131.31 5 243.98

13729 1/2/07 0:00 Matt Collister West Idaho 83877 Syrup Aminosyn 8.5% W/ Electrolytes Delayed Release Competitor A Human – OTC 0.08 0.82 872.48 872.48 -342.91 9 95.99

28774 1/2/07 0:00 Jessica Myrick Central Wisconsin 53081 Syrup Zanaflex Iv (Infusion) Competitor B Human – OTC 0.1 0.68 180.36 180.36 -111.8 32 5.98

44069 1/3/07 0:00 Elizabeth Moffitt East Connecticut 6928 Ointment Dilaudid Extended Release TableauCeutical Human – OTC 614.8 100% 0.08 0.39 614.8 614.8 247.79 43 15.04

44069 1/3/07 0:00 Elizabeth Moffitt East Connecticut 6928 Ointment Erythromycin Stearate Extended Release TableauCeutical Human – OTC 137.63 100% 0.09 0.4 137.63 137.63 26.71 16 9.11

9285 1/3/07 0:00 David Philippe East New York 14210 Tablet Dextrose 7.7% In Plastic Container Iv (Infusion) TableauCeutical Human – OTC 124.81 100% 0.06 0.36 124.81 124.81 -11.937 3 40.98

37537 1/3/07 0:00 Alan Schoenberger West Colorado 80001 Syrup Isovue-300 Iv (Infusion) TableauCeutical H

Read First – Joins

Worksheet Name Book Author Info Award Checkouts Edition Publisher Ratings Series Sales

Fields in the Worksheet
(# Unique Records) BookID (58) AuthID (41) BookID (58) Title (18) BookID (57) ISBN (95) PubID (4) BookID (57) SeriesID (6) Sale Date

Title (58) Author Name Genre Award Name CheckoutMonth BookID (57) Publishing House Rating Series Name ISBN (93)

AuthID (34) Birthday SeriesID
(7 incldng ‘blank’) Year Won Number of Checkouts Format City ReviewerID Planned Volumes Discount

Country of Residence Volume Number PubID (4) State ReviewID Book Tour Events ItemID

Hrs Writing per Day Staff Comment Publication Date Country OrderID

Pages Year Established

Print Run Size (k) Marketing Spend

Price

Keys are identified with color

How to create joins in Tableau

Join Order Left Join

1 Book with Author on [AuthID] Step 1 – Connect to the Bookshop Dataset Step 2 – Drag the Book sheet/table onto the canvas

2 Book with Award on [Title]

3 Book with Checkouts on [Book ID]

4 Book with Edition on [Book ID]

5 Book with Info on [Book ID]

6 Book with Ratings on [Book ID]

7 Edition with Publisher on [PubID]

8 Edition with Sales on [ISBN]

9 Info with Series on [SeriesID]

Step 3 – Double-click on the Book table in Canvas to open enable joins Step 4 – Drag the Author sheet/table onto the canvas to the right of Book table

Step 5 –

How the joins should look in Tableau

Book

BookID Title AuthID

BB194 Ballinby Boys AM329

NC652 Nothing But Capers AS443

AD222 Alanna Saves the Day BH149

PA169 Post Alley BM856

TC188 Thatchwork Cottage BM856

ZT703 Zero over Twelve BM856

PP866 Portmeirion BT132

RR774 Rystwyth BT132

TM925 The Mallemaroking BT132

CH391 Can I Be Honest? CF829

NL209 No More Lightning CF829

NR695 9803 North Millworks Road CS190

TH296 The Winchcombe Railway Museum Heist CS190

MM424 (im)Mortality CW626

TP887 the life and times of an utterly inconsequential person DB605

LS176 Land Water Sky Space EH487

AY135 And I Said Yes EK605

IA439 Interrobangs for All EK605

KA663 Kalakalal Avenue EK605

BF889 Banana Slug and the Glass Half Full GG800

NB483 Not to Gossip, But GG800

TI225 The Thing Is GG800

CP573 Concerning Prophecy GH671

BC244 Banana Slug and the Lost Cow HB302

BF374 Banana Slug and Xyr Friends HB302

CC830 Cimornul JH502

QQ737 Quiddity and Quoddity JH502

TH556 The Startling End of Mr. Hidhoo JK592

SS693 Say it with Snap! JS525

TH143 The Elephant House JS525

AM124 A Horrible Human with the Habits of a Monster KD840

TT359 Turn Left Til You Get There KE397

DR914 Dust on the Rim KY296

TC401 Tales of the Compass KY296

BS284 Burnished Silver LD375

DY800 Did You Hear? LD375

LB510 Lace and Brandy LD375

MW621 Muddy Waters LD375

SE355 Saint Esme LD375

TO369 The Scent of Oranges LD375

TS869 The Seawitch Sings LD375