Explores the differences between event and entity data modeling, when to use each approach, and practical design considerations for structuring data effectively.
Explains the data lakehouse architecture, its layers (storage, table format, catalog, processing), and its advantages over traditional data warehouses.
A data engineer reflects on their 2-year career journey at the City of Boston, sharing lessons learned in data warehousing, ETL, and civic tech.
A developer shares their setup for tracking analytics with Posthog and running ads via Facebook, focusing on key events for a project.
An introduction to analytical data warehouses, explaining their purpose, differences from transactional databases, and their role in team-based analytics.
A developer's perspective on the challenges and purpose of implementing analytics and tracking in software features.
A guide for iOS developers on implementing private analytics using TelemetryDeck SDK, covering setup and basic event tracking.
Explains survivorship bias in web performance, using examples like Project Feather to show how missing data from failed users skews metrics.
A developer reflects on 'decision paralysis' when choosing tech tools like analytics, email providers, and note-taking apps.
A developer introduces Webmention Analytics, a tool for visualizing and filtering webmention data from webmention.io to combat spam and gain insights.
An update on TinyPilot's 5th month, covering a 20% revenue increase, the launch of a new pre-assembled Voyager model, and a new paid course.
A developer analyzes a third-party widget causing severe performance issues, blocking the main thread for 2.5s on a high-end laptop and 48.6s on a low-end Android device.
A developer's journey from a hacky PHP prototype to launching a SaaS product that automates analytics and SEO tasks for small businesses.
A developer builds a privacy-focused web analytics system from scratch, avoiding cookies and PII to eliminate GDPR notices.
A review of privacy-focused alternatives to Google Analytics, including Plausible, GoatCounter, and Fathom.
A developer shares their experience migrating personal projects to Netlify, focusing on domain management and a simpler, server-side analytics alternative to Google Analytics.
A data scientist explains their method for crowdsourcing and ranking 41 data science podcasts by analyzing Google search results.
Analyzes the significant traffic boost a PowerShell blog receives from being featured on the Planet PowerShell community aggregator site.
Explains the concept of a dimensional model in data, breaking down 'model' and 'dimension' to show how data is represented for analysis.
