Extract, translate, and load (ETL) are steps used to prepare data for reporting. We might think that data warehousing or “big data” is just for the enterprise. But most of us perform these tasks, just at a smaller scale. That one-off rake task? Almost never one-off. Pulling from APIs? Endpoints throttle requests and users paste randomly encoded characters into your text fields. This talk will walk through basic ETL and dimensional modeling concepts applied with an example project.