BI Infrastructure, Support & Operation Management Course

Course Schedule and Upcoming Batches

Please call us to confirm the dates for new batches
Classes Start
Time (IST)
Price (INR)
Price (USD)
To be confirmed
5 Weeks
9:00 AM- 1:00 PM

This course is open for Enrollment and Payment.

In case you want to Register now and take up this course later, you can register by clicking on " Register" section.

If you have any query, you can call/mail or send your query by clicking on " Send a Query" section.

About the Course

Infrastructure , Support and Operation Management is an integral part of any IT system and Business Intelligence is no exception to it. However the important thing to know is how these things are handled in the BI world.

The person who handles Infrastructure , Support and Operation activities of BI systems should have in-depth knowledge of Systems, Processes, Documentations and important factors impacting these areas.

This course is designed to give a learner the end to end knowledge on Infrastructure , Support and Operation management activities for BI, Datawarehousing, Analytics and Big Data. This course is useful for those who are currently involved in BI Support processes or planning to enter into that area.

Course Objective

After completion of this course, you will be able to:

  1. Learn about various components of Business Intelligence, Datawarehousing, Analytics and Big Data Infrastructure which together form a big giant information management system.
  2. Learn about various support activities associated with BI Infrastructure, e.g. Monitoring , Ticket Management etc.
  3. Learn how support processes are different for DWH/BI/Analytics/Big Data.
  4. Learn about standard processes used for Operation and Support Management.
  5. Learn about various important factors which directly impact the Infrastructure, its usage, costs and other important aspects.
  6. Learn about designing an architectural plan and sizing a deployment.
  7. Learn about Security, Publishing and Configuration Management etc.
  8. Learn about Scheduling ETL, Reporting and other related activities.
  9. Learn about designing a System Architecture.
  10. Learn about industry standard Support Model.
  11. Learn about Documentation related to these activities.

Why is it the right course for you?

If you want to get deep knowledge on BI Infrastructure, Support, Operation, Processes then this is the right course for you. This course is particularly suited for BI and Datawarehousing professional as it would open up the opportunities in Operation and Support Management.


It's recommended that you are familiar with Business Intelligence, however it is not mandatory.

Course Curriculum

Section A: Introduction

Learning Objectives : In this part, you will get introduced to Infrastructure, Support and Operations.

1) Introduction

What is Infrastructure, DWH/BI/Analytics/Big Data tool infrastructure, What is Support, Operation and escalation policies ? Levels in support (L1, L2, L3, L4).

Section B: Components of BI/DWH/Analytics/Big Data Infrastructure

Learning Objectives : In this part, you will know about various components of Business Intelligence, Datawarehousing, Analytics and Big Data Infrastructure which together form a big giant information management system.

1) Source system

Operational source system, Source system database/storage considerations, Source system OS, Source system connection methods, Departmental or individual files External data like survey data, competitor data, Big data

2) Data Acquisition Systems

FTP Server, Database and DB Servers, Big Data connectors, Storage space/OS/Hardware considerations, Connection lines, Automation of Data acquisition

3) Data Store Systems

File Storage, Datastaging DB, ODS Data store

4) Data Processing Servers

ETL tools Database tools and scripts, Manually written programs, Proprietary tools to handle various data related operations like sorting, matching, error validation, missing value filler and other data related things, Scheduler, Operating system with capability to write and run various script programs, Database tools to handle the creation, maintenance and programming of database

5) Data Warehouse /Data Mart

Database Server, Database to store Data Mart or Datawarehouse, Operational data sources to be used directly by Report Services

6) Data warehouse Views

View Database on top of Physical Datawarehouse Database, Virtualization Server for OLTP Data

7) Usage Data Views

Department Centric Datawarehouse Database Views

8) Information Delivering Tools

Reporting Tools, Configuration, Security, Creation, Delivery, OLAP, Adhoc, Data Mining Tools, Query Tools, Dashboards, Score Cards, Performance Management Systems, CRM Connectors, Downstream Connectors

9) Metadata Management System

10) Management and Control Systems

Scheduling, Alert Systems, Monitoring

Section C: Support Activities

Learning Objectives : In this part, you will learn about various support activities associated with BI Infrastructure.

1) Monitoring Activities

2) Change Management

3) Ticket Management

4) SLA Management

5) TOOL Infrastructure and Support

6) How support processes are different for DWH/BI/Analytics/Big Data

Section D: Infrastructure Factors

Learning Objectives : In this part, you will learn about various important factors which directly impact the Infrastructure, its usage, its costs and other important aspects.

1) Data Size

2) Volatility

3) Number of users

4) Number of Business processes

5) Nature of use

6) Service Level Agreements

7) Technical Readiness

8) Software Availability

9) Hardware architecture

Parallel processing, Symmetric multiprocessing (SMP), Massively Parallel Processing (MPP), Non Uniform Memory Architecture (NUMA), Partitioning hardware, Hardware performance boosters

10) Servers

Processing Server, Client Application, Reporting Server, ETL Server, DB Server, Web Server, DB Software DW Appliances

11) Warehouse appliance

12) Database Platform factors

13) Front Room Infrastructure

Application server considerations, Desktop considerations, Cross platform support, Desktop operating system and software, Memory

14) Reporting Infrastructure

Client applications, Application Servers, Web Servers, Storage Services, Processing Services

15) BI portal infrastructure

16) Connectivity and network factors

Bandwidth, Remote access, File transfer Database connectivity , Directory services

17) Monitoring of Usage

18) Backup and Recovery plan

19) Infrastructure MAP

Server Hardware, Disk systems, Network, Security , Desktop

20) Installation of Hardware and Software

21) Indexing

Indexing for Dimension Tables, Indexing for Fact Tables, Indexing for Loads, Indexing for OLAP, Analyze Tables and Indexes after the Load

22) Designing and Building the Database Instance

23) Developing the physical storage structure

Section E: Infrastructure Processes

Learning Objectives : In this part, you will go through with various support and operation related processes used for BI/Information Management Infrastructure.

1) Service Level Management

2) Availability Management

3) Designing a reliable system

Designing a system for high availability, Designing a single server system for high availability, Designing a multiple server system for high availability

4) Designing an architectural plan

Determining system load, The number of potential and concurrent users, The number of simultaneous requests, Determining reporting requirements, Report viewing requirements, Report scheduling requirements, Determining system deployment requirements, Determining architecture requirements, Designing a system architecture

5) Sizing a deployment

Determine the Load, Determining the number of required services, Determining the configuration of machines, Performing system testing and tuning

6) Change Management

Upgrade, Migration, Managing enterprise system data, Managing system data between environments, Copying system data, Copying objects from test system to a production system

7) Configuration Management

8) Deployment Management

Planning for Deployment and MOP. Deploying a System, Installing and configuring , Preparing the environment for installation, Installing, Testing the installation, Configuration, Production schedules

9) Backup and Recovery

Creating a disaster recovery plan, Creating a successful disaster recovery plan, Creating a backup copy of system data, Using a backup copy of system data during disaster recovery, Hot and cold fail over systems

10) Security

ETL Authorization/Authentication, Report Authorization/Authentication, Database Authorization/Authentication, Application Security, Users and Groups, Licensing , Folders & Categories, Access levels and rights, Global Security, Folder Level Security, Object level Security, Calculating effective rights, Inheritance rules, Authentication and Mapping third party accounts, Publishing and configuring content, Secure the hardware and OS, Secure the development environment, Secure the network, Network component, Routers and firewalls, Directory server, Encryption, Private and Public key encryption, Trusted certificate authorities, Secured socket layer (SSL), Virtual private network, Kerberos authentication , Authenticating the users, Secure the Data, Provide open access for internal users, Itemize sensitive data, Minimize or mask sensitive data, Secure the Data Access, Unrestricted Reports , Restricted Reports

11) Scheduling

ETL Scheduling, Reporting Scheduling, Database Scheduling, Scheduling Tools, Scheduling options, Recurrence patterns, Notification, Alert notification, Destination, Formats, Caching options, Scheduling for a user, Printer

12) Planning content

13) Publishing, configuring & auditing

Publishing, configuring, Designing a system auditing plan, Designing and implementing system auditing, System management planning

Section F: Designing a System Architecture

Learning Objectives : In this part, you will learn how to design a system architecture for better performance and fault tolerance.

1) Designing a scalable system

Increasing overall system capacity, Increasing the ETL processing capacity. Increasing scheduled reporting capacity, Increasing report viewing capacity, Improving web response speeds

Section G: Support Model & Documentation

Learning Objectives : In this part, you will learn about the standard Support Model which is currently being used by companies to manage their BI Infrastructure. You will also learn about the documentation needed for these activities.

1) Support Model

Organization, Problem Identification & Resolution, Error Handling, Various Support and Admin Roles

2) Deployment and Production Support Documentation

Deployment checklist, End to end deployment, Pre implementation, checkpoint calls, post implementation, MOP

Course Duration

Online Classes : 30 Hours

There will be ten instructor led interactive online classes during the course. Each class will be of approximately three hours. If you miss a class then you can reschedule it in a different batch or you can also access Class video recordings anytime.

Assignment Work : 25 Hours

Assignment work will be given to learners to be completed during the course duration.

Course Work : 40 Hours

Study material of 40 hours or more will be given as a course work to be completed.

Exam : 1 Hour

A proctored exam of 1 hour will be conducted for final assessment.

Course Features

  • Live Classes

    Live Instructor Led classes from Industry Experts. Option to choose from Online or Classroom Lectures. Case studies from real life projects.

  • Ongoing Research

    Research team works hard to bring out the latest innovations and best practices of course subjects. Courses are evolving continuously; they never get stale.

  • Be More Productive

    Get work related tips and perform your work more efficiently. Once you know the tricks of trade, you become more productive.

  • Industry Experts

    Classes are conducted by Industry Experts. Learners gain from world class curriculum and extensive experiences of Trainers as well.

  • Award of PDUs

    We award you 28 PDUs which can be used towards PMI certifications' requirements. It is completely free but you need to raise a separate request for it.

  • Learning Material

    Learners get unlimited access to online and offline materials. Don't worry if you miss any class, we will be providing you a repeat class online or offline.

  • Learning Support

    Learners are encouraged to ask online and offline questions. Our team of Trainers makes it a priority to answer these questions.

  • Money-back Guarantee

    If you are not satisfied with the quality then take full refund within the seven days of first class. No questions will be asked.

  • Easy Reschedule

    Have you missed a class? Don't worry !!, You can watch the class videos or you can also request for a reschedule. We will invite you for next class for Free.

  • Career Support

    Learner's resume is reviewed and a one-to-one discussion is arranged with an expert to advice on career roadmap and job opportunities. For details, visit Career Centre


Certificate of Participation

A certificate of participation will be awarded after participating in the training program. The name of certificate is "BIWHIZ CERTIFICATE OF PARTICIPATION ON BI SUPPORT, INFRASTRUCTURE & OPERATION MANAGEMENT".

Certification after Completion

A certification will be issued after assessment of assignments, course work requirements, projects and a written test as per the course curriculum. After successfully completing all the requirements and passing the written test, a certification will be issued. The name of the certification is "BIWHIZ CERTIFICATION ON BI SUPPORT, INFRASTRUCTURE & OPERATION MANAGEMENT".

Certificate Issuing Authority

BIWHIZ is part of the company "Business Intelligence Consultant and Services LLP". Certificates are issued by "Business Intelligence Consultant and Services LLP". This is a registered company with Ministry of Corporate Affairs, Government of India.

Sample Exam Questions

This sample is only for illustrative purpose and only basic level questions are displayed here. Actual exam questions may be completely different with different format as well. Please contact your coordinator to know more about prevailing exam format.

Best time for Scheduling?

Choose one.

  1. Night
  2. Day
  3. Business Hour
  4. Non-Business Hour

Archive data older than?

Choose one.

  1. Ten years
  2. Three years
  3. As per requirement
  4. One Month

Report Scheduling Destinations?

Choose three.

  1. LAN Folder
  2. Laptop
  3. Reporting tool Inbox
  4. Mail Inbox

To change the code?

Choose one.

  1. Ask developers
  2. Raise a CR
  3. Change in Production
  4. Test in Development then promote

MOP is?

Choose one.

  1. Management of Processes
  2. Method of Procedure
  3. Monitoring of Pilot project
  4. Master of Project

Best Sequence is?

Choose one.

  1. Develop->System Test->Performance Test->Promote in Production
  2. Develop->System Test->Unit Test->Promote in Production
  3. Develop->Promote in Production->System Test->Performance Test
  4. Develop->Version Control->Performance Test->Promote in Production

Frequently Asked Questions

  1. Is it necessary to have any prior knowledge of Support and Operation before starting this course?

    No, Support and Operation knowledge is not required but it is good if you are aware about Business Intelligence domain.

  2. Is this course for me? What value would it add to my career?

    If you are planning to take up the Infrastructure, Support and Operation management roles in BI or already working in this area then this is the right course for you. This will provide you complete knowledge on these subjects and help you grow your career.

  3. What would be the part of Assignments?

    You would be required to carry out Infrastructure, Support and Operation related activities and would submit the documentation of these activities.

  4. I guess I need to have very fast Internet connection to be able to attend these courses?

    Generally 1 MB connection is sufficient however lower bandwidth connections are also working fine.

  5. Can I request for another class if I miss it?

    You can watch the recorded session video or you can also attend the same class in next batch.

  6. Why Certification is included in the course?

    This is to make sure that a learner has understood the course content and BIWHIZ has verified the knowledge level of the Learner. Certification is the proof that you have achieved a certain level of expertise on course and any authorized organization can verify that with us.

  7. What if I am not able to clear the Certification exam in first attempt?

    You can take extra attempts for free.

  8. What is the learning support and would it be available after completing the course as well?

    You can raise your queries and doubts during and post training period. All queries will be resolved by Infrastructure, Support and Operation Management experts.

  9. Do you help in career related issues as well, like reviewing resume, mentoring for my career growth?

    Yes, we have a panel of Infrastructure, Support and Operation Management experts who will guide and mentor you; please check Career Centre for more details.

  10. Will you sell my data to Recruitment/marketing companies or will you use it for Recruitment or any other activities not related with Training?

    NO, Never. Your details are highly confidential and safe with us. But If you are willing to accept any such calls then you can inform us in advance with a specific need and we will contact only for those specific requirements. For a detailed privacy policy please check Terms, Conditions & Privacy Policy.

Register Here

Please register for this course here. Even if you are not ready to Enrol now, you can register now and get an intimation about our next batch whenever it is starting.

Please Fill Your Details

Send a Query

You got a query for us? Please use the Form below to send your query. We will get back to you soon. Have a great day !!

Please Fill Your Details & Query