Live Help (Start Chat)
Download syllabus copy Download printable copy

MSBI incl. SSRS, SSIS and SSAS

Image

Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it's the solution for automating data movements. SSIS provides a way to build packages made up of tasks that can move data around from place to place and alter it on the way.

Though SSIS is almost infinitely customizable, Microsoft has produced a simple wizard to handle some of the most common ETL tasks: importing data to or exporting data from a SQL Server database. The Import and Export Wizard protects you from the complexity of SSIS while allowing you to move data between any of these data sources

Microsoft has come up with its own reporting service, in conjuction with SQL server database to introduce the Microsoft SQL Server Reporting services[SSRS]. It provides projects of type Business Intelligence Project thus enabling not only large companies but also medium-sized and small companies also to earn from its benefits. This aids in better business decisions too.

Microsoft SQL Server Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases.


MSBI incl. SSRS, SSIS and SSAS Objectives

  • To understand MSBI application development Lifecycle.
  • To understand basic Data Warehousing Concepts
  • To understand the Concept of OLTP and OLAP
  • To Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
  • To learn SSIS Architecture, Components of SSIS.
  • To gain complete understanding of different control flow tasks, containers and precedence constraints.
  • To gain complete understanding of wide variety of data flow Sources, Transformations and Destinations.
  • To learn to work with variables, data types, functions, expressions and parameters and providing Dynamism in SSIS
  • To develop packages using different tasks and different Transformations based on real time requirements.
  • To learn working with event handler, Logging, Configuration Files.
  • To learn Error Handling and Debugging in SSIS.
  • To learn package deployment and project deployment.
  • To gain understanding of Security and Package management.

Prerequisites

SQL Server 2012

MSBI incl. SSRS, SSIS and SSAS Duration

  • Regular classroom based training available for this course. 6 week ends
  • Visit for online training by Mrs.Vandana Soni,Please visit :

http://www.bestdotnettraining.com/online-sqlserver-training

MSBI incl. SSRS, SSIS and SSAS Syllabus

  1. What is SSIS?
  2. Need for SSIS
  3. BIDS and SSMS tools
  4. SSIS and DTS Comparison
  1. Launching BIDS
  2. The package designer
  3. The Toolbox
  4. Solution Explorer
  5. The Properties window
  6. The Variables window
  7. The SSIS menu
  1. Runtime Engine Dataflow Engine
  2. Object Model
  3. SSIS Service
  4. Buffer Management
  5. Creating SSIS Packages
  6. Solution, project and package creation
  7. Simple package creation using import export wizard
  8. Simple packages creation for data movement between (Flat file, xml, raw,database etc)
  1. Control flow overview
  2. Working with containers
    1. For each loop
    2. For loop
    3.  Sequence
    4.  Handling Enumerations
  3. Working with tasks
    1. . Execute SQL Task
    2. . Bulk Insert Task
    3. . File System Task
    4.  FTP Task
    5.  Transfer Database Task
    6.  Backup database task
    7.  Script task
    8.  Execute process task
facultyImg

Vandana Soni

A well known trainer at Deccansoft for more than 6 years, she is a specialist in SQL Server and has taught well over 80 batches. Her uniqueness lies in conducting her classes with ease and clarity, making her students understand even the most complex queries with no difficulty at all. more

Post an Enquiry

Email Id
Contact No
Course
Details
Scroll to Top