Search for question
Question

Your next assignment is to make a dashboard for Lyft. I'm giving you two days of data, one for February 28th 2023 and one for March 1st 2023. Your assignment

is to make a dashboard that the person who manages the city of Boston for Lyft will review every morning at 8:00 am. The manager of the city of Boston for Lyft is your client. You can expect this will be consumed by your client on March 2nd, and then again on March 3rd, again on March 4th, etc. I'm really specifying this because I don't want annotations in the dashboard unless those annotations will dynamically update in the future, and I don't want dashboard titles to be specific to these two days unless those dashboard titles dynamically update as well. As a general thing to remember, this is a dashboard, not an infographic. Your client is aware that there was a Red Sox spring training game on 3/1/2023 - so that won't be a big surprise in and of itself. She will be interested to know whether there were adequate rides delivered to people during the game. Generally, Lyft has a goal of 95% of all sessions to end in a ride. Usually, sessions don't end in a ride because people are "multi-apping" and call a Uber instead if the Uber is cheaper or closer. For nights like 3/1/2023, particularly in Fenway where the game was, Lyft has an internal goal of achieving 90% of all sessions ending in a ride. Lyft also has a goal that the time to pickup for each ride is less than 5 minutes, and the average number of rides that use surge in a given hour is less than 2%. Price is based on the type of car, the distance of the ride, and whether their was a surge. The manager is aware of the basic formula around this, so I would not make graphs that show things like "Lyft Lux rides make more money than normal Lyft rides, on average." because that is basically true by definition. Lyft has a goal of earning $100,000 per "regular" day and $200,000 on nights that MLB games occur. Lyft has a goal that at least 8,000 unique drivers give a ride each day. In general, Lyft does NOT like surges. It considers surges to be a failure of their platform to not provide drivers where they are needed. Even though surges create a one-time revenue boost, Lyft basically believes that the bad experience of paying a significantly higher cost for a ride outweighs the temporary increase in revenue. I'd encourage you to think about other KPIs Lyft might care about and to visualize those as well. There are more people being picked up from Fenway than are being dropped off at Fenway - I made it this way because I assumed people could get to Fenway from work by walking there or taking the T, but they'd want to Lyft home because it would be cold walking or taking the T home. All you have to submit is a .twbx file. The dashboard should be your standard 1,000 wide by 800 tall dashboard. If you use shapes or colors to indicate not meeting goals then I would suggest making the dashboard so that the shapes or colors change if the goal becomes met.