HOME     CIS DEGREES     CLASSES     INTERNS     DR. DAVIS     FEEDBACK     CIS BLOG     RMU
 


INFS 6730 - DATA INTEGRATION FOR ANALYTICS

>> Submit feedback about this course, the professor, or this website HERE

CLASS HANDOUTS
Syllabus  
Project 1: ETL/DW Build
Project 2: OLAP Cube Build
Project 2: Cube Build Steps
Project Grading Rubric
 


DISCUSS QUESTIONS
Discuss 1: Need for DW
Discuss 2: In-Memory DB

Discuss 3: Data Lakes
Discuss 4: Dim. Modeling

PROJECT TUTORIALS
SSIS - Part 1 (5 minutes)
SSIS - Part 2 (4.5 minutes)

SSIS - Part 3 (5 minutes)
SSIS - Part 4 (5 minutes)
Connect to Tables in SSIS
Connect to a Remote Cube
Navigate Cubes (6 minutes)

ADDITIONAL SLIDES
Intro to DA/BI
Evolution of DA/BI
DWs and Laundromats
Road to Denormalization
Example BI Environment
Intro to OLAP

ADDITIONAL VIDEOS
Benefits of a DW (3 min)
Real Data Warehouse? (4 min)
Turning Data into Info (3 min)
The Star Schema (2 min)
Road to Denormalization (13 min)
What is In-Memory Analytics?
What is In-Memory Computing?
What is Hadoop / Big Data?
What is a Data Lake? (3.5 min)
Data Lake versus a DW (4 min)
What is Metadata? (2 min)
Dimensions & Measures (3 min)
What is an ETL Tool? (5 min)
Data as Plastic (5 min)
What is OLAP? (5 min)

What is BI & OLAP? (10 min)

WEB LINKS / RESOURCES
MS-BI Video Tutorials

MS-BI Tools via VMWare View
MS-Power BI Service
INFORMS

Teradata University (TUN)
TUN - BSI Case Study
Gartner Group

Information Management Website
Intelligent Solutions
What is? IT Encyclopedia
Chart Examples - World Health
iDashboard Examples