Question
3. Open Sheet 1 and scan all dimensions and measure variables. 4. Convert Paid Wage Per Year and Prevailing Wage per Year from Dimensions to
3. Open Sheet 1 and scan all dimensions and measure variables.
4. Convert Paid Wage Per Year and Prevailing Wage per Year from Dimensions to Measures.
5. Now you are ready to do some data visualization and analysis tasks.
Deliverable -1
For this exercise, you will use Paid Wage Per Year as your Dependent variable. The Job Title Sub-group will be your Independent variable.
1 (a) Create a column chart showing the relationship between the above variables and sort them from highest to lowest wages. Note: use the Median value for Paid Wage Per Year while creating the graph.
- compare and show the general trend of paid wages of four data related job positions Business Analyst, Data Analyst, Data Scientist and Software Engineer. Filter the Job-Title Subgroup dimension to these four positions. 2. (a) Create line graphs for each of these 4 job title subgroups showing change in median wage per year from 2009 -2015, in a single visualization Hint: Use Job Title SubGroup, Case Received Date and Median Wage Per Year variables
2. (c) What change do you observe happening to the salaries for these four data-related jobs? Note your observation in the text entry box below.
Note; Please use tableau software to do it and show the process
P1 :Xfx COUNTRY_OF_CITIZENSHIPStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started