All Courses
×
iHUB IIT R

Executive Post Graduation Certification in Business Analysis & Project Management

6,629 Ratings

Ranked #1 Business Intelligence Program by India Today

This Executive Post Graduate Certification in Business Analysis & Project Management, provided by iHUB, IIT Roorkee, delivers thorough training in Agile methodologies, Tableau, and SQL for business analytics. With a focus on hands-on experience through industry-based projects, the course incorporates modules for IIBA CBAP & CBDA certification. The program has been thoughtfully crafted by industry experts in collaboration with iHUB DivyaSampark, IIT Roorkee

In collaboration with

IIBA logo
Apply Now

Learning Format

Online

Live Classes

7 Months

Executive PG

Certification

Campus Immersion

iHUB, IIT Roorkee

EMI Starts

at ₹4999/month*

trustpilot 3109
sitejabber 1493
mouthshut 24542

About Program

The Executive Post Graduation Certification program is designed to support individuals to become proficient in business analysis and project management. The program offers thorough training led by the Industry experts, ensuring that participants acquire valuable skills. These carefully selected skills are geared towards enhancing resumes and meeting the growing demands of the industry.

Key Highlights

400 Hrs of Applied Learning
134 Hrs Self-paced Videos
60+ Live sessions across 7 months
30+ Industry Projects & Case Studies
Learn from IIT Faculty & Industry Practitioners
One-on-One with Industry Mentors
24*7 Support
Dedicated Learning Management Team
Designed for Working Professionals & Freshers
1:1 Mock Interview
No-Cost EMI Option
iHub Divya Sampark - IIT Roorkee Certification
2 Days Campus Immersion at iHUB, IIT Roorkee
3 Guaranteed Interviews upon movement to Placement Pool
Free Career Counselling
The top 2 performers per batch will receive Rs 80000 in fellowship*
Up to Rs. 50 Lakhs startup Incubation Support*

About iHUB DivyaSampark, IIT Roorkee

iHUB DivyaSampark at IIT Roorkee, established under the National Mission on Interdisciplinary Cyber-Physical Systems (NM-ICPS) by the Department of Science and Technology (DST), focuses on fostering innovation in advanced technologies such as AI, ML, and more. The hub plays a pivotal role in technology development, incubation, and startups, particularly in areas like Healthcare,Read More..

Upon the completion of this program, you will receive:

  • Executive Post Graduate Certification in Business Analysis & Project Management from iHUB DivyaSampark, IIT Roorkee.
EPGC in Business Analysis and Project Management Certificate Image Click to Zoom

Career Transition

55% Average Salary Hike

$1,30,000 Highest Salary

12000+ Career Transitions

300+ Hiring Partners

Career Transition Handbook

*Past record is no guarantee of future job prospects

Who can apply for the course?

  • Anyone with a bachelor’s degree and a passion for project management
  • Professionals looking to grow their career as a business analyst
  • Professionals with a bachelor’s degree who want to enter project management
  • Freshers who want to pursue business analysis and project management
  • IT and sales professionals
who can apply

What roles can a Business Analysis and Project Management professional play?

Chief Technology Officer (CTO)

They are masters of strategic thinking and capable of conducting technological analysis with strong leadership and organizational skills.

Project Manager

They possess data-driven business acumen that helps them plan, budget, and oversee an organization’s project.

Market Research Analyst

Market research analysts compile complex reports, surveys, spreadsheets, etc. to gather and evaluate significant market intelligence.

Project Manager

They are responsible for the strategy, roadmap, and features of a product, as well as working well with cross-functional teams.

Project Manager Director

It is a senior and executive-level leadership position that focuses on making sure the team is running effectively and improving processes.

Chief Product Officer (CPO)

This role typically oversees all product activities and defines the big-picture product strategy and sets long-term goals.

View More

Skills to Master

SDLC

Agile Business

UML Diagrams

Agile Scrum

Data visualization

SQL

Analytics

Entity Relationship Model

Python

NumPy

SciPy

Machine Learning

View More

Tools to Master

MS Visio JIRA software tableau 3 Adv Excel SQL 1 python 1 anaconda numpy Scipy 2 pandas

Meet Your Mentors

Curriculum

Live Course Self Paced Industry Expert

MS-Excel –

1.1 Excel Fundamentals 

  • Reading the Data, Referencing in formulas , Name Range, Logical Functions, Conditional Formatting, Advanced Validation, Dynamic Tables in Excel, Sorting and Filtering
  • Working with Charts in Excel, Pivot Tables, Dashboards, Data and File Security
  • VBA Macros, Ranges and Worksheets in VBA
  • IF conditions, loops, Debugging, etc.

