A developer creates a reusable AI agent recipe using Goose to transform messy lost and found data into organized web applications.
A technical guide on normalizing SQL cross-join data in ColdFusion by using table prefixes and restructuring query results into nested objects.
A technical guide on splitting email address strings in Azure Logic Apps using expressions to separate the domain from the full address.
Explains core data engineering concepts, comparing ETL and ELT data pipeline strategies and their use cases.
Explores the challenges of analyzing ordinal data, focusing on transformation invariance and the limitations of statistical comparisons.
Explores using Python's pattern matching and comprehensions for efficient data cleaning, transformation, and analysis.
A guide explaining dbt macros, their purpose, benefits, and how to use them to write reusable, standardized SQL code in data transformation projects.
Part 1 of a series on data warehouse transformation flows, building intuition for analytics engineers and data professionals.
Interview with Gabi Steele, co-founder of Preql, discussing data visualization, building data culture, and the future of data transformation tools.
A visual guide explaining core LINQ functions in C#/.NET with sketches and examples, including Select, Where, Aggregate, and more.
Explains the purpose and usage of the second 'replacer' argument in JavaScript's JSON.stringify() method.
Explains the new Object.groupBy() and Map.groupBy() methods in JavaScript for easily grouping array data, comparing them to the traditional reduce() approach.
Explores data transformation challenges in Terraform using a real-world example of managing Azure Kubernetes Service RBAC permissions.
Exploring different approaches for transforming data when using React Query with REST APIs, including backend, queryFn, and frontend methods.
The Gamma project simplifies data visualization creation with a new four-step guide, allowing users to upload CSV data and build interactive charts.
A developer shares a coding problem: transforming a flat array of objects into a 2D array grouped by a key, using JavaScript's reduce method.
