Data Warehousing and Data Mining Dr. Mohammad A. Rob
SYLLABUS Spring 2010 GROUP PROJECT Project Requirements Presentation Schedule Final Group Test RESEARCH PAPER Paper Requirements and Schedule SQL SERVER ANALYSIS SERVICES Step by Step Approach of Building a Cube Individual Student Assignment	STUDENT PROJECTS Spring 2005, Summer 2006, Spring 2010 STUDENT PAPERS Summer 2006 TEXT BOOKS Paulraj & Ponniah, SQL Server Analysis Services 2008 SAMPLE DATA WAREHOUSE FoodMart Data Warehouse
LECTURE NOTES	RESOURCES
Background and definitions The data warehouse environment Data Warehouse Technology Principles of Dimensional Modeling Dimensional Modeling: Advanced Topics SQL Server Analysis Services Online Analytical Processing (OLAP) Data Extraction, Transformation and Loading (Microsoft) The data warehouse design Methodology Data warehousing and the web An overview of Data Mining Techniques Strategies of Data mining (Microsoft) Data mining query language	SQL Server Analysis Services: Designing Analysis Services Multidimensional Database SQL Server Analysis Services Tutorial SQL Server Data Mining: SQL Server Analysis Services - Data Mining BI withExcel: Business Intelligence with Excel 2007 BI with Access: Business Intelligence with Access 2007
· Multidimensional Database Technology · Building the Data Warehouse · Introduction to OLAP · Maintenance of Aggregate Facts in Data Cubes · Microsoft Data warehouse Design Considerations · Cubes in the Real World (Microsoft)	International Institue of Business Analysis: http://www.theiiba.org/am/ Business Analysis Body of Knowledge: BABOK Guide Certification: http://www.theiiba.org