MSBI Training with SSIS, SSAS, SSRS and Realtime Project

SQL School, one of the best institutes for online training provides Microsoft Business Intelligence [MS BI] course with one REALTIME PROJECT. Course Duration is for minimum of 60 hours, completely practical and covering SQL Server Integration Services [SSIS], SQL Server Analysis Services [SSAS] and SQL Server Reporting Services [SSRS].

SQL Server Integration Services

·        Need for MSBI  Process and Workflow Management

·        Control Flow  and Data flow Tasks

·        Data Modeling Requirements

·        ETL with non-SQL Server sources

·        Variables and Dynamic SSIS Configurations 

·        Advanced Control Flow Tasks

·        Error Handling and Event Handling

·        Incremental Data Load and Buffer Management

·        SSIS Transactions, Isolation Levels and Checkpoints

·        SCD, DQS and SCRIPT Operations

·        Custom SSIS Components (CHECKSUM) and Data Profiling

·        SSIS Catalog (SQL Server 2012) versus MSDB Deployments

·        SSIS Deployment Wizard and ISPAC Management

·        SSIS Tuning and Issue based Troubleshooting tips

·        SSIS Interview Questions and Guidance

For detailed SSIS course content  http://sqlschool.com/SSIS_Online_Training.html

   

SQL Server Analysis Services

·        Data Warehousing Principles

·        Analysis Services Architecture (SSAS 2012) – Tabular and Multidimensional

·        DW Entity Identification Techniques

·        Dimension Design and Attribute Relations

·        Cube Design and Hierarchy Design

·        Advanced SSAS Design and MDX Expressions

·        Advanced MDX Functions and limitations

·        KPI Identification and Calculations

·        Implementing Tabular Datawarehouse with DAX Expressions

·        Managing Data warehouses and Security with XMLA

·        Data Mining Operations with DMX

·        Performance Counters and Optimizations

·         Migrating SSAS 2008 (R2) Projects to SSAS 2012

·         Generation of Reports from SSAS Cubes

·        SSAS Tuning and Issue based Troubleshooting tips

·         SSAS Interview Questions and Guidance

For detailed SSAS course content http://sqlschool.com/SSAS_Online_Training.html

SQL Server Reporting Services

·         SSRS 2012 Architecture and Need for Web Services

·         Reporting life Cycle and SSRS Workflow

·         Report Filters and Dynamic Parameters

·         Chart Based Reports

·         List and Rectangle Reports

·         Sub Reports and Linked Reports

·         Gauges Reports and Dundas Report Control Operations

·         Cube Reports with MDX and DAX

·         Report Tuning and Schedules

·         Report Caching, Refresh and Snapshot  Options

·         Data Driven Subscriptions

·         Managing Reporting Services

·         Report builder Applications

·         Security Management

·         Report Delivery and Hosting

·         SSRS Tuning and Issue based Troubleshooting tips

·         SSRS Interview Questions and Guidance

For detailed SSRS course content http://sqlschool.com/SSRS_Online_Training.html

*ALL OUR SESSIONS ARE COMPLETELY PRACTICAL*

For free Demo and further training details, please contact us.

SQL School

contact@sqlschool.com

Office: (+91)   040 64577244 (SR Nagar, Hyderabad, India)
http://sqlschool.com