SQL

This presentation provides an overview of common business reporting scenarios and challenges, and discusses how SQL Server 2008 R2 Reporting Services can address them.  A brief overview of the architecture of Reporting Services is also covered. Presenter: Peter Myers, Mentor, Solid Quality…

This demo introduces the concept of data flow in a SQL Server 2008 R2 Integration Services package.  Data flows can be developed to extract data from multiple sources, and then integrate and transform that data into a format that is useful for reporting and analytics.  Presenter: Peter…

Dimensional data models have unique traits that must be considered when implementing an ETL process to load them.  This presentation describes how to load fact and dimension tables in a SQL Server 2008 R2 Integration Services package, including slowly changing dimensions.  Presenter:…

SQL Server 2008 R2 Integration Services includes a powerful data flow engine optimized for ETL processing.  This presentation covers how to build data flow tasks which are a fundamental part of any ETL process. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This demo introduces the concept of control flow in a SQL Server 2008 R2 Integration Services package.  Control flow governs the order and precedence of how tasks are executed.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation introduces how SQL Server 2008 R2 Integration Services uses control flow to govern the order and precedence of how tasks are executed. Presenter: Peter Myers, Mentor, Solid Quality Mentors.

ETL processing (extract, transform, load) is a fundamental component of many Microsoft BI solutions.  ETL enables the transformation of raw data into meaningful and actionable information.  SQL Server 2008 R2 Integration Services provides a comprehensive set of tools and services for…

This demo shows how to build a data model for a Microsoft BI solution using the Microsoft Entity Framework that exposes an OData feed to support self-service analytics.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This presentation introduces developers to semantic modeling techniques.  Semantic data models make it easy for developers and users alike to query and analyze data in a Microsoft BI solution.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

This demo introduces the dimensional modeling techniques used in the AdventureWorksDW2008R2 sample database.  This sample is helpful for learning how to build a star schema.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.