|
Course Title:
|
End to End Business Intelligence Register Now!
|
|
Duration:
|
4 days
|
|
Overview:
|
Our Business Intelligence class is designed to introduce students to all of the tools used for reporting and analysis. Students begin by learning the basics of loading and transforming data using Integration Services, move into building Analysis Service cubes, and then learn how to build reports using Reporting Services. Time permitting the students do a final workshop on the last day that uses many of the skills and techniques taught during the course.
|
|
Prerequisites:
|
Students should have some basic familiarity with writing queries against SQL Server. No previous knowledge of Integration Services, Analysis Services, or Reporting Services is required. This course targets beginner to intermediate users, but even intermediate users will find this class valuable. For more advanced training please look at our Integration Services and Analysis Services courses.
|
|
Course Materials:
|
Students will receive a printed copy of the course materials. Students will also receive the following reference books:
- Microsoft SQL Server 2005 Analysis Services Step by Step
|
|
Outline:
|
Day 1
- Module 1:
Introduction to the SSIS environment
- Give a demonstration of Business Intelligence Development Studio (BIDS)
- How to create a shared connection.
- Module 2: Tasks
- Overview of the commonly used tasks.
- Hands-on Lab: Create your first package.
- Module 3: Drilling into the Data Flow
- Overview of the commonly used transforms, source and destinations.
- Hands-on Lab: Creating your first data flow.
- Module 4: Expressions and Variables
- The expression language in SSIS.
- The scoping of variables.
- Debugging SSIS with the watch window
- How to use variables and expressions to make a package dynamic.
- Hands-on Lab: Creating a dynamic package using variables.
- Module 5: Containers
- Using the various containers.
- Looping through tasks.
- Hands-on Lab: Looping through a series of tasks.
Day 2
- Group Lab: Design and Architect an end-to-end SSIS package to loop through a
directory and load data into a table.
- Module 6: Developing the Dimensional Model
- Basics of data warehouse design
- Metric Decomposition Data Profilng
- Analysis Services terminology
- The UDM
- SSAS development and deployment tools
- SSAS Projects
- Hands-on Lab: Creating a DSV
- Module 7: SSAS Overview
- Dimensions and Measures
- Aggregates
- Storage and processing options
- Hands-on Lab: Creating your first cube.
Day 3
- Module 8: Advanced Cubes & Dimensions
- Creating hierarchies
- Dimension and attribute properties
- Varying types of dimensions in SSAS
- Defining dimension, attribute and hierarchy properties
- Hands-on Lab: Creating a cube without the wizard
- Group Lab: Creating an End-to-End Cube against Project Real.
- Module 9: Introduction to Reporting Services 2005
- Architecture
- RDL
- Web Service based
- Module 10: Creating, Managing & Deploying Reports
- Report Builder
- Report Manager
- Creating Folders
- Deploying Datasources & Reports
- Hands-on Lab:
Create an Enterprise Folder System and Deploy Initial Reports
Day 4
- Module 11: Introduction to BI Design Studio
- UI Walkthrough
- Solutions & Projects
- Source Control
- Using the Report Wizard
- Data Sources & Views
- Module 12: Using Controls in Reports
- List
- Table
- Image
- Crosstab
- Chart
- Sub Report
- Hands-on Lab: Exploring the Controls
- Module 13: Parameters
- Applied to Data Source
- Applied to Report
- Multi Value Parameters
- Hands-on Lab: Build & Deploy a Parameterized Report
- Module 14: Using Models & Cubes For Reporting
- Concepts & Advantages
- Creating a Basic Model
- Adding Fields to a Model
- Hands-on Lab: Build & Deploy a Model
- Group Lab: Bringing it all together
|