Data Modeling with Apache Cassandra

See how to extract data from CSV files, transform it, and load it into Apache Cassandra. Understand how Cassandra -- or any partition row store databases -- provides scalability and fast reads and writes by adding redundant or de-normalized tables.

more ...

Data Modeling with PostgreSQL

See how to extract data from CSV files, transform it, and load it into PostgreSQL. Learn how to extract log data from CSV files using pandas, transform it with SQL and python, and then load it into a star-scheme perfect for aggregations and analytics.

more ...

How do college-town home prices fare during a recession?

During a recession, home prices suffer. How do college towns compare to other communities? Let's find out. But first, a few definitions.

  • A quarter is a specific three month period, Q1 is January through March, Q2 is April through June, Q3 is July through September, Q4 is October through December …

more ...