In keeping up with my goal to do more learning this year, I’m allotting some time outside the daily grind for learning. My overarching goal is to explore popular data engineering tools such as dbt...

I’ve recently learned about Cumulative tables, a table design to do historical tracking. The timeframe (however it is defined), are inserted sequentially at every time partition, which eliminates t...

With the recent blue screen of death incident, I kind of thought about how much I missed working in Linux. I’ve also been mentally resisting to learn more CMD commands for a while now. That said, ...

Here’s a demo on how pydantic can be used to validate, correct, and quarantine data. Access the code and demo file here. Given a csv file users.csv containing the following records id,name,email ...

Suppose a dataset looks something like this, with no overlapping keys: "rows": [ { "a": "1234ABC", "b": 5.768, "c": 1, "d": [ { "e":...

Here’s a Power Query snippet to create a Calendar in Power BI In the Power Query Editor: Create a Calendar table with one column [StartDate] containing the starting date of the calendar e.g. 2...

Here’s my take on visualizing the “Financial Consumer Complaints” dataset from Maven Analytics. It’s a simple, straight-forward dashboard that shows the number of complaints by year, products, and...

A couple of months ago, I applied to Microsoft’s Power Up training. Luckily, I was picked as one of the participants in the March 2024 cohort. Power Up is approximately a month-long training on th...

Here’s a quick follow up to the first Pokemon dashboard I’ve made. (I keep doing this because this has been so much fun for me 😁). I discussed some aspects about the game in this post so 📢 SPOILER ...

Recently, I picked up my console and started playing Pokemon Fire Red again. At this point, I can’t count how many times I’ve played and re-played that game. It’s kind of nostalgic having been born...