Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012

English | Mar 26, 2014 | .MP4 | Audio: aac, 44100 Hz, mono | Video: h264, yuv420p, 1280x720, 15.00 fps(r) | 424 MB

Genre: E-learning

Learn how to design and implement an enterprise data warehouse. Microsoft Certified Trainer Martin Guidry shows how to design fact and dimension tables using both the star and snowflake techniques, use data quality services to cleanse data, and implement an ETL process with SQL Server integration services.

Topics include:

Typical databases vs. vdata warehouses

Choosing between star and snowflake design schemas

Working with appliances and "big data"

Exploring source data

Implementing data flow

Debugging an SSIS package

Extracting and loading modified data

Enforcing data quality

Consuming data in a data warehouse

More Info