Introduction to BI Modeling Techniques This unit will introduce you to data common data modeling techniques used when building Microsoft BI solutions. Dimensional data models and semantic data models make it easy for developers and users alike to query and analyze data. Hands-On Labs Hands On Lab: Your First Look at the SQL Server 2008 R2 Sample Databases This Hands On Lab introduces the AdventureWorks Sample Databases. These sample databases are ideal for learning how to build Microsoft BI solutions. Hands On Lab: Building Your First Semantic Model with the ADO.NET Entity Framework This Hands On Lab covers how to build a semantic model to enable query and analysis using the ADO.NET Entity Framework. Videos Presentation: Designing Data Models for Microsoft BI Solutions This presentation introduces developers to dimensional data modeling techniques. Dimensional 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. Demo: Exploring a Sample Dimensional Data Model 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. Presentation: Designing Semantic Models for Microsoft BI Solutions 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. Demo: Creating a Data Model with the Microsoft Entity Framework 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.