Dec 30, 2020

SF Data Weekly - 52 Weeks of Learning and Supercharging 2021

Revue

December 30 · Issue #170 · View online

Our pick (picks, really) this week are two different approaches to teaching yourself data science that you can use as a basis for your 2021 resolutions. We also have some interesting Twitch data visualizations, and a piece on supercharging your 2021 learning curve. Happy New Year and Stay Healthy!

Our Pick

A Complete 52 Week Curriculum to Become a Data Scientist in 2021 | by Terence Shin | Dec, 2020 | Towards Data Science

towardsdatascience.com – Share

In addition to Terence Shin’s complete curriculum for Data Science, you might also be interested in Madison Hunter’s Step-by-Step Curriculum that she’ll use to teach herself data science in 2021.

Data Pipelines

Scheduling SQL queries on your Amazon Redshift data warehouse | Amazon Web Services

aws.amazon.com – Share

Using Amazon Eventbridge and the Redshift Data API to schedule queries in your Redshift database.

Optimizing Your Data Strategy with Modern ETL

www.xplenty.com – Share

The new year is around the corner, and it’s the perfect time to think about your 2021 data strategy. Luckily, our webinar “Optimizing Your Data Strategy with Modern ETL” is here to help. Watch this webinar now. [Sponsored Content]

Data Storage

A gentle introduction to the 5 Google Cloud BigQuery APIs | by Antonio Cachuan | Dec, 2020 | Towards Data Science

towardsdatascience.com – Share

BigQuery has Core, Storage, Data Transfer, Connection and Reservation APIs, and this piece has solid, python-based introductions to each one.

Data Analysis

How to make your Pandas operation 100x faster | by Yifei Huang | Dec, 2020 | Towards Data Science

towardsdatascience.com – Share

Pandas is a great tool for exploring and working with data. As such, it is deliberately optimized for versatility and ease of use, instead of performance. This article tells you how to wring more performance out of your Pandas jobs.

7 Must Know SQL Querying Mistakes & Fixes | by Ashish Tomar | Towards Data Science

towardsdatascience.com – Share

This article aims to refine your querying skills by pointing out some common, yet ignored mistakes, with demonstrations and fixes.

Resources to Supercharge your Data Science in 2021 | Towards Data Science

towardsdatascience.com – Share

Websites, YouTube videos, and podcasts to advance your machine learning skills. Featuring git best practices, data viz tips, and much more.

Data Visualization

An Ultimate Cheat Sheet for Data Visualization Techniques in Seaborn | by Vildansarikaya | Clarusway | Dec, 2020 | Medium

medium.com – Share

Seaborn is a python data visualization library often used for exploratory data analysis (EDA). This article demonstrates a number of EDA techniques using Seaborn.