MSBI (SSIS, SSAS, SSRS) Online Training Course Content +91 - 9246 333 245
- MSBI COURSE CONTENT
- Introduction to Microsoft Business Intelligence
- Installing and using BI tools
- Configuring BI tools
SSIS
- INTRODUCTION TO SQL SERVER 2008
- INTEGRATION SERVICES
- Over view of integration services solutions
- Integration Services Tools
- DEVELOPING INTEGRATION SERVICES SOLUTIONS
- Creating an Integration Services Solution
- Using Variables
- Building And Running a Solution
- IMPLEMENTING CONTROL FLOW
- Control Flow Tasks
- Control Flow Precedence Constraints
- Control Flow Containers
- IMPLEMENTING DATA FLOW
- Data Flow Sources and Destinations
- Data Flow Transformations
- Data Flow Pipeline
- IMPLEMENTING LOGGING
- Overview of Integration Services Logging
- Implementing Logging
- DEBUGGING AND ERROR HANDLING
- Debugging a Package
- Implementing handling
- IMPLEMENTING CHECKPOINTS AND TRANSACTIONS
- Implementing Checkpoints
- Implementing Transactions
- SSIS ADMINISTRATION
- Deploying Packages
- Managing Packages
- Securing Packages
- Scheduling a Package
SSRS
- INTRODUCTION TO MICROSOFT SQL SERVER REPORTING SERVICES
- Over View of SQL Server Reporting Services
- Installing Reporting Services Reporting Services Tools
- AUTHORING REPORTS
- Creating a Basic Table Report
- Formatting Report Pages
- Calculating Values
- Interactive Navigation
- Displaying Data
- MANIPULATING DATA SETS
- Defining Report Data
- Using parameters and Filters
- Using Parameter Lists
- PUBLISHING AND EXECUTING REPORTS
- Publishing 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
- SSRS ADMINISTRATION
- Server Administration
- Performance and Reliability monitoring
- Administering Report Server Databases
- Security Administration
SSAS
- INTRODUCTION TO ANALYSIS SERVICES
- OLTP,DWH
- OLAP TYPES
- SSAS Architecture
- Dimension Tables
- Fact tables
- Cubes
- Analysis Services Tools
- CUBE DESIGN PROCESS AND CONCEPTS
- Dimensions
- Measure groups
- Creating Simple Calculations
- Aggregations and Hierarchies
- Dimensions Relationships
- Transactions
- Perspectives
- ADVANCED CUBE DESIGN PROCESS
- MDX introduction and Queries
- Implementing KPI
- Implementing Actions
- Using Write back
- SSAS ADMINISTRATION
- Apply Security Roles
- Levels of Security
- VLDB with partitioning
- OLAP Processing
- Monitoring Cube activity
- Deployment and Scheduling
- Planning for Disaster Recovery
- Performance Tuning SSAS
- For best msbi online training with ssis training by real time expert trainer contact @+91 - 9246333245
