MSBI Training Demo Video

Best MSBI Training institution is SkillXpert. Learn MSBI Training with one of the software industry expert, who have been dealing with MSBI Applications since a decade.

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

Job Opportunities:

After the course completion, we have strong clients Relation Existing with many IT Organizations, we will help the students with Placement Assistance Program with these Clients.

List of the Companies Offering Job Opportunities to our Students.

Infosys	Wipro	Prokarma
Cognizant	Virtusa	Marlabs
GalaxESolutions	CapGemini	Cigniti
Polaris	HSBC	ValueLabs
NCR	Dell	IBM
Deloitte	NTT Data	GalaxESolutions
Persistent	iGate	Sapient

Course Complete Certification:

We implemented Course Complete Certification process to give enormous information and support through the projects to our students, the one who gets the course complete certification is eligible to login to the projects developed and will be developed by us on the related technology, tools and course.

This Access will be provided for 12 months for the student from the day when he gets his CCC for SkillXpert.