Data Analysis Journal $5 / month

The Data Analysis Journal explores the multifaceted field of data analysis, ranging from SQL tutorials, analytics engineering, to practical guides on root cause analysis and regression scores. It targets data professionals with insights into tools, techniques, industry trends, and career advice, emphasizing the importance of data quality, user engagement, and continuous learning.

Data Analysis Techniques Career Development in Data SQL and Programming Product and User Analytics Analytics Tools and Technologies Data Science and AI Industry Trends and Insights

The hottest Substack posts of Data Analysis Journal

And their main takeaways

Special Edition 🔥: Analytics As Applied Accounting | Lauren Balik

687 implied HN points • 08 Jan 24
🕹 Technology Data Analytics BI Tools Data Platforms AI Privacy
  1. Becoming a data analyst or engineer through bootcamps is becoming less prevalent due to economic factors.
  2. Analytics leaders face challenges in setting boundaries and avoiding overlap with finance teams in accounting functions.
  3. Decentralized data team setups are generally more efficient, and the future may see more of this with changes in tax regulations.

A Selection Of SQL Tutorials - Issue 141

628 implied HN points • 26 Apr 23
🕹 Technology Data Analysis Interview Preparation
  1. SQL is a must-have skill in the data field today for increasing trust in data and data cleanliness.
  2. Learning SQL through free tutorials and practice sites is effective and recommended over expensive programs.
  3. Practicing SQL in a local database, using tools like SQLFiddle, and following online tutorials are great ways to improve SQL skills.
Get a weekly roundup of the best Substack posts, by hacker news affinity:

Celebrating An Anniversary: Three Years of Writing About Analytics - Issue 154

452 implied HN points • 26 Jul 23
🕹 Technology Analytics Data science Newsletter Writing Career development
  1. The author reflects on three years of writing a newsletter about analytics, thanking supporters and subscribers.
  2. The author's newsletter aims to document their journey, bridge the gap between academics and industry, and encourage classic data analysis.
  3. The author shares insights on their writing strategy, the power of being small and independent, and future plans for the newsletter.

How To Do a Root Cause Analysis - Issue 162

275 implied HN points • 20 Sep 23
🕹 Technology Data Analysis Framework KPIs User Behavior
  1. Root cause analysis is essential for understanding unexpected changes in user behavior or metric decline.
  2. Tools like Root Cause Analysis (RCA) can pinpoint anomalies quickly, but additional work is needed to truly understand why something is happening.
  3. Analyzing the 'what' and 'why' behind metrics decline or user behavior change requires a comprehensive framework.

Embracing the New Era of Accelerated Testing - Issue 150

235 implied HN points • 28 Jun 23
🕹 Technology Data science Analytics A/B Testing Experimentation Tooling
  1. Embracing accelerated testing in the modern data analysis landscape is essential for success.
  2. The current traditional academic workflow for A/B testing may not be suitable for the evolving landscape of experimentation.
  3. To thrive in the era of rapid feature flagging and A/B testing, teams need to adapt by automating statistical checks, simplifying documentation, and eliminating bias.