INTRODUCTION

Microsoft provides a complete set of business intelligence tools as part of the Microsoft SQL Server, Sharepoint, and Office applications.Microsoft has products for data integration (SSIS), analytics (SSAS), business intelligence (SSRS), and visualization. These tools can be deployed either stand-alone or as part of a Sharepoint system. After the course participant will be able to: Understand Datawarehouse Principles and Implementation Rules Desing Data warehouses with ETL and Data Cleansing activities, Implement Incremental Data Loads and Data Delta operations, Perform DW Coding, Deployment, Analysis and Forecasts, Work with MDX Joins, Complex sub Queries, Report Integrations.
Module 1 - SQL Server Integration Services (SSIS)
. SSIS Architecture and DW Concepts
. SSIS Expressions & Debugging
. Data Flow Transformations
. Event Logging and Event Handling
. Deployment Procedures
. Deployment Options & Utilities
. SSIS Package Security and Upgrades
Module 2 - SQL Server Analysis Services (SSAS)
. Introduction to SSAS and DW Storage
. SSAS Design Entities & Cube Usage
. KPI Calculations and Partitioned Aggregations
. MDX Functions, FILTERS and JOINS
. Data Mining and Forecast
. Deployment (Tabular & Multidimensional)
. OLAP Management (Tabular & Multidimensional)
Module 3- SQL Server Reporting Services (SSRS)
. Reporting Services Architecture
. Report Design with Data Sets & Aggregates
. Sub Reports Parameters & Filters
. Cube Reports and Report Models
. Report Builder Usage & Schedules
. Delivering SSRS Reports
. Managing Reports
. Scheduling and Subscriptions
. SSRS Report Security
. SSRS Configurations

SHARE WITH YOUR FRIENDS