1.2 Excel For Data Analytics 

  • Handling Text Data, Splitting, combining, data imputation on text data, Working with Dates in Excel, Data Conversion, Handling Missing Values, Data Cleaning, Working with Tables in Excel, etc.

1.3 Data Visualization with Excel

  • Charts, Pie charts, Scatter and bubble charts
  • Bar charts, Column charts, Line charts, Maps
  • Multiples: A set of charts with the same axes, Matrices, Cards, Tiles

2.1 SQL Basics – 

  • Fundamentals of Structured Query Language
  • SQL Tables, Joins, Variables

2.2 Advanced SQL – 

  • SQL Functions, Subqueries, Rules, Views
  • Nested Queries, string functions, pattern matching
  • Mathematical functions, Date-time functions, etc.

2.3 Deep Dive into User-Defined Functions

  • Types of UDFs, Inline table value, multi-statement table.
  • Stored procedures, rank function, SQL ROLLUP, etc.

2.4 SQL Optimization and Performance

  • Record grouping, searching, sorting, etc.
  • Clustered indexes, common table expressions.

Hands-on exercise: 

Writing comparison data between the past year and the present year concerning top products, ignoring the redundant/junk data, identifying the meaningful data, and identifying the demand in the future using complex subqueries, functions, and pattern matching concepts.

Tools covered

SQL 1

3.1 Introduction to MS Excel & Data Extraction
3.2 Referencing in formulas
3.3 Name range
3.4 Logical functions
3.5 Conditional formatting
3.6 Advanced-level validation
3.7 Important formulas in Excel
3.8 Dynamic table
3.9 Data sorting, filtering
3.10 Chart creation techniques
3.11 Pivot tables in Excel
3.12 Data and file security
3.13 VBA Macros
3.14 Best practices of dashboards visualization
3.15 Creating dashboards
3.16 Creation of interactive components

Tools covered

excel 1

4.1 Introduction to Business Analysis 

  • Business Analysis overview
  • Who is a Business Analyst?
  • Introduction to governance body (IIBA)
  • Business analysis body of knowledge
  • Knowledge areas of BABOK
  • SDLC & requirement analysis

4.2 Business Analysis Concepts and Knowledge Areas                    

  • Business Analysis core concepts and knowledge areas
  • Planning and monitoring
  • Business Analysis Approach and Governance
  • Business Analysis Information Management
  • Elicitation and collaboration

4.3 Requirement Lifecycle Management and Strategy Analysis 

  • Trace, maintain, & prioritize requirements
  • Assess requirement changes and approval
  • Analyze current state
  • Define future state
  • Assess risks
  • Define change strategy

4.4 Requirement Analysis, Design Definition, Model Requirements, and Solution Evaluation 

  • Specify model requirements
  • Verify and validate requirements
  • Define requirement architecture and design options
  • Measure and analyze solution performance
  • Assess solution and enterprise limitations
  • Recommend actions to increase solution values
  • Data model, UI model, user stories

4.5 Agile Business Perspectives and Creating UML 

  • Introduction to business Agile perspective
  • Business Intelligence perspective
  • Information Technology perspective
  • Business architecture perspective
  • Business Process Management Perspective

4.6 Understand BA Role on the Agile Team

  • Write effective user stories and acceptance criteria
  • Develop backlogs into great products
  • BA role in new age Business Analysis

4.7 Underlying Competencies of a Business Analyst & Microsoft Visio 

  • Business Analyst underlying competencies
  • BA Skills
  • Soft skills, leadership, and personal development
  • UML diagrams using Microsoft Visio
  • Types of flowcharts, cross-functional flowcharts

Tools covered

MS Visio

5.1 Introduction to Power BI
5.2 Data Extraction
5.3 Data Transformation – Shaping & Combining Data
5.4 Data Modelling & DAX
5.5 Data Visualization with Analytics
5.6 Power BI Service (Cloud), Q&A, and Data Insights
5.7 Power BI Settings, Administration & Direct Connectivity
5.8 Embedded Power BI with API & Power BI
5.9 Power BI Advance & Power BI Premium

Tools covered

Power BI 1

6.1 Data Science and Analytics Fundamentals

  • Introduction to data science and Analytics
  • Use cases in data science and analytics
  • Data science life cycle
  • Data analytics: Types
  • AI and Machine Learning: Overview

6.2 CBDA: Introduction

  • CBDA: Overview
  • What is Business Data Analytics?
  • Eligibility criteria
  • Six Business Data Analytics domains

6.3 Business Analysis and Data Analytics

  • Business analysis in data analytics projects
  • Comparison between business analysis and data analytics

6.4 Business Data Analytics Domains: Introduction

