SF Data Weekly - Automate Your Life, Prefect and Pendulum

Using mitosheet and selenium to automate repetitive tasks like creating spreadsheets and graphs, and scraping data from websites.

How to break your workflow into chunks with Prefect, automatically.

Real-time data replication is needed by many idustries including: eCommerce, Fintech, Healthcare, and SaaS. If you need real-time data insights, FlyData could be a good solution. [Sponsored]

Hierarchical databases are useful when you need to represent data in a tree-like hierarchy, and Redshift’s recently introduced Common Table Expressions (CTEs) can help make querying hierarchical tables easier and faster.

Google offers four different ways to connect to their offerings. This piece helps you decide which one is right for your application.

A look at of the most important types of ML algorithms.

Pendulum is a drop-in replacement for the standard Python datetime library that resolves the issues that the standard library has with timezones, for example.

After having explained how to read box plots to thousands of workshop participants, the author now believes that they’re poorly conceived and prone to misinterpretation.

Activist and technologist Murray Cox has been described as a “Lone Data Whiz” who is Airbnb’s “Public Enemy No. 1 in New York.“ This piece describes how his project, Inside Airbnb, became a key tool for housing advocates in New York City.

How Twitter engineers apply machine learning techniques to forecast SQL query resource utilization during the development and maintenance of our large-scale SQL system.

TrueBlue, a staffing company, uses QuickSight to provide regional pricing data to its sales team.