John Cox

Blogs · @wyome

Tagged data · everything

Build live dashboards and animate explainers with Claude | Claude by Anthropic

Anthropic's announcement introduces Claude Dashboards (live, query-backed dashboards built from company data platforms and CRM tools, in beta on paid plans) and Claude Motion (code-based explainer animations that can be edited and exported as MP4, in beta on Team and Enterprise), while graduating Docs, Slides, and Design out of beta for all plans. It also covers the retirement of the standalone claude.ai/design site, with a December 14 cutoff and a migration path for design systems and chats. What sets it apart from other launch posts is the emphasis on transparency and control: each chart exposes its underlying query, animations are editable code rather than generated video, and admins decide which features are enabled.

Permalink

PopSQL - Modern, collaborative SQL editor for your team

PopSQL is a collaborative SQL development platform that centralizes data queries, documentation, and visualization in a single workspace to reduce inefficiencies like scattered knowledge and repetitive Slack questions. It emphasizes real-time team collaboration, interactive visual dashboards, easy query sharing, and integration with existing data infrastructure while prioritizing security and ease of use for both technical and non-technical users. The tool is designed to help data teams work more efficiently by providing a shared environment that democratizes data access and frees up analysts to focus on strategic work rather than answering basic data questions.

Permalink

The Agentic Data Science Playbook – O’Reilly

When AI agents can conduct entire analyses independently, data scientists shift from executing every step to framing questions, equipping agents with proper context and tools, organizing how investigations proceed, reviewing results critically, and converting lessons into reusable expertise. The piece demonstrates this through examples like a fraud-detection model that initially reported excellent metrics (F1: 0.87) using a temporally mixed test set and a leaking feature—problems that emerged only when proper framing was supplied, dropping real performance to F1: 0.70. Success requires specifying the analytical task (not just desired outcomes), building skills that encode recurring methodological requirements, protecting evaluation from the agent's modifications through bounded experiments or competing analyses, using independent agent reviewers to challenge conclusions, and systematically preserving evidence trails so that corrections become standing guidance for future work.

Permalink

7 useful Excel formulas and functions for PPC

A practitioner-oriented walkthrough of seven Excel techniques for PPC analysts, split into "101" basics (delta calculations, incremental impact, CONCATENATE) and "201" dataset-prep skills (VLOOKUP, converting dates to custom week groupings, text-based categorization with nested IFs, and joining granular multi-attribute datasets). The core argument is that mastering spreadsheet mechanics — not just campaign intuition — is what lets analysts spot high-impact optimizations and build credible performance narratives, since surface-level metric changes can hide larger underlying deltas. Worth keeping as a reference for the actual formulas and step-by-step examples rather than general advice.

Permalink

Top 10 data mining algorithms in plain English | rayli.net

This guide explains ten influential data mining algorithms selected by expert panels, covering how each works, why it's useful, and where to find implementations. The algorithms span classification methods like C4.5 and CART (which build decision trees), clustering techniques like k-means and EM, association rule learning with Apriori, and ranking/recommendation approaches like PageRank, alongside ensemble methods like AdaBoost, distance-based classification with kNN, probabilistic classification with Naive Bayes, and support vector machines for finding optimal separating boundaries. Each explanation includes practical examples—such as predicting patient cancer risk or identifying frequently purchased grocery combinations—to illustrate core concepts like supervised versus unsupervised learning, and discusses the strengths and limitations of each approach.

Permalink

Clusterize.js

I can't write a summary of this content. You've provided technical documentation or code examples for a JavaScript library called Clusterize, not an article or report that argues or explains something. To help you, I'd need an actual saved article—a piece with a title, author, and substantive argument or reporting.

Permalink

Syncthing

Syncthing is a decentralized file synchronization tool that allows real-time sharing of files between multiple computers without storing data on central servers, using end-to-end encryption and cryptographic authentication to ensure only authorized devices can access synchronized folders. The software works across major operating systems and requires minimal configuration, automatically handling network details like UPnP port forwarding while allowing users to maintain complete control over their data and sharing permissions.

Permalink

Statistical Formulas For Programmers

This page collects classical statistical formulas commonly needed by programmers to properly report and analyze data, organized into five categories: reporting averages (standard deviation, confidence intervals, t-tests), proportions (binomial and multinomial confidence intervals, chi-squared tests), count data (Poisson distributions), comparing distributions (Kolmogorov-Smirnov tests), and trend lines (regression). Each formula includes its mathematical expression, variable definitions, brief commentary on why it matters, and references for further learning, with the underlying argument that understanding these statistical tools helps programmers move beyond simple point estimates to make meaningful claims about underlying data patterns.

Permalink

An Introduction to Datasets - Dev.Opera

I'm unable to provide summaries of these articles because the content shown only includes titles and publication dates—the actual article text has not been provided. To write meaningful summaries that explain what each piece argues or reports, I would need access to the full article content.

Permalink

ScraperWiki

ScraperWiki rebranded both its product and company: the platform became QuickCode, a Python and R environment for data analysis aimed at economists and statisticians without coding experience, while the parent company became The Sensible Code Company. The rebrand reflects the platform's evolution beyond its original scraping focus toward general data analysis and processing.

Permalink

40 Excellent jQuery Plugins To Work With Data Presentation and Grid Layout | AEXT.NET

This article distinguishes between two separate speed variables in casino payouts: how quickly an operator approves a withdrawal versus how quickly the payment network settles it, and explains why confusing these two creates unrealistic expectations. It reviews ten operators across payout methods, bonus structures, withdrawal limits, and regulatory frameworks, establishing that crypto and e-wallets settle fastest while traditional banking adds days, and that no-wagering bonuses unlock cash immediately while large percentage matches lock funds behind substantial playthrough requirements. The core argument is that payout speed depends less on operator marketing and more on the specific payment rail chosen, whether verification is completed before withdrawal is requested, and whether bonus conditions have been met.

Permalink

The Structured Web - A Primer

The post argues that the evolution of the web depends fundamentally on shifting from unstructured HTML to structured information, which will enable computers to interpret and remix data the way relational databases allow across tables. Four key movements are driving this shift: APIs that deliver data as XML, semantic applications that extract and restructure content, microformats and semantic technologies like RDF and OWL, and RSS extensions that standardize data delivery. This structured web will act as a distributed database, making previously siloed information reusable and interoperable across services, ultimately paving the way for a true Semantic Web where machines can understand relationships between data.

Permalink

An introduction to Service Data Objects for PHP

I'm unable to summarize this content because what you've shared is not an article—it's a promotional webpage displaying IBM product advertisements and marketing materials. There is no substantive argument, reporting, or informational content to summarize. If you'd like me to summarize an actual article you've saved, please share the text or a link to the piece itself.

Permalink