Question.4452 - Unit 4 Self-Check Assignment: Milligan Chapter 10 Welcome to your hands-on activity! This assignment invites you to work with Tableau using a mix of generated and real-world data. You will follow these steps:Download the attached spreadsheets, and upload those data sets into Tableau. If you need help loading your data sources, refer to the Unit 1 Self Check Assignment: Milligan Chapter 1Go through this document, and use Tableau to answer all the questions listed below. Where applicable, paste screenshots into the template below.When you are ready, complete the online quiz, which verifies your homework. Use the answers you found in this document to answer the questions. When you have completed the online quiz, submit the Word document.Remember, you can always ask your instructor for help if needed. If you need to adjust the size of your visualizations to match the options in the questions, use the “Format”-> “Cell size” options. For example, “Ctrl+Shift+B” on a Windows computer will make the visualization bigger, and “Ctrl+Up” will make it taller.This assignment contains 7 datasets and 6 icon files:Pacific West National Park Visitation 2001–2022Monthly Personal Budget (two worksheets: July and August)Video game sales2022 NYC Restaurant InspectionsSeptember 2023 Baltimore City Crime DataUniversity course completion ratesUniversity pass ratesIcon files:BiologyChemistryComputer ProgrammingData AnalyticsMathPhysicsQuestion 1: Bump chartYou have been asked to help the Northwest National Park system to find trends. Specifically, what do five-year visitation trends look like for the parks? Load the Pacific West National Park Visitation 2001–2022 into your data sources. Drag “Year” into the columns and create an ad hoc calculation in the row: SUM (Visitor Count). Then drag “Park Type.” Select only the “National Park” park type. Then, drag “Year” into the filters for the years 2018–2022. Keep in mind that the year 2020 will have anomalies due to the COVID-19 pandemic shutdown of many parks. Drag “Park Name” onto “Color” in the “Marks” tab and “Park Name” onto “Label.” Make sure the marks type is set to “Line.” Edit the label so that it shows the “Line Ends.” You should now have a bump chart that looks like this:From this chart, we can see that Yosemite, Olympic, and Death Valley all had [missing word], but they took downturns in 2020. They are rising again, but still not seeing the numbers they had previously. Joshua Tree, Mount Rainier, Hawaii Volcanoes, and Haleakala NP have increased visitors in 2022 compared to 2018.While this is helpful, the leadership has requested to see a chart with 10 years (2013–2022). They also want to see only national parks with at least 1 million visitors annually. Add both filters to your bump chart. Add Visitor Count as a Label. Question 1A: For the Yosemite NP, was there an increase or decrease between 2013 and 2022?Question 1A Answer:<<insert your screenshot>>Question 1B: What was the highest visitor count for Yosemite NP between 2013 and 2022?Question 1B Answer:<<insert your screenshot>>Question 2: Waterfall Your friend is always complaining to you that they can’t save any money and their bank account is always going down. You ask your friend to write down all the expenses and income in a month, and you record them in the Monthly Personal Budget: July. For each expense, you have tracked the date, type, whether it is income, fixed, or discretionary, and the amount (negative for expenses and positive for income). Load the dataset into Tableau and choose the July worksheet to start. Create a waterfall chart of the July data by dragging the “Income/Fixed/Discretionary” and “Type” dimensions into the columns. Then drag “Amount” into the rows. Because we want to see the total as the month goes on, we will create a running total calculation using table across. To do this, first, right-click “Amount” and select “Add Table Calculation…”. This should bring up the following window, ... in which you should change the Calculation Type and Compute Using to match: Drag the “Amount” measure onto Color, Size, and Label in the Marks tab. Change the chart type to “Gantt Bar.”Double-click on “SUM(Amount)” on Size and edit in the shelf. Add a negative sign before the SUM([Amount]).Change the “SUM(Amount)” on Label to be a Running Total. Your waterfall chart should be taking shape now. You should see something similar to the following image:Now, we can see quickly that your friend spent $794 in the month of July just on discretionary spending. Then by the time they paid their rent, they had spent a total of $4,960 for the month. They make $4,140 from their regular job and another $805 from side gigs. This means that in July, your friend overspent their monthly income by $15 dollars. If they spend like that every month, that means they are overspending $180 a year. Your friend would really like to start saving money, so you help them go through expenses and try to spend less money. Now, they return with their August expenses (another worksheet in the Monthly Personal Budget), and they want to see the same chart. Question 2: How much money did your friend save this month? Provide your answer rounded to the nearest dollar (no cents). Question 2 Answer:<<insert your screenshot>>Question 3: Step linesFor this exercise, you will be using the “Video game sales” data set to answer questions about how certain genres have performed by global sales in the last five years. Drag “Genre” over to Columns and “Global Sales” into Rows. Add a quick calculation of Running Total to the “Global Sales.” Drag “Global Sales” onto Color in the Marks tab.Filter by Years 2011 to 2016.Change the Marks type to “Line,” and then click on “Path” and choose “Step.”Click on Ctrl+Shift+B (or CMD+Shift+B if you’re on a Mac) a few times to make the graph wider (this might help to read the bottom axis better).We can see that shooter games had a significant step within global sales between 2011 and 2016.However, we can see that action starts around $140. Let’s modify this a bit. Right-click on “Genre” in the columns area, click on the “Sort” function. We want to sort by Field, Ascending, Field Name-Global Sales, and Aggregation type: Sum. Now, we can see where the calculation starts in the bottom left corner with Fighting and slowly steps up until we get to Action and then Shooter games, where we see two big jumps. This is a better representation of the step-line chart. Now, change the years to 2006–2010. Question 3: What is the top-selling genre? What was the amount of global sales for that genre? Option A: Role-playing, 316.1Option B: Shooter, 899.3Option C: Action, 437.4Option D: Sports, 209.4Question 3 Answer:<<insert your screenshot>>Question 4: Sparklines You are being asked to find trends about the New York City Health Department Restaurant Inspections. There are over 27,0000 restaurants in the five boroughs of New York City. You need to load the data source: 2022 NYC Restaurant Inspections. This is a rather large data source and may take a little longer to load the data. When restaurants have violations, they receive scores for each violation. Therefore, restaurants want low scores, and high scores are not desirable. Grades A–C are assigned to restaurants based on their scores. Restaurants with scores of 0 to 13 receive an “A.” If they score between 14 and 27, they receive a “B.” A “C” grade is 28 or more. If you would like to read more, see ABCEats-Restaurants. Drag “Inspection Date” into columns and “Boro” into rows. Now pull “Score” into the row, and change the aggregation to “Average” instead of sum. Change the date from ”Year” to ”Week Number” (right-click on the inspection date field in columns). Right-click in the line graph area, and click on format. Then click on the Lines icon, and turn off the gridlines. Widen the “Boro” column to make it easier to read the names of each borough. Your sparkline chart should look like the following image:We can see that this is very sporadic data that doesn’t really show a clear pattern. Add “Grade” to the filters, and select A, B, and C. Next, add Grades to the color mark. Question 4a: Based on these sparklines, which grade (A, B, or C) has a steady average score throughout the year for each borough (boro)?ABCQuestion 4A Answer:Question 4b: Using the sparklines, which grade had the biggest average swings (increases and decreases) over the year?ABCQuestion 4B Answer:Question 5: DumbbellIn this exercise, you will look for crime patterns in the City of Baltimore that occur inside versus outside. To do this, we will use the dumbbell method. First, load the data source: September 2023 Baltimore City Crime Data: All Districts into Tableau, and start a new worksheet. Drag the “All districts (Count)” measure into columns. Repeat this again (you will have two next to each other). Now drag “District” into the rows. Move “Inside Outside” into filters, and choose “Inside and Outside.” Right-click on the “CNT(All Districts)” column on the right, and select “Dual Axis.”In the Marks area, change the first CNT(All Districts) to be a line. Drag “Inside Outside” onto the path marks area. Make sure the second CNT(All Districts) mark is a circle. Now, drag “Inside Outside” onto the color inside that Marks menu. You should have dumbbells that look like the following image:Question 5: Which district has a different pattern of inside crimes versus outside crimes compared to the other districts?Option A: CentralOption B: NortheasternOption C: WesternOption D: SouthwesternQuestion 5 Answer:Question 6: Unit/symbolWe will be analyzing enrollment versus room capacity for a university. Load the dataset University courses and completion rates. Create a scatterplot by dragging “Student enrollment” and “Student Completed” onto columns and rows. Now, we are going to make groups for each subject. Right-click on the “Course Number” dimension, highlight all the BIO classes, and click Group.Repeat this for CHE, CSI, DTA, MAT, and PHY. After you finish this, change the field name to “Subjects.”Now, drag that new field, “Subjects,” onto the “Shapes” mark. We get a scatterplot that looks like this:The problem is that our user has to look at the legend on the right to know what the subjects are. Let’s eliminate this problem by adding icons to make it easier for the user to read our graph. Download the six icon image files that were provided to you in the assignment. You need to save them into your Tableau Repository file. To find out where that file is, go under File ->Repository LocationMake a note of the location where your Tableau Repository is located. In the image above, it is located in “Documents.” Go to the location of your Tableau Repository, and create a new folder called “University subjects.” Then copy and paste the six images provided to you into this folder. Return to the scatterplot you made. Click on the “Shape” mark. Change the Shape Palette from Default to University subjects. If you don’t see the shapes, click on “Reload Shapes.” Now, you will assign the data item on the left to the appropriate icon on the right. They are both in alphabetical order. Click “Apply” when you are finished. Your scatterplot probably has very small icons now:Click the Size Marks, and move the slider to the next-to-last position. Hide the legend card. Now, your scatterplot should be easy to interpret.Question 6: Which subject has the lowest number of students enrolled and courses completed?A: MathB: Computer ScienceC: Data AnalyticsD: PhysicsQuestion 6 Answer:Question 7: Marimekko The University we have been working with has asked for an analysis of the student pass/fail rates by major/nonmajor within six departments. Load the dataset: University pass rates. Drag “Department,” “Major/NonMajor,” and “Pass/Fail” into rows. Drag “Students” onto the Label. You should see a simple table. If we want to create a visualization across the three dimensions, we can create a Marimekko chart.We need to create two calculated fields that will help us to get the right level of detail calculation for this analysis:“Students per column” Syntax: {EXCLUDE [Pass/Fail]: SUM([Students])}“# of students” Syntax: IF FIRST()==0 THENMIN([Students per column])ELSEIF MIN([Department]) != LOOKUP(MIN([Department]),-1) THENPREVIOUS_VALUE(0) + MIN([Students per column])ELSEIF MIN([Major/NonMajor]) != LOOKUP(MIN([Major/NonMajor]),-1) THENPREVIOUS_VALUE(0) + MIN([Students per column])ELSEPREVIOUS_VALUE(0)ENDMove the three dimensions “Department,” “Major/NonMajor,” and “Pass/Fail” out of the rows and into the detail of the Marks area. Drag the new calculated field: "# of students” into columns. Right-click to create a table calculation using across the dimensions “Department,” “Major/NonMajor,” and “Pass/Fail.”Drag the measure “Students” up into rows. Right-click, add table calculation: Percent of total, and compute using Pass/Fail. Change the graph chart from Automatic to Bar. Drag “Students per column” into the size marks. Click on the Size box, and change it to Fixed and Right alignment. Drag “Pass/Fail” onto the Color mark. You should now have a bar chart like this:Set a filter for “majors” only. Add “Department” to the label. Change the Label setting to “Allow labels to overlap.” Question 7a: Which department had the most majors fail? (Hint: hover over the bars to look at the tooltips). A: BiologyB: ChemistryC: Computer ScienceD: Data AnalyticsE: PhysicsQuestion 7a Answer:Question 7b: What percentage of that department (from 7a) failed? (Hint: hover over the bars to look at the tooltips). Question 7b Answer:Question 8: Animated For this animation, we will create a scatterplot using the Video game sales dataset. Create a new worksheet. Drag the measures “Global Sales” into columns and “Rank” into rows. Leave the aggregation as a SUM.Drag “Platform” into Color. Change the Mark type to Circle. Click the size button to increase the size.Drag “Genre” and “Platform” into the filters. Right-click, and select “Show filter” for each. Click “ok.” Make sure you have a blank scatterplot by ensuring no filters are selected. Go up to the Format Menu, and select Animations. In your filters, click “PS” for the Platform and “Role-Playing” for Genre. Make a note of where the dot is located on the graph. What color is the dot?Now, click “DS” for Platform; you should have two dots. Then click on “Puzzle” for Genre to add it as a filter. Question 8: What happened to the PS dot? You can unclick the filters and apply them again to watch the animation. Option A: Nothing changedOption B: The PS dot dropped Option C: The PS dot liftedOption D: Both drops became equalQuestion 8 Answer:
Answer Below:
Unit xxxxxxxxxx Assignment xxxxxxxx Chapter xxxxxxx to xxxx hands-on xxxxxxxx This xxxxxxxxxx invites xxx to xxxx with xxxxxxx using x mix xx generated xxx real-world xxxx You xxxx follow xxxxx steps xxxxxxxx the xxxxxxxx spreadsheets xxx upload xxxxx data xxxx into xxxxxxx If xxx need xxxx loading xxxx data xxxxxxx refer xx the xxxx Self xxxxx Assignment xxxxxxxx Chapter xx through xxxx document xxx use xxxxxxx to xxxxxx all xxx questions xxxxxx below xxxxx applicable xxxxx screenshots xxxx the xxxxxxxx below xxxx you xxx ready xxxxxxxx the xxxxxx quiz xxxxx verifies xxxx homework xxx the xxxxxxx you xxxxx in xxxx document xx answer xxx questions xxxx you xxxx completed xxx online xxxx submit xxx Word xxxxxxxx Remember xxx can xxxxxx ask xxxx instructor xxx help xx needed xx you xxxx to xxxxxx the xxxx of xxxx visualizations xx match xxx options xx the xxxxxxxxx use xxx Format x Cell xxxx options xxx example xxxx Shift x on x Windows xxxxxxxx will xxxx the xxxxxxxxxxxxx bigger xxx Ctrl xx will xxxx it xxxxxx This xxxxxxxxxx contains xxxxxxxx and xxxx files xxxxxxx West xxxxxxxx Park xxxxxxxxxx Monthly xxxxxxxx Budget xxx worksheets xxxx and xxxxxx Video xxxx sales xxx Restaurant xxxxxxxxxxxxxxxxxxxx Baltimore xxxx Crime xxxxxxxxxxxxxx course xxxxxxxxxx ratesUniversity xxxx ratesIcon xxxxx BiologyChemistryComputer xxxxxxxxxxxxxxx AnalyticsMathPhysicsQuestion xxxx chartYou xxxx been xxxxx to xxxx the xxxxxxxxx National xxxx system xx find xxxxxx Specifically xxxx do xxxxxxxxx visitation xxxxxx look xxxx for xxx parks xxxx the xxxxxxx West xxxxxxxx Park xxxxxxxxxx into xxxx data xxxxxxx Drag xxxx into xxx columns xxx create xx ad xxx calculation xx the xxx SUM xxxxxxx Count xxxx drag xxxx Type xxxxxx only xxx National xxxx park xxxx Then xxxx Year xxxx the xxxxxxx for xxx years xxxx in xxxx that xxx year xxxx have xxxxxxxxx due xx the xxxxxx pandemic xxxxxxxx of xxxx parks xxxx Park xxxx onto xxxxx in xxx Marks xxx and xxxx Name xxxx Label xxxx sure xxx marks xxxx is xxx to xxxx Edit xxx label xx that xx shows xxx Line xxxx You xxxxxx now xxxx a xxxx chart xxxx looks xxxx this xxxx this xxxxx we xxx see xxxx Yosemite xxxxxxx and xxxxx Valley xxx had xxxxxxx word xxx they xxxx downturns xx They xxx rising xxxxx but xxxxx not xxxxxx the xxxxxxx they xxx previously xxxxxx Tree xxxxx Rainier xxxxxx Volcanoes xxx Haleakala xx have xxxxxxxxx visitors xx compared xx While xxxx is xxxxxxx the xxxxxxxxxx has xxxxxxxxx to xxx a xxxxx with xxxxx They xxxx want xx see xxxx national xxxxx with xx least xxxxxxx visitors xxxxxxxx Add xxxx filters xx your xxxx chart xxx Visitor xxxxx as x Label xxxxxxxx A xxx the xxxxxxxx NP xxx there xx increase xx decrease xxxxxxx and xxxxxxxx A xxxxxx DecreaseQuestion x What xxx the xxxxxxx visitor xxxxx for xxxxxxxx NP xxxxxxx and xxxxxxxx B xxxxxx Question xxxxxxxxx Your xxxxxx is xxxxxx complaining xx you xxxx they xxx t xxxx any xxxxx and xxxxx bank xxxxxxx is xxxxxx going xxxx You xxx your xxxxxx to xxxxx down xxx the xxxxxxxx and xxxxxx in x month xxx you xxxxxx them xx the xxxxxxx Personal xxxxxx July xxx each xxxxxxx you xxxx tracked xxx date xxxx whether xx is xxxxxx fixed xx discretionary xxx the xxxxxx negative xxx expenses xxx positive xxx income xxxx the xxxxxxx into xxxxxxx and xxxxxx the xxxx worksheet xx start xxxxxx a xxxxxxxxx chart xx the xxxx data xx dragging xxx Income xxxxx Discretionary xxx Type xxxxxxxxxx into xxx columns xxxx drag xxxxxx into xxx rows xxxxxxx we xxxx to xxx the xxxxx as xxx month xxxx on xx will xxxxxx a xxxxxxx total xxxxxxxxxxx using xxxxx across xx do xxxx first xxxxxxxxxxx Amount xxx select xxx Table xxxxxxxxxxx This xxxxxx bring xx the xxxxxxxxx window xx which xxx should xxxxxx the xxxxxxxxxxx Type xxx Compute xxxxx to xxxxx Drag xxx Amount xxxxxxx onto xxxxx Size xxx Label xx the xxxxx tab xxxxxx the xxxxx type xx Gantt xxx Double-click xx SUM xxxxxx on xxxx and xxxx in xxx shelf xxx a xxxxxxxx sign xxxxxx the xxx Amount xxxxxx the xxx Amount xx Label xx be x Running xxxxx Your xxxxxxxxx chart xxxxxx be xxxxxx shape xxx You xxxxxx see xxxxxxxxx similar xx the xxxxxxxxx image xxx we xxx see xxxxxxx that xxxx friend xxxxx in xxx month xx July xxxx on xxxxxxxxxxxxx spending xxxx by xxx time xxxx paid xxxxx rent xxxx had xxxxx a xxxxx of xxx the xxxxx They xxxx from xxxxx regular xxx and xxxxxxx from xxxx gigs xxxx means xxxx in xxxx your xxxxxx overspent xxxxx monthly xxxxxx by xxxxxxx If xxxx spend xxxx that xxxxx month xxxx means xxxx are xxxxxxxxxxxx a xxxx Your xxxxxx would xxxxxx like xx start xxxxxx money xx you xxxx them xx through xxxxxxxx and xxx to xxxxx less xxxxx Now xxxx return xxxx their xxxxxx expenses xxxxxxx worksheet xx the xxxxxxx Personal xxxxxx and xxxx want xx see xxx same xxxxx Question xxx much xxxxx did xxxx friend xxxx this xxxxx Provide xxxx answer xxxxxxx to xxx nearest xxxxxx no xxxxx Question xxxxxx Question xxxx linesFor xxxx exercise xxx will xx using xxx Video xxxx sales xxxx set xx answer xxxxxxxxx about xxx certain xxxxxx have xxxxxxxxx by xxxxxx sales xx the xxxx five xxxxx Drag xxxxx over xx Columns xxx Global xxxxx into xxxx Add x quick xxxxxxxxxxx of xxxxxxx Total xx the xxxxxx Sales xxxx Global xxxxx onto xxxxx in xxx Marks xxx Filter xx Years xx Change xxx Marks xxxx to xxxx and xxxx click xx Path xxx choose xxxx Click xx Ctrl xxxxx B xx CMD xxxxx B xx you xx on x Mac x few xxxxx to xxxx the xxxxx wider xxxx might xxxx to xxxx the xxxxxx axis xxxxxx We xxx see xxxx shooter xxxxx had x significant xxxx within xxxxxx sales xxxxxxx and xxxxxxx we xxx see xxxx action xxxxxx around xxx s xxxxxx this x bit xxxxxxxxxxx on xxxxx in xxx columns xxxx click xx the xxxx function xx want xx sort xx Field xxxxxxxxx Field xxxxxxxxxxx Sales xxx Aggregation xxxx Sum xxx we xxx see xxxxx the xxxxxxxxxxx starts xx the xxxxxx left xxxxxx with xxxxxxxx and xxxxxx steps xx until xx get xx Action xxx then xxxxxxx games xxxxx we xxx two xxx jumps xxxx is x better xxxxxxxxxxxxxx of xxx step-line xxxxx Now xxxxxx the xxxxx to xxxxxxxx What xx the xxxxxxxxxxx genre xxxx was xxx amount xx global xxxxx for xxxx genre xxxxxx A xxxxxxxxxxxx Option x Shooter xxxxxx C xxxxxx Option x Sports xxxxxxxx Answer xxxxxx DSports xxxxxxxx Sparklines xxx are xxxxx asked xx find xxxxxx about xxx New xxxx City xxxxxx Department xxxxxxxxxx Inspections xxxxx are xxxx restaurants xx the xxxx boroughs xx New xxxx City xxx need xx load xxx data xxxxxx NYC xxxxxxxxxx Inspections xxxx is x rather xxxxx data xxxxxx and xxx take x little xxxxxx to xxxx the xxxx When xxxxxxxxxxx have xxxxxxxxxx they xxxxxxx scores xxx each xxxxxxxxx Therefore xxxxxxxxxxx want xxx scores xxx high xxxxxx are xxx desirable xxxxxx A x are xxxxxxxx to xxxxxxxxxxx based xx their xxxxxx Restaurants xxxx scores xx to xxxxxxx an x If xxxx score xxxxxxx and xxxx receive x B x C xxxxx is xx more xx you xxxxx like xx read xxxx see xxxxxxxxxxxxxxxxxxx Drag xxxxxxxxxx Date xxxx columns xxx Boro xxxx rows xxx pull xxxxx into xxx row xxx change xxx aggregation xx Average xxxxxxx of xxx Change xxx date xxxx Year xx Week xxxxxx right-click xx the xxxxxxxxxx date xxxxx in xxxxxxx Right-click xx the xxxx graph xxxx and xxxxx on xxxxxx Then xxxxx on xxx Lines xxxx and xxxx off xxx gridlines xxxxx the xxxx column xx make xx easier xx read xxx names xx each xxxxxxx Your xxxxxxxxx chart xxxxxx look xxxx the xxxxxxxxx image xx can xxx that xxxx is xxxx sporadic xxxx that xxxxx t xxxxxx show x clear xxxxxxx Add xxxxx to xxx filters xxx select x B xxx C xxxx add xxxxxx to xxx color xxxx Question x Based xx these xxxxxxxxxx which xxxxx A x or x has x steady xxxxxxx score xxxxxxxxxx the xxxx for xxxx borough xxxx ABCQuestion x Answer xxxxxxxxx b xxxxx the xxxxxxxxxx which xxxxx had xxx biggest xxxxxxx swings xxxxxxxxx and xxxxxxxxx over xxx year xxxxxxxxxxx B xxxxxx CQuestion xxxxxxxxxx this xxxxxxxx you xxxx look xxx crime xxxxxxxx in xxx City xx Baltimore xxxx occur xxxxxx versus xxxxxxx To xx this xx will xxx the xxxxxxxx method xxxxx load xxx data xxxxxx September xxxxxxxxx City xxxxx Data xxx Districts xxxx Tableau xxx start x new xxxxxxxxx Drag xxx All xxxxxxxxx Count xxxxxxx into xxxxxxx Repeat xxxx again xxx will xxxx two xxxx to xxxx other xxx drag xxxxxxxx into xxx rows xxxx Inside xxxxxxx into xxxxxxx and xxxxxx Inside xxx Outside xxxxxxxxxxx on xxx CNT xxx Districts xxxxxx on xxx right xxx select xxxx Axis xx the xxxxx area xxxxxx the xxxxx CNT xxx Districts xx be x line xxxx Inside xxxxxxx onto xxx path xxxxx area xxxx sure xxx second xxx All xxxxxxxxx mark xx a xxxxxx Now xxxx Inside xxxxxxx onto xxx color xxxxxx that xxxxx menu xxx should xxxx dumbbells xxxx look xxxx the xxxxxxxxx image xxxxxxxx Which xxxxxxxx has x different xxxxxxx of xxxxxx crimes xxxxxx outside xxxxxx compared xx the xxxxx districts xxxxxx A xxxxxxxxxxxxx B xxxxxxxxxxxxxxxxxx C xxxxxxxxxxxxx D xxxxxxxxxxxxxxxxxxxx Answer xxxxxx D xxxxxxxxxxxxxxxxxxxx Unit xxxxxxxx will xx analyzing xxxxxxxxxx versus xxxx capacity xxx a xxxxxxxxxx Load xxx dataset xxxxxxxxxx courses xxx completion xxxxx Create x scatterplot xx dragging xxxxxxx enrollment xxx Student xxxxxxxxx onto xxxxxxx and xxxx Now xx are xxxxx to xxxx groups xxx each xxxxxxx Right-click xx the xxxxxx Number xxxxxxxxx highlight xxx the xxx classes xxx click xxxxx Repeat xxxx for xxx CSI xxx MAT xxx PHY xxxxx you xxxxxx this xxxxxx the xxxxx name xx Subjects xxx drag xxxx new xxxxx Subjects xxxx the xxxxxx mark xx get x scatterplot xxxx looks xxxx this xxx problem xx that xxx user xxx to xxxx at xxx legend xx the xxxxx to xxxx what xxx subjects xxx Let x eliminate xxxx problem xx adding xxxxx to xxxx it xxxxxx for xxx user xx read xxx graph xxxxxxxx the xxx icon xxxxx files xxxx were xxxxxxxx to xxx in xxx assignment xxx need xx save xxxx into xxxx Tableau xxxxxxxxxx file xx find xxx where xxxx file xx go xxxxx File x Repository xxxxxxxxxxxx a xxxx of xxx location xxxxx your xxxxxxx Repository xx located xx the xxxxx above xx is xxxxxxx in xxxxxxxxx Go xx the xxxxxxxx of xxxx Tableau xxxxxxxxxx and xxxxxx a xxx folder xxxxxx University xxxxxxxx Then xxxx and xxxxx the xxx images xxxxxxxx to xxx into xxxx folder xxxxxx to xxx scatterplot xxx made xxxxx on xxx Shape xxxx Change xxx Shape xxxxxxx from xxxxxxx to xxxxxxxxxx subjects xx you xxx t xxx the xxxxxx click xx Reload xxxxxx Now xxx will xxxxxx the xxxx item xx the xxxx to xxx appropriate xxxx on xxx right xxxx are xxxx in xxxxxxxxxxxx order xxxxx Apply xxxx you xxx finished xxxx scatterplot xxxxxxxx has xxxx small xxxxx now xxxxx the xxxx Marks xxx move xxx slider xx the xxxxxxxxxxxx position xxxx the xxxxxx card xxx your xxxxxxxxxxx should xx easy xx interpret xxxxxxxx Which xxxxxxx has xxx lowest xxxxxx of xxxxxxxx enrolled xxx courses xxxxxxxxx A xxxxx Computer xxxxxxxx Data xxxxxxxxxx PhysicsQuestion xxxxxx D xxxxxxxxxxxxxxx Marimekko xxx University xx have xxxx working xxxx has xxxxx for xx analysis xx the xxxxxxx pass xxxx rates xx major xxxxxxxx within xxx departments xxxx the xxxxxxx University xxxx rates xxxx Department xxxxx NonMajor xxx Pass xxxx into xxxx Drag xxxxxxxx onto xxx Label xxx should xxx a xxxxxx table xx we xxxx to xxxxxx a xxxxxxxxxxxxx across xxx three xxxxxxxxxx we xxx create x Marimekko xxxxx We xxxx to xxxxxx two xxxxxxxxxx fields xxxx will xxxx us xx get xxx right xxxxx of xxxxxx calculation xxx this xxxxxxxx Students xxx column xxxxxx EXCLUDE xxxx Fail xxx Students xx students xxxxxx IF xxxxx THENMIN xxxxxxxx per xxxxxx ELSEIF xxx Department xxxxxx MIN xxxxxxxxxx - xxxxxxxxxxxx VALUE xxx Students xxx column xxxxxx MIN xxxxx NonMajor xxxxxx MIN xxxxx NonMajor x THENPREVIOUS xxxxx MIN xxxxxxxx per xxxxxx ELSEPREVIOUS xxxxx ENDMove xxx three xxxxxxxxxx Department xxxxx NonMajor xxx Pass xxxx out xx the xxxx and xxxx the xxxxxx of xxx Marks xxxx Drag xxx new xxxxxxxxxx field xx students xxxx columns xxxxxxxxxxx to xxxxxx a xxxxx calculation xxxxx across xxx dimensions xxxxxxxxxx Major xxxxxxxx and xxxx Fail xxxx the xxxxxxx Students xx into xxxx Right-click xxx table xxxxxxxxxxx Percent xx total xxx compute xxxxx Pass xxxx Change xxx graph xxxxx from xxxxxxxxx to xxx Drag xxxxxxxx per xxxxxx into xxx size xxxxx Click xx the xxxx box xxx change xx to xxxxx and xxxxx alignment xxxx Pass xxxx onto xxx Color xxxx You xxxxxx now xxxx a xxx chart xxxx this xxx a xxxxxx for xxxxxx only xxx Department xx the xxxxx Change xxx Label xxxxxxx to xxxxx labels xx overlap xxxxxxxx a xxxxx department xxx the xxxx majors xxxx Hint xxxxx over xxx bars xx look xx the xxxxxxxx A xxxxxxxx ChemistryC xxxxxxxx ScienceD xxxx AnalyticsE xxxxxxxxxxxxxxx a xxxxxx Computer xxxxxxxxxxxxxxx b xxxx percentage xx that xxxxxxxxxx from x failed xxxx hover xxxx the xxxx to xxxx at xxx tooltips xxxxxxxx b xxxxxx Question xxxxxxxx For xxxx animation xx will xxxxxx a xxxxxxxxxxx using xxx Video xxxx sales xxxxxxx Create x new xxxxxxxxx Drag xxx measures xxxxxx Sales xxxx columns xxx Rank xxxx rows xxxxx the xxxxxxxxxxx as x SUM xxxx Platform xxxx Color xxxxxx the xxxx type xx Circle xxxxx the xxxx button xx increase xxx size xxxx Genre xxx Platform xxxx the xxxxxxx Right-click xxx select xxxx filter xxx each xxxxx ok xxxx sure xxx have x blank xxxxxxxxxxx by xxxxxxxx no xxxxxxx are xxxxxxxx Go xx to xxx Format xxxx and xxxxxx Animations xx your xxxxxxx click xx for xxx Platform xxx Role-Playing xxx Genre xxxx a xxxx of xxxxx the xxx is xxxxxxx on xxx graph xxxx color xx the xxx Now xxxxx DS xxx Platform xxx should xxxx two xxxx Then xxxxx on xxxxxx for xxxxx to xxx it xx a xxxxxx Question xxxx happened xx the xx dot xxx can xxxxxxx the xxxxxxx and xxxxx them xxxxx to xxxxx the xxxxxxxxx Option x Nothing xxxxxxxxxxxxx B xxx PS xxx dropped xxxxxx C xxx PS xxx liftedOption x Both xxxxx became xxxxxxxxxxxxx Answer xxxxxx B xxx PS xxx droppedMore Articles From Data visualization
.ico)
.ico)
.ico)
.ico)
