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...

Reference: Microsoft Power BI Desktop for Business Intelligence The following are lifted from the Udemy course above 👆, which I found really helpful when learning PowerBI. Since new features in t...