Intermediate
Placement Assistance Professional Courses

Business Analyst

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

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.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Intermediate
Placement Assistance Professional Courses

Data Analyst

100h
53
20
Add to Cart
Intermediate
Placement Assistance Professional Courses

Azure Data Engineer

100h
35
20
Add to Cart
0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    Continue Shopping
    Scroll to Top