Domain 1: Identifying the Research Questions

  • Defining business problems or opportunities
  • Identifying and understanding stakeholders
  • Current state assessment
  • Defining the future state
  • Formulation of research questions
  • Planning the Business Data Analytics approach
  • Selection of techniques for the identification of research questions

Domain 2: Source Data

  • Data collection planning
  • Determination of datasets
  • Data collection
  • Data validation

Domain 3: Data Analysis

  • Developing a Data Analysis Plan
  • Data preparation
  • Data exploration
  • Performing data analysis
  • Assessment of the analytics and system approach

Domain 4: Interpreting and Reporting Results

  • Validating the understanding of stakeholders
  • Planning for stakeholder communication
  • Determining the communication requirements of the stakeholders
  • Deriving Insights from Data
  • Documentation and communication of findings from the completed analysis
  • Selection of techniques for interpreting and reporting results

Domain 5: Using Results to Influence Business Decision-making

  • Action recommendation
  • Implementation plan development
  • Change management
  • Guiding the organizational-level strategy for Business Data Analytics
  • Organizational strategy
  • Talent strategy
  • Data strategy

6.5 Techniques

  • Business simulation
  • Business visualization
  • Concept modeling
  • Data dictionary, flow diagrams, mapping, and storytelling
  • Decision modeling and analysis
  • Descriptive and inferential statistics
  • Extract, Transform, and Load (ETL)
  • Exploratory data analysis
  • Hypothesis formulation and testing
  • Interface analysis
  • Optimization
  • Problem shaping and reframing
  • Stakeholder list, map, and personas
  • Survey and questionnaire
  • Technical visualizations
  • The big idea
  • Three-minute story

7.1 Introduction to Agile Scrum 

  • Agile Scrum overview
  • Agile project principles
  • Sprint and Increment in Agile Scrum
  • Scrum theory
  • Other Agile Frameworks

7.2 Scrum Team and Artifacts and Events

  • Scrum team and Scrum Master
  • Scrum roles
  • Scrum flow
  • Scrum artifacts: product backlog 
  • Artifacts transparency
  • Scrum events: sprint planning and retrospective
  • Agile estimating, planning, monitoring, and control

7.3 Project Management Using Jira 

  • Introduction to Project Management in Jira
  • Jira issue types
  • Scrum & Kanban boards
  • Customizing board settings
  • Release and backlog management
  • Jira reports

Tools covered

JIRA software

8.1 Class diagram
8.2 Component diagram
8.3 Composite structure diagram
8.4 Deployment diagram
8.5 Object diagram
8.6 Package diagram
8.7 Profile diagram
8.8 Activity diagram
8.9 State machine diagram
8.10 Use case diagram
8.11 Communication diagram
8.12 Interaction overview diagram
8.13 Sequence diagram
8.14 Timing diagram

9.1 Communication skills
9.2 Leadership skills
9.3 Problem-solving skills
9.4 Business knowledge
9.5 IT knowledge

You will be working on multiple projects in different domains like retail, finance, and banking and learn how Machine Learning is used to solve today’s world problems.

11.1 Python Environment Setup and Essentials

  • Introduction to Python 
  • Features
  • Python installation – Windows, Mac & Linux distribution for Anaconda Python
  • Deploying Python IDE
  • Basic Python commands, data types, variables, keywords, etc.

Hands-on Exercise

Installing Python Anaconda for Windows, Linux, and Mac

11.2 Python language Basic Constructs

  • Built-in data types in Python
  • Learn classes, modules, Str(String), Ellipsis Object, Null Object, Ellipsis, Debug
  • Basic operators, comparison, arithmetic, slicing and slice operator, logical, bitwise
  • Loop and control statements 

Hands-on Exercise

Write your first Python program, write a Python function (with and without parameters), use Lambda expression, write a class, create a member function and a variable, create an object, and write a for loop.

11.3 OOP Concepts in Python

  • Write OOP concepts program in Python
  • Connecting to a database
  • Classes and objects in Python
  • OOPs paradigm
  • Python functions, return types, and parameters
  • Lambda expressions

Hands-on Exercise

Creating an application that helps to check balance, deposit money, and withdraw the money using the concepts of OOPS.

11.4 Database Connection

  • Database and need of a database
  • Installing MySQL on Windows
  • Database connection using Python

Hands-on Exercise

Demo on Database Connection using Python and pulling the data.

11.5 NumPy for Mathematical Computing

  • Arrays and matrices
  • Broadcasting of array math
  • Indexing of the array
  • Standard deviation, conditional probability, correlation, and covariance

Hands-on Exercise

How to import the NumPy module, creating an array using an ND-array, calculating standard deviation on an array of numbers, calculating the correlation between two variables.

