Are there any excellent sources (book, podcast, tribal folklore, etc) fo rgetting a grasp on using OLAP for data analysis in SQL Server (or just in generic terms that can be applied to SQL Server)?
+1
A:
The Oracle Magazine has some good techniques and articles from the field.
Abhinav
2008-08-27 15:13:35
+2
A:
This presentation has a good deep introduction to what OLAP is, what it does for you, and how people use it.
This website has a good tutorial on setting up an example DB set for learning OLAP and then shows you how to use it.
Google will give you more specific examples if you are targeting MSQL, Oracle, DB2, etc.
You will also want to refer to the terms "Multidimensional modeling" and "Data warehouse". You'll find lots of books on the subject, but don't get one until after you go through the online materials.
-Adam Davis
Adam Davis
2008-08-27 15:22:00