🗓️ 6-Month Roadmap: MBA (HR + Marketing) → Business Analyst

🎯 Goal Overview

By the end of 6 months, you will be able to:

• Analyze and visualize data (Excel, Power BI, Tableau, SQL)
• Create business insights dashboards
• Understand HR/Marketing KPIs
• Prepare business requirement documents (BRD)
• Apply for Business Analyst / HR Analyst / Marketing Analyst jobs

🩵 MONTH 1 – FOUNDATION

🎯 Focus: Strengthen business + Excel skills

Learn:

• Business Analysis Basics
• Advanced Excel for analytics

Key Topics:

• Pivot tables, VLOOKUP/XLOOKUP, conditional formatting
• Data cleaning & analysis
• KPI dashboards for HR & marketing
• Business requirements documentation (BRD, FRD basics)

Free Courses:

1. Excel Skills for Business (Coursera - Macquarie University)
2. Business Analysis Fundamentals (Udemy)

Mini Projects:

1. Create an HR Dashboard – employee performance, attrition, salary distribution

2. Create a Marketing Campaign Tracker – leads, conversions, ROI

🧡 MONTH 2 – DATA VISUALIZATION

🎯 Focus: Learn Power BI or Tableau

Tools (Choose one to master):

Power BI (Microsoft) – easy integration with Excel

Tableau – powerful visualization for analytics roles

Learn:

Connecting data sources (Excel, CSV)

Building interactive dashboards

Storytelling with data

Free Resources:

Microsoft Learn – Power BI Guided Learning

Tableau Free Training Videos

Mini Projects:

1. Employee Engagement Dashboard (Power BI/Tableau)

2. Marketing Funnel Dashboard (Leads → Sales Conversion)

💚 MONTH 3 – SQL + Data Basics

🎯 Focus: Learn to query and extract data

Learn:

• SQL basics: SELECT, WHERE, GROUP BY, JOIN
• Data cleaning, filtering, and summarizing
• Writing queries for HR/Marketing use cases

Free Courses:

1. SQL for Data Analysis (Khan Academy)
2. Mode Analytics SQL Tutorial

Mini Projects:

1. HR Database Query – find top-performing employees, attrition trends

2. Marketing Data Query – analyze region-wise sales performance

💙 MONTH 4 – BUSINESS ANALYSIS TOOLS & METHODS

🎯 Focus: Learn tools & frameworks used in companies

Learn:

• Jira / Confluence – for agile projects
• Lucidchart / Draw.io – for process mapping
• SDLC, Agile, Scrum fundamentals
• Requirement elicitation and stakeholder management

Free Courses:

1. Agile with Atlassian Jira (Coursera)
2. Business Process Modeling (LinkedIn Learning)

Mini Project:

Document a “Recruitment Automation Process” in Jira or Lucidchart.

Write a sample BRD (Business Requirement Document) for a marketing dashboard project.

💜 MONTH 5 – CERTIFICATIONS & PORTFOLIO

🎯 Focus: Build credibility + showcase your work

Recommended Certifications:

1. Google Data Analytics (Coursera) – beginner-friendly, practical

🔗 Google Data Analytics Certificate

2. ECBA (Entry Certificate in Business Analysis) – if you want IIBA recognition

🔗 IIBA ECBA Certification

3. HR Analytics / Marketing Analytics (LinkedIn Learning)

Build a Portfolio (on GitHub / LinkedIn): Include:

• Excel dashboards (HR + Marketing)
• Power BI / Tableau projects
• SQL queries & documentation samples (BRD, process maps)

Mini Project:

Combine HR & marketing data for a "Recruitment Campaign ROI Dashboard" (measure how marketing attracts job applicants and conversion rates).

💛 MONTH 6 – JOB PREPARATION & NETWORKING

🎯 Focus: Resume, projects, LinkedIn, applications

Prepare:

BA Resume: Highlight analytical skills, projects, certifications

LinkedIn Profile: Add dashboards, project links, and keywords like “Business Analyst | HR & Marketing Analytics”

Mock Interviews: Practice scenario-based BA questions

Where to Apply:

Job portals: Naukri, LinkedIn, Indeed

Companies: Deloitte, Accenture, Zoho, Nielsen, EY, Mercer

Roles: HR Business Analyst, Marketing Analyst, Data Analyst, Associate BA

🧾 Bonus: Resume Keywords

Use terms like:

> “Business Analysis”, “Data Visualization”, “Power BI”, “Dashboard Creation”, “SQL”, “Process Improvement”, “HR Metrics”, “Marketing ROI”, “Stakeholder Management”, “Agile”.

💰 Expected Outcome (After 6 Months)

Skill Level Role Salary (India)

Beginner (6 mo.) HR/Marketing Analyst ₹5–₹8 LPA

Intermediate (1–2 yrs exp.) Business Analyst / Data Analyst ₹8–₹14 LPA

Advanced (3+ yrs) Senior BA / Consultant ₹1

4–₹25 LPA