SF Data Weekly - A New Home in Dublin and Plenty of Athena

Using Data Science to find a new home in a high demand market, featuring a number of tools in the Google Cloud Platform, with lots of detail and code snippets.

EMX’s pipeline is dumping data into S3, then using Athena SQL to aggregate the data and push it into Redshift. This post explains their pipeline and shows how it saved them significant costs over their traditional data warehouse.

Benchmarks for two python big data libraries that handle datasets larger than those that can fit in-memory when using Pandas.

Rapid data preparation and transformation for ever-evolving and changing data requirements. Secure & compliant data pipelines. Get started today. [Sponsored Content]

Using Facebook’s Prophet, a time-series forecasting tool, to forecast future usage of cloud computing resources.

A basic introduction to partitioning, and the benefits and drawbacks of different partitioning approaches.

Error-Trend-Seasonality (ETS) is a model used for time series decomposition to understand, as the name implies, trend and seasonality in a dataset. This piece uses pandas and matplotlib to perform ETS analysis.

Using Sweetviz, an open-source python library that has a HTML interface, for EDA. A nice introduction to a powerful library.

Bar chart races are a popular animated data visualization technique. This piece shows how to make them quick and easy using a python package.

Athena runs SQL queries against data stored in AWS S3 data lakes. This post shows how to use Athena and Tableau Desktop to create data visualizations quickly and economically.

How Airbnb customized Apache Superset for business intelligence at scale - 2K users, 50K SQL queries, 6K dashboard views and 125K graph views per week.

Mixpanel, a data visualization tool, launched an all new Free Plan with 100x the data volume of their old one, and made changes to their pricing curve to give startups more runway for growth. This post explains why.