Albert Cheng

Unlocking the Mystery of Google Analytics and Advertising

Why do I keep seeing ads about shoes!?

I deep-dive into Google Analytics and Advertising works to dissect how the tracking works!

Posted by Albert Cheng on 24 May 2020

Property vs Shares - Which One is the Better Investment?

Let's see which one wins!

Which is a better investment in the long-run - property or shares? I attempt to answer this using a data-driven approach.

Posted by Albert Cheng on 11 May 2020

Lock It Up - Keeping Your Data Safe with Security Best Practices

The prevention is definitely better than the cure!

As the old saying goes, 'a stitch in time says nine'. A little bit of extra work to have good security practices can go a long way.

Posted by Albert Cheng on 09 May 2020

Sailing Through Data Privacy Waters - A Recap on How Data Protection Laws Work

A practical guide to privacy law in the context of data work

This blog post will explore how data protections laws, like the GDPR, affect day to day data professionals and how to avoid getting on the wrong side of the law.

Posted by Albert Cheng on 07 May 2020

Event, Action! A Beginner's Guide to Event-Driven Architecture

Fully embracing the scalability and flexilibility of cloud serverless infrastructure

This article will discuss how to leverage serverless cloud computing even further with event-driven architecture. No more schedules!

Posted by Albert Cheng on 04 May 2020

Time Series Forecasting - Different to Regular Machine Learning

An example of using data science to predict electricity usage

I explore how to use data science to forecast electricity usage. Spoilers - you can't just use regular ML algorithms!

Posted by Albert Cheng on 19 April 2020

Navigating the date islands and finding the gaps - Part 2

Mind the Gap!

Identifying the gaps and how long a continuous date range is an important exercise a few industries/domains. For example, in the insurance industry, identifying whether a person has a policy covered continuously.

Posted by Albert Cheng on 11 March 2020

Need a Date Dimension Table? Why not BYO!

A dimension date that fits into your very own Jupyter Notebook!

A date dimension is life saver for analytics work! I explore how to make your own in a few simple lines of code.

Posted by Albert Cheng on 11 February 2020

Date Islands - A Kimball Approach

Navigating the islands without sinking

Data warehouse design is an important thing - I explore how to navigate 'date islands' using a Kimball perspective to avoid getting lost!

Posted by Albert Cheng on 08 February 2020

The Secret Sauce of Scalability - Building data pipelines without servers!

A Guide to Serverless Data Pipelines without the big bill!

I explore how to get data into the cloud without the big bill using the magical world of 'serverless' computing. Pay only for what you use!

Posted by Albert Cheng on 06 February 2020

The Prophets have Spoken! A Quick Exploration of Weather Forecasting

An experiment using Facebook's Prophet library

To make life easier and come up with quick forecasts, Facebook's Core Data Science team developed Prophet. It's forecasting out of the box for time-series data- and its free!

Posted by Albert Cheng on 27 October 2019

How it all started - From TV to Data Visualisation

A data visualisation journey from humble beginnings

Tracking personal spending is a tight task! To help with this, I began to track my spending on entertainment products, such as movies, video games and creating some fancy visualisations!

Posted by Albert Cheng on 26 October 2019

A Peek Under the Hood - this Website's Architecture and Analytics

Explaining how this website infrastructure works

As the beginning blog of this website, I discuss how this website works and the technology under the hood. I explore how I combined serverless and cloud technology to achieve this.

Posted by Albert Cheng on 01 October 2019