 |
Introduction To SQL SERVER 2005(MSBI) Training 
|
|
SQL SERVER 2005(MSBI) Training Overview
SQL SERVER 2005 is a complete database stage providing data Management with Integrated Business Intelligence(BI) tools. In this Sql Server 2005 training course,Basic Data warehousing concepts are discussed in detail.Data warehousing and Data Mart architecture is explained.ETL process is shown.students will learn to install complete Sql Server package.complete undertsanding of SSIS(Sql Server Integration Services), SSAS(Sql Server Analysis Services) and SSRS(Sql Server Reporting Services) is given.students are helped to build packages in SSIS using manual and wizard method.All the control flow and data flow transformation are shown. In SSRs creation of Data source view,Dimension,Fact Table and Cube is shown in detail.Performance parameters are analysed using Cube. Finally,in SSRS Cube is used for Reporting.creation of new and different formats of Reports is shown.Later preview and deploy of Report is done
|
|
SQL SERVER 2005(MSBI) Training Class Goals
- Learn The basic DAta Warehousing Concepts
- Learn the installation of Sql Server 2005
- Learn the differences between SSIS,SSAS,SSRS
- Learn to create Data Packages using SSIS
- Learn different Transformations
- Learn to create Cube,Dimension and Fact using SSAS
- Learn to Analyse Data with different view
- Learn to create different format Reports
- Learn to preview and deploy Report
|
|
Micrsoft Business Intelligence (MSBI) Courseware
- Data Warehousing Introduction
-
- Basic Concepts
- Views AND Dimensio
- Fact Data Overview
- MS SQL SERVER 2005 Introduction
-
- Why MS Sql Server 2005
- Features of Sql Server 2005
- Installation of Tools
- SQL SERVER 2005 Management Studio Database
-
- Introduction
- Data Manipulation Language(DML)
- Data Control Language(DCL)
- Triggers
- Cursors
- Functions
- Views
- Synonyms
- MS Business Intelligence Introduction
-
- Introduction To ETL
- Introduction To SSIS,SSAS,SSRS
- BI Architecture Overview
- Sql Server Integration Services(SSIS)
-
- Introduction
- Steps to start SSIS
- Creating Packages
- importing data from different sources like Oracle,flat File,Management Studio,Excel
- Creating Sourse Connection
- Using EXPORT/IMPORT Wizard
- Data Flow Transformation
- Control Flow Transformation
- Conclusion
- Sql Server Analysis Services(SSAS)
-
- Starting with Analysis Services
- Connecting to Data Source
- Creation of a data Sourse View
- Diffrentiating FACT AND DIMENSION Data
- Creating Dimension
- Creating Fact
- Creating Cube
- CUBE Features
- Conclusion
- Transformation Basic Concepts
-
- Data Integration Concepts
-
- Source Qualifier,Reusable Transformation,Debugger,Detail Review of the Expression,Filter
- Sorter, Aggregator , Joiner, Lookup, Update Strategy,
- Router and Sequence Generator Transformations, Source and Target Overrides
- Parameters and Variables ,Self-Join ,Incremental Aggregation ,Dynamic Lookup Cache
- Slowly Changing Dimension ,Audit ,Character Map ,Conditional Split ,Copy Column
- Data Conversion ,Derived Column. ,Export Column ,Look Up ,Fuzzy Look Up ,Merge
- Merge Join ,Row Count
- IMPORT/EXPORT Of Data
-
- From Management Studio To ORACLE,FLAT FILE,EXCEL AND VICE VERSA
- FRrom EXCEL TO DB2 AND VICE VERSA
- Sql Server Reporting Services(SSRS)
-
- Introduction
- Starting with Report Services Model prOject
- Defining Data Source
- Creating a New Report
- Creating New Data Set
- Writing T-SQL for the Report
- Designing Report
- Previewing and DEploy the Report
- Conclusion
|
|
 |
I got the opportunity of getting a practical experience on SAS couse from InfoSchool. It helped me in learning new analytical tools and their applications, today I am in my dream job. Thanks to InfoSchool for giving this opportunity.
By Vidya,
SAS Developer, PowerSoft Technologies,
|
|
|
