Top Ten Quick Takes From The Past Month - Issue 12

Today marks 3 months since I launched a newsletter for my Data Analytics Journal

As you know, I started writing this journal to bridge the gap between academic knowledge and industry requirements. I want to show what data analysis is or does “in action”.

Why landing an analyst job is difficult nowadays? 

Today, data analysis means many different things, and every company is expecting something else from it. That’s why, it is challenging for analysts to adapt, meet the expectation, and understand what they have to do or learn to excel. 

  • For smaller companies or early-stage startups, data analysts often become product analysts + data scientists + and data engineers all in one role. You will need to know SQL, Python, Statistics (heavy experimentation), data modeling, and data architecture. And how to play in beer pong. As the company grows, more and more differentiation develops between these roles and responsibilities. 

  • For enterprises, a data analyst becomes more a business analyst with a strong focus on data systems and data validation knowledge and less on engineering or data design skills. You will need to know SQL, Excel, and Excel again, and the right printer settings at your office. (Okay, you also can shoot for SPSS if you feel more creative. Depending on the domain though). 

Your value position, interview, transition, and professional growth for big or small (size, stage, profit) companies will be very different. 

Anyway, today, I wanted to summarise some quick takes from the past month from my previous newsletters and published stories. 

✨ 10 Quick Takes From Last Month Newsletters:

  1. Refresh your reading list with these 15 must-read books on data analysis

  2. The best way to practice SQL:

    • in your local database. You can install the PostgreSQL database and use the DataGrip client (free 30-day trial!) with it. 

    • Or use SQLFiddle or DB-Feddle tools. You can either paste your SQL there and polish the syntax or design your own table schema.

  3. Writing SQL, make sure you have respect for your reader and follow a proper SQL style. If you need more ideas or examples for interview questions and cases, check my post on SQL Interview Questions.

  4. Launching a new section - Ask Away! I aim to periodically post some common questions I receive from my subscribers. My first Ask Away post covers SQL interview challenges, A/B testing, and Portfolio questions.

  5. Learn about how data analysis influences and develops cancer research enriching it with visualizations. Scroll down here and watch Cancer Moonshot leaders and data experts speak about cancer data visualization at National Cancer Institute.

  6. How to choose the right ML algorithm? There are many different ML algorithms with different levels of complexities, and it can be challenging to figure out which model to choose for your analysis. For supervised ML, check my recent publication to decide which ML algorithm to pick for which business problem. 

  7. Did you know there are 715 total database systems? Here is an online encyclopedia of all databases, and it has the best name - Database of Databases.

  8. The top 5 essential data engineering concepts data analysts should understand:

    1. Types of data structures (how to work with structured and unstructured data)

    2. The basics of data architecture or model (know the difference and purpose for a data warehouse, data lake, data mart)

    3. Types of ETL (batch upload or streaming)

    4. Concept of memory and cost in RDBS (!)

    5. Version control (Git) and CI/CD pipeline

  9. Want to be a data engineer? Start with a roadmap of data engineering in 2020 - a modern data engineering landscape covering must-know tools and frameworks. 

  10. Watch Live Coral Reef Cam from California Academy of Sciences in San Francisco. It’s not related to data analysis, but it’s calming and, if you are lucky, you can spot a diver!

🍸 Drink and Mingle

Upcoming free events, meetups, talk, webinars


If you missed my previous newsletters, here are the links to the last 3 months of publications:

September newsletters: 

  1. 5 Concepts Of Data Engineering Every Data Analyst Must Know - Issue 11

  2. SQL Guide For Data Analysis - Issue 10

  3. How To Choose The Correct ML Algorithm For Your Problem - Issue 9

August newsletters:

  1. Behold, That’s How You Handle Missing Data - Issue 7

  2. While I Was Drinking, AI Wrote This Newsletter - Issue 6

  3. Improving User Retention: Expert Insights - Issue 5

July newsletters:

  1. The Meow cyber attack and statistics for data analysis - Issue 3

  2. SQL Joins Don’t Scale? - Issue 2

  3. Taking Off: Scaling User Growth - Expert Insight + SQL - Issue 1

Thank you all again for your support and for sharing this ride with me ❤️. 

Until next Wednesday!