Articles in watch

Turn Small Data Into Smart Data. Part 2: ETL with NodeJS and ES6 Promises

This is the second of a three part series focused on an open source tool chain for small data business intelligence. Part 1 explored dimensional modeling from a logical and use case perspective. Part 2 focuses on Extract, Transform and Load with Nod…

Continue reading »

Turn Small Data Into Smart Data. Part 1: The Star Schema

This is the first of a three part series focused on an open source tool chain for small data business intelligence. Part 1 explores the history and reasoning behind dimensional modeling via a use case: online video viewing analysis. We examine the de…

Continue reading »

Ecto 2.0: The Database Tool for Elixir and Phoenix

This screencast introduces Ecto 2.0. It starts with an overview of the entire stack Ecto works with from Erlang to Elixir to Phoenix. Then it walks thru using Ecto with PostgreSQL by creating a mix project, configuring database access, seeding some d…

Continue reading »

Watch: Create a PostgreSQL Deployment on Compose and Load It

This screencast walks thru creating a deployment. We load festival data from the Bonnaroo 2016 lineup into an example database via psql. Through Compose's online data browser, we review the example schema and seed data. Plus, there is a quick example…

Continue reading »