Advanced Business Intelligence Course and Certification

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

This course is designed to give a learner the Advanced level knowledge on Business Intelligence. Here by "BI" we mean the systems which are mostly to deal with front-end or information delivery systems; for example reporting systems, dashboard, visualization and other mediums which carry the information to end users. This course will help learners to gain knowledge on how to create Architecture and Design for world class BI systems.

Most of the training courses in market are focused on BI tools now days; tools are no doubt necessary to start a career but the next logical step should be to grow as an Architect or a Designer. This training is focused on BI Architecture & Design and uncovers best industry practices, knowledge and processes around them.

Course Objective

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

  1. Gain understanding of all Business Intelligence concepts.
  2. Learn about Business Intelligence components.
  3. Learn about Business Intelligence environment.
  4. Gain a good understanding of Business Intelligence Architecture and its components.
  5. Learn about end to end system flow of BI systems.
  6. Learn about User Management and BI Resource Management.
  7. Learn about Security, Publishing, Scheduling and Content Management.
  8. Learn about BI Design components and how to create a BI Design.
  9. Learn details about BI Quality Management and BI Testing processes.
  10. Learn advanced topics like Data Governance,Data Profiling, Data Quality,Metadata, Tool Selection etc
  11. Learn about BI Success and Risk factors, BI Roadmap, BI Organization Structures , BI Roles and responsibilities.
  12. Get a one on one guidance from us regarding the career.
  13. Get a customized career roadmap.

Why is it the right course for you?

If you aspire to become a world class Architect ,Project Manager or Designer in Business Intelligence space then this is the right course for you. This course will help you equip with an overall understanding of Business Intelligence Architecture. This will enable you to start taking complex assignments in Business Intelligence space.


You need to be familiar with Business Intelligence domain. You need to have a basic understanding of Database concepts. Experience in Business Intelligence is desirable but not necessary.

Course Curriculum

Section A : Introduction

1) Introduction to Business Intelligence

  • What is BI?
  • Definitions of BI
  • Dresner's definition
  • Loshin's definition
  • Well's definitions
  • Rud's definitions
  • Why BI?
  • BI usage in various industry
  • Business Intelligence Value?

2) BI Components

Four components of Business Intelligence.

3) Data to Plan Cycle

How the Data is first converted to Information and then to Plans through Business Intelligence cycles.

4) Questions of Business Intelligence

We will discuss about the six most important question of Business Intelligence or any Information Management application.

5) What is the difference between Business Intelligence, Data Warehousing, Analytics and Big Data

In this module you will get a clear idea about the distinctions between BI, Data Warehousing, Analytics and Big Data and learn how these Data Science technologies co-exists together.

6) Framework of Business Intelligence and Data Science Study

In this module you will learn about various discipline of data sciences and how are they interlinked together. You will also learn about various learning and job related opportunities and how can you transition yourself for next generation roles.

Section B : Building Blocks of BI

1) Data

  • Corporate data
  • Data quality
  • Data standards
  • Data Components
  • Data Architecture
  • Data Model
  • Build or buy Data Model?

2) Business Intelligence Environment

  • Aspects of a Business Intelligence and Analytics Platform and Strategy
  • Fundamentals and Requirements
  • Business Intelligence Architecture and Design
  • Data Preparation
  • Data Integration
  • Business Intelligence Platforms
  • Analysis
  • Delivery and Presentation
  • The Organizational Business Intelligence Framework
  • Business Process Modeling and Analytic Needs Assessment
  • Metadata Management
  • Data Modeling
  • Data Profiling
  • Data Quality
  • Business Rules
  • Database Management System
  • Data Integration
  • Analytical Platforms
  • Canned Reporting
  • Dimensional Analysis
  • Ad Hoc/Self-Service
  • Search
  • Text Analysis
  • Predictive Analytics
  • Dashboards and other Visualization Techniques
  • System/Network Management
  • Data Security

Section C : Architecture

1) Business Architecture

  • Performance
  • Stakeholders
  • Processes
  • Business Rules
  • Business Information

2) Organization Architecture

  • People- roles, skills
  • Action- Goals, Results, RACI
  • Information flow- Decision, execution,communication
  • Structure- Reporting structure, dependencies

3) Data Architecture

  • Concept
  • Collection
  • Storage
  • Distribution
  • Access
  • Application
  • Documentation

4) BI Architecture Views

  • From IT Infrastructure Perspective
  • From Data Flow Perspective
  • From Business Usage Perspective
  • From BI Application Development Perspective

5) BI Deliverables

  • Facts
  • Dimensions
  • Measures
  • Metrics
  • KPI (Key Performance Indicator)
  • Trends
  • Graphs
  • Monitoring
  • Forecast

6) Carriers of BI deliverables

  • Production reports
  • Standard Reports
  • Adhoc Reports
  • Adhoc Queries
  • OLAP
  • Score card
  • Balanced Scorecard
  • Dashboard
  • Visualization
  • Query web services
  • Data feeds

