LYNDA IMPLEMENTING A DATA WAREHOUSE WITH MICROSOFT SQL SERVER 2012 TUTORIAL-kEISO

Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012 TUTORIAL-kEISO
3h 6m - Intermediate - Mar 26, 2014
Size: 364.159 MB

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
Read more at http://ebookee.org/Lynda-Implementing-a-Data-Warehouse-with-Microsoft-SQL-Server-2012-TUTORIAL-kEISO_2589941.html#ZQA0wvt30pJhzido.99