Data Analysis Movie – Obtaining Insights on Van Orders

Hi guys! I’ve created a short “movie” on analyzing van orders.

Watch my video here!

Hope you guys enjoy it and I’d appreciate your feedback 🙂 Below is a brief description of the movie and the data I used –

Part 1 – Use SQL to obtain insights

Data:
Vanorders – contains information on all orders, including

  • idvanOrder: order ID, the primary key
  • requestor_client_id: client account ID
  • servicer_auth: driver ID
  • total_price: price of the order
  • order_status: whether the order is completed (=2), cancelled (=3) or expired (5)

Vaninterest – an entry is created whenever a driver picked up an order. The driver can reject the order  then another driver could pick it up. In this case 2 entries will be shown in Vaninterest for the same order.

  • idvaninterest: the primary key
  • idvanOrder: order ID
  • servicer_auth: driver ID

Part 2 – Assess whether a system change in the order allocation system improved order match time

A system change was introduced at midnight on 30 March 2017 on the order allocation system. The objective of the change is to improve order match time. I would like to analyze whether this system change has achieved its objective.

Data:

  1. Orders from 24 March – 3 April 2017
  2. Time those orders were placed
  3. Time those orders were accepted by drivers

The difference between 2 and 3 is the order match time.

 

An Overview of TED Talks using Tableau

I’ve always been a huge fan of TED talks. TED talks cover a wide range of topics from technology, innovation, society and personal growth and have always been a huge source of inspiration for me. Therefore, I’ve decided to use this topic to practice building dashboards in Tableau. In this visualization, I hope to understand more about TED talks by asking the following questions:

  • How has TED talks changed across the years (e.g. number of talks, topics)?
  • What are the most popular TED talks?
  • What do audiences generally think about TED talks?

The data set used is from Kaggle, which covers 2,550 TED talks from 1972 to 22 Sep 2017. I have done some basic cleaning of the data, mostly on converting the format of ratings and themes. You can view the interactive Tableau dashboard by clicking the image.

TED Talks (1972 - 2017)
To summarize:
  • The number of TED talks significantly increased in 2009. This is also the same year when TEDx talks started.
  • Most TED talks are held in Feb – Mar, the month when the Annual TED conference is held. Most TED talks are held on Wednesdays and Thursdays.
  • Technology and science have always been a common topic for TED talks. Since 2015, there are more and more talks about innovation and society.
  • Audiences generally have positive perceptions on TED talks. Looking at the most popular TED talks, the top 10 most commented talks are viewed as inspiring, informative, fascinating and persuasive. The top 10 most viewed talks share similar ratings, and are also viewed as funny.
I have also build a recommender, which recommends 10 talks with the most specific rating, for example, the 10 most inspiring talks. Now I have some idea of what TED talks to watch next!