Business Intelligence with Ruby
summary
Argues that small apps get big BI value by building a single star schema fact table as a single source of truth, loading it via simple ETL (even a nightly full rebuild) so analysts avoid divergent SQL. Claims a metric‑filter‑groupby pattern covers ~90% of queries, cites a 30 MB prototype warehouse and a real dashboard for The Conversation as proof it works. Recommends Ruby with the Sequel gem to write testable, maintainable transforms.
AI-written summary · about
chapters (7)
- 0:00Start
- 11:38Star Schema
- 14:43Druid
- 15:53Etl Extract Transform Load
- 20:17Signal Gem
- 28:33Multi Value Dimension
- 29:09Bridge Table
related talks
30mLightweight Business Intelligence
39mData Warehouses and Multi-Dimensional Data Analysis
29mBig Data Enterprisy Analytics App and Ruby
36mData Management with Ruby
10mBI Tooling with Rails
34mBuilding Data Driven Products with Ruby
25mPowerful Data: Making Rails Apps Faster with Aggregation
40mLevel-up Your ActiveRecord Skills: Learn SQL!