A product manager discusses five essential skills for product and leadership roles: SQL, Excel, clear communication, storytelling, and prioritization.
A guide to using SQL for efficient data analysis, comparing performance with pandas and demonstrating advanced SQL techniques.
A Kusto query snippet for Azure Log Analytics to filter records from the last 7 days, showing only entries between 9am and 5pm in local time.
A guide to efficiently cleaning and standardizing text data in large datasets using Python's pandas library, with a practical example.
A statistical analysis of multicollinearity in regression models, discussing its impact on coefficient interpretation and prediction.
A review of Python tools and libraries for visualizing and interactively exploring Pandas DataFrames, comparing them to Excel's graphical interface.
A guide to using pandas' groupby and aggregation functions for data analysis, covering basic to complex custom operations.
A technical tutorial using Python and JAX to model and correct for survivorship bias in housing market data during the pandemic.
A programmer writes an interpreter for a subset of BASIC to run the original 1978 Oregon Trail game within R, discussing code translation challenges.
A guide to implementing a simple anomaly detection system using only SQL and basic statistics, aimed at developers.
Explores the Bayesian equivalent of a two-sample t-test, questioning traditional assumptions and proposing a model using discrete distributions.
Explains the three main types of statistical weights (precision, frequency, sampling), their uses, and the software documentation challenges they create.
A data scientist shares three essential pre-project tasks—the one-pager, time-box, and breakdown—to avoid common pitfalls and ensure project success.
Overview of new features in version 4.0 of the R survey package, focusing on improved contrast estimation and replicate handling.
Explains how to use Monte Carlo analysis for product development, using TweetDeck screen capacity as a practical example.
Analyzing UK river flood data using an environmental API and Python to understand storm impacts.
A review of the best #TidyTuesday data visualization submissions from 2019, highlighting creative and insightful uses of R and ggplot2.
A guide on using PowerShell and a matrix/spreadsheet approach to visualize and audit Active Directory group memberships for IT administration.
Tips for using Google BigQuery's public datasets while managing and minimizing query costs, including using the free tier and setting budgets.
A guide to common SQL mistakes and optimization opportunities for developers and data professionals, covering integer division, UNION vs UNION ALL, and query performance.
