During this Microsoft Business Intelligence [MSBI] training program, you will dive into Designing an ETL Solution Architecture Using Microsoft SQL Server Integration Services and Implementing and Maintaining Microsoft SQL Server Integration Services. In addition, we will extensively cover how to Design an Analysis Solution Architecture Using Microsoft SQL Server Analysis Services and Implement and Maintain Microsoft SQL Server Analysis Services. You will expand your knowledge on MDX Queries and learn how to create complex reports employing expressions, global collections, and conditional formatting using SQL Server Reporting Services.
Microsoft Business Intelligence [MSBI] course consists of all real time tasks which arise in day to day activities. Each and every topic is covered with unique case studies. Microsoft Business Intelligence [MSBI] course is divided into 3 modules and totals more than 50 hours of instructor-led training for SQL Server 2008/2005 Business Intelligence.
Audience
Microsoft Business Intelligence [MSBI] course is intended for IT Professionals who are responsible for implementing and maintaining SQL Server 2008/2005 reporting and analysis solutions.
Course fee - 600$(Save 150$)
The charge for each module SSIS-250$, SSRS-250$, SSAS-250$.
If you take entire Microsoft Business Intelligence [MSBI] it is going to be 500$. Save 100$.
For any queries on how to pay, mail us to billing@sqlservermasters.com
SQL SERVER INTEGRATION SERVICES :
Integration services overview
- Integration Services Architecture
- Common SSIS Applications
- SSIS Objects
- SSIS Process Control
- SSIS Components
Building Your First Package
- Exploring Business Intelligence Development Environment
- Using the SSIS Import and Export Wizard
- Reviewing the Package Elements
- Testing the Package
- SQL Server 2000 DTS Migration
Integration Services Objects and Concepts
- Integration Services Packages
- Control Flow Elements
- Integration Services Containers – For Loop,Foreach Loop, Sequence & Task Host Container
- Control Flow Tasks – Data Flow Task, FTP Task, Execute SQL Task..etc
- Precedence Constraints
- Data Flow Elements
- Data Flow Sources
- Data Flow Destinations
- Data Flow Transformations
- Integration Services Connections
- Integration Services Variables
- Integration Services Event Handlers
- Integration Services Log Providers
Designing and Creating Integration Services Packages
- Working with Data in Data Flows
- Using Data Source and Data Source View in Packages
- Setting Package Properties Window
- Creating Connection Managers
- Creating Package Control Flow
- Creating Package Data Flow
- Creating Package Event Handlers
- Reusing and Viewing Package Objects
Scripting Tasks
- Understanding Script Tasks
- Implementing a Script Task
- Understanding the Script Component
- Implementing the Script Component
- Understanding an ActiveX Script Task
Debugging Packages
- Debugging Control Flow
- Debugging Data Flow
- Debugging Script
Managing Package Execution
- Implementing Logging in Packages
- Implementing Transactions in Packages
- Using Checkpoints and Checkpoint Restarts in Packages
- Using Variables in Packages
- Using Expressions in Packages
Detecting and Handling Processing Errors
- Basic Error Detection and Handling
- Understanding Event Handlers
- Creating Event Handlers
- Maintaining Data Consistency with Transactions
Deploying SSIS Packages
- Package Configurations
- Creating and Applying Package Configurations
- Creating the Deployment Utility
- Deployment Options
- Installing Packages
- Redeployment of Packages
Securing the Packages
- Setting the Protection Level of Packages
- Integration Services Roles – Role Based Security
- Protecting Access to Running Packages
- Protecting Files Used by Packages
Administering the Integration Services
- Integration Services Service
- Managing Integration Services Packages
- Scheduling Package Execution in SQL Server Agent
- Backing Up and Restoring the Packages
- Monitoring Integration Services Performance and Activity
Optimizing and Troubleshooting Integration Services
- SSIS Engine Overview
- Memory Buffer Architecture
- Execution Trees
- Synchronous and Asynchronous Process
- Data Blocking
- Troubleshooting Package Development
- Troubleshooting Package Execution
- Troubleshooting Package Performance
Applying SSIS to Data Warehousing
- Data Warehouse Concepts
- Populating Data Warehouse Structures using SSIS
- SSIS General Principles
* For all the above topics there will be a Demo and Lab session. Case studies will be provided based on the scenario.
SQL Server Analysis Services
Introduction to Dataware Housing
- Core Concept – BI is the cube
- Example cube as seen using Excel Pivot Table
- Demonstrating of SSRS with cube as a Data Source
Introduction to Dataware Housing
- Core Concept – BI is the cube
- Example cube as seen using Excel Pivot Table
- Demonstrating of SSRS with cube as a Data Source
OLAP Modeling
- Modeling source schemas – Star and Snowflake Schema
- Dimensional Modeling –Type 1,2 & 3
- Understanding Fact and Dimensional Tables
Using SSAS in BIDS
- Understanding the development environment
- Creating Data Sources and Data Source Views
- Creating cubes – using the UDM and the cube Build Wizard
- Refining Measures and Dimensions in BIDS
Intermediate SSAS
- KPIs
- Perspectives
- Translations – cube metadata and Currency Localizations
- Actions – regular, drill-through and reporting
Advanced SSAS
- Using Multiple Fact Tables
- Modeling Changing Dimensions – Dimension Intelligence Wizard
- Using the Write-back, semi-additive measures
Cube Storage and Aggregation
- Advanced Storage Design – MOLAP,ROLAP,HOLAP
- Partitions – relational and Analysis Services Partitions
- Customizing Aggregation Design
- Proactive Caching
- Cube Processing options
Beginning MDX
- Basic syntax
- Using the MDX query editor in SSMS
- Most-used Functions & Common tasks
- New MDX functions
Intermediate MDX
- Adding Calculating members
- Adding Scripts
- Adding named sets
SSAS Administration
- XMLA scripting (SSMS)
- Security – roles and permissions
- Disaster Recovery –backup / restore
* For all the above topics there will be a Demo and Lab session. Case studies will be provided based on the scenario
SQL Server Reporting Services
Introduction to SQL Reporting Services
- Reporting Services Features
- Reporting Services Architecture
Reporting Services Components Overview
- Components
- Report Manager
- Report Server
- Report Builder
- Report Designer
- Model Designer
- Reporting Services Configuration Tool
- Report Server Administration Tools
Building Your First Report
- Report Creation Wizard
- Authoring a Report
- Data Sources
- Datasets
- Report Layout
- Managing a Report
- Reviewing and Changing Report Properties
- Reviewing and Changing Execution Properties
- Changing Data Source Properties
- Accessing a Report
- Displaying, Searching and Exporting a Report
Structuring , Formatting and Expressions
- Structuring a Report
- Sorting and Grouping of Data
- Adding Group Headers
- Computing Sub Totals
- Formatting a Report
- Setting the Format Property
- Working with Page Headers and Page Footers
- Triggering Page Breaks
- Expressions
- Creating Expressions
- Using Aggregate Functions
- Using Conditional Formatting
Organizing Data in Reports
- Using a Matrix
- Grouping Rows and Columns
- Sorting Rows
- Using Subtotals in a Matrix
- Using Static Rows and Columns in a Matrix
- Using a Chart
- Adding a Chart
- Adding Values and Column Groups to a Chart
- Grouping Data by Series
- Adding a Chart Legend
- Setting Chart Properties
- Using a List
- Adding a List
- Grouping and Sorting a List
Advanced Reports
- Creating Report Parameters
- Creating Drop-down parameters
- Linking Information with Interactive Features
- Adding Sub Report
- Working with Hierarchical Data
- Creating , Modifying and Managing the Report Model
Managing Reporting Services
- Deploying Reports and Data Sources
- Exporting Reports and Printing
- Using the Web-Based Report Manager
Reporting Services Security
- Using Report Server Security
- Applying Data Security
Programming Reporting Services
- Integrating Reporting Services into Applications using URL Access
- Using the Report Viewer Controls
Snapshots and Subscriptions
- Caching and Snapshots
- Created Standard Subscriptions
- Creating Data-Driven Subscriptions
- Managing Subscriptions
Ad-Hoc Reporting with Report Builder
- Creating Report Model Projects
- Running Report Builder
* For all the above topics there will be a Demo and Lab session. Case studies will be provided based on the scenario.
No prior experience is presumed.
Hands-on/Lecture Ratio
This class is 70% hands-on, 30% lecture.
Software Needed on Each Student PC
- Windows Server 2003 or 2008, Windows XP Professional, with at least 1GB RAM
- SQL Server 2008/2005 and Business Intelligence Components
After completing Microsoft Business Intelligence[MSBI] course, students will be able to:
- Understand the structure of a Business Intelligence Solution, including multi-dimensional database models and the role of data transforms and data analytics
- Design and implement data transformation solutions to populate data-marts and data-warehouses using SSIS
- Define business dimensions, measures, hierarchies, members and KPIs in BIDS using SSAS
- Build custom reporting solutions using SSRS
All students will receive:
A copy of Guide to SQL Server Integration services, Analysis Services and Reporting Services.
