INTRODUCTION
- Need of Business Intelligence
- OLTP Vs OLAP
- Types of OLAP
- Available technologies and tools
- About Microsoft Business Intelligence
- About SSIS, SSRS
SSIS: SQL Sever Integration Services
- About SSIS
- ETL procedures
- About DTS Packages
- About Business Intelligence Projects
- About SQL Server Business Intelligence Development Studio
- Elements of a SSIS project
- Data Sources
- SSIS Packages
- Elements of a Package
- Connection Managers
- Control Flow Items
- Maintenance Tasks
- Dataflow
- Event handlers
- Package explorer
- Creating a SSIS Project using SQL Server Business Intelligence Development Studio
- Creating a new Package
- Executing a package
- Debugging a package
- Logging ETL operations
- Handling errors (exception handling)
- Adding an existing package to the Project
- Deploying a SSIS Project into an SQL Server
Planning an SSIS project
- Understanding the tasks
- Planning control flow operations
- Planning data flow operations
- Planning data change operations
- Planning Data mapping and migrations
- Planning maintenance tasks and operations
Optimizing an SSIS Project
- Running and monitoring
- Optimizing and Scaling
Deploying & Running SSIS Projects
- Deployment procedure
- Manual Execution
- Scheduling
Advanced
- Extracting data from other databases to SQL Server Database
SSRS: SQL Sever Reporting Services
- Importance of Reporting Servers & Services
- About SSRS
- Installing SSRS
- Stopping and starting SSRS services
- Using reporting services tools
- Logon to SSRS
SSRS Projects
- Elements of SSRS projects
- Data sources
- Reports
- Report designer
- Report planning/modeling
- Creating a SSRS project
- Formatting reports
- Adding/Removing data sets
- Adding calculated values to the reports
- Using parameters and filters
- Using Parameter lists
- Implementing Interactive Navigation in reports
- Executing reports
Publishing reports
- Publishing reports onto a SSRS Server
- Creating cached instances
- Creating Snapshots and history
- Browsing and configuring of published reports
Report Subscriptions
- About Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
SSAS: SQL Server Analysis Services
- Importance of Analytical systems and solutions in business development
- Introduction and About SSAS
Building SSAS Projects
- Elements of SSAS Projects
- SSAS Database (OLAP database)
- Data sources
- Data source views
- Dimensions & Facts
- Measures
- Cubes
- Mining structures
- Creating a SSAS Project (Multidimensional Analysis Solution)
- Creating a cube
- Planning Dimensions and facts (tables/views)
- Dimension hierarchies
- Sorting an Grouping attributes
- Configuring Measures & Measure groups
- Building KPI (Key Performance Indicators)
- Building Actions
- Building Partitions
- Building Perspectives
- Building Translations
MDX Queries
- MDX Fundamentals
- Writing MDX queries
- Adding MDX Calculations to a Cube
Data mining
- Introduction
- Planning data mining models & structures for a SSAS database
- Creating data mining models & structures
- Validating data mining models & structures
- Browsing data mining structures
Deploying a SSAS Package
- Debugging a SSAS Project
- Deploying a SSAS Database (Project)
- Securing SSAS database services using Roles
Advanced
- Using a SSIS package to supply data to a SSAS database