Data Analytics & Business Intelligence

In Part 1 I built an OLS regression model on three years of B2B marketing data across eight channels. Continue reading on Medium »

What Python, options skew, and news sentiment revealed about how markets price fear Continue reading on Predict »

This post is part of my 2026 series, From Insight to Impact, where I explore what practical, real-world analytics looks like beyond tools… Continue reading on M

Master data warehousing and dimensional modeling — OLAP vs OLTP, star schemas, snowflake schemas, fact and dimension tables, and Slowly… Continue reading on Med

Understanding how data moves through an organization is a core competency for any analyst or engineer. Continue reading on Medium »

I am in the journey of using python in MS SQL Stored procedures. Continue reading on Medium »

For more than a century, clinical research has been dominated by the frequentist paradigm of statistical analysis. Concepts such as… Continue reading on Medium

We still don’t understand what those forecasts mean Continue reading on Medium »

As part of my SQL learning journey, I worked on a Zomato-style food delivery dataset consisting of 7 interconnected tables: Continue reading on Medium »

← Voltar ao blog GUIA · COMPARATIVO Como escolher a melhor inferência estatística...

Your Pipeline Is 21.2h Behind: Catching Finance Sentiment Leads with Pulsebit We recently...

← Voltar ao blog GUIA · INFERÊNCIA QUANTITATIVA Inferência Estatística Quantitativa B3:...

DuckDB Delta Lake Writes, Cross-DB Query Planning, and Pterocos SQLite/DuckDB Editor ...

← Voltar ao blog GUIA · COMPARATIVO Como escolher a melhor inferência estatística...

Sometimes curiosity quietly changes the direction of your week. Continue reading on Medium »

The carmaker scaled back electric vehicle plans, but is going all in on advanced batteries, including a new sodium-ion chemistry designed for large-scale power

A complete technical walkthrough of VariantLens - a production-grade VCF parsing, validation, annotation, and visualisation pipeline built… Continue reading on

A complete technical walkthrough of VariantLens - a production-grade VCF parsing, validation, annotation, and visualisation pipeline built… Continue reading on

How TopVideoHub moved 12M daily video view events off SQLite onto TimescaleDB hypertables: chunking,

Your 24h momentum spike of +0.750 in inflation sentiment is a stark indicator of incoming trends. We...

Every other business function got its system of record. Sales got the CRM. Marketing got the campaign and content platforms. Finance got… Continue reading on Me

And why I deliberately over-engineered it Continue reading on Towards Data Engineering »

Privacy-First Analytics Is Not Blind Analytics is a practical operating principle, not a slogan. The...

Introduction Before I enrolled in this data analytics program, Excel was something I associated...

Introducción del Autor Continue reading on Medium »

Sempre achei difícil encontrar dados organizados e visuais sobre cidades do Brasil — então decidi construir meu próprio painel. Continue reading on Medium »

Dataflows are a type of cloud-based ETL (Extract, Transform, Load) tool for building and executing...

When most people think about energy companies, they often imagine engineers building power plants, maintaining electricity lines, or… Continue reading on Medium

Learn how to interpret confidence intervals and margin of error in A/B test results, why your conversion rate is always an estimate with… Continue reading on Me

One of the toughest parts of any data science project is the acquisition of real-world data. There is always toy data available on Kaggle… Continue reading on M

If you scrape Weibo's hot-search board you get a snapshot: ~50 trending topics, ranked, right now....

Most lineage tools produce beautiful diagrams that don't answer the one question that matters: 'What...

What I learned after losing the data behind a question that actually mattered — and why owning your raw event layer is not just an… Continue reading on Medium »

The best dashboards don’t tell you what happened. They tell you what is starting to. Continue reading on Medium »

What building a forecasting system for 100+ restaurant stores taught me Continue reading on Medium »

Semantic Views in Snowflake are incredibly powerful. They are the engine that will drive the effectiveness of your structured data for… Continue reading on Snow

A friend who works in HR for a growing analytics firm shared a devastating, clarifying screening statistic with me recently. Continue reading on Medium »

And How a Medallion Pipeline in Microsoft Fabric Fixed It Continue reading on Medium »

At every information technology inflection point for forty years the enterprise has asked the same question. Continue reading on Medium »

Understanding ClickHouse® Data Types: A Beginner’s Guide When working with ClickHouse®,...

In today’s data-driven world, learning data analytics is not just about theory — it’s about understanding how data solves real problems… Continue reading on Med

In today’s data-driven world, learning data analytics is not just about theory — it’s about understanding how data solves real problems… Continue reading on Med

The Case Study Based Data Analytics e-Book is a practical learning resource designed to help students and beginners understand data… Continue reading on Medium

Hi everyone, I recently started working at a company where I have a monthly recurring task that involves extracting data from a website and pasting it into Exce

Data Science is an interdisciplinary field that involves collecting, processing, analyzing, and interpreting data to extract meaningful… Continue reading on Med

Data Science and Data Analytics are related fields, but they have different goals and approaches. Continue reading on Medium »

In the world of data, pristine datasets are a myth. From customer lists to inventory records, nearly every CSV file you encounter is likely to harbor a silent,

A walk through what ~17,900 prediction markets look like in bulk — favorite-longshot bias, late convergence, and why volume != movement — using a dataset of 17.