I&#x27;m very aware of working with databases in a transactional environment (Oracle&#x2F;SQLServer&#x2F;Postgres) and I&#x27;ve done a lot of work creating reports and BI with Jasper, Oracle&#x27;s tools and Business objects. I&#x27;ve never created a data warehouse or a star schema though. I&#x27;m aware of Ralph Kimball, but I was wondering if there are any classic texts I should be aware of or any modern takes on the subject.<p>I have a rough idea how to do all this and could knock up manual scheduled scripts to do the ETL and get close to the kind of schema design. I guess what I&#x27;m looking for is a case study or overview of best practice.
Ask HN: What is a good book or resource discussing how to create a data warehouse