Author: Tom Tao

Digital Analytics Professional, NTRP 4.0 tennis player.

Analyze first and second serve , and rally length breakdown using exported data from Swing Tennis App

Back by popular demand, this blog post continues diving into making use of the data we captured via Swing App from my Apple Watch. 

If you are new to the tennis tracking via apple watch, please check out my introductory blog post.

If you are interested in tennis, and subscribed to the Pro version of the Swing App, you will be able to export all the data to a clean Excel format. That is really cool, but what can you do about it?

In this blog, I will share my experience of playing and analyzing the raw data for over 30 hrs over the past few months. Hopefully by reading this article, you will have slightly more incentive to make use of the data, after your hard fought game and logging via Apple Watch.

We will cover the following three topics with hands-on examples:

  • Basic data cleaning and data modeling for the required analysis using Excel build-in feature
  • How to breakdown the first and second serve performance with speed and distribution
  • How to breakdown the short, medium and long rally on game points

Continue Reading

Tennis score tracking and exported data analysis with Apple Watch using Swing App

Tennis score tracking and exported data analysis with Apple Watch using Swing App

During the winter of 2018-2019, I was able to take my tennis tracking journey into a new level.  By now most of my tennis hitting partners are calling me a “data nerd”, clicking my watch like crazy during the game. But when I show them the stats after the game, they all (seem to be) impressed.

I did the following two new things in particular:

  1. Used the “Point by Point + ” score tracking in the Swing App to track all the points I have played. In total, I tracked 18 matches over the last 4 month, all of them were single matches and played in 1 hour.
  2. Exported the captured data into spreadsheets. By analyzing the data set, I was able to identify some of the limitations, as well as some opportunities to further enhance the analytics experience.

Before we dive in, if you are interested in knowing the tennis tracking tools and methodology, or a high-level overview, you can check my 1st blog post of this series: Tennis tracking after 18 month of usage. Or if you prefer to track drills instead of match, you can check out my last post on advanced tennis shots tracking.

Continue Reading

Tracking tennis swing with Apple Watch (Series 4) and the updated Swing App

Tracking tennis swing with Apple Watch (Series 4) and the updated Swing App

It has been 9 months since I first shared experience to track tennis performance with Apple Watch.   Backing up by popular demand(Surprised so many visitors found this blog from search engine all over the world), I’d like to take it further with a more in-depth review, of my own experience tracking and analyzing my tennis workout with the Swing app.  

Continue Reading

Advanced Analytics with Swimming data from Apple Watch

Advanced Analytics with Swimming data from Apple Watch

This blog post is aiming to provide a step-by-step guide to perform advanced analytics on swimming data, captured by Apple watch.  Microsoft PowerBI and Python on Jupyter Notebook are the primary tools to prepare, analyze and visualize the data.

You will learn how to export the workout data efficiently to your PC, make necessary data transformation, and understand what metrics and dimensions are available.  Then I will walk you thru how to analyze the data to answer typical questions related to why certain behaviors happened.   You will then see my preliminary attempt to use advanced analytics tools to predict future swimming performance.

Most importantly, you will find quite a few reference articles related to this topic, hopefully fulfilling your intellectual curiosity.

It is also the #3 articles of a series, the previous articles can be found here:

#1: How to use Apple Watch to monitor and improve swim performance

#2: Improving swimming performance with Apple Watch(WatchOS 4)

Continue Reading

7 steps to be a life-long learner – Exam isn’t the destination

7 steps to be a life-long learner – Exam isn’t the destination

The “life-long learner” is a pretty sexy title.

Over the past few years, I have received feedbacks, from both trusted and the anonymous sources, that self-improving seems to be one of my characters.

As a normal human being, I was flatted;  As an analyst, I can’t control the skepticism: Is this a filtered bubble?

What does it really take, to become “life-long” learner? – Let me tell you my version:

Continue Reading

Why you should use Apple Watch to track and analyze sleep

Why you should use Apple Watch to track and analyze sleep

Sleep tracking isn’t new. But what’s unique about using Apple Watch?

General Introduction

Sleep is the single most important activity for a normal human being, measured by time spent. Having a good night of sleep usually means a jump start of the day. On the flip side, bad sleep (or no sleep at all) will lead to serious implication – both physically and mentally.

In this blog post, I am happy to share my story of using the Apple Watch + 3rd Party App to better measure the sleep.  Hopefully, it will inspire you to pick up a few things here and there and take action to make your own sleep better.

Continue Reading

Tracking tennis using Apple Watch – My own takes after 18 month of usage

Tracking tennis using Apple Watch – My own takes after 18 month of usage

Playing tennis has been a major part of my adult life: It is fun, competitive and a truly global sport. More importantly, it has shaped my character and my social network.  Over the past 18 months, I have been using my Apple Watch to track, and subsequently, to analyze my tennis performance along with swimming    

In this post, we will cover the background, the pros and cons of different apps, and how the additional metrics playing a role in my mindset shift.

