Scattered Profile (Most Freshers):
LinkedIn: "Aspiring Data Analyst | Open to opportunities"
Resume: Skills — Excel, SQL, Power BI; Projects — Sales Dashboard
GitHub: Empty or no README
Result: Recruiter sees three different stories → no trust → skip

Aligned Profile (Interview-Ready):
LinkedIn Headline: Data Analyst (Fresher) | SQL, Power BI, Excel | Projects with measurable impact
Resume: Same headline + 2–3 projects with metrics
GitHub: Pinned repos with READMEs explaining problem, data, tools, impact
All three link to the same project story
Result: Recruiter trusts the profile in 30 seconds → interview call

LinkedIn Optimization Checklist:
- Headline: target role + tools + value
- About: 3–4 lines with one project metric + link
- Featured: pin GitHub / dashboard / portfolio
- Skills: top 3 tools + get endorsements
- Experience: project-based entries with metrics
- Open to work: set to "Data Analyst" roles only
- Custom URL: linkedin.com/in/yourname-dataanalyst

What Recruiters Scan on LinkedIn:
1. Headline — does it match the role?
2. About — any proof or just adjectives?
3. Featured — working links?
4. Skills — relevant tools only?
5. Activity — any posts or engagement?
Result: If headline, About and Featured align, recruiter clicks the link.

# Regional Sales Performance & Inventory Reallocation

## Problem
Identify why one region's revenue dropped 12%

## Data
80K sales rows, 18 months, 5 regions

## Tools
- SQL: JOINs, window functions
- Power BI: KPI dashboard

## Insight
12% drop due to stock-outs in top 3 SKUs

## Impact
Recommended reallocation → stock-outs reduced by 18%

## Live Dashboard
[Link to Power BI dashboard]

## How to Run
1. Load data from /data folder
2. Run queries from /sql folder
3. Open dashboard from /dashboard folder

GitHub Optimization Checklist:
- Pin only 2–3 best projects
- Every repo has a clear README
- README includes problem, data, tools, insight, impact
- Folder structure is clean (data/, sql/, dashboard/)
- Live dashboard link works
- Commit history shows regular work
- Profile README with headline + links to LinkedIn + Resume

Resume Alignment with LinkedIn + GitHub:

Headline:
Data Analyst (Fresher) | SQL, Power BI, Excel | Projects with Measurable Impact

Projects:
1. Regional Sales Performance & Inventory Reallocation
   - Built SQL queries + Power BI dashboard on 80K sales rows
   - Identified 12% revenue drop in one region
   - Recommended inventory reallocation → stock-outs reduced by 18%
   - Link: github.com/yourname/sales-analysis

2. Customer Segmentation with SQL
   - Used JOINs + window functions on 50K customer records
   - Found high-value segment contributing 18% revenue
   - Link: github.com/yourname/customer-segmentation

Skills:
SQL, Power BI, Excel, Python (basic), Data Cleaning, Dashboarding

ATS Keyword Matching:
- Read job description carefully
- Extract tools: SQL, Power BI, Excel, Python
- Extract skills: data cleaning, dashboard, reporting
- Extract terms: KPI, insights, stakeholder, visualization
- Use these exact terms in resume headline, skills, and project bullets
- Don't keyword-stuff — use naturally in context
Result: ATS passes, human recruiter sees relevant profile

Data Analyst Profile Alignment Plan:

Step 1: Headline → Same Everywhere
- LinkedIn headline = Resume headline
- Include target role + tools + value

Step 2: Projects → Same Everywhere
- Pick 2–3 best projects
- Same project names on Resume, LinkedIn, GitHub
- Same metrics in all three places

Step 3: Links → Working
- Test every GitHub and dashboard link
- Make sure README explains the project clearly

Target outcomes:
- One consistent story across three platforms
- Recruiter can verify claims in under 30 seconds
- Higher chance of interview call

Helpful Resources:

Free:
- LinkedIn profile optimization guides
- GitHub README templates for analytics projects
- ATS resume checkers and keyword tools

Paid / Structured:
- Uncodemy – Data Analytics Training Course
- Profile + portfolio review sessions
- Mock interviews focused on project storytelling

Certifications (Supporting only):
- Useful only when paired with real projects
- Certificate alone is never enough