I am trying to build a dashboard from the dataset(attached). The dataset is a survey questionnaire which is mapped to the data dictionary as given in Appendix tab. I have done the data mapping and cleansing.
I have prepared a dashboard (attached with the thread as well as loaded on the public server)as well:
https://public.tableau.com/profile/vinamra.mathur#!/vizhome/Book1_16029708058040/Sheet1
End Result Dashboard:
Need help (Question):
A survey on 500 respondents and asked six questions in the survey (Details in “Questions (CS 1)” of the attached excel file). The company needs to identify the % of respondents who answered 4 or 5 in each “Domain area” (Question 6).
We need to create the Tableau dashboard as per below requirements.
- Chart
o Primary axis: Create a bar chart of the number of respondents who answered 4 or
5 in Domain area (Q6)
o Secondary axis: Create a line chart showing split by countries on the same chart.
- Tooltip
o Bar chart: Area, # of respondents, % of respondents who answered 4 or 5
o Line chart: Country, Area, # of respondents, % of respondents who answered 4 or
5
- Filters: Add the following filters in dashboard:
o Country: UK, USA, India
o Job Type: IT/Software, Analytics, Core, Education
o Job Specialization: Electrical/Electronics, Mechanical, Civil, Industrial,
Infrastructure
- Filter should show “NA” for all the Job Types except Core
o Monthly Salary: Slider filter
o Activity: Office work, Music/Painting/Dancing, Sleep, School/College, Homework,
Sports, Others
o Domain Area: Area A-Q
Key pointers:
1. All filters except Monthly Salary should be Multiple Values Dropdown type
2. There should be a legend of countries.
Can Someone help me. I will mark the answer as best answer
