Course Schedule and Upcoming Batches
|Please call us to confirm the dates for new batches|
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.
After completion of this course, you will be able to:
- Learn What is BI Centre of Excellence, how to setup it and other important aspects of it.
- Learn about Project Management models used for Business Intelligence, Datawarehousing, Analytics and Big Data projects.
- Learn about models like Ralph Kimbal Model, Bill Inmon Model and others.
- Learn Agile project development model for Business Intelligence.
- Learn about Industry standard project management processes and fundamentals of BI project management.
- Learn BI Project management stage by stage, starting from Assessment, Planning to Design to Coding to Implementation.
- Learn about a model where we prescribe sixteen process stages to carry out a BI project.
- Learn about important documentation specific to BI projects.
- 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.
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
Job Roles and Role Descriptions
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.
Online Classes : 30 HoursThere 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.
Live Instructor Led classes from Industry Experts. Option to choose from Online or Classroom Lectures. Case studies from real life projects.
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.
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.
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.
Learners are encouraged to ask online and offline questions. Our team of Trainers makes it a priority to answer these questions.
If you are not satisfied with the quality then take full refund within the seven days of first class. No questions will be asked.
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.
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?
- Upto some extent
- Yes because they support decisions
ETL and Reporting projects can be parallel?
- Yes, because they are not dependent on each other
- Yes, because they connect to different databases
- No, because they are on same critical path
- No, because they are not dependent on each other
Who are the stakeholders in BI project?
- End User
- Project Manager
Correct order is?
- Planning->Requirement gathering
- Performance Testing->System Testing
- Requirement gathering->Planning
User is not interested in?
- Primary Keys
- Surrogate Keys
In BICC, which is not important?
Frequently Asked Questions
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.
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.
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.
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 Project 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 Project 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?
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.