Data Analytics & Business Intelligence

DuckDB Embraces Lakehouse Vector Search; SQLite Deep Dives into xUpdate & VFS Builds ...

New chapter in Learning data analytics and data science. The focus now is on Pandas as a Python...

When I started building Rubies Unleashed — an open publishing platform for indie games, apps, and...

I built an unusual educational website: a bilingual (EN/ZH) platform that maps the ancient Taiji...

Someone sends you a CSV. Then a folder of CSVs. Then a CSV that's actually tab-separated but named...

Introduction As datasets grow larger and analytical workloads become more demanding, query...

Introduction Ask ten people what data science is and you'll hear things like...

For the last decade, the workflow for Business Intelligence hasn't changed much: A business...

Most SaaS apps collect tons of data but give customers almost nothing back. Here's what customer-facing analytics looks like in practice, and how to build it ri

Manually converting invoice data from PDF or Excel files into CSV format is one of the most...

How I turned messy Naver review keywords into a "workability score" for 8,000+ Seoul cafes, aggregated it by district, and published the whole thing as a free d

FXpeek's annual reference report for dated exchange-rate lookup, CSV exports, widgets, and lightweight JSON API workflows.

Design effective completions dashboards: choose KPIs, model data for Power BI/Tableau, visualize progress, and automate distribution to stakeholders.

Can Data Science Do Without Statistics? 1. Introduction: The Debate Nobody Wants...

Automate your data cleaning pipeline with Python. Handle duplicates, missing values, dates, and outliers.

Introduction With my Iceduck project, I’ve been diving deep into Data Lakehouse...

The Problem After losing 50 pounds on a GLP-1, I thought the hard part was over. It wasn't. The...

As your data grows, a single ClickHouse server may eventually reach its limits. Whether it's storage,...

“Real data analysis starts with Python or SQL.” That’s what I believed too until I spent weeks...

I wanted a single screen that told me what the internet was feeling during a World Cup match — which...

"Without statistics, data is just a collection of numbers. With statistics, data becomes...

I Analyzed 500+ Bank Statements. Here's What I Found. Over the past few months, while...

Most enterprise AI projects don't fail because the model is wrong. They fail because the data feeding the model is unreliable, stale, or structurally

A practical guide to adding embedded SQL dashboards to your SaaS product — covering architecture, authentication, multi-tenancy, and when to build vs. buy.

Today we launched a new plugin for Datasette, datasette-apps , with this launch announcement post on the Datasette project blog. That post has the what , but I'

A question I kept circling when I started treating prediction markets as a trading venue: by the time...

Intro Last year, I joined a team responsible for a mature data platform with several tools...

Microsoft has introduced a limited-time opportunity for Data Professionals, Analysts, BI Developers,...

You've probably used Microsoft Excel at some point — maybe to track a budget, keep a list, or add up...

Compare Redfin and Zillow data sources for real estate analysis. Learn field differences, accuracy, and best use cases for each platform.

The Question What happens to soccer scorelines after the 87th minute? I wanted real data,...

How building an AI-powered geomancy platform forced us to rethink data modeling Most...

When financial and operations personnel use the backend of cross-border purchasing agents or...

You don't need Tableau or a $50k BI platform to show your users live charts. Here's how to wire SQL queries directly to charts in your app, fast.

Every dashboard you build makes an implicit promise: the number on the screen is true right now....

Public clinical trial data is valuable, but it is not always analytics-ready. An API response can be...

I've watched candidates with 8 years of experience go blank when asked to define the grain of a fact...

data lake : repository of data stored in natural format as blobs or files. Azure Data Lake Storage...

Time-series data is one of the most common types of data generated by modern applications. Every log...

Six essential SQL queries that give SaaS founders direct visibility into signups, active users, conversion, churn, MRR, and retention — no BI tool required.

One of the most common performance bottlenecks in analytics is running the same expensive...

What does this big word really mean? The first week of data engineering at luxdev was...

Release: datasette 1.0a34 Quoting the release notes: The big feature in this alpha is tools to insert, edit and delete rows within the Datasette interface. Thes

When I first opened Excel, I saw rows and columns.......nothing more.Over the past two weeks ,I have...

Data privacy regulations such as GDPR, LGPD, and HIPAA demand that organizations know exactly where...

Querying ecommerce data often requires writing manual SQL queries or building complex dashboards....

Every Indian data scientist hits the same wall. You need district-level population data. You go to...

If you trade, model, or just read prediction markets, there's one question that decides whether the...