University of Houston-Clear lake Dr. Mohammad A. Rob, CAPM
Data Warehousing and Data Mining

Project Requirements
Presentation Schedule

Spring 2005, Summer 2006,
Spring 2010
, Fall 2011, Spring 2013
Fall 2015
RESEARCH PAPER Job Prospect of a Big Data Analyst
Basic Principles of Effective Writing
TEXT BOOKS Paulraj & Ponniah
SQL Server Analysis Services 2012
SQL SERVER ANALYSIS SERVICES Steps of Creating Cube for Group Project
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
Background and definitions Sample Database Project **
The data warehouse environment Building a Data Warehouse
Principles of Dimensional Modeling FoodMart Data Warehouse **
Dimensional Modeling: Advanced Topics AdventureWorks Data Warehouse
Online Analytical Processing (OLAP) Contoso Database
SQL Server Analysis Services  
DATA.GOV: 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