Data Analysis Journal

Share this post
Goodbye 2021šŸŽ„ - Issue 75
dataanalysis.substack.com

Goodbye 2021šŸŽ„ - Issue 75

Some of the best publications, some gratitude, and heaps of confetti

Olga Berezovsky
Dec 29, 2021
8
Share this post
Goodbye 2021šŸŽ„ - Issue 75
dataanalysis.substack.com

Hello dear readers, this is the last newsletter of the year!Ā 

ā¤ļø Thank you so much to my mentors, friends, supporters, and all my readers. You inspire me to write this journal. Every newsletter develops more connections with my audience, and I believe that we can all together drive and advance the current state of analytics, bringing more visibility to it, with the hope of creating and developing better data-driven products and services as a result.

A half year ago I was celebrating a year of writing wherein I shared the reasons for writing this newsletter, my team, mission, and learnings.Ā 

To add to that, I would like to report that I take profound offense when I hear that being an analyst today is not ā€œcoolā€. A correction: to be a mediocre analyst today is not cool. A mediocre analyst is an analyst who expects the data to be clean and nicely packaged in some sort of data mart and then proceeds to get lost when no structured data or easy-to-read data is available. It’s the type of analyst who is locked into a Tableau workbook, generating continuous data puking (putting a pile of color-coded variables into one chart) without the ability to simplify or break that data down.

Creating an analytics legacy, making a company truly data-driven, owning data governance, and setting the right frameworks based on the proper foundation are all challenging and exciting. It doesn’t happen overnight, and sometimes takes years to bring data into decision-making and business strategy. In my journal, I want to create a ladder showing how to get there. I want to encourage and inspire my fellow data analysts to enjoy genuine analytics and build a data heritage at your company that you would be proud of.Ā Ā 

šŸ† Grow and upskill

Over the years, I’ve created a lot of checklists, playbooks, and code snippets. This journal is a place for me, first of all, to store, keep, and reread this type of content. My favorite articles across different domains, best frameworks, good examples, gotchas and caveats, reminders, calculations, and definitions - all of which are based on my own experience, learnings, or research of best practices and working solutions. I put it all up here for my subscribers to reuse and, hopefully, upskill and grow (or curse me! You never know).Ā Ā 

I’m honored to have thousands of readers around the world with different levels of knowledge and experience, from experts to beginners, or people transitioning into the world of data from other fields, and across all industries.Ā 

Data analysis is a challenging field, still emerging and always transforming. Navigating through it is tough and exciting. I’m grateful to everyone who is reading my newsletter. I hope it can help you find a path for professional growth, point you to the right sources and documentation, and inspire you to learn and love data analysis. Ā Ā Ā 

šŸ’° Spend Your Annual Training Budget

With the end of the year almost here, it can be time to spend any unused training budget allocated to your team. Paid subscribers receive:Ā 

  • SQL and Python interview questions, solutions, and guidance.

  • Interesting and tricky deep dives and case studies.

  • Data analysis projects examples and walkthroughs.

  • A/B tests approach, real-life scenarios, and implementation.

  • Insights from data analysts and data science experts who walk us behind the scenes of their daily work, challenges, and share their learnings.Ā 

  • Interesting stories about how data affects people’s lives and how data analysts make a change.

Additionally, paid subscriber questions and support are prioritized.Ā 

You can cancel anytime. And, you also can expense the subscription.Ā 

If you are currently looking for a job, and can’t expense or afford the subscription, just email me and let me know. Hopefully, my journal will help you land a job (as it did to other readers).

šŸ†• New Journal ChaptersĀ 

Substack, the newsletter platform I am using, keeps adding more features (and yet it still doesn’t support the basic code markdown ā˜ ļø). Now you have a fancy option to subscribe or navigate to a specific topic in my journal and ignore the rest. As of now, I have 6 different chapters:

  1. Product analysis

  2. A/B testing

  3. SQL

  4. Python

  5. Statistics and ML

  6. What experts say

Each chapter works as a separate newsletter. For example, if you are interested only in SQL, you can subscribe to SQL publications, and do not receive A/B test, ML, or Product Analytics articles. If you are subscribed to the Data Analysis Journal (as you are now), you will receive every newsletter.

