INFS 4260 - 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: DL/Big Data Analysis
Project Grading Rubric

REVIEW QUESTIONS
Chapter 1   |   Chapter 9
Chapter 2   |   Chapter 10
Chapter 3   |   Chapter 12
Chapter 4   |   Chapter 13
Chapter 5   |   Chapter 14
Chapter 7   |   Chapter 15

DISCUSS QUESTIONS
Discuss 1: Need for DWs?
Discuss 2: In-Memory DB
Discuss 3: Data Lake/Big Data
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
MS-Azure Portal
AWS AppStream
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