we provide MSBI online trainings

This course aims to provide participants with the solid experience and know-how to do SQL Server 2012 MSBI tools

(Data ware housing concepts).



Introduction SQL Server 2012.

SQL-Architecture.

GAM, SGAM, Pages, Extents.

Database engine,

Multiple instances,

Sql server2012 editions,

SQL Server 2012 databases and Objects,

Sql Server Physical Structure.

MSBI studio.

What is new for MSBI in SQL Server 2012?

MS-BI (SSIS, SSAS, SSRS)

SSIS Objectives

Plan data transfer and staging solutions for an ETL operation
Plan an SSIS Solution
Design and implement data flows
Incorporate logging, error handling and reliability into a
package

Optimize an SSIS Solution
Deploy an SSIS Solution
Contents: Planning for ETL

Identifying Data Sources and Destinations
Evaluating Source Data
Identifying Staging Requirements


Planning an SSIS Solution

Planning Packages
Planning Package Development
Designing Package Control Flow
Designing Data Flow

Understanding Data Flow
Designing Data Flow Operations
Handling Data Changes
Logging, Error Handling and Reliability

Logging ETL Operations
Handling Errors in SSIS
Implementing Reliable ETL Processes with SSIS
Optimizing an SSIS Solution

Monitoring SSIS Performance
Optimizing SSIS Packages
Scaling Out SSIS Packages
Deploying and Operating an SSIS Solution

Deploying SSIS Packages
Operating an SSIS Solution


SSAS Objectives:

Describe how SQL Server Analysis Services can be used to
implement Analytical solutions

Create multidimensional analysis solutions with SQL Server
Analysis Services

Implement dimensions in an Analysis Services solution
Implement measures and measure groups in an Analysis
Services solution

Query a multidimensional Analysis Services solution
Customize an Analysis Services cube
Deploy and secure an Analysis Services database


Maintain a multidimensional Analysis Services solution

Implement Data Mining solution
Contents: Introduction to Microsoft SQL Server 2012 Analysis

Services

Overview of Data Analysis Solutions
Over of SQL Server 2012 Analysis Services
Installing SQL Server 2012 Analysis Services
Creating Multidimensional Analysis Solution

Developing Analysis Services Solutions
Data Sources and Data Source Views
Creating a Cube
Working with Dimensions

Configuring Dimensions
Defining Hierarchies
Sorting and Grouping Attributes
Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups
Querying Multidimensional Analysis Solutions

MDX Fundamentals
Adding Calculations to a Cube

Customizing Cube Functionality

Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations
Deploying and Securing an Analysis Services Database

Deploying an Analysis Services Database
Securing an Analysis Services Database


Maintaining a Multidimensional Solution

Configuring Processing Settings
Logging, Monitoring and Optimizing an Analysis Services
Solution

Backing Up and Restoring an Analysis Services Database
Introduction to Data Mining

Overview of Data Mining
Creating a Data Mining Solution
Validating Data Mining Models
SSRS Objectives

Describe SQL Server Reporting Services and its components
Create a Reporting Services report
Enhance a Reporting Services report
Create and implement data sets
Use report models to implement reporting for business users
Configure report publishing and execution settings
Implement subscriptions for reports
Implement custom Reporting Services applications
Contents: Introduction to Microsoft SQL Server Reporting Services

Overview of SQL Server Reporting Services
Reporting Services Tools
Authoring Basic Reports

Creating a Basic table Report
Formatting Report Pages
Calculating Values
Enhancing Basic Reports

Interactive Navigation
Displaying Data
Manipulating Data Sets

Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Manipulating Data Sets
Publishing and Executing Reports

Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Using Subscriptions to Distribute Reports
Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions