Course

Business Analyst

WHAT’S THIS PROGRAM ABOUT?

Enrol in our Business Analysis Workshop Program for an immersive dive into cutting-edge business analysis methodologies. Gain expertise in requirements gathering, analysis, documentation, effective communication, stakeholder and team management, project delivery, and post-implementation tasks.

We believe in hands-on learning, where practical experience is key. There are no shortcuts on this journey. You'll be challenged and empowered to tackle real-world scenarios head-on, just like a seasoned BA.

Through our program, you'll not only grasp the fundamentals but also cultivate essential Business Analysis Experience. This ensures that when you step into your next role, you'll feel confident and equipped to handle challenges independently from day one.

Program objectives

• ACQUIRE SKILLS: Gain practical experience in Business Analysis Essentials, laying a strong groundwork.
• APPLY: Learn Each topic covered in the workshop is immediately put into practice, offering real-time simulations.
• ENGAGE: Undertake two full-scale project implementations, assuming the role of a Business Analyst, to solidify your learning.

CURRICULUM

• Introduction to Business Analysis: Introduction to Business Analysis, Business Analysis Overview & Origin, what is Business Analysis? Who is a Business Analyst (Functions)? What a BA does in a project? Types of IT companies, Client - Stakeholder - End Users, Stakeholders and Types of Stakeholders, Business Analyst Prerequisites, Roles and Responsibilities of a BA, Do’s and Don’ts of a BA.
• Requirement Elicitation: Introduction to Requirement Elicitation, Types of Elicitation Techniques, Interviews, Focus groups, JAD session, Brainstorming, Observation, Surveys & Questionnaire, Prototyping Interface Analysis, Document analysis, Brainstorming, Reverse engineering, Workshops,
• Requirement Analysis: Introduction to Requirements Analysis, Defining Project Objective, Background & Drivers, Minimal Viable Product, Pareto analysis, Fishbone analysis, SWOT analysis, GAP analysis, Kano Analysis, Competitive Analysis, Feasibility study, Analyse Current State, Define Future State, Business case writing,
• SDLC Waterfall & Agile: Introduction to SDLC & Phases, Role of a Business Analyst in SDLC, Introduction to Waterfall Methodology, Pros & Cons of Waterfall Methodology, Introduction to Agile Methodology, Pros & Cons of Agile Methodology Waterfall vs Agile, which methodology to choose for a project?
• Agile Fundamentals: Origins and History of Agile/Scrum, Benefits of moving to Agile Methodologies for development, Agile v/s Waterfall, Agile Overview, Agile frameworks and terminology, Agile Mindset, Agile Manifesto values and principles Deep Dive with [ (a)Examples and (b) Case Study]
• Scrum Fundamentals: History of Scrum, Scrum Theory / Empirical Process, Scrum Values, Scrum Roles Vs Non-Core Roles, Scrum Master Role and Responsibilities, Development Team Role and Responsibilities, Team Engagement and Motivation
• Agile - Scrum Framework: Introduction to Scrum Framework , User Stories + Acceptance Criteria , Epics, Sprints, Types of Backlogs - Product, Release & Sprint , Backlog Refinement Meeting, Sprint Planning Meeting , Sprint Review Meeting, Sprint Retrospective Meeting , Daily Scrum Meeting , Handling Impediments, Agile Estimation techniques, Planning poker, T-shirt sizing & Story points , Velocity and Prioritisation (MoSCoW technique) , Charts - Sprint, Velocity, Burndown & Burnup , Role of Product Owner, Role of Product Manager , Role of Stakeholders , Role of Scrum Team
• Requirement Documentation: Introduction to Requirement Documentation , Types of Requirements, Business Requirements Document (BRD) , Functional Requirements Document (FRD) , Software Requirement Specification (SRS) , Scope of Work Document (SoW), Work breakdown structure (WBS), Use case documents (UCD) & RACI Matrix , How to write User stories and acceptance criteria?, Requirements Traceability Matrix, How documentation differs between Waterfall and Agile?, How to create wireframe designs using Balsamiq? , How to draw business process flow diagrams?, How to create and manage project documents in confluence?, How to manage product backlog and sprints in Jira Software?
• Software testing: Introduction to Software testing , Role of BA in software testing , Manual testing & Automation testing , Creating Test plans, Creating Test cases , Creating Test Scenarios , Test Case Documents, How to work with software testers?, Types of Testing, Functional and Regression testing , White box and Black box testing , Positive and Negative testing, GUI and Unit testing , Smoke and Sanity testing , System Integration testing, Security and penetration testing , Load and stress testing, User Acceptance Testing (UAT)
• Project Challenges & Risks: Introduction to Project Challenges & Risks, Scope Creep - How to handle it? Effective Change Management, Frequent Changes in Scope, Reluctant Stakeholders or team, Misalignment between Business needs and technology, Conflict Among Stakeholders, Handling Business and Technical feasibility issues, Inadequate Time Allotted for BA Work, Lack of clarity on requirements, Getting Stakeholders to take time for project, Blame games and team politics.
• Release Planning: Creating a Release plan, Velocity and burndown charts, Release Planning Mistakes, Done Criteria, Agile Estimation Techniques / Planning Poker, Risk Management, Product Backlog Management
• Sprint Flow: Sprint Planning Meeting, Product Owners Responsibilities during Sprint, Daily Scrum, Agile Development Practices, Sprint Tracking, Product Backlog Grooming, Agile Testing, Sprint Review, Sprint Retrospective, Release Retrospective
• Recap: Recap and Questions

Curriculum on Technical Aspects

SQL

• Introduction to Databases: What is a database? Types of databases (relational, non-relational), Structured vs. unstructured data
• Introduction to SQL: What is SQL? History and importance of SQL, Relational databases and tables
• Retrieving Data: SELECT statement, FROM clause, WHERE clause for filtering, ORDER BY clause for sorting, LIMIT/OFFSET for paging
• Filtering and Sorting Data: Comparison operators, Logical operators (AND, OR, NOT), BETWEEN and IN operators, LIKE operator for pattern matching, IS NULL and IS NOT NULL
• Working with Data in Tables: INSERT statement for adding data, UPDATE statement for modifying data, DELETE statement for removing data, Handling NULL values
• Aggregating Data: COUNT function for counting rows, SUM function for adding values, AVG function for calculating averages, MIN and MAX functions for finding extremes
• Joining Tables: Understanding table relationships, INNER JOIN for combining data from multiple tables, Self-joins for relating data within the same table
• Subqueries: What are subqueries? Subqueries in the WHERE clause for filtering, Understanding correlated subqueries
• Data Modification Statements: Transaction control (COMMIT and ROLLBACK), SAVEPOINT for partial rollbacks
• Data Integrity and Constraints: Primary keys for unique identification, foreign keys for establishing relationships, UNIQUE and CHECK constraints for data validation

PYTHON

• Introduction to Python: Overview of Python and its history, setting up the Python development environment, Writing and running your first Python program, Basic syntax and data types
• Control Structures: Conditional statements (if, elif, else), Loops (for and while loops), Iteration and control flow, Practical examples and exercises
• Data Structures: Lists, tuples, and dictionaries, Sets and frozen sets, Strings and string manipulation, Lists comprehensions and generators
• Functions and Modules: Defining functions, Function parameters and return values, Scope and lifetime of variables, Importing and using modules
• File Handling: Reading from and writing to files, Working with different file formats (text, CSV, JSON), Exception handling and error messages
• Error Handling and Exception Handling: Understanding exceptions, Try, except, and finally blocks, Raising and handling custom exceptions,
• Data Manipulation and Processing: Working with NumPy for numerical data, Data analysis with pandas, Data visualization with libraries like Matplotlib and Seaborn
• Database Interaction: Connecting to databases with Python, SQL queries and database operations,
• Python For Data Visualization: Data Visualization Section, Introduction to Matplotlib, work with Matplotlib

POWERBI

• Introducing Power BI Desktop: installing Power BI Desktop, exploring the Power BI workflow, comparing Power BI vs. Excel, etc
• Connecting & Shaping Data: Connecting to data, shaping & transforming tables, using profiling tools, editing, merging & appending queries, etc.
• Creating a Data Model: Building relational models, creating table relationships, understanding cardinality and filter flow, etc.
• Visualizing Data with Dashboards: Inserting charts and visuals, customizing formats, editing interactions, applying filters and bookmarks, etc.

Case Studies & Assignments

• Task Allocation: Participants will be introduced to real-time case studies and assigned specific tasks to tackle.
• Evaluation: Upon submission of their assignments, our mentors will thoroughly review them, offering constructive feedback during the session.
• Refinement: Participants are encouraged to refine their work based on the feedback received, rectifying errors and enhancing their documentation as needed.
• Progression: The assignment process will persist until participants are adept at the methodologies inherent to the role of a Business Analyst.

WHAT SUPPORT WILL YOU GET?

• One To One Mentoring: No matter which background our participants come from, we provide 1-1 mentoring as every profile is unique in its way and we need to work based on their career goals.
• Career Coaching: Our diverse team of dedicated career coaches actively guide and coach students on their career paths and put together a plan to achieve their goals
• Portfolio And Resume: Students will have the opportunity to work one on one with career coaches to build a strong resume and portfolio that demonstrates their skill sets & strengths
• Mock Interview Events: We conduct mock interviews with mentors, and industry experts so our participants know the areas of improvement before they take a real interview
• Job Support: Our support will not end when our participants get the job. We provide on-the- job support so the initial days of their work won't be scary as they will always have their mentor by their side whenever they need.
• Interview Analysis: We will prepare you for interviews as per the job description shared by recruiters and also analyze your performance POST interview so you will know where to improve next time and also avoid the same mistakes