A hands-on review of the new DuckDB UI, exploring its features for data analysis and comparing it to previous workflows with Rill Data.
A technical walkthrough of loading and exploring UK Environment Agency flood data using DuckDB and Rill for a streaming pipeline project.
A tutorial for R users on mastering data wrangling in 5 progressive levels, using the dplyr package and the Ames housing dataset.
A comparison of the native Base R pipe (|>) and the {magrittr} pipe (%>%), covering their syntax, strictness, and use cases for data analysis.
A tech blogger analyzes the decline in their blog's ad revenue, linking it to the rise of AI tools like ChatGPT and GitHub Copilot.
A tutorial on using R to parse Apple Music XML data and create personalized listening statistics similar to Spotify Wrapped.
Analyzing ORNL's AI-generated dataset of 131 million US building footprints, including download, setup, and technical analysis.
The Big Book of R adds five new free, open-source books covering R programming for production, survey analysis, causal inference, biodiversity data, and natural resources.
Analyzing Baltic Sea maritime traffic data using the Finnish Transport Infrastructure Agency's open AIS API with Python and DuckDB.
Explores Bayesian alternatives to the frequentist t-test for comparing two means, discussing non-parametric and resampling-based approaches.
Analysis of 5 years of Hacker News 'Who's Hiring' thread data using Deno and the HN API to visualize tech hiring trends.
A technical guide explaining why ggplot2 line charts sometimes appear blank and how to fix the issue, focusing on data structure and grouping.
A developer reflects on SQL's relevance after a colleague's unfamiliarity with it, questioning if it's becoming a niche skill in modern tech stacks.
A tutorial on the six most fundamental R functions for data cleaning, using the tidyverse and palmerpenguins dataset.
Using R simulations to calculate birthday probabilities instead of complex probability math, with code examples.
A tutorial on using Dremio and Docker to run SQL queries directly on Excel files from your local machine.
A technical walkthrough of preparing and analyzing the global Open Charge Map dataset for EV charging points using DuckDB and Python.
A technical analysis of aircraft flight routes using ADS-B telemetry data, Python, and GIS tools, focusing on a specific AirBaltic Airbus A220-300.
Argues against using LLMs to generate SQL queries for novel business questions, highlighting the importance of human analysts for precision.
A benchmark analysis of DuckDB's performance on a massive 1.1 billion row NYC taxi dataset, comparing it to other database technologies.
