MSBI Course Curriculum

Duration : 35 Days

SQL Server Development

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

SSIS (SQL Server Integration Services)

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

SSRS (SQL Server Reporting Services)

  • Introduction to SSRS
  • Architecture of SSRS
  • What is Report Server
  • What is Report Manager
  • Creating Reports using Wizards
  • Creating reports using BIDS
  • What are Data sources
  • What are Shared Data sources
  • Types of Reports (Table and Matrix)
  • Parameterized report
  • Multi-valued Parameterized Reports
  • Drill Down report
  • Page break concept
  • AdHock Report / Wizards – DONE
  • Cascading report
  • Drill through Report / hyperlink report / jump report / navigation report / go to report/ Action report
  • Rectangle Report
  • Chart report and its properties
  • Sub report
  • Gauge
  • Map Reports
  • 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
  • Types of Relationships Concepts:
  • One – One
  • One – many
  • many – many
  • 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
  • Referenced Relationship
  • Hierarchies and Performance Tuning Technique
  • 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 and Different types of Creations
  • Storage design – ROLAP, MOLAP , HOLAP
  • How to use Cube in Excel
  • MDX Queries

Course Info

Learn MSBI

We determined the requirements of IT industries and designed the courseware by our panel of Mentoring Board, while considering MSBI standards, Industrial ongoing changes and valuable feedbacks from senior competency heads.

Read This For A Minute And Think For A While

All Small to Large Scale Industries need the Business Intelligence and Extensive Automated Process to understand their Business and to do so they have opted technologies related to ETL / Integration / Reporting / Analysis.

Though you have lots of ETL, Reports and Analysis Services in the Business, MSBI technology has been supporting Most of the clients with END – END Solutions and Since it has All the Products Integrated inside it together and also because MSBI is the Microsoft Product it has been trusted by all the companies and have been implemented.

MSBI (Microsoft business Intelligence suit)

This technology is implemented by MICROSOFT and majorly consists of tools like SQL, SSIS, SSRS and SSAS to full fill the customer End – End requirement related to ETL (extract transform load), Analysis part and the Reporting part.

SSIS (SQL Server Integration Services)

SSIS is the ETL tool of Microsoft used to Extract the data from multiple sources and apply any business logic and load into the target, Wherein it has many Transformations (business rules) to process the data before loading into the Target, so that it can be used for many purpose.

SSRS (SQL Server for reporting services)

The Reporting Services tool is used to create the Interactive server reports or the client reports, to convert your Raw data into charts, Bars, grids etc., with all printing option, converting options (pdf, excel, word, csv etc).

SSAS (SQL Server for Analysis Services)

This Analysis Services Tool is used for Creating Cubes in Multidimensional / OLAP Database and for Performance Tuning of your data base.

Who Should Attend?

  • Entry-level Software professionals (From any background)
  • MBA, BBA, MCA, M.Sc, B.Tech, B.E Fresher / Experienced people
  • Domain experienced professionals ( Banking, Insurance, Finance, Capital market, Pharma, Telecom, energy & Utilities, Marketing, Retail, Consumer durables, Consulting, Manufacturing, Aerospace etc. )
  • Developers / Programmers / Middleware tool consultants / .Net / Java Develope
  • r
  • Manager / Project Manager / BI Developer / Database Developer, etc.
  • Test engineers / Test leads
  • Reporting Analysts from any technology
  • SAP/Siebel/PeopleSoft/PEGA/Sales Force etc., [ERP/CRM/BPM] Business consultants