Call Us: +91-9000011489

Register for Free Demo

INTRODUCTION

  1. Need of Business Intelligence
  2. OLTP Vs OLAP
  3. Types of OLAP
  4. Available technologies and tools
  5. About Microsoft Business Intelligence
  6. About SSIS,  SSRS

SSIS: SQL Sever Integration Services

  1. About SSIS
  2. ETL procedures
  3. About DTS Packages
  4. About Business Intelligence Projects
  5. About SQL Server Business Intelligence Development Studio
  6. Elements of a SSIS project
    1. Data Sources
    2. SSIS Packages
  7. Elements of a Package
    1. Connection Managers
    2. Control Flow Items
    3. Maintenance Tasks
    4. Dataflow
    5. Event handlers
    6. Package explorer
  8. Creating a SSIS Project using SQL Server Business Intelligence Development Studio
  9. Creating a new Package
  10. Executing a package
  11. Debugging a package
  12. Logging ETL operations
  13. Handling errors (exception handling)
  14. Adding an existing package to the Project
  15. Deploying a SSIS Project into an SQL Server

Planning an SSIS project

  1. Understanding the tasks
  2. Planning control flow operations
  3. Planning data flow operations
  4. Planning data change operations
  5. Planning Data mapping and migrations
  6. Planning maintenance tasks and operations

Optimizing an SSIS Project

  1. Running and monitoring
  2. Optimizing and Scaling

Deploying & Running SSIS Projects

  1. Deployment procedure
  2. Manual Execution
  3. Scheduling

Advanced

  1. Extracting data from other databases to SQL Server Database

SSRS: SQL Sever Reporting Services

  1. Importance of Reporting Servers & Services
  2. About SSRS
  3. Installing SSRS
  4. Stopping and starting SSRS services
  5. Using reporting services tools
  6. Logon to SSRS

SSRS Projects

  1. Elements of SSRS projects
    1. Data sources
    2. Reports
    3. Report designer
  2. Report planning/modeling
  3. Creating a SSRS project
  4. Formatting reports
  5. Adding/Removing data sets
  6. Adding calculated values to the reports
  7. Using parameters and filters
  8. Using Parameter lists
  9. Implementing Interactive Navigation in reports
  10. Executing reports

Publishing reports

  1. Publishing reports onto a SSRS Server
  2. Creating cached instances
  3. Creating Snapshots and history
  4. Browsing and configuring of published reports

Report Subscriptions

  1. About Report Subscriptions
  2. Creating Report Subscriptions
  3. Managing Report Subscriptions

SSAS: SQL Server Analysis Services

  1. Importance of Analytical systems and solutions in business development
  2. Introduction and About SSAS

Building SSAS Projects

  1. Elements of SSAS Projects
    1. SSAS Database (OLAP database)
    2. Data sources
    3. Data source views
    4. Dimensions & Facts
    5. Measures
    6. Cubes
    7. Mining structures
  2. Creating a SSAS Project (Multidimensional Analysis Solution)
  3. Creating a cube
  4. Planning Dimensions and facts (tables/views)
  5. Dimension hierarchies
  6. Sorting an Grouping attributes
  7. Configuring Measures & Measure groups
  8. Building KPI (Key Performance Indicators)
  9. Building Actions
  10. Building Partitions
  11. Building Perspectives
  12. Building Translations

MDX Queries

  1. MDX Fundamentals
  2. Writing MDX queries
  3. Adding MDX Calculations to a Cube

Data mining

  1. Introduction
  2. Planning data mining models & structures for a SSAS database
  3. Creating data mining models & structures
  4. Validating data mining models & structures
  5. Browsing data mining structures

Deploying a SSAS Package

  1. Debugging a SSAS Project
  2. Deploying a SSAS Database (Project)
  3. Securing SSAS database services using Roles

Advanced

  1. Using a SSIS package to supply data to a SSAS database