Your cart is currently empty.
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
Learning Format
Online
Live Classes
7 Months
Executive PG
Certification
Campus Immersion
iHUB, IIT Roorkee
EMI Starts
at ₹4999/month*
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.
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:
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
They are masters of strategic thinking and capable of conducting technological analysis with strong leadership and organizational skills.
They possess data-driven business acumen that helps them plan, budget, and oversee an organization’s project.
Market research analysts compile complex reports, surveys, spreadsheets, etc. to gather and evaluate significant market intelligence.
They are responsible for the strategy, roadmap, and features of a product, as well as working well with cross-functional teams.
It is a senior and executive-level leadership position that focuses on making sure the team is running effectively and improving processes.
This role typically oversees all product activities and defines the big-picture product strategy and sets long-term goals.
Skills to Master
SDLC
Agile Business
UML Diagrams
Agile Scrum
Data visualization
SQL
Analytics
Entity Relationship Model
Python
NumPy
SciPy
Machine Learning
Tools to Master
MS-Excel –
1.1 Excel FundamentalsÂ
1.2 Excel For Data AnalyticsÂ
1.3 Data Visualization with Excel
2.1 SQL Basics –Â
2.2 Advanced SQL –Â
2.3 Deep Dive into User-Defined Functions
2.4 SQL Optimization and Performance
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.
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
4.1 Introduction to Business AnalysisÂ
4.2 Business Analysis Concepts and Knowledge Areas                   Â
4.3 Requirement Lifecycle Management and Strategy AnalysisÂ
4.4 Requirement Analysis, Design Definition, Model Requirements, and Solution EvaluationÂ
4.5 Agile Business Perspectives and Creating UMLÂ
4.6 Understand BA Role on the Agile Team
4.7 Underlying Competencies of a Business Analyst & Microsoft 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
6.1 Data Science and Analytics Fundamentals
6.2 CBDA: Introduction
6.3 Business Analysis and Data Analytics
6.4 Business Data Analytics Domains: Introduction
Domain 1: Identifying the Research Questions
Domain 2: Source Data
Domain 3: Data Analysis
Domain 4: Interpreting and Reporting Results
Domain 5: Using Results to Influence Business Decision-making
6.5 Techniques
7.1 Introduction to Agile ScrumÂ
7.2 Scrum Team and Artifacts and Events
7.3 Project Management Using JiraÂ
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
Hands-on Exercise
Installing Python Anaconda for Windows, Linux, and Mac
11.2 Python language Basic Constructs
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
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
Hands-on Exercise
Demo on Database Connection using Python and pulling the data.
11.5 NumPy for Mathematical Computing
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
Hands-on Exercise
Importing of SciPy, applying the Bayes’ theorem on the given dataset
11.7 Matplotlib for Data Visualization
Hands-on Exercise
Deploying MatPlotLib for creating Pie, Scatter, Line, Histogram
11.8 Pandas for Data Analysis and Machine Learning
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.
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.
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!
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.
Submit Application
Tell us a bit about yourself and why you want to join this program
Application Review
An admission panel will shortlist candidates based on their application
Admission
Selected candidates will be notified within 1–2 weeks
Total Admission Fee
EMI Starts at
We partnered with financing companies to provide competitive finance options at 0% interest rate with no hidden costs
Financing Partners
Admissions are closed once the requisite number of participants enroll for the upcoming cohort. Apply early to secure your seat.
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) |
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.
What is included in this course?