SF Data Weekly - Redshift Performance, Cockroach DB and Marrimeko Charts

Simple yet useful introduction to Redshift performance tuning from the author’s experience at Revel Systems.

RSQL is a command-line tool that allows scripting of Redshift commands, for ETL and any other use that would benefit from scripting commands.

Even the best e-commerce solution isn’t an all-in-one software. So which software tools and plugins should you consider? We give you 8 tips for a successful data stack. [Sponsored]

A description of CockroachDB, an open-source distributed SQL layer built on top of a distributed key-value store.

Confidence intervals are an essential concept to understand in Statistics and thus Data Science. This piece attempts to explain them simply and concisely.

D-Tale combines a Flask back-end and a React front-end to allow you to view and analyze Pandas data structures. This piece covers installation and some usage examples.

Also known as tiled charts or stacked charts, Marimekko charts are useful to visualizing category assessments by their common members, such as sales volumes of different product types over different time periods.

Leafmap is a relatively new package designed to help display geospatial data and to extract data from a map, or load data into a map.

A treemap is a visualization used to display hierarchical data. The traditional treemap consists of nested rectangles, however, there are also circular treemaps that consist of nested circles. This piece shows how to create a treemap in Python using Plotly.

The details of Uber’s internally-developed load testing framework.

Streamlit, an open-source data app building tool, is now part of Snowflake.

For those of you doing some online learning, this piece gives an overview of YouTubers offering free classes on data science and related topics. Here are this week’s job picks: