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.

  • Weekdays Batches : Monday - Friday - 9:00 AM -2:00 PM & 2:00 PM -6 :00 PM
  • 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.

    Students Testimonial

    It is a good for new comer or experienced .Job is waiting because u get to learn which support you in industries.Join asap to make your future in IT industries !
    -Pranav


    It Career Makers is best coaching to learn the software and improve your skill ability .
    - Brajendra Kumar


    They have excellent faculty. There is a wide range of courses that they offer, also the method of teaching is excellent unlike rest of the IT institutes today. They start from the basics and also clear each and every doubt one has practically.
    -Vasu Vimal


    I have good experience with ITCM. Good for Software Testing Learning.
    -Yash Tehlan


    It's good enough for understanding environment of IT industries .I got job with the help of ITCM Only.
    -Kshitij Arora


    Supportive and cooperative faculties.Full of zest and enthusiasm.Focused study delivery.Highly motivated morale.
    -Mudit Rastogi