šŸ”„ Popular publications from Data Analysis Journal:Ā 

Data analysis

  • The Future Of Data Analytics

  • How To Create A Data Analyst Portfolio

  • User Segmentation and Power User Analysis in SQL

  • Advanced Analytics: Feature Engineering

  • When To Use Client-Side Or Server-Side Events For Analytics

  • The Top 10 Best Blogs To Read For Data Analysts

  • How To Choose The Right Chart For Analysis

  • User Engagement and Activity Histogram Analysis

  • When Things Go South

  • Essential Tools For Data Analysis

  • Financial Forecasting 101: Why, When, And How

  • How To Develop Critical Thinking

  • Ditch Tableau For God’s Sake. It’s 2021

Read more - Data Analysis Journal - Product Analysis

Metrics

  • Introduction to Product Metrics and KPIs

  • How To Measure Product Adoption

  • How To Pick The Right Metric

  • Analytical Case Study On User Engagement

  • As The World Churns

  • SaaS Growth Metrics One-Pager

  • What Is Customer Acquisition Cost And How To Improve It

Experimentation

  • A/B One-Pager (initial checklist)

  • A/B Test Checklist (updated checklist)

  • A Guide To A/B Test Evaluation

  • 5 Mistakes To Avoid When Running A/B Tests

  • These Tricky A/B Tests Or Why Significance Matters

Read more - A/B Testing

Python

  • How To Install And Set Up Python

  • Correlation Analysis 101 in Python

  • How To Pass A Take-Home Python Assignment

  • Python Questions For A Data Analyst Interview

  • Generating a Word Cloud In Python

  • A Selection Of Python Tutorials for Analysts

Read more - Data Analysis Journal - Python

SQL

  • Facebook SQL Interview Question

  • SQL Interview Questions + Preparation Tips

  • SQL Date-Time Checklist

  • How To Create User Profiles in SQL

  • How To Create Date Series in SQL

  • A new SQL function - QUALIFY! And How To Optimize A Query Run Time

  • Joining two tables that are not related by a foreign key relationship

  • Day Of The Week Analysis in SQL

  • Advanced SQL Functions For Data Analysis

  • Currency Conversion In SQL and Python

Read more - Data Analysis Journal - SQL

Data Science and Statistics

  • How To Handle Missing Data in Your Analysis or Modeling

  • Applying Statistics For Data Analysis

  • Supervised machine learningā€Šā€”ā€ŠBinary logistic regression overview

  • Supervised Machine Learning — An Introduction To Support Vector Machines

  • Supervised Machine Learning - The Decision Tree Classifier Intro

  • Which ML Algorithm Should I Pick For The Price Estimation?

Read more - Data Analysis Journal - ML

Expert insights:

  • Brian Balfour - Learn Your Domain and Differentiate Yourself

  • Trenton Huey - Learning Every Day

  • Duong Vu - Best Ways to Learn Data Science

  • Ziv Wangenheim - How Data Analysts Can Evolve and Adapt

  • Haki Benita - Choosing The Right Tool For The Job

Read more - Data Analysis Journal - Expert Insights


Before I go skiing and celebrate life, here’s one last thing from my favorite source - 2021: A Year In Charts. The whole 2021 in 25 charts. Here’s a similar one from McKinsey - 2021: The year in charts. Enjoy!Ā 

Hope you have a great end of the year ā˜ƒļø. I will be away for the next 2 weeks, but then back every Wednesday, as always!Ā 

See you in January!

Share this post
Goodbye 2021šŸŽ„ - Issue 75
dataanalysis.substack.com
Comments

Create your profile

0 subscriptions will be displayed on your profile (edit)

Skip for now

Only paid subscribers can comment on this post

Already a paid subscriber? Sign in

Check your email

For your security, we need to re-authenticate you.

Click the link we sent to , or click here to sign in.

TopNewCommunity

No posts

Ready for more?

Ā© 2022 Olga Berezovsky
Privacy āˆ™ Terms āˆ™ Collection notice
Publish on Substack Get the app
SubstackĀ is the home for great writing