About Makeover Monday
MakeoverMonday is a social data project which “offers inspiration and a dose of perspective for those who communicate data, and allow people to explore different perspectives and approaches to create more effective visualizations.”
To be more specific, “Each week we post a link to a chart, and its data, and then you rework the chart. Maybe you retell the story more effectively, or find a new story in the data. We’re curious to see the different approaches you all take. Whether it’s a simple bar chart or an elaborate infographic, we encourage everyone of all skills to partake. Together we can have broader conversations about and with data.”
Inspired by Dong Yu (an amazing data analyst also graduated from USC), I started this project from January 2019 and hope to better understand how to interpret data and translate insights into impactful visualizations.
All my Tableau visualizations can be found here through my Teableau Public profile.
Makeover Monday Week 7
This week, the visualization is based on the information provided by Axios, about President Trump’s official schedule breaks down. A White House source has leaked nearly every day of President Trump’s private schedule for the past three months after midterm election, around 60% of which were spent on unstructured “Executive Time”.
The original visualization and dataset is here in case you are interested, and the data source is from Axios.
Although the original visualization already outlined President Trump’s overall schedule, it only covered from 8AM to 5PM, and also did not included any detailed statistics. Therefore, to further improve that, I first visualized his daily schedule and then analyzed the time he spent on different categories and different weekdays.
Insights
- President Trump has spent around 60% of his revealed working hours on unstructured “Executive Time”, which was followed by meeting (15.3%) and travel (10.2%) time.
- On average, he worked 9.7 hours per day (if we count all “Executive time” as work), which is relatively high compared to the normal 8-hour shift for average people.
- Travel usually happens on Monday, Thusday and Friday, and seldom happens on Tuesday and Wednesday.