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

Examples of CRUD operations because I always forget the syntax! Reference: 100 Days of Code - The Python Pro Bootcamp by Dr. Angela Yu. Create new database from flask import Flask from flask_sql...

Taking steps to learn more about GCP (Google Cloud Platform) services and thinking about what I can do with it. Here are some notes. It’s mostly based on Qwiklab challenges. Github repo 👉: gcp-clo...