Building a digital dashboard – Part 1: business side

In the last couple of years, I have been asked numerous times for a “dashboard”. In reality I was asked a chart showing “what is my project (‘s KPI) doing”.  I usually performed a few data pukes and provided one PowerPoint slide, once the KPI is clearly defined, and the source data is in a “reasonable-messy” format.  I was not impressed by the business reality of over-used term “dashboard”.

“What is a dashboard” 

In my opinion, a true “dashboard” should serve beyond “what”, but also “why”.

Continue Reading

How to use Apple Watch to monitor and improve swim performance

I love new technology stuff. That is why I bought the Apple Watch 2 series 2 the day when it was launched. Mostly attracted by its waterproof feature for swim tracking, I was so pumped and even lined up in the retail store to get it on the first day.

Now I have been using it for almost 5 months and recorded 29 swimming workout. I’d conclude that it is a worthwhile purchase, as it helped me monitor and improve swim performance. Although the journey is not a smooth as I expected, let me share my experience.

Continue Reading

What 2017 Australian Open Men’s final means to me

I recently found out one benefit of handling parenting duties early in the morning  – watching sports happening on the other side of the globe. The game I watched, is the 2017 Australian Open Men’s final tennis between the legendary Roger Federer, 17 time grandslam champion and arguably the “greatest of all time” tennis player, versus Rafael Nadal, a 14 time grandslam champion, my early 20s “idol” for his toughness and mastery of top spin.


Going over the game detail is not the intention of this blog post. (This link will guide you to the official game recap).  I’d rather share what I have learned, or more specifically, what inspired me from this match.

Continue Reading

Why reading still matters, and my top 3 picks

The second half of 2016 is the fastest learning period for me professionally in a decade. Being put in the new job, I was forced to step out of my comfort zone, and learn to “swim” quickly in the deep water of digital analytics world. A “multi-channel” approach has been taken:

  • participating interactive webinars (most of them are free as part of the solution-sell from vendors),
  • formal on-line training(passed Google Analytics IQ certification),
  • follow blogs and newsletters (started from Occam’s Razor),
  • peer to peer learning (10+ face to face meeting with leading digital marketers, and analysts within my company),
  • reading books

This approach is essential to build the competencies thru different angles, just like we need multiple “marketing channels” to promote products and services.  You will always want to know which one is the best. For me personally, “reading books” is the channel that come on top without doubt.

Continue Reading

Using Facebook Graphic API Explorer to retrieve insights over 180 days

Recently, Facebook – the largest social media site has given me some headache. My assignment is quite simple – the business needs its facebook page’s key metrics(impressions, engagements) on a year over year basis, to see understand how our company’s facebook performance is doing.
Surprisingly, I can’t do it by login the standard facebook business manager function.Facebook won’t allow its business user to download metrics over 180 days from its “insights” portal.


Continue Reading