From NoSQL to SQL: Turning Key-Value Pairs into Old Fashioned Tables for Analytics
Key:Value tables are great for when you're dealing with unstructured data but sometimes you just need an old-fashioned tabled to run analytics on.
Working With Data
Designing For Data-Intensive Applications
Some thoughts on designing for data-heavy applications.
Data: Cleaning Data from an ELT Process
Some reference scripts for transforming, cleaning, and modifying PostgreSQL/Redshift data generated by an ETL feed.