Business Analyst.
Bridging business goals and technical execution—turning complex data across E-commerce, SaaS, HR, and Operations into actionable strategies.
Think you could survive a real stakeholder meeting? Seven requests, three meters, one launch date.
I'm a Business Analyst and Data Analytics professional focused on turning raw data into decisions businesses can act on. My projects and case studies cover e-commerce, SaaS, HR analytics, finance, operations and customer analytics. Each one starts from a real business problem, not a tutorial.
I start with the business question, not the dataset. I translate stakeholder requirements into analytical frameworks, clean and analyse the data, and explain the findings simply enough that a non-technical decision-maker can act on them.
I combine Business Analysis (requirements, stakeholders, process improvement) with Data Analytics (SQL, Power BI, Excel, Tableau) to close the gap between what a business needs and what the data shows.
Understand the "Why". Every project begins with a clear business question: What decision are we trying to inform?
Wrangle the Data. I extract, clean, and validate raw data streams using SQL, Python, and Excel to build a single source of truth.
Spot the Patterns. Through Power BI and Tableau, I build intuitive dashboards that make complex trends obvious at a glance.
Bridge to Action. Insights are useless without execution. I write clear BRDs, FRDs, and user stories so dev and business teams can act immediately.
Tap any project to open the full case study: problem, process and outcomes.
End-to-end BA case study. Diagnosed a 37% ride-failure rate and 53% one-time-rider leakage across 100K+ bookings, then scoped five product fixes across 4 Jira sprints.
Case studyRetrospective analysis of 100K+ OLA bookings (10,000+ records deep-dived) showed a marketplace under strain, with completed rides converting only about 62% of demand.
Dynamic cancellation-penalty engine, driver stationary alerts, smart vehicle allocation, UPI cashback checkout, and automated WhatsApp re-engagement.
Retail profitability analysis for a U.S. multi-region superstore: $2.29M in sales, 9,994 orders, 21.1% loss-making. Delivered a discount governance framework projecting 10 to 15% annual margin recovery.
Case studyA multi-region superstore with $2.29M across about 10K transactions had plateaued on profit despite strong revenue. The job was to find where value was leaking.
A real business problem in a new industry every day, solved end to end with SQL, Excel and Power BI.
Case studyInstead of repeating one type of project, I picked a new industry each day and solved a real problem. The goal was analytical thinking across domains, not only technical skill.
SQL (MySQL), Python
Power BI, DAX, Tableau, Data Modeling, Dashboard Automation, Google Looker
Microsoft Excel, Pivot Tables, VLOOKUP, Conditional Formatting
KPI Development, Customer Segmentation, Business Insights, Reporting, Data Storytelling, EDA, ETL
MySQL, PostgreSQL
Requirements Gathering, Stakeholder Management, Process Improvement, Gap Analysis, BRD / FRD, As-Is / To-Be, JIRA
Stakeholder Communication, Business Reporting, Problem Solving, Data Storytelling
CGPA 8.03 / 10
Government Degree College Nagrota Bhagwan, Himachal Pradesh University
Final-year focus on data systems, database management, software engineering and analytical problem solving, with capstone projects in SQL, Python and Power BI.
Live Project category
Led the data analysis layer for a real-time Disaster Relief Management system. Turned emergency-response requirements into data flows and worked with the development team to ship a working solution under competition conditions.
Free resource hubs for people starting out. No fluff, no paywalls.
The tools, frameworks and mindsets that matter in real work: SQL foundations, Power BI basics, Python for analysis, a career roadmap, resume tips and interview prep.
Explore resourcesA toolkit for aspiring BAs: BRD and FRD guides, Agile and Scrum, process mapping, Jira and Confluence, SQL for BAs and stakeholder management.
Explore resourcesLet's work together.
Open to Business Analyst and BA related roles, freelance analytics projects and collaborations. Available to relocate. I reply within 24 hours.
Your path to becoming a Data Analyst. Everything I wish I had when I started — a clear roadmap, handpicked resources, and a 90-day action plan to land your first DA role. 100% free.
A structured path from zero to job-ready. Each stage builds on the last — don't skip ahead.
Before touching code, master the tool every analyst uses daily. Learn data entry, sorting, filtering, basic formulas, and pivot tables. This is your data intuition foundation.
SQL is used in 90%+ of DA job descriptions. Learn SELECT, WHERE, GROUP BY, JOINs, subqueries, and window functions. Practice on real datasets daily.
Python automates what Excel can't. Focus on Pandas for data manipulation, NumPy for calculations, and Matplotlib/Seaborn for visualisation. Don't try to learn everything — focus on data tasks.
Turn data into decisions with interactive dashboards. Learn DAX for calculated measures, data modeling, and how to tell a story through charts. Power BI is free and widely used in India.
You don't need a statistics degree — but you need to know mean vs median, distributions, correlation vs causation, and how to validate insights. This separates good analysts from great ones.
Projects are your proof of skill. Analyse a real dataset, ask a business question, clean the data, visualise it, and write your findings. Put it on GitHub. This is what gets you interviews.
Optimise your resume for ATS, write a strong LinkedIn profile, start applying on Naukri/LinkedIn/Internshala, and prepare for SQL and case study interviews. Consistency beats intensity here.
No fluff. These are the actual resources I used and recommend — organised by skill.
The best starting point for SQL basics. Interactive exercises, clear syntax examples, instant results.
w3schools.com/sql →Goes beyond basics — covers window functions, subqueries, and analytics-specific SQL. Highly recommended.
mode.com/sql-tutorial →Best platform to practice SQL interview questions. Start from Easy and work your way up. Employers check this profile.
hackerrank.com →Practical SQL tutorials built for aspiring data analysts. Great for beginners who prefer video learning.
YouTube →Interview-focused SQL problems. The Top 50 set covers everything you'll face in DA interviews at top companies.
leetcode.com →Interactive SQL learning with real databases. Practice on actual data — much better than reading alone.
sqlzoo.net →Best free Python course for analysts. Focused on data tasks, not software engineering. Includes hands-on notebooks.
kaggle.com/learn →Pandas is the #1 Python library for data analysis. This course teaches it the right way — with real data problems.
kaggle.com/learn →Python for data analysis series. Covers Pandas, Matplotlib and real project walkthroughs — great for beginners.
YouTube →In-depth Python tutorials including data analysis, pandas, and visualisation. Higher quality than most free content.
realpython.com →Official Microsoft learning path for Power BI. The most up-to-date and comprehensive free resource available.
learn.microsoft.com →Best Power BI YouTube channel. Covers DAX, data modeling, and advanced report design in a practical, no-fluff style.
YouTube →The DAX function reference. Bookmark this immediately. Every DAX function explained with examples and best practices.
dax.guide →Chandoo has been teaching Excel and Power BI for 15+ years. Practical, project-based, excellent for Indian learners.
YouTube →The best Excel reference site. Every formula explained clearly with examples. Use as a lookup when stuck on a formula.
exceljet.net →300+ Excel tutorials covering everything from basics to advanced dashboards. The go-to channel for Excel learners in India.
YouTube →Download free real-world datasets to practise Excel analysis. Sales data, HR data, ecommerce — all available for free.
kaggle.com/datasets →Best place to learn statistics from scratch. Covers mean, median, distributions, probability, and hypothesis testing — all free.
khanacademy.org →Learn how to visualise data to surface patterns and communicate findings. Practical Python-based course using real datasets.
kaggle.com/learn →Statistics explained with clarity and humour. Best channel for understanding stats concepts visually. Highly recommended.
YouTube →Best platform for DA jobs in India. Optimise your profile first, then apply daily. Set job alerts for "data analyst" + your city.
linkedin.com/jobs →India's largest job portal. Most mid-size and enterprise companies post DA roles here. Upload your resume and apply daily.
naukri.com →Best platform for freshers and students. Get your first data experience through internships before applying to full-time roles.
internshala.com →Every project you do should live on GitHub. Recruiters check it. Even 2–3 clean repos with good README files stand out.
github.com →A week-by-week breakdown to go from beginner to job-ready in 90 days. Be consistent — 1.5–2 hours daily is enough.
Excel + SQL — the two must-haves
Week 1
Week 2
Week 3–4
Month Goal Comfortable writing SQL queries & building Excel dashboards
Automate analysis + visualise it
Week 5–6
Week 7
Week 8
Month Goal Completed one end-to-end project using Python + Power BI
Portfolio + resume + active job hunt
Week 9–10
Week 11
Week 12–13
Month Goal Resume submitted to 50+ roles, 2–3 interviews secured
Tick these off before sending your first application. Each one increases your chances significantly.
Your path to becoming a Business Analyst. Everything I wish I had when I started — a clear roadmap, handpicked resources, and a 90-day action plan to land your first BA role. 100% free.
A structured path from zero to job-ready. Each stage builds on the last — don't skip ahead.
Before learning tools, understand the role. A Business Analyst bridges the gap between business problems and technical solutions. Learn the core responsibilities — requirements, stakeholders, documentation, and process improvement.
The heart of BA work. Learn how to elicit requirements from stakeholders through interviews, workshops, and surveys. Practice writing BRDs (Business Requirements Documents) and FRDs (Functional Requirements Documents).
Learn to map As-Is processes (current state) and To-Be processes (future state). Identify gaps, inefficiencies, and improvement opportunities. Tools like Lucidchart, Visio, or even pen-and-paper work here.
BAs who can analyse data are 2x more valuable. Learn Excel deeply — pivot tables, VLOOKUP, dashboards. Add SQL for querying databases. Power BI or Tableau for visualising insights for stakeholders.
Most BA roles operate in Agile environments. Learn Scrum ceremonies, sprint planning, and backlog grooming. JIRA is the industry-standard tool — know how to create epics, stories, and manage sprints. Stakeholder communication is everything.
Pick 2–3 real business problems and document them end-to-end — requirements, process maps, gap analysis, and recommendations. No work experience? Use public datasets and simulate a client scenario. Show your thinking, not just the output.
Handpicked — no fluff, no paid courses that waste your time. These are the ones that actually help.
Free BRD, FRD, use case, and stakeholder register templates. Download and customise for your own case studies.
modernanalyst.com →YouTube walkthroughs of real BRD writing — structure, stakeholder sections, functional requirements, and acceptance criteria.
Watch free →Best free diagramming tool for process maps, flowcharts, and As-Is/To-Be diagrams. Used by BA professionals globally.
lucidchart.com →Official JIRA tutorials — creating issues, managing sprints, backlog grooming, and reporting. Free and comprehensive.
atlassian.com →Microsoft's official free Power BI learning path. Build dashboards that communicate requirements and business insights visually.
microsoft.com →Everything on Agile, Scrum, Kanban, and sprints — written by the people who build JIRA. The best free Agile resource available.
atlassian.com →Official Scrum framework explanation — roles, events, artifacts. Read this before any BA interview in an Agile company.
scrum.org →Follow for regular BA + data analytics insights, case study breakdowns, career tips, and job search strategies.
Connect on LinkedIn →How to build a BA resume with no experience — what to include, how to frame projects, and what recruiters actually look for.
Watch free →International Institute of Business Analysis — home of ECBA (entry-level) and CBAP certifications. Check their free resources too.
iiba.org →A realistic, week-by-week plan to go from zero BA knowledge to job-ready in 90 days.
Build the BA base
Week 1–2
Week 3–4
Month 1 goal
Get hands-on with BA tools
Week 5–6
Week 7–8
Month 2 goal
Build proof, apply with confidence
Week 9–11
Week 12
Month 3 goal
Tick these off before sending a single application. Don't rush the process.