SF Data Weekly - The Titanic, Data Lake Security and Redshift SUPER

A detailed, step-by-step analysis of survival data from the most famous shipwreck in history, the 1912 sinking of the HMS Titanic. Despite the rather grim subject matter, the piece is a great template for similar projects, because it includes exploratory data analysis and data cleanup in addition to the ML component. If you like this piece, the same author’s look at insurance fraud detection using ML is also worth a look.

With the new SUPER data type and the PartiQL language, Amazon Redshift expands data warehouse capabilities to natively ingest, store, transform, and analyze semi-structured data, such as weblogs and sensor data.

Need to get data out of your data warehouse and into Salesforce? Follow this comprehensive guide. [Sponsored]

This is the fourth part of a series that explained how to set up governed tables, add streaming and batch data to them, and use ACID transactions in AWS Lake Formation. This post explains how to set up filter expressions for row-level security, and how to hide or show specific columns for some users.

El Carro is a new project that offers a way to run Oracle databases in Kubernetes as a portable, open source, community driven, no vendor lock-in container orchestration system. El Carro provides a powerful declarative API for comprehensive and consistent configuration and deployment as well as for real-time operations and monitoring.

A deep dive into the stats of four top cricket players who emerged in the early 2010s. All the data and a Jupyter notebook can be found on the author’s github.

Using Python to format a data table similar to conditional data formatting in Excel.

Grafana Labs’ Grafana 8.0 release features a number of new features, including the combination of different types of alerts in a single interface and a wider range of visualization options. A good example to draw from for your data visualization projects.

An interactive tool to find the best data visualization tool for your software development project, based on the framework and licensing.

Netflix is open-sourcing Netflix Data Explorer, which allows fast, safe access to data stored in Cassandra and Dynomite/Redis data stores. This piece shares some examples to show how the tool is used at Netflix.

Learn about ArcGIS StoryMaps’ timeline block and some creative ways to use it.