Reddit reviews Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema
We found 4 Reddit comments about Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema. Here are the top ones, ranked by their Reddit score.
Definitely. We actually used that book for my Business Intelligence masters course in my MIS program. I met a BI manager hiring for a data engineering role and she recommended the following text as well. The content was pretty similar as they focus on the Kimball method but goes over BEAM*, which is a requirements gathering framework for designing data warehouses.
https://www.amazon.com/Agile-Data-Warehouse-Design-Collaborative/dp/0956817203/ref=sr_1_1?s=books&ie=UTF8&qid=1511661160&sr=1-1&keywords=agile+data+warehouse+design
https://www.amazon.co.uk/Agile-Data-Warehouse-Design-Collaborative/dp/0956817203
OLAP is all about analyzing data.
OLAP is a set of operations you can do against a set of data, such as slicing, dicing, pivoting.
You don't need a database to do OLAP, for example, you can do OLAP operations against a flat file using MS Excel PivotTables.
Some stackexchange answers here:
http://dba.stackexchange.com/questions/45655/what-are-measures-and-dimensions-in-cubes
http://stackoverflow.com/questions/18916682/data-warehouse-vs-olap-cube
This is a good book: http://www.amazon.com/Agile-Data-Warehouse-Design-Collaborative/dp/0956817203
Is this the one you mean? https://www.amazon.com/Agile-Data-Warehouse-Design-Collaborative/dp/0956817203