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
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more