BI Program & Project Management 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

Program Management and Project Management are integral part of IT department. There are various generic methods to deal with IT Project Management, however certain customizations are required for each domain and each technology type. Business Intelligence are unique applications in a sense that they neither come under traditional application development type projects like web development nor they come under tool customization projects like tool based ERP projects (SAP etc). BI applications are somewhat in between these two types of integration projects. BI requires special considerations and tweaking for Project management processes.

This course is designed to give a learner the detailed idea about Program Management, Project Management and how these ideas are implemented in BI world. You would also gain knowledge about how to setup BI Centre of Excellence and how to execute a BI project step by step.

Course Objective

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

  1. Learn What is BI Centre of Excellence, how to setup it and other important aspects of it.
  2. Learn about Project Management models used for Business Intelligence, Datawarehousing, Analytics and Big Data projects.
  3. Learn about models like Ralph Kimbal Model, Bill Inmon Model and others.
  4. Learn Agile project development model for Business Intelligence.
  5. Learn about Industry standard project management processes and fundamentals of BI project management.
  6. Learn BI Project management stage by stage, starting from Assessment, Planning to Design to Coding to Implementation.
  7. Learn about a model where we prescribe sixteen process stages to carry out a BI project.
  8. Learn about important documentation specific to BI projects.
  9. Gain access to standard BI Project document templates.

Why is it the right course for you?

If you want to get knowledge about Project Management processes and models specific to Business Intelligence, Datawarehousing, Analytics and Big Data projects 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 Management space.


You should be familiar with any one of the Business Intelligence,Datawarehousing, Analytics or Big Data domains.

Course Curriculum

Section A: BI Centre of Excellence and Program Management

1) Introducing BI Centre of Excellence

Reasons to Establish a BICC, Primary Functions of the Business Intelligence Competency Center.

2) Planning a Business Intelligence Competency Center

  • Multiple Dimensions of a BICC
  • Dimension 1: People
  • Dimension 2: Processes
  • Dimension 3: Culture
  • Dimension 4: Infrastructure
  • Multiple Levels of Maturity in the Information Model
  • Level 1: Operate
  • Level 2: Consolidate
  • Level 3: Integrate
  • Level 4: Optimize
  • Level 5: Innovate
  • Defining the BI Strategy

3) People

Job Roles and Role Descriptions

4) Processes

From Individual to Departmental to Enterprise, Knowledge Processes in the Business Intelligence Competency Center's Functional Areas, Business Intelligence Program, Data Stewardship, Support ,BI Delivery, Data Acquisition, Analytics ,Training ,Vendor Contracts Management

5) Program Management

Section B: Project Management Models for BI

1) Project Management Approaches for BI

Ralph Kimball Model, Bill Inmon model, Detail of Ralph Kimball Model, Detail of Bill Inmon model, Top down, Bottom up, Hybrid (Normalized Design and OLAP), Agile Model

2) Agile Model

Agile Analytics, Guiding Principles, Myths and Misconceptions, Building approach, Top down ,Agile Project Management, Phased Sequential DWH/BI Development, Changing the role of Project Management, Making sense of Agile Flavors, Tents of Agility

Section C: Project Management Processes

1) Industry Standards for Project Management Processes

2) Fundamentals of BI Project Management

Engineering Stages and the Development Steps, Parallel Development Tracks, BI Project Team Structure, The Core Team, The Extended Team

3) Stage 1: Business case Assessment

Business Justification, Business Drivers, Business Analysis Issues, Information Needs, Cost-Benefit Analysis, Risk Assessment, Business Case Assessment Activities ,Deliverable Resulting from These Activities ,Roles Involved in These Activities

4) Stage 2: Enterprise Infrastructure Evaluation

The Hardware Platform ,The Middleware Platform, The DBMS Platform ,Technical Infrastructure Evaluation Activities, Deliverables Resulting from These Activities ,Roles Involved in These Activities, Nontechnical Infrastructure Evaluation ,The Effects of Stovepipe Development, The Need for Nontechnical Infrastructure, Enterprise Architecture, Enterprise Standards, Development Approach, Data Naming and Abbreviations, Meta Data Capture, Logical Data Modeling, Data Quality, Testing, Reconciliation, Security, Service-Level Agreements, Policies and Procedures , Nontechnical Infrastructure Evaluation Activities, Deliverable Resulting from These Activities, Roles Involved in These Activities

3) Stage 3: Project Planning

Managing the BI Project, Defining the BI Project ,Project Goals and Objectives, Project Scope, Project Risks, Project Constraints, Assumptions, Change-Control Procedures, Issues Management Procedures, Planning the BI Project, Activities and Tasks, Estimating Techniques, Resource Assignment, Task Dependencies ,Resource Dependencies, Critical Path Method, Project Schedules ,Project Planning Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

4) Stage 4: Project Requirements Definition

General Business Requirements ,Interviewees for General Business Requirements, Data Quality Requirements, Business Requirements Report, Project-Specific Requirements, Interviewees for Project-Specific Requirements, Application Requirements Document, The Interviewing Process, Project Requirements Definition Activities, Deliverable Resulting from These Activities, Roles Involved in These Activities

5) Stage 5: Data Analysis

Business-Focused Data Analysis, Top-Down Logical Data Modeling, Bottom-Up Source Data Analysis, Technical Data Conversion Rules, Business Data Domain Rules, Data Cleansing, Data Quality Responsibility, Source Data Selection Process, To Cleanse or Not to Cleanse, Data Analysis Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

