Course Schedule and Upcoming Batches
| Please call us to confirm the dates for new batches | |||||
|---|---|---|---|---|---|
16,000 +S.T. | 330 |
||||
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:
- Learn about various components of Business Intelligence, Datawarehousing, Analytics and Big Data Infrastructure which together form a big giant information management system.
- Learn about various support activities associated with BI Infrastructure, e.g. Monitoring , Ticket Management etc.
- Learn how support processes are different for DWH/BI/Analytics/Big Data.
- Learn about standard processes used for Operation and Support Management.
- Learn about various important factors which directly impact the Infrastructure, its usage, costs and other important aspects.
- Learn about designing an architectural plan and sizing a deployment.
- Learn about Security, Publishing and Configuration Management etc.
- Learn about Scheduling ETL, Reporting and other related activities.
- Learn about designing a System Architecture.
- Learn about industry standard Support Model.
- 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.
Pre-requisites
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
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
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
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
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
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
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
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
Certification
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?
- Night
- Day
- Business Hour
- Non-Business Hour
Archive data older than?
- Ten years
- Three years
- As per requirement
- One Month
Report Scheduling Destinations?
- LAN Folder
- Laptop
- Reporting tool Inbox
- Mail Inbox
To change the code?
- Ask developers
- Raise a CR
- Change in Production
- Test in Development then promote
MOP is?
- Management of Processes
- Method of Procedure
- Monitoring of Pilot project
- Master of Project
Best Sequence is?
- Develop->System Test->Performance Test->Promote in Production
- Develop->System Test->Unit Test->Promote in Production
- Develop->Promote in Production->System Test->Performance Test
- Develop->Version Control->Performance Test->Promote in Production
Frequently Asked Questions
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
What if I am not able to clear the Certification exam in first attempt?
You can take extra attempts for free.
-
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.
-
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.
-
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.