Effectiveness by Customer Experience

The Chief Operations Officer has asked me to provide him some information so he can understand how some training programs have impacted interactions with our clients and their experience. I have worked with the Client Services team to get a year’s worth of data (from 2017) for our flight attendant employees and myself have pulled some data on them to capture their assigned route and crew as well as information about which cohort they recruited with and the trainer who worked with them. The data is attached. I am needing you to bring all of this together data and build a few simple visualizations to help me figure out the following Also if you can I need to try and be able to look at the number of compliments in context to the number of complaints. I mean a million compliments doesn’t mean much if there 10 million complaints right? Thanks Rebecca Structure and clean the data provided and build a dashboard with visualizations that answer the five items in Rebecca’s email. Guided Instructions a. Three sheets with flight attendant performance i.All Data proved pertains only for the year 2017 ii.Data are organized in columns by month and type of response 1. 1/1/2017 – Compliment | 1/1/2017 – Complaint b. One sheet with employee information that contains: i.Ensure for the technique the requirements are met. ii.See Additional Guidance 5 a. See Additional Guide 4b i. Should contain Compliments and Complaints in the column i. Month (Two Options) 1. Option 1: Apply Aliases a. 1 is January; 2 is February…. 2. Option 2: Create a new field a. Add a Calculated Field CASE [Month] WHEN “1” THEN “January” WHEN “2” THEN “February” [continue the logic for the remaining months] WHEN “11” THEN “November” WHEN “12” THEN “December” ELSE “ERROR” END i.Rename “Cohort” ii.Rename “Trainer” i.Rename “Crew” ii.Rename “Crew Member Number” iii.Note: these fields have a hierarchical relationship to the Route and each other 1. Route ® Crew® Crew Member i. To form distinct crews by route create a New Calculated Field i.All should have Clear Titles ii.Vertical Scrolling is Permitted on all but the visualization on Monthly Complaints f. Include a small note with your name in the lower bottom right i. Dashboard designer: [yourname] Requirements: Any and all help would be appreciated! Im at a loss and out of time! Please help! Which routes have the highest number complaints? Which months have the highest number complaints? Which crews have the most compliments? Which cohorts have the most compliments? Which trainers have the flight attendants that have the most compliments? Open the Excel file using Excel and inspect the sheets Performance data sheets needs to be brought together and the employee information added on. Open Sheet 1 Pivot Performance Data Split and relabel Pivot Field Names into two fieldsRelabel one as Response TypeRelabel the other as Month Relabel one as Response Type Relabel the other as Month Split and relabel field names for Co-Train and Cr-MmCo-TrainCr-Mm Co-Train Cr-Mm Relabel Pivot Field Values“Response Count” “Response Count” Build a Visualization in a new sheet to answer: Which routes have the highest number complaints? a. Horizontal Bar ChartSort Highest to LowestCounts (marks) should be visibleClear clutter where you can Sort Highest to Lowest Counts (marks) should be visible Clear clutter where you can Build a Visualization in a new sheet to answer: Which months have the highest number complaints? a. Vertical Bar ChartOrder by chronological sequenceCounts (marks) should be visibleClear clutter where you can Order by chronological sequence Counts (marks) should be visible Clear clutter where you can Build a Visualization in a new sheet to answer: Which crews have the highest number complaints? a. Horizontal Bar Chart Build a Visualization in a new sheet to answer: Which cohorts have the most compliments? a. Horizontal Bar Chart Build a Visualization in a new sheet to answer: trainers have the flight attendants that have the most compliments? Build a Dashboard with the five visualizations Optional: Develop a calculation that uses conditional logic that reverse scores the complaints negative values and leaves the compliments positive. Use Tableau Desktop Hide unneeded fields Use a simple table to count records to ensure your shaping is correct after major transformation Here are some figures for that you match toThere are 1500 total employee recordsAfter the Pivot there should be 36000 records There are 1500 total employee records After the Pivot there should be 36000 records Changes in the Excel File may be necessary