Microsoft Business Intelligence [MSBI] Course Content:-
- What is MS-BI
- BI/DWH life cycle
- ETL and OLAP Tools
- Features of MS-BI
INTEGRATION SERVICES(SSIS)
- Need for SSIS & Scope of Use
- SSIS Configuration & Catalog DB
- Control Flow & Data Loads (ETL)
- Data Flow Transformations
- Dynamic Precedence & Loading
- SSIS Configuration Options
- SSIS Variables and Parameters
- SCD Types and Data warehouse
- OLTP and DW
- Checkpoints & SSIS Logging
- Transactions and Isolation Levels
- Error Handling & Event Handling
- Scripting
- Deployment Tools
- Package Deployment & Security
- Scheduling SSIS Package Jobs
- SSIS Performance Tuning Tips
- Real-time Case Study on SSIS
INTEGRATION SERVICES(SSIS)
- Need for SSIS & Scope of Use
- SSIS Configuration & Catalog DB
- Control Flow & Data Loads (ETL)
- Data Flow Transformations
- Dynamic Precedence & Loading
- SSIS Configuration Options
- SSIS Variables and Parameters
- SCD Types and Data warehouse
- OLTP and DW
- Checkpoints & SSIS Logging
- Transactions and Isolation Levels
- Error Handling & Event Handling
- Scripting
- Deployment Tools
- Package Deployment & Security
- Scheduling SSIS Package Jobs
- SSIS Performance Tuning Tips
- Real-time Case Study on SSIS
REPORTING SERVICES(SSRS)
- Need for SSRS & Report Tools
- SSRS Configuration & Keys
- Data Sources & Shared Data Sets
- Table Reports and Matrix Reports
- Report Designer Paging Options
- Global Variables and Data Sets
- Drill-down Reports & Bar Charts
- Types of Reports
- Parameters & DataSet Filters
- SSRS Dashboard Design
- Chart Reports & Map Reports
- Report Models
- SSRS Deployment & Options
- Cache Refresh and Snapshots
- Security Management & Roles
- Report Builder Configuration
- SSRS Report Monitoring & Tuning
- Realtime Case Study on SSRS
*Qualification: B.Tech/B.Sc.(IT)/BCA/M.Sc(IT)/MCA/M.Tech completed in any discipline.No Prior experience is presumed.
*MIS guys can be upgrade themselves opting MSBI course for better opportunity and growth in IT industry.
*The guys who are working as a Dot net developer having more than 3 years of experience can switch their Profile as a MSBI professionals.
Course duration will be approx for 3 months. Weekdays and Weekends batches are available. In weekdays 3 classes of 2 hours and in weekends 2 classes of 2.5 Hours.
Trainers having good practical exposure are only eligible for taking the classes of students.They share theirs own experience and guide the students accordingly according to the industry needs of professionals.We are guiding the students at each and every moment of time where they stuck.Our honest approach towards the student to trained them and try to get them establish in IT industry ASAP.