Data Analytics & Business Intelligence

If you're building anything that touches Medicare Advantage risk adjustment, sooner or later you hit...

Learn how to structure a data analyst resume for US jobs after graduating from a Chinese university. Includes before/after bullet rewrites, ATS-friendly formatt

Hey guys... I'm AshwinUdhayakannan, a guy trying to upskill in the world of information technology....

Los sitios financieros son minas de oro de datos tabulares. Precios de acciones, tenencias de ETFs,...

apache beam is the write-once-run-anywhere programming model that most senior data engineers meet the...

flink cdc is the ingest stack that quietly replaced Debezium + Kafka + a downstream Flink job on...

Introduction Real-time data pipelines power modern applications such as analytics...

If you've ever wondered how a shopping mall knows exactly how crowded its west wing is right now, or...

How to Recover Data from Failed Storage Arrays: A Complete Technical GuideStorage arrays—whether...

I've been thinking about how easy it is to trust the wrong metric, even when the data itself is...

Most "Debezium vs managed tool" articles get the question wrong. They frame it as a product bake-off,...

Battery energy storage systems are not one data source. A BESS site may include a BMS, PCS, EMS,...

Every large organization has the same quiet problem: the best information about risk doesn't live in...

Five US states — New York, Colorado, Pennsylvania, Oregon, and Connecticut — publish their entire business registries as open data with commercial use

I'm Heshan. I build data products. No VC, no team — just me, a lot of Playwright scripts, and...

The problem with two datasets A recent project of mine called for two things that are easy...

beginner has been there. You memorize services like: Amazon...

When we talk about data visualization and dashboards, enterprise tools like Tableau or PowerBI...

I built JSON Utility Kit as a small browser-based toolkit for everyday JSON tasks. The CSV to JSON...

AI-assisted coding is changing how data engineering teams work. A developer can now generate SQL,...

Introduction For the past few days I have been doing data cleaning using PowerBi 34...

TL;DR — I scored 525 Chinese social posts on two foreign-vs-domestic rivalries. Coffee: Starbucks...

Mastering Pandas — Part 1: Reading, Sorting & Displaying Data ...

Matomo is an open-source web analytics platform that keeps full ownership of visitor data on...

Plausible Analytics is an open-source, self-hosted web analytics tool that tracks traffic without...

Introduction Parametric and non-parametric statistical tests are used to analyze data. The...

Airflow is an open-source platform for programmatically authoring, scheduling, and monitoring...

Databricks Auto Upgrades introduces a revolutionary way to keep your lakehouse tables optimized and current, automating the adoption of advanced features to boo

Learn how to translate Chinese university project experience into US-style resume bullets for data engineering roles. Includes before/after examples, a 3-step r

SNOWFLAKE SQL INTERVIEW QUESTIONS – QUICK NOTES What is Snowflake? Snowflake is a cloud-based data...

Japan's qualified invoice system requires every invoice to carry a registration number (a "T"...

I once watched a marketing team wait four months for a single dashboard. Every request had to go...

Introduction Analytical platforms often execute the same SQL queries repeatedly. Business...

Introduction Modern analytics platforms rarely store all business data in one place....

How I built an ETL script to pull GitHub release cadence, open issue counts, and archived status into ossfind.com — and why I kept all AI opinions out of it.

This week I fixed a set of bugs in a mobile export pipeline where the scary part was not that the...

Originally published at han-co.com · Part of the "Basics" strand of my Credit & Finance Data...

The Problem: Candlestick Gaps That Confuse Users and Algorithms When our team integrated...

Learn what SQL Server heaps are, when to use them, common interview questions, and practical SQL scripts for identifying and managing heap tables.

Welcome to the Database Deep Dive Series—a collection of articles designed to help database...

When I first heard the words star schema, fact table and DAX, I honestly had no idea what any of that...

Introduction The data we work on using Power BI is collected from different sources. These...

Job hunting needs salary data, certification ROI, employer-city take-home pay, and (if you're moving...

Sleep-stage classification is where a lot of consumer sleep tech quietly cheats. A quick tour of the...

This is the story of a for-fun project, Luka Fit Index that started with me typing "ai for fun?...

Here's something nobody tells you when you start Power BI: the visuals are the easy part. You can...

Introduction The S&P 500 and Nasdaq are two of the most widely followed indices in the...

Over the past few weeks, I’ve been diving into the fundamentals of data analysis. It’s been an eye...