Windows Server
Admin 0 hours

Session 27: Implementing a Data Warehouse with Microsoft SQL Server 2012

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.

0 min.

Learning Objectives:

  • 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
Back to Course

Tanuj

Instructor

Duis egestas aliquet maecenas erat eros, fringilla et leo eget, viverpretium. Quisque sed augue tincidunt, posuere dui tempor, dapibus nisi. Donec vel lectus sapien. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.

Full Profile

Ready to get started?

Get in touch

Contact Us