Trainings : BI
Overview
The Focus of the Initial Modules of the Course deals about what is SQL Server, Queries, Procedures And Development in SQL Server which targets even the people new to SQL Server 2008. Later that a Deep Drive on SQL Server Integration Services, Reporting Services, Analysis Services with Practical Examples & live scenarios.
In this phase, audiences will get in familiar with developing Business Intelligence applications by using the IDE. At the end, it takes the audience to a case study that explores all the features of a SQL Server & Its business intelligence features in the mock up.
Attendee Prerequisites
Mandatory: Attendees should have Knowledge of Computers
Optional: It is also recommended (but not required) that attendees have a background any version of SQL Server or Any Database.
Career Path
After completing this course you will be able to take up the roles of
- SQL Server Developer
- SQL Server Business Intelligence / MSBI Developer
Introduction to Business Intelligence
- Business Intelligence and features
- Microsoft Business Intelligence Vision
- Components of MSBI
- SSIS
- SSRS
- SSAS
- Real time scenarios
SQL Server Integration Services (SSIS)
Introduction to SSIS
- Introduction to ETL
- SSIS and Features
- SSIS package lifecycle
- Developing simple packages with Import and Export wizard
- Analyzing the packages
- Tools of SSIS
- Developing package with BIDS
- Architecture of SSIS
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
- Built in Log Providers
SSIS Package Management
- The SSIS Service
- Managing packages with DTUtil
- Managing packages with SQL Server Management Studio
- Scheduling Packages
Working with Control Flow Tasks
- What is control flow?
- Types of control flow tasks
- Working with tasks
- Variable overview
- Creating and Working with variables
- SSIS system variables
- Using variables in control flow
- Using variables to pass information between packages
- Using Expressions
- Introduction to .Net framework
- Working with Script Tasks
- Script Task
- ActiveX Script
- Script Components
SSIS Package Deployment
- Configuration and deployment
- Deployment Utility
- Deployment Options
- Package Security
- Executing packages using DTExec, DTExecUI
Implementing Data Flow
- Data Flow elements
- Working with Transformations
- Types of Transformations
- Row Transformations
- Row Set
- Split and Join
- Synchronous and Asynchronous
- Other transformations
Advanced Data Flow
- Revisiting data sources and destinations
- Lookup Transformations
- Getting Fuzzy: Fuzzy Lookup and Fuzzy Grouping Transformations
- Slowly Changing Dimensions
- Working with Checkpoints
SQL Server Reporting Services (SSRS)
Introduction to Reporting Services
- Different ways of Reporting
- Types of Reporting
- Characteristics of a good report
- Reporting Life cycle
- Introduction to SSRS
- Features and Tools
- Developing Sample report
Using Subscriptions to Distribute Reports
- Introduction to Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
Administering Reporting Services
- Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
Authoring Reports
- Installing and Configuring SSRS
- Developing Reports with Report wizard
- Developing Reports from scratch
- Using Datasets
- Tabular Report
- Matrix Report
- Working with Report parameters
- Formatting Reports
- Adding calculated values
- Using Dynamic Visibility
- Using a List Data Region
- Working with Stored Procedures
- Creating Report models
- Using Report builder
Publishing and Executing Reports
- Publishing Reports
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
Programming Reporting Services
- Querying for Server Information Using a Web Service
- Automating Report Management
- Rendering Reports
- Creating Custom Code
SQL Server Analysis Services (SSAS)
Introduction to Analysis Services
- Introduction to OLTP, OLAP, DWH
- Type of OLAP Systems
- Basic of Multidimensional Architecture
- Dimensional Tables
- Fact Tables
- Cubes
- Introduction to SSAS
- Features, Tools and Services
Advanced Cube Design
- Implementing Key Performance Indicators
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
- Partitioning
Introduction to Data Mining
- Overview of Data Mining
- Creating a Data Mining Solution
Creating Multidimensional Analysis Solutions
- 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
- Working with Measure Groups
Managing Cubes
- Configuring Processing Settings
- Implementing Security
- Logging, Monitoring and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
Querying Multidimensional Analysis Solutions
- What is MSX?
- MDX Fundamentals
- Members
- Cells
- Tuples
- Sets
- MDX Query
- SELECT Statements and Axis Specification
- FROM Clause and Cube Specification
- WHERE Clause
- WITH Clause
- MDX Expressions
- Operators
- MDX Functions
