SF Data Weekly - How Long, Soda and Sankey

The founder of the dataviz consultancy 3iap analyzes and visualizes timesheets for 10 client projects.

Transforming a dataset before loading it into Power BI improves query performance and saves memory. This piece shares best practices for transformation before loading.

API Integration tools are used to share data and improve the functionality of apps. These tools can also assist digital transformation, which streamlines business processes, creates more opportunities for automation, and brings more flexibility to IT ecosystems. [Sponsored]

A community-driven list of database tools, updated frequently.

Learn how hotspots can impact the performance of your Cloud Bigtable database. Debugging hot tablets can reduce P99 latencies and increase throughput.

An in-depth look into the past and present of data validation, and how you can leverage today’s tools to ensure data quality at scale, using Soda Core as an alternative to Great Expectations.

Statistical bias and its relationship to variance, illustrated.

Sankey diagrams are good for presenting many-to-many mappings between domains, or multiple paths through a number of stages. This piece uses Titanic survival data to create an example in Javascript.

How to use Amazon Athena Federated Query to connect a MongoDB database to Amazon QuickSight in order to build dashboards and visualizations.

Social Technology Operating Measures Principles - or STOMP - is a set of principles to help standardize the measurement and qualification of metrics at Snapchat.

Joleen shares five mistakes she made when constructing her self-study plan.

Here are this week’s job picks:

Data Quality Engineer - Affinity

Data Science Manager - Lawrence Berkeley National Lab

Lead Threat Data Scientist - TikTok