I wonder that this question hasn't already been asked. Google only has very few results for me that don't show a high quality tool
What are some Open Source (also free is ok) solutions for Data Warehouses and more specifically Business Intelligence Tools? What are your experiences with them. I have had a course in my masters programm and we worked with MS Business Intelligence and MSSQL as Data Warehouse storage. Now I want to get more into this topic with tools that are "open".
Are there any compareable tools for Business Intelligence (mostly database independent) and do you have any experience with them?
edit With Marian's comment to Stephanie's answer, I see that I have formulated the question wrong. I am aware that DWH are just "reporting-optimized" databases, Stephanie's explanation was very clear on that. I am more interessted how to get the data into such optimised forms with WHAT kind of BI software/tools/other techniques.