6) Stage 6: Application Prototyping

Purposes of Prototyping ,Time-Boxing, Best Practices for Prototyping, Considerations for Prototyping, Types of Prototypes, Show-and-Tell Prototype, Mock-Up Prototype, Proof-of-Concept Prototype, Visual-Design Prototype, Demo Prototype, Operational Prototype, Building Successful Prototypes, Prototype Charter, Guidelines for Prototyping, Skills Survey, Application Prototyping Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

7) Step 7: Meta Data Repository Analysis

The Importance of Meta Data, Meta Data Categories, Meta Data Repository as Navigation Tool, Meta Data Classifications, Groupings of Meta Data Components, Meta Data Repository Challenges, The Logical Meta Model, The Entity-Relationship Meta Model, Meta-Meta Data, Data Repository Analysis Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

8) Stage 8: Database Design

Differences in Database Design Philosophies, Operational Databases, BI Target Databases ,Logical Database Design, The Star Schema, The Snowflake Schema, Physical Database Design, Implementation Options ,Physical Dataset Placement ,Partitioning ,Clustering ,Indexing ,Reorganizations, Backup and Recovery ,Parallel Query Execution ,Database Design Activities, Deliverables Resulting from These Activities ,Roles Involved in These Activities

9) Stage 9: Extract/Transform/Load Design

Implementation Strategies, Preparing for the ETL Process, The Initial Load, The Historical Load, The Incremental Load, Processing Deleted Records ,Designing the Extract Programs ,Designing the Transformation Programs, Source Data Problems, Data Transformations, Designing the Load Programs, Referential Integrity, Indexing, Designing the ETL Process Flow, Evaluating ETL Tools, ETL Design Activities, Deliverables Resulting from These Activities , Roles Involved in These Activities

10) Stage 10: Meta Data Repository Design

Meta Data Silos ,Sources of Meta Data, Meta Data Repository Solutions, Designing a Meta Data Repository, Licensing (Buying) a Meta Data Repository, Meta Data Repository Design Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

11) Step 11: Extract/Transform/Load Development

Source Data Transformation, Data Transformation Activities, Underestimating Data Transformation Efforts, Reconciliation, Peer Reviews, ETL Testing ,Formal Test Plan, ETL Development Activities, Deliverables Resulting from These Activities, Roles Involved in These

12) Step 12: Application Development

Online Analytical Processing Tools, Advantages of OLAP Tools, Multidimensional Analysis Factors, Multivariate Analysis, Online Analytical Processing Architecture, Presentation Services, OLAP Services, Database Services, Development Environments, The Web Environment, Application Development Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

13) Step 13: Data Mining

Defining Data Mining, The Importance of Data Mining, Data Sources for Data Mining, Data Mining Techniques, Data Mining Operations, Applications of Data Mining, Data Mining Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

14) Step 14: Meta Data Repository Development

Populating the Meta Data Repository, Meta Data Repository Interface Processes, Meta Data Repository Testing ,Preparing for the Meta Data Repository Rollout ,Meta Data Repository Development Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

15) Step 15: Implementation

Incremental Rollout, Security Management, Security Measures for BI Applications ,Security in a Multi-Tier Environment, Security for Internet Access, Data Backup and Recovery, Monitoring the Utilization of Resources, Growth Management, Implementation Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

16) Step 16: Release Evaluation

The Application Release Concept, Guidelines for Using the Release Concept ,Post-Implementation Reviews, Organizing a Post-Implementation Review, Post-Implementation Review Session Flow, Release Evaluation Activities, Deliverables Resulting from These Activities, Roles Involved in These Activities

Section D: Project Management Documentation

1) End to End Documentation

Explanation of the documentation required for BI project management. Templates of all project management documents will be provided for your reference.

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 PROGRAM AND PROJECT 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 PROGRAM AND PROJECT 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.

BI Projects are mission critical?

Choose one.

  1. Yes
  2. No
  3. Upto some extent
  4. Yes because they support decisions

ETL and Reporting projects can be parallel?

Choose one.

  1. Yes, because they are not dependent on each other
  2. Yes, because they connect to different databases
  3. No, because they are on same critical path
  4. No, because they are not dependent on each other

Who are the stakeholders in BI project?

Choose three.

  1. MIS
  2. Sponsorer
  3. End User
  4. Project Manager

Correct order is?

Choose one.

  1. Planning->Requirement gathering
  2. Design->Analysis
  3. Performance Testing->System Testing
  4. Requirement gathering->Planning

User is not interested in?

Choose one.

  1. Primary Keys
  2. Surrogate Keys
  3. Facts
  4. Dimensions

In BICC, which is not important?

Choose one.

  1. People
  2. Tool
  3. Culture
  4. Cost

Frequently Asked Questions

  1. Is it necessary to have any prior knowledge of Project Management before starting this course?

    It's good if you have basic awareness about BI, Datawarehousing, Analytics or Big Data but any prior experience or knowledge in Project Management is not required.

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

    If you are planning to take up Project Management roles or already involved in Management activities for BI/DWH/Analytics/Big Data projects then this course is right for you. Even if you are in non-BI Project management but planning to move into BI domain then this course will be good for you.

  3. What would be the part of Assignments?

    You would be required to carry out BI Project Management 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 Project 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 Project 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 Enroll 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