11.6 SciPy for Scientific Computing

  • Introduction to SciPy
  • Functions building on top of NumPy, cluster, linalg, signal, optimize, integrate, sub-packages
  • SciPy with Bayes Theorem

Hands-on Exercise

Importing of SciPy, applying the Bayes’ theorem on the given dataset

11.7 Matplotlib for Data Visualization

  • How to plot graph and chart with Python?
  • Various aspects of line, scatter, bar, histogram, 3D, the API of Matplotlib, subplots

Hands-on Exercise

Deploying MatPlotLib for creating Pie, Scatter, Line, Histogram

11.8 Pandas for Data Analysis and Machine Learning

  • Introduction to Python data frames
  • Importing data from JSON, CSV, Excel, SQL database, NumPy array to data frame
  • Various data operations 

Hands-on Exercise 

Working on importing data from JSON files, selecting record by a group, applying a filter on top, viewing records

Capstone Project

Substantiate your learning experience and Business Analysis skills via this practical, industry-based capstone project based on our course and showcase your skills in the field of Product Management and Business Analysis.

Tools covered

python 2 anaconda Scipy matplotlib pandas

Substantiate your learning experience and Business Analysis skills via this practical, industry-based capstone project based on our course and showcase your skills in the field of Product Management and Business Analysis.

  • Job Search Strategy
  • Resume Building
  • LinkedIn Profile Creation
  • Interview Preparation Sessions by Industry Experts
  • Mock Interviews
  • Placement opportunities with 400+ hiring partners upon clearing the Placement Readiness Test.
View More
Disclaimer
Intellipaat reserves the right to modify, amend or change the structure of module & the curriculum, after due consensus with the university/certification partner.

Program Highlights

60+ Live sessions across 7 months
30+ Industry Projects & Case Studies
134 Hours of Self-paced Videos
24*7 Support

Project Work

Reviews

( 5 )

Career Services By Intellipaat

Career Services
guaranteed
Placement Assistance
job portal
Exclusive access to Intellipaat Job portal
Mock Interview Preparation
1 on 1 Career Mentoring Sessions
resume 1
Career Oriented Sessions
linkedin 1
Resume & LinkedIn Profile Building
View More

Our Alumni Works At

Hiring Partners

Peer Learning

Via Intellipaat PeerChat, you can interact with your peers across all classes and batches and even our alumni. Collaborate on projects, share job referrals & interview experiences, compete with the best, and make new friends – the possibilities are endless and our community has something for everyone!

class-notifications
hackathons-
career-services
major-announcements
collaborative-learning

Admission Details

The application process consists of three simple steps. An offer of admission will be made to selected candidates based on the feedback from the interview panel. The selected candidates will be notified over email and phone, and they can block their seats through the payment of the admission fee.

ad submit

Submit Application

Tell us a bit about yourself and why you want to join this program

ad review

Application Review

An admission panel will shortlist candidates based on their application

ad admission 1

Admission

Selected candidates will be notified within 1–2 weeks

Program Fee

Total Admission Fee

₹ 75,012

Apply Now

EMI Starts at

₹ 4,999

We partnered with financing companies to provide competitive finance options at 0% interest rate with no hidden costs

Financing Partners

dk-fee-emi-logo

The credit facility is provided by a third-party credit facility provider and any arrangement with such third party is outside Intellipaat’s purview.

Upcoming Application Deadline 14th Dec 2024

Admissions are closed once the requisite number of participants enroll for the upcoming cohort. Apply early to secure your seat.

Program Cohorts

Next Cohorts

Date Time Batch Type
Program Induction 14th Dec 2024 08:00 PM - 11:00 PM IST Weekend (Sat-Sun)
Regular Classes 14th Dec 2024 08:00 PM - 11:00 PM IST Weekend (Sat-Sun)
Apply Now

Frequently Asked Questions

How do I move from business analyst to project manager?

To transition from a Business Analyst to a Project Manager, acquire skills in product development, user experience, and leadership.

Project Managers generally earn more than Business Analysts due to their strategic roles.

A minimum qualification for a Business Analyst typically includes a bachelor’s degree in business, analytics, or related fields.

Intellipaat’s business analysis and project management online course will give you hands-on experience in mastering the domains of business analysis and project management.

You will also get to master various topics like UML 2.0, SQL functions, Agile business perspectives, and many more.

As part of this course, you will work on real-time projects and assignments that have high relevance in the corporate world. Upon completion, you can apply for some of the best jobs in top MNCs around the world.

View More

What is included in this course?

  • Non-biased career guidance
  • Counselling based on your skills and preference
  • No repetitive calls, only as per convenience
  • Rigorous curriculum designed by industry experts
  • Complete this program while you work