Microsoft BI Training explains how to create real world integration, Analytical and Reporting applications with MSBI. Microsoft BI tools cover a wide range of functionalities and they hold up to the competition very well.
MSBI Training Curriculum
Introduction & Installation – Microsoft Business Intelligence
Get started with the Installation of MSBI and how to configure BI tools..
using BI tools
Configuring BI tools
Microsoft SQL Server Integration Services (SSIS)
Overview of Integration Services, Different Integration tools present and get yourself introduce to SQL Server..
Introduction to SQL Server 2008
Overview of integration services solutions
Integration Services Tools
Developing Integration Services Solutions
Learn, How to create an Integration Services using variables and also how to run the services after building it..
Creating an Integration Services Solution
Building And Running a Solution
Implement Control Flow
The focus in this module will train you to learn different types of Control flow elements..
Control Flow Tasks
Control Flow Precedence Constraints
Control Flow Containers
Implement Data Flow
SQL Server Integration Services provide three different types of data flow components: Sources, Transformations, and Destinations.
Data Flow Sources and Destinations
Data Flow Transformations
Data Flow Pipeline
Implement Logging in SSIS
SSIS includes log providers that you can use to implement logging in packages, containers, and tasks. With logging, you can capture run-time information about a package, helping you audit and troubleshoot a package every time it is run.
Overview of Integration Services Logging
Explore Debugging and Error Handling
While a package is running in the debug environment you are able to see the status of both control flow and data flow components.
Debugging a Package
Implement error handling
Implement Checkpoints AND Transactions
In this module, you’ll learn, How to implement Checkpoints and Transactions..
When you install SQL Server, all users in the Users group have access to the Integration Services so that they can grant permissions at Deploying, Managing, Securing and Scheduling a package level..
Scheduling a Package
Microsoft SQL Server Reporting Services (SSRS)
Get a complete overview on SQL Server Reporting Services and also how to install the Services tool..
Overview of SQL Server Reporting Services
Installing Reporting Services Tools
This section briefly defines, How to Create a Basic Table report, Formatting a Report pages, Calculating its value and also interactive navigation..
Creating a Basic Table Report
Formatting Report Pages
In this module, you’ll learn, how to define a report data using parameter lists, filters and parameters..
Defining Report Data
Using parameters and Filters
Using Parameter Lists
Publishing and Executing Reports
Understand how to publish, execute reports and also learn how to create Cached instances, Create Snapshots and Report History..
Creating Cached instances
Creating Snapshots and Report History
Using Subscriptions to Distribute Reports
A Reporting Services subscription is a configuration that delivers a report at a specific time or in response to an event, and in a file format that you specify.
Creating Report Subscriptions
Managing Report Subscriptions
Administering a Reporting Services installation requires that you know how to perform routine maintenance tasks for server components, Security administration and how to manage the content and ongoing operations of the report server.
Performance and Reliability monitoring
Administering Report Server Databases
Microsoft SQL Server Analysis Services (SSAS)
In this tutorial, we will learn about the differences between Data Warehouse database and OLTP database and the different types of OLTP..
Introduction To Analysis Services
DWH and OLTP Types
The focus in this module trains you on, SSAS Architecture that includes Analysis Services tools and Different types of tables..
Analysis Services Tools
Cube Design Process and Concepts
Learn about, how to create simple calculations, Aggregations, Hierarchy and measuring groups..
Creating Simple Calculations
Aggregations and Hierarchies
Advanced Cube Design Process
By the end of this module, you’ll learn about, How to implement Actions, KPI and also about the Queries and MDX introduction..
MDX introduction and Queries
Using Write back
Members of the Server administrator role within an instance of Analysis Services have unrestricted access to all Analysis Services objects. In this module, you’ll get a detail description about OLAP Processing, Assigning security roles, How to monitor cube activity, and also about Performance tuning of SSAS..
Apply Security Roles
Levels of Security
VLDB with partitioning
Monitoring Cube activity
Deployment and Scheduling
Planning for Disaster Recovery
Performance Tuning SSAS.
- 10 Days
- 0 Units
- 0 Hrs