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 implementing...
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.
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.
This demo introduces the primary development tools used to build Microsoft BI solutions, including Visual Studio / Business Intelligence Development Studio, SQL Server Management Studio. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This presentation introduces Microsoft BI solution development and its primary value proposition. Microsoft BI expands the reach of your investments in the Microsoft productivity platform, data infrastructure and collaboration tools you already own. Our solution delivers business intelligence...
This demo shows a complete BI solution end-to-end that delivers information to decision makers using SQL Server 2008 R2 and Office 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This presentation defines business intelligence and discusses how to apply business intelligence to address common business problems. It also discusses several different BI solution scenarios and introduces the key scenario covered in this course: integrated reporting and analytics. Presenter:...
Microsoft SQL Azure Database is a cloud-based relational database service built on SQL ServerĀ® technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. In this session you will learn everything you need to know to get started with...