MSBI Online Training

2796 Ratings

MSBI Training Demo Video

MSBI Online Training Course Content

SQL Server Development

  • SQL Server database Overview
  • What is DDL, DML
  • Data Types
  • What are Constraints (Identity, Unique, Check, NULL, Default)
  • Operators
  • Aggregates
  • Where
  • Group by
  • Having
  • Distinct, Top
  • Date functions
  • Temp tables
  • Table Variables
  • Usage of While loop & if conditions
  • Case Statement
  • Ranking Functions
  • Scalar Functions
  • Exception handling
  • Transactions
  • Joins
  • Sub Queries
  • Views
  • CTE
  • Cursor
  • Stored Procedures
  • User Defined Functions (String, Table value: inline Functions and multi value)
  • Triggers

SSIS (SQL Server Integration Services)

  • SSIS Introductions
  • Control Flow
  • Data Flow
  • Precedence constraint & Expressions
  • Sequence Container
  • Annotation
  • Data Flow Components
  • Data viewer
  • Copy
  • OLEDB Source
  • OLDB Destination
  • Audit
  • Character Map
  • Conditional Split
  • Row sampling
  • Percentage sampling
  • Multicast
  • Data conversion / Type Cast
  • Sort
  • Merge
  • Union all
  • Aggregate
  • Derived
  • RowCount
  • BreakPoints
  • Merge join
  • Flat File Destination
  • Excel Destination
  • OLEDB Command
  • Cache transformation (target is cashed)
  • Lookup
  • SCD (type 1, type 2)
  • Excel Source
  • Flat File Source
  • Control Flow Components
  • Sequence Containers
  • For loop
  • For each loop
  • Variables with default values
  • Variables with dynamic values through Expressions
  • Dynamic loading of Excel files into SQL target
  • FTP Task
  • Execute SQL Task – Basic
  • Execute SQL task with parameter and with result
  • Breakpoints
  • Script task
  • Bulk Insert Task ( sending FF – SQL)
  • Execute package
  • Execute process
  • ERROR Output in DF
  • File system Task
  • Send Mail Task
  • Logging
  • Checkpoints (restart ability)
  • Jobs (Scheduling)
  • Deployment
  • Configurations

Real-time Project related to Image and Capture Work stream with Banking Domain which implement  real time Working Framework with ERROR Handling

SSRS (SQL Server Reporting Services)

  • Introduction to SSRS
  • Architecture of SSRS
  • What is Report Server
  • What is Report Manager
  • Creating reports using BIDS
  • What are Data sources
  • What are Shared Data sources
  • Types of Reports (Table and Matrix)
  • FOTTER
  • HEADERS AND EXPRESSIONS.
  • Parameterized report
  • Multi-valued Parameterized Reports
  • Page break concept
  • Drill Down report
  • Report Wizard / Adhock Report /Ad-Hock Report / Wizards
  • Cascading report — Parameter Dependency
  • Drill through Report / hyperlink report / jump report / navigation report / go to report/ Action report
  • Chart report and its properties & expressions
  • Sub report
  • List Report with Image
  • Rectangle Report
  • Indicators
  • Gauge
  • Deployment
  • Report Subscription (Email and Windows File Share) and Scheduling
  • Report Manager Operations
  • Edit Report
  • Move / Delete Report
  • Linked Report
  • Cashed / Execution Report
  • Snap short and History comes under this report

SSAS (SQL Server Analysis Server)

  • Introduction to SSAS
  • Schemas
  • Star Schema
  • Snowflake Schema
  • Data source
  • Data source views
  • Options in DSV
  • Dimension
  • Measures
  • Cube Creation
  • Build
  • Deploy
  • Process
  • How to Brows the CUBE
  • Types Of Relationships inside CUBE
  • No relationship
  • Regular Relationship
  • Fact Relation
  • Referenced Relationship
  • Many to Many
  • None
  • Hierarchies
  • What are KPI’s and How to Create KPI’s in SSAS
  • What are Perspective and how to create
  • What are Partitions
  • What are Translations
  • What are Actions
  • What are Calculations
  • Aggregations
  • Storage design – ROLAP, MOLAP , HOLAP
  • How to use Cube in Excel
  • MDX in Report

for MSBI Online Training Course Demo Register Now

Register Now






Training Type:
ClassroomOnline

MSBI Job Trends