Background – how it started

Prior to receiving my Apple Watch in Sep 2016, there are only two ways to see my tennis performance in retrospect:  win/lose — a quantitative measure, and my feeling after the game — a qualitative measure.

To be honest, I am happy with it for over 10 years. The smartwatch was intended to track swim, which will be so boring without the number. Pressing buttons before and after a tennis game doesn’t require much effort. It also brings at least one significant benefit: bragging about my “closed rings” to friends and family.

New data points shape my view

The availability of the additional metrics, empowered by technology (Watch + Apps), allows me to have a much more quantitative pulse of the workout.

The 1st thing I always look at is the “distance ran” during the workout because it is a measure reflecting how active on my court coverage.  

The 2nd metric is the “average heart rate”. It is a metric to measure the intensity. An app I used called “HeartWatch” did a great job bringing additional context to interpret the breakdown of each heart rate range.

Over time, It has gradually changed how I look at my tennis game.  I know a lot more how I did, and subsequently cares a lot less about winning (No more ugly winning) . Even if lose the game, or not play a match at all, I know it is a good workout, as long as running over 2km , and has an average bpm of 130+.

In short, my own focus has shifted toward fitness, instead of fulfilling my internal “competitive fire”. 

Bonus – Subconsciously, I felt I am getting more “value” out of each workout as well.  Just by looking at the number just generated, I must be feeling pretty proud. (Bingo! another mental trick)

Apps to track tennis

Not many Apps were available at the beginning, and my only choice was the native “workout” app offered by Apple.

The app starts fast – native app offered by Apple always has the advantage. But it is almost the only benefit. Tennis is not even included in the default drop-down list, and can be only available after selecting “others”.

I have been using the above two 3rd party apps:

  • One is called “Tennis Keeper“, built by a Canadian tennis athlete.
  • The other one is called “Swing” from the famous silicon valley 

Both of these two offered a lot more functionality than the native app:  Running distance – the one matters the most.  Also, both of them claimed to track shot type and speed. Unfortunately, the result wasn’t the as accurate as I would hope. 

img_4546
Running Distance captured by Swing(top), compared to native Apple workout(bottom)

Swing is the app of my choice so far, mostly due to it can show “running distance” in the activity dashboard above.  The loading speed of the app is near my tolerance level – in my Series 2 apple watch, it requires over 10 seconds. That is not fun at all.  Maybe Apple is the one who should be blamed, considering its record of slowing down existing product to boost sales…

HeartWatch deserved special attention – It is a sophisticated health data analyzing app. My current usage is only touching its surface. What I like it the most, is it breaks down the workout by heart rate, and provide additional context for each heart rate range.  

  • Fat burn: 112-130 
  • Build Fitness: 131-148  
  • High Intensity: 149 – 167
  • Extreme:  167+

For example, I don’t like playing doubles because it is not intense enough. 

The data validates my “lack of intensity” theory, but also kindly reminding me – it also helps burning fat.  Of course, I want to burn fat – how can I burn more fat and faster, I guess I gotta play more doubles…

Closing

Compared to swimming, I feel I am just touching the tip of an iceberg using data to understand my tennis workout. I am hoping the app can make tracking a bit easier – for example making the app load within 3 seconds.  Also, if switching the watch to the dominating hand can make the app count 90% of the shot properly, I am willing to try it. Right now it is not even close.

Bonus – Here is my follow up post reviewing the Swing app in a much greater detail: Tracking tennis swing with Apple Watch (Series 4) and the updated Swing App

If you want to learn how I track my tennis match point by point, you can check out this follow up post: Tennis score tracking and exported data analysis with Apple Watch using Swing App

If you are an existing pro user and would like to try to make the most out of the exported excel dataset, please check out this recent post : https://bubbletao.com/2019/11/30/analyze-first-and-second-serve-and-rally-length-breakdown-using-exported-data-from-swing-tennis-app/

Three lessons learned from 5 years analytics experience in a Fortune 100 company

Three lessons learned from 5 years analytics experience in a Fortune 100 company

 

I have recently wrapped up 5 years (4 years + 9 months to be exact) of analytics career in a Fortune 100 company. In this precious in-between moments, I’d like to take the time to reflect on 3 lessons learned as an analytics professional in the digital marketing industry.

Continue Reading

PowerQuery and PowerPivot, the two new powerful features for the latest Excel

PowerQuery and PowerPivot, the two new powerful features for the latest Excel

You are a proficient Microsoft Excel user – vlookup is an appetizer, pivot-table is the main course, and VBA/Macro is your dessert.   And your company just gave you an upgraded Microsoft 365 subscription, and a brand new version of Excel is just being served.  You are wondering – “What’s new?”

As an analyst living and breathing with Excel, PowerPivot and PowerQuery are the two killer features, period.  I’d like to share my story on how you can save time and make your spreadsheet work more efficient.

Continue Reading