SF Data Weekly - Stats Gist List, Window Functions and Little Worlds

Whether you have gaps in your statistics knowledge, or you’re trying to communicate stats concepts to beginners, this jargon guide can help.

Using AWS EMR and Kinesis Data Streams, Cynamics was able to perform near-real-time AI inference threat analysis. This piece describes the pipeline they implemented for their security product.

Automate your order fulfilment process using little to no code with a bi-directional sync between Salesforce and NetSuite. Learn how here. [Sponsored]

Replacing Common Table Expressions (CTEs) with window functions to simplify your SQL, including examples.

This piece introduces Arrow Flight SQL, a protocol for interacting with SQL databases over Arrow Flight. The goal of this early release product is to replace JDBC/ODBC with a native approach for Arrow.

A nice example of how to use one of the many public datasets available to BigQuery users to do analysis and visualization, in this case, using COVID-19 mobility data.

With over 200 modules in the Python standard library, it’s no surprise that most programmers don’t have experience with many of them. This piece highlights five lesser-know modules, including some of the most useful functions in each.

Creating a “cold” atmosphere for a story about the northernmost city of 100,000 inhabitants or more.

After a two-year pandemic hiatus, the Data Visualization Society is once again hosting the Information is Beautiful Awards. This piece describes the awards and how to keep track of developments related to them.

How changes in the 4 Ms (Model, Machine, Mechanization and Map Optimization) can reduce your ML model energy usage by 100X and emissions by 1000x.

Lyft’s data visualizations of where you start and where you want to go.