7) Delivery Mechanism

  • Pull
  • Push

8) What can you do with these deliverables

  • Parametric query (on reports)
  • Navigation (on BI portal)
  • OLAP
  • Hierarchies
  • Drill Down
  • Drill Up
  • Drill across
  • Drill Through
  • Performance management
  • Business Process Management
  • Knowledge Management

9) User Organization and Security

  • User Types
  • Authentication
  • Authorization
  • User Hierarchy
  • Security
  • Mapping Third party accounts
  • Delegated administration
  • Selective content delivery
  • Vertical data security
  • Horizontal data security

10) Content management plans

11) Publishing

12) Scheduling

13) Application Security

Section D : BI Design and Development

1) Types of development models

2) Designing BI Systems

  1. BI Design flow
  2. Requirements
  3. High level plan as per the requirement
  4. Tool selection
  5. Guidelines and Checklists
  6. Estimation
  7. Detailed Plan
  8. Architecture design
  9. Data design
  10. Detailed design specifications
  11. Development environments
  12. Development steps
  13. Reviews and Quality
  14. Testing
  15. Deployment
  16. Maintenance
  17. Enhancements
  18. CR

3) BI Testing in Detail

  • What is a Datawarehousing & BI testing, How is it different from a general software testing?
  • Test Flow and Test Categories
  • Test Plans & Test Cases
  • Validating Source to Target Mapping
  • Validation of BI/ DWH Architecture
  • Test Data Preparation
  • Extraction Testing
  • Transformation Testing
  • Loading Testing
  • End User Browsing and OLAP Testing
  • Ad-hoc Query Testing
  • Unit Testing
  • System Integration testing
  • Performance Testing
  • User Acceptance Testing
  • Down Stream Flow Testing
  • Stress and volume Testing
  • Full Production Simulation
  • Black,White & Grey Box Testing
  • Boundary Testing
  • Negative Testing

Section E: BI Essentials

1) Data Governance

2) Data Quality

3) Data Profiling

4) Metadata

5) Business Rules

6) Business and IT Collaboration

7) Tool Selection

8) BI Roadmap

9) BI Success and Risk Factors

10) BI Organization structure

11) Career Roadmap for a BI professional

Section F: Roles and responsibilities

  • Team
  • Senior expertise
  • Leadership
  • Project sponsor
  • Business executive sponsor
  • IT executive sponsor
  • Data Steward
  • Steering committee
  • Project manager
  • DW Architect
  • Data Modelers
  • Business Analyst
  • Subject Matter expert
  • ETL programmer
  • DBA
  • BI Programmer
  • Testers
  • Trainer
  • Support
  • Big Data programmer
  • Analytics experts

Course Duration

Online Classes : 20 Hours

There will be ten instructor led interactive online classes during the course. Each class will be of approximately two 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 : 20 Hours

Assignments 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.

  • 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.

  • 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.

  • 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 BUSINESS INTELLIGENCE".

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 BUSINESS INTELLIGENCE".

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.

What is BI?

Choose one.

  1. A Technology
  2. A Process
  3. Set of Tools
  4. Decision support system

Which is not a BI tool?

Choose one.

  1. BusinessObjects
  2. Cognos
  3. Microsoft XLS
  4. Informatica

BI Development model?

Choose one.

  1. Agile
  2. Top Down
  3. Bottom Up
  4. Hub & Spoke

Which is not an OLAP?

Choose one.

  1. MOLAP
  2. DOLAP
  3. WOLAP
  4. BOLAP

What is a BI deliverable?

Choose one.

  1. Report
  2. Dashboard
  3. Scorecard
  4. All of above

What is not a delivery mechanism?

Choose one.

  1. Broadcast
  2. Scheduling
  3. Push
  4. Pull

Frequently Asked Questions

  1. Is it necessary to have an experience in BI before starting this course?

    It is not necessary that you should have a prior experience, however we recommend that you should be aware of BI domain. You can also take up Beginner's course before starting on Advanced course.

  2. I am already working in BI for long time and I have a good command on BI Tools, I think I do not need to take up this course?

    If you think that you can work on Design and Architecture parts of BI and have good experience and knowledge on those then you can skip this course, however if you have good knowledge on coding and BI tools but still not doing design then you can enroll for this course to get knowledge on Design and Architecture skills.

  3. 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.

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

    You can take extra attempts for free.

  5. 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 BI experts.

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

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

  7. I heard that BI is dying and Big data is going to replace all BI technologies very soon, why should I still learn BI?

    It is a myth that Big Data will kill all existing BI technologies. All these technologies are going to co-exist together as there are specific use cases for each of these technologies. Slowly all BI tools will start incorporating access to Big Data as well. In case you are interested only for Big Data or Analytics, we run those courses too.

  8. 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