🗓️ 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