Deploying an Analytical Database
O’Reilly has a short but interesting article on “5 mistakes to avoid when deploying an analytical database”.
Point one is pretty much the case of the engineer in the sweet shop. Stop and think before you decide on the technology stack, and if its really going to help. 🙂
Point four is critical from my perspective. The best TLA to describe this is the ELT paradigm compared to the old ETL world. Extract all data element from the source systems, and store in your analytical database. Zero information loss.
Tales from a Trading Desk 