SQL Server Business Intelligence Overview
Introduction to Integration Services, Reporting Services, and Analysis Services
What you'll learn
This course introduces you to some of the Business Integration tools available in SQL Server, including SSIS, SSRS, and SSAS.
Table of contents
- Introduction 3m
- Overview 2m
- Package 1m
- Package Example 6m
- Control Flow 1m
- Control Flow Example 13m
- Parallel Control Flow example 9m
- Loop example 13m
- Data Flow 1m
- Data Flow Source 1m
- Data Flow Source example 17m
- Data Flow Transform 1m
- Transform Example 14m
- Package Deployment 1m
- Deploy and Run example 8m
- Summary 4m
- Introduction 1m
- Defining OLTP 3m
- Defining OLAP 2m
- The Data Warehouse 1m
- Star Schema 2m
- Multi-Dimension Concepts 1m
- Understanding Dimensions 1m
- Members, Levels and Hierarchies 1m
- Measures and Aggregates 2m
- SQL Server Analysis Services 2m
- System Roles and Workflow 2m
- Creating an Analysis Services Project 1m
- Creating a Data Source 2m
- Creating a Data Source View 1m
- Customizing the Data Source View 3m
- Creating Name Queries 2m
- Creating the Customer Dimension 4m
- The Product and Date Dimensions 2m
- Creating the Cube 3m
- Deployment and Processing 2m
- Verifying Deployment 1m
- Browsing the Cube 2m
- SSAS Clients 3m
- Querying from Excel 2m
- Querying from SSRS 5m
- Querying with ADOMD.NET 7m
- SUmmary 1m
About the authors
Bret is a consultant based in Ramona, CA. Bret has over 20 years of experience in the IT field, and over a decade of experience as a trainer. He is a published author having contributed to multiple Syngress publications. He is also frequent speaker at regional events such as Code Camps and user groups. He focuses primarily on SQL Server, but is an expert in .NET development as well as SharePoint development, configuration and administration.
Scott has worked on everything from 8-bit embedded devices to large scale web sites during his 15+ years in commercial software development. Since 2001, Scott has focused on server-side and web technologies, like ASP.NET, ASP.NET AJAX, Windows Workflow, Silverlight, and LINQ. Scott is also a speaker at national conferences like VSLive!, as well as code camps and user groups near his hometown of Hagerstown, MD. Scott has been recognized as a Microsoft MVP since 2005, and has written or co-... more
Dan is an independent consultant, author, and speaker. He likes data; pointy data, rectangular data, even data just lying around on the floor. He is a co-author of the book "A Developers Guide to SQL Server 2005". His articles have been published in MSDN Magazine and SQL Server Magazine and he has spoken at WinDev, Microsoft events, as well as to various developer groups.