PSN Trainings is the Best MSBI Microsoft Business intelligence training(SSIS, SSAS, SSRS)Training institute in Hyderabad,India
Course Description
Introduction
Data Warehousing Basic Concepts
- Data Warehouse Definition,
- Reasons for using, uses
- Characteristics of DWH
- OLTP Vs OLAP Databases
msbi training in india
Data Marts and Star Schema Design
- Design of Dimension and Facts
- Definition of Star Schema
- Snow Flake Star Schema
- Slowly Changing Dimensions
- Type of Facts
- Conformed Dimensions
Implementation Methodology
- Kimball Methodology
- Inmon Methodology
Types of Loads
- First Time Load
- Full Load
- Incremental Load
I) SQL Server Integration Services (SSIS)
1. Introduction to SQL Server Integration Services
- Product History
- SSIS Package Architecture Overview
- Development and Management Tools
- Deploying and Managing SSIS Packages
- Source Control for SSIS Packages
2. SQL Server Data Tools(Visual Studio)
- Launching Data tools
- Project templates
- The package designer
- The Toolbox
- Solution Explorer
- The Properties window
- The Variables window
- The SSIS menu
3. Introduction to Control Flow
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
- The FTP Task
- The Send Mail Task
4. Advanced Control Flow
- Containers - grouping and looping
- The Analysis Services tasks
- The Execute Process Task
- The Execute Package Task
msbi online training in hyderabad
5. Introduction to Data Flow
- Data Flow Overview
- Data Sources
- Data Destinations
- Data Transformations
- The Copy Column Transformation
- The Derived Column Transformation
- The Data Conversion Transformation
- The Conditional Split Transformation
- The Aggregate Transformation
- The Sort Transformation
- Data Viewers
6. Variables and Configurations
- Variables Overview
- Variable scope
- SSIS system variables
- Using variables in control flow
- Using variables in data flow
- Using variables to pass information between packages
7. Debugging, Error Handling and Logging
- SSIS debugging overview
- Breakpoints in SSIS
- SSIS debugging windows
- Control Flow: The On Error event handler
- Data Flow: Error data flow
- Configuring Package Logging
8. Advanced Data Flow
- The Lookup Transformation
- Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
- The Multicast Transformation
- The Slowly Changing Dimension Transformation
9. Extending SSIS through Custom Code
- Introduction to SSIS scripting
- The SSIS script editor
- The SSIS object model
- Script in Control flow: The Script Task
- Script in Data flow: The Script Component
- Introduction to SSIS component development
10. SSIS Package Deployment
- Configurations and deployment
- Managing packages with DTutil
- Managing packages with SQL Server Management Studio
II) SQL Server Reporting Services (SSRS)
1. Introducing SQL Server Reporting Services
- Features
- Reporting Services Architecture
- Reporting Services Terminology
- Reporting Services Editions
2. Creating Reports
- Shared Data Sources
- Creating Reports from Scratch
3. Calculations and Formatting
- Reporting Services Items
- Basic Expressions
- Using the Global Collections
- Formatting Fields
- Conditional Formatting
4. Grouping and Sorting
- Creating Groups
- Interactive Sorting
- Creating Drill-Down Reports
- Calculating Totals and Percentages
5. Report Parameters
- Creating Report Parameters
- Binding Report Parameters to Dataset Parameters
- Creating Drop-Down Parameters
- Multi-Valued Parameters
6. Creating Matrix Reports and Charts
- Creating a Basic Matrix Report
- Matrix Subtotals
- Creating Chart Reports
- Exploring the Charting Possibilities
- Charting Add-ons
7. Managing Reporting Services
- Using the Web-Based Report Manager
- Using SQL Server Management Studio- based Reporting Services Manager
- Deploying Reports and Data Sources
8. Reporting Services Security
- Reporting Services Security
- Managing Roles
9. Distributing Reports via Subscriptions
- How Subscriptions Work
- Creating Standard Subscriptions
- Creating Data-Driven Subscriptions
- Managing Subscriptions
10. Ad-Hoc Reporting with Report Builder
- The Report Builder Architecture
- Creating Report Model Projects
- Running Report Builder
III) SQL Server Analysis Services (SSAS)
1. Introduction to Microsoft SQL Server Analysis Services
- Overview of Data Analysis Solutions
- Overview of SQL Server Analysis Services.
- Installing SQL Server Analysis Services.
2. Creating Multidimensional Analysis Solution
- Developing Analysis Services Solutions.
- Data Sources and Data Source Views
- Creating a Cube
3. Working with Dimensions
- Configuring Dimensions
- Defining Hierarchies
- Sorting and Grouping Attributes
4. Working with Measures and Measure Groups
- Working with Measures.
- Working with Measure Groups.
5. Querying Multidimensional Analysis Solutions
- MDX Fundamentals
- Adding Calculations to a Cube
6. Customizing Cube Functionality
- Implementing Key Performance Indicators.
- Implementing Actions
- Implementing Perspectives.
- Implementing Translations.
7. Deploying and Securing an Analysis Services Database
- Deploying an analysis Services Database.
- Securing an Analysis Services Database.
