September 2010
Beginner to intermediate
424 pages
12h 17m
English
book
Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis
Content preview from Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Understanding SSIS
If you’re new to SQL Server Integration Services (SSIS), it can be a very intimidating and over-
whelming tool. It consists of a myriad of diverse components, each of which can perform a
multitude of operations. SSIS is a tool that can be used to construct high-performance work-
flow processes, which include, but are not limited to, the extraction, transformation, and load-
ing of a data warehouse (ETL). It encompasses most of the tools required to migrate data from
various data sources, including flat files, Excel workbooks, databases (SQL, Oracle, MySQL,
DB2), and many other sources. Coupling SSIS with the SQL Server Agent you have the ability
to construct an entire ETL framework that can fully or incrementally load your warehouse on
a time-based interval that meets your organization’s needs. In this section we demystify some
of the key components of SSIS. We focus primarily on those that are essential in the develop-
ment of most SSIS packages.
BUSINESS INTELLIGENCE DEVELOPMENT STUDIO BIDS
BIDS is the Graphical User Interface (GUI) that you will use to develop, debug, and maybe
deploy SSIS packages, which are the building blocks of SSIS. This tool allows you to develop
packages that can:
Execute SQL Tasks
Extract data from various sources
Load data into various sources
Perform data cleansing
Lookup, Merge, and Aggregate data
Note that this is not an exhaustive ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.