Class Room Training
- Training for 30 Days
- Daily 1Hr 30 Min
- Printed Material
- 24/7 Lab Facility
- Placement Assistance
Online Training
- Training for 30 Days
- Daily 1Hr 30 Min
- Material through Softcopy
- 24/7 Lab Facility
- Placement Assistance
Weekend Training
- Training for 4 Weeks
- Every Weekend day 3 Hrs
- Printed/Softcopy Material
- 24/7 Lab Facility
- Placement Assistance
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.