SQL Server Business Intelligence Overview

Introduction to Integration Services, Reporting Services, and Analysis Services
Course info
Rating
(600)
Level
Beginner
Updated
May 10, 2010
Duration
3h 47m
Table of contents
Description
Course info
Rating
(600)
Level
Beginner
Updated
May 10, 2010
Duration
3h 47m
Description

This course introduces you to some of the Business Integration tools available in SQL Server, including SSIS, SSRS, and SSAS.

About the author
About the author

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.

More from the author
Alan Turing's Wonderful Machine
Beginner
2h 20m
Dec 16, 2015
XML Fundamentals
Intermediate
4h 51m
May 11, 2012
.NET Regular Expressions
Intermediate
3h 29m
Oct 31, 2011
More courses by Dan Sullivan
About the author

Scott has over 15 years of experience in commercial software development and is a frequent speaker at national conferences, and local user groups. Scott is a Microsoft MVP and has authored books on several Microsoft technologies, including ASP.NET, C#, and Windows Workflow.

More from the author
More courses by Scott Allen
About the author

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.

Section Introduction Transcripts
Section Introduction Transcripts

SQL Server Reporting Services
Hi, this is Scott Allen of Pluralsight, and this module is an introduction to SQL Server Reporting Services. In this module, we're going to look at Reporting Services from a developer's perspective and come to an understanding about what Reporting Services can do for us. SQL Server Reporting Services is a platform that we can build on, and it consists of both server and client components. We're going to take a look at both of those pieces and we'll also start building some basic reports.

SQL Server Analysis Services
Hi my name is Bret Stateham from Pluralsight. In this session, we'll look at an overview of SQL Server Analysis Services 2008. Specifically, we'll talk about SQL Server analysis services by first looking at some general industry standard concepts around Online Transaction Processing or OLTP as well as Online Analytical Processing or OLAP. We'll also get some vocab out as we discuss some different multi-idimensional concepts, and then we'll look at SQL Server Analysis Services as Microsoft's offering for a multi-dimensional database engine. We'll then come in and look at, how do we go about developing SQL Server Analysis Services databases. We'll look at the different computers or systems that are involved in the overall system and what their roles are, as well as what the general workflow is, as we go from developing to actually having a completed process database up on a server. We'll actually walk through that in a demo, and then we'll wrap up this session, looking at the different types of clients that can connect to SQL Server Analysis Services. We'll look at an overview of those clients, look at some of the different APIs that are available to you as a developer, and then go through some demos. We'll look at connecting to Analysis Services from Excel. We'll look at connecting to it from another SQL Server BI tool, SQL Server Reporting Services, and then also look at connecting to it from a custom. NET application.