Intermediate
Business Analyst
Get job-ready as a Business Analyst with this hands-on training program designed for both beginners and career-switchers. Learn how to gather and document requirements, analyze data using Excel, SQL & Power BI, model business processes, and work with tools like JIRA and Confluence. Through weekly mini-projects, real-world case studies, and a capstone project, you’ll build a portfolio that showcases your skills to employers.
Perfect for students, graduates, or working professionals looking to enter the field of Business Analysis with strong technical and communication skills.
Curriculum
- 10 Sections
- 49 Lessons
- 100h Duration
WEEK 1: INTRO TO BUSINESS ANALYSIS & REQUIREMENTS GATHERING
6 Lessons
- Role & responsibilities of a Business Analyst
- Business Analysis vs. Data Analysis
- SDLC, Agile, Scrum & Kanban
- Stakeholder communication
- Elicitation techniques (interviews, surveys, workshops)
- Mini Project: Define requirements for a retail app (w/ Power BI insights)
Week 2: Business Process Modeling & Documentation
5 Lessons
- Week 2: Business Process Modeling & Documentation
- Tools: BPMN, flowcharts, swimlane diagrams
- Writing BRDs (Business Requirement Documents)
- Functional vs. non-functional requirements
- Mini Project: Service request system process map + Power BI visual tracking
Week 3: Data Literacy for Business Analysts
5 Lessons
- Data-driven decision-making
- Excel basics: Pivot tables, charts, VLOOKUP
- Data interpretation & insight generation
- Dashboard storytelling
- Mini Project: Sales trend analysis & reporting in Excel & Power BI
Week 4: Agile Tools – JIRA, Confluence & Project Tracking
5 Lessons
- Agile PM tools overview
- Writing user stories & managing epics
- Sprint planning with JIRA
- Collaborative documentation in Confluence
- Mini Project: Product backlog for a feature (JIRA + Power BI progress tracking)
Week 5: SQL & Database Fundamentals
5 Lessons
- Introduction to relational databases
- Writing SQL queries: SELECT, WHERE, GROUP BY, JOIN
- Extracting insights from real data
- SQL for automated reporting
- Mini Project: Revenue & customer insights using SQL + Power BI
Week 6: Requirements Analysis & Solution Design
5 Lessons
- Gap analysis, root cause analysis
- Creating use cases & user stories
- Intro to wireframing: Figma, Balsamiq
- Evaluating solutions for feasibility
- Mini Project: E-commerce tracking system design + Power BI support
Week 7: Data Visualization & KPI Reporting
5 Lessons
- Defining & tracking KPIs
- Power BI essentials: Reports, dashboards, DAX basics
- Building stakeholder-ready dashboards
- Translating insights into decisions
- Mini Project: Customer satisfaction dashboard (Power BI)
Week 8: Strategic Thinking & Business Case Development
5 Lessons
- SWOT, PESTLE, Porter’s Five Forces
- Cost-benefit analysis & ROI calculation
- Writing & presenting a business case
- Aligning projects with organizational strategy
- Group Case Study: Digital transformation strategy (with Power BI)
Week 9: Career Prep & Interview Readiness
5 Lessons
- Resume crafting & portfolio building
- LinkedIn optimization
- Behavioral + situational mock interviews
- Real-world case-based mock rounds
- Mini Project: Build your BA portfolio using SQL & Power BI
Week 10: Capstone Project & Final Presentation
3 Lessons
- End-to-end business analysis project
- 1:1 Mentorship & Career Support
- Placement Assistance
