University of Houston-Clear lake Dr. Mohammad A. Rob, CAPM
Data Warehousing and Data Mining
SYLLABUS Fall 2017 TEACHING ASSISTANT Sowmya
GROUP PROJECT

Project Requirements
Presentation Schedule


STUDENT PROJECTS & PAPERS
Spring 2005, Summer 2006,
Spring 2010
, Fall 2011, Spring 2013
Fall 2015
RESEARCH PAPER Job Prospect of a DW Analyst
Basic Principles of Effective Writing
TEXT BOOKS Paulraj & Ponniah
SQL Server Analysis Services 2012
SQL SERVER ANALYSIS SERVICES Step by Step Approach to Building a Cube
SQL Server Primary Key Issue
Individual Student Assignment
Sample Individual Report
PROFESSIONAL CERTIFICATIONS International Institute of Business Analysis

Exam 70-767: Implementing Data Warehouse with Microsoft SQL Server
  LECTURE NOTES RESOURCES  
Background and definitions Designing a Data Warehouse; Building a Data Warehouse
The data warehouse environment  
Principles of Dimensional Modeling FoodMart Data Warehouse **
Dimensional Modeling: Advanced Topics AdventureWorks Data Warehouse
Online Analytical Processing (OLAP) Contoso Database
SQL Server Analysis Services  
Public Data Sets for Group Project **
Create a Pivot Table in Excel 2013; Contoso Database ** Data Warehouse Technology
Pivot Table and Pivot Chart in Excel 2010 SQL Server Analysis Services Tutorial
SQL Server Analysis Services Tabular Modeling Step byStep SQL Server Analysis Services Data Mining Tutorial
   
SQL Server 2012 Analysis Services Multidimensional Modeling Step byStep ** Business Intelligence with Excel
SQL Server 2012 Analysis Services Data Mining Step by Step ** Building data Models with PowerPivot in Excel 2013
   
Data Extraction, Transformation and Loading (Microsoft)  
The Data Warehouse Design Methodology  
An Overview of Data Mining Techniques  
Strategies of Data mining (Microsoft)  
   
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)


Management Information Systems
The Choice is Clear