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 an Alteryx workflow to perform the data manipulations, transformations and
use the output of Alteryx to create the Tableau Dashboard
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.
o Sample dashboard attached – refer “Case study 1.jpg”
- 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
Expected Output
Alteryx workflow, Tableau dashboard
Key pointers:
1. All filters except Monthly Salary should be Multiple Values Dropdown type
2. There should be a legend of countries.
3. Add Note and Source text at bottom
4. Font should be “Arial”
I am stuck with designing the Alteryx workflow along with tableau dashboard. I am new to both the softwares and need help. This is a text question I am trying to solve would appreciate help and I will accept as correct answer to the person who helps me with this.
