यह रोडमैप अभी हिंदी में अनुवादित नहीं है: इसकी सामग्री अंग्रेज़ी में दिखाई जा रही है।
Data Analyst
Make sense of data and help teams decide what to do
पक्का नहीं कि यह आपके लिए सही है? अपना करियर खोजें →
13 में से 0 मिशन पूरे
क्या यह करियर आपके लिए है?
महीनों लगाने से पहले दो मिनट
जो आप जैसा लगे, उस पर टिक करें
जो बातें आप पर सही बैठती हैं, उन पर टिक करें।
आप ये कौशल सीखेंगे
इससे मिलने वाली नौकरियाँ
- Data Analyst
- Business Analyst
- Marketing Analyst
- Reporting Analyst
शुरू करने से पहले
- ✓ Comfort with spreadsheets
- ✓ Basic math skills
Data Analyst तक 13 मिशन
5 वर्ल्ड, 13 मिशन। खोलने के लिए किसी भी गोले पर टैप करें; चमकता हुआ गोला अगला है।
Most analysts start here, and so should you.
SQL shows up in almost every data analyst job posting.
Turn your data into dashboards people can actually read.
Add Python and statistics to your toolkit.
Assemble a few projects that show what you can do.
इस करियर के बारे में और
नौकरी के बारे में, आपके इलाके का वेतन, लोगों के सवाल, और यह करियर आगे आपको कहाँ ले जा सकता है।
काम के बारे में
आप क्या करेंगे
- Produce standard or custom reports that summarise business, financial or economic data
- Build and maintain dashboards, databases and other business intelligence tools
- Collect data from industry reports, public information and other sources
- Spot industry or regional trends that matter for business strategy
- Pull trend data together to support recommendations for action
आप कहाँ काम करेंगे
- Professional, scientific and technical services firms
- Finance and insurance companies
हर कदम पूरा पढ़ें
हर कदम का पूरा पाठ, पढ़ने या प्रिंट करने के लिए। इन पर काम ऊपर की यात्रा में करें।
Excel & Spreadsheets 3 कदम
Advanced Formulas & Data Retrieval
Mastering the programmatic side of spreadsheets to lookup, aggregate, and calculate values efficiently without manual entry.
असली काम: Given a massive, unformatted raw export of sales data, use XLOOKUP and SUMIFS to create a summary table answering 'Total revenue per region'. Use IFERROR to catch missing regions gracefully.
यह क्यों ज़रूरी है: Companies run on spreadsheets. Being the person who can instantly retrieve cross-referenced data using purely formulas will make you invaluable in your first week.
चेकलिस्ट
- Learn lookups: VLOOKUP, HLOOKUP, INDEX/MATCH, and XLOOKUP
- Master logical statements (IF, AND, OR, nested IFs)
- Learn statistical functions (COUNTIFS, SUMIFS, AVERAGEIFS)
- Understand absolute vs. relative cell referencing ($A$1 vs A1)
- Practice error handling (IFERROR) to keep sheets functional
Data Cleaning & Organization
Real-world data is dirty. You need to standardize formats, handle blanks, and split strings before any real analysis can happen.
असली काम: Take a dataset intentionally corrupted with trailing spaces, varied date formats (MM/DD/YY vs DD-MM-YYYY), and inconsistent capitalization. Write formulas to clean it into a pristine, unified format without manually retyping values.
यह क्यों ज़रूरी है: If your data is bad, your analysis is wrong. You'll spend more time standardizing messy data extracts than making charts, guaranteed.
चेकलिस्ट
- Use Text-to-Columns and string manipulation (LEFT, RIGHT, MID, CONCATENATE)
- Remove duplicates and standardize text casing (PROPER, UPPER, LOWER)
- Learn how to handle empty cells and NA values logically
- Understand Data Validation to restrict inputs going forward
- Format data as Tables for dynamic range referencing
Pivot Tables & Basic Dashboarding
The fastest way to aggregate, slice, and present spreadsheet data to stakeholders without writing code.
असली काम: Build a one-page interactive 'Executive Dashboard' in Excel tracking Monthly Key Performance Indicators (KPIs). Include slicers so a manager can filter the metrics by department or quarter.
यह क्यों ज़रूरी है: Stakeholders don't want to see 10,000 rows of raw data. They want a dashboard they can click around in to get immediate answers.
चेकलिस्ट
- Create Dynamic Pivot Tables from structured Data Tables
- Use Calculated Fields within a Pivot Table
- Add Slicers and Timelines for interactive filtering
- Build basic visual charts (Bar, Line, Scatter) from Pivot data
- Design a clean layout avoiding 'spreadsheet clutter'
SQL & Databases 3 कदम
Data Retrieval & Filtering
Querying exactly the rows you need out of massive databases securely and efficiently.
असली काम: Query a sample 'Customers' database table. Retrieve the top 50 customers living in a specific state who signed up in the last year, ordered by their lifetime value.
यह क्यों ज़रूरी है: You will rarely be analyzing data stored locally. You have to query the company's central database to pull just to the sandbox data you need before analyzing it.
चेकलिस्ट
- Write basic syntax: SELECT, FROM, WHERE, LIMIT
- Filter accurately using AND/OR, IN, BETWEEN, and LIKE for text patterns
- Order results using ORDER BY (ASC, DESC)
- Understand basic data types (VARCHAR, INT, DATE)
- Learn to alias tables and columns (AS) for readability
Aggregation & Multi-Table JOINs
Combining data scattered across different tables (e.g., matching a Users table with an Orders table).
असली काम: Join three tables: 'Orders', 'Products', and 'Users'. Write a query to find the top 5 product categories generating the most revenue, but only include users who registered in Q3.
यह क्यों ज़रूरी है: Relational databases are normalized (split apart) for storage efficiency. You have to know how to piece the puzzle back together to see the whole picture.
चेकलिस्ट
- Master GROUP BY and aggregate functions (COUNT, SUM, AVG, MAX)
- Filter aggregated data using the HAVING clause
- Understand the differences between INNER, LEFT, RIGHT, and FULL OUTER JOINs
- Write multi-condition JOINs handling null values
- Use UNION to vertically stack query results
Advanced SQL: CTEs & Window Functions
Level up from writing scripts to engineering multi-step data transformations.
असली काम: Write a query utilizing CTEs and a Window Function to calculate the month-over-month revenue growth percentage for a generic e-commerce store, partitioned by product category.
यह क्यों ज़रूरी है: Window functions are the #1 way analysts separate themselves from beginners in technical interviews. They make complex time-series analysis trivial natively in SQL.
चेकलिस्ट
- Use Common Table Expressions (WITH clause) to string together logical steps
- Learn Window Functions over partitions (ROW_NUMBER(), RANK(), DENSE_RANK())
- Calculate running totals and moving averages (SUM() OVER (...))
- Use LEAD() and LAG() to compare period-over-period data
- Familiarize yourself with Subqueries and when NOT to use them (performance)
Data Visualization 2 कदम
Business Intelligence (BI) Fundamentals
Learning how to navigate and build within enterprise BI tools like Tableau or PowerBI.
असली काम: Connect Tableau Public (or PowerBI Desktop) to a regional COVID-19 dataset. Replicate standard metrics: total cases (KPI card), cases over time (Line chart), and cases by district (Bar chart).
यह क्यों ज़रूरी है: No executive wants to read a list of numbers. You are hired to translate numbers into a visual signal they can glance at to make a decision.
चेकलिस्ट
- Connect BI tools to flat files (CSV) and live SQL databases
- Understand dimensions (categorical data) vs measures (numerical data)
- Build core standard charts: Bar charts, Line graphs, Scatter plots, and Heatmaps
- Create calculated fields within the BI environment itself
- Format axes, labels, and legends clearly
Dashboard Design & Storytelling
It's not just about making a chart; it's about telling a compelling and accurate story.
असली काम: Redesign a cluttered, poorly-made dashboard (find an example online). Strip away 3D effects, fix the color palette for accessibility (colorblind safe), and add a clear headline that explicitly states the insight rather than just a generic title.
यह क्यों ज़रूरी है: A brilliant analysis is useless if nobody understands the dashboard. Communicating the insight effectively is just as important as finding it.
चेकलिस्ट
- Learn the principles of Data Ink Ratio (removing clutter, gridlines, 3D effects)
- Use color strategically to highlight anomalies, not to make it 'pretty'
- Implement drill-downs and cross-filtering for interactivity
- Design tooltips that provide extra context on hover
- Learn 'Z-pattern' layout to guide the viewer's eye across the dashboard
Python & Statistics 3 कदम
Python for Data Analysis (Pandas & NumPy)
Replacing Excel for datasets that are too large (1 million+ rows) or require programmatic processing.
असली काम: Load a 2-million row CSV into a Pandas DataFrame. Filter out invalid rows, group by a target variable, calculate the mean of another column, and export the cleaned aggregated result back to a new CSV.
यह क्यों ज़रूरी है: Excel crashes around 1 million rows. Python handles millions easily and, more importantly, creates reproducible, automatable workflows.
चेकलिस्ट
- Set up Jupyter Notebooks / Google Colab for interactive coding
- Understand basic Python syntax: loops, lists, dictionaries, functions
- Use NumPy for fast numerical arrays and calculations
- Use Pandas DataFrames to load, inspect, filter, and merge datasets
- Handle null values and duplicates strictly mapped in Pandas
Foundational Statistics
The math protecting you from making blatantly false claims about your data.
असली काम: Take a dataset comparing two marketing campaigns. Use a t-test in Python (using scipy.stats) to determine if Campaign B actually outperformed Campaign A, or if the difference was just random statistical noise.
यह क्यों ज़रूरी है: If you cannot determine statistical significance, you might tell your company to spend millions on a strategy change that was actually a fluke in the data.
चेकलिस्ट
- Understand mean, median, mode, and when to use which (handling outliers)
- Learn variance, standard deviation, and normal distributions
- Understand correlation vs. causation logically
- Grasp the concept of statistical significance (p-values) and confidence intervals
- Learn basic probability theory
A/B Testing & Experimentation
Applying statistical rigor directly to business product decisions.
असली काम: Write a 1-page brief analyzing an A/B test for a website button color change. Include the p-value, the confidence interval, and a final bottom-line recommendation to the product team on whether to launch the change.
यह क्यों ज़रूरी है: A/B testing is the standard protocol for tech companies launching features. Being the analyst who can definitively say 'Yes, this worked' is highly valued.
चेकलिस्ट
- Design an experiment: hypothesis, null hypothesis, control vs variant
- Determine sample sizes statically before running the test
- Avoid common traps: peeking at data early, Simpson's Paradox
- Segment experimental data to find hidden behavioral insights
- Communicate the test result definitively to non-technical teams
Portfolio & Job Hunt 2 कदम
Building a Distinctive Portfolio
Proving you can analyze data end-to-end without your hand being held.
असली काम: Scrape or download a unique dataset (e.g., from a local government API). Clean it, throw it into Tableau, find three actionable insights, and write a Medium/LinkedIn article explaining your process.
यह क्यों ज़रूरी है: A hiring manager will look at your portfolio for 30 seconds. If it's the exact same project from a bootcamp tutorial, you get rejected.
चेकलिस्ट
- Select 2-3 datasets you actually care about (Sports, Finance, Gaming, Public Health)
- Do NOT use Titanic, Iris, or Housing Prices datasets (too cliché)
- Clean data in Python/SQL, analyze it, and build a Tableau/PowerBI dashboard
- Write a Markdown README on GitHub explaining the business problem and your findings
- Host visualizations publicly (Tableau Public / GitHub Pages)
The Technical & Case Interview Prep
Passing the gauntlet of recruiter screens, SQL whiteboard tests, and business case studies.
असली काम: Do a mock interview translating a technical SQL finding to a 'business manager' (played by a friend). They will ask 'So what?'. You must be able to abstract the code and answer with business impact.
यह क्यों ज़रूरी है: The technical interview ensures you aren't lying on your resume. The business sense interview ensures you actually understand how the company makes money.
चेकलिस्ट
- Practice live SQL coding on platforms like HackerRank or StrataScratch
- Prepare the STAR method for behavioral questions
- Translate resume bullets from 'Looked at data' to 'Increased metric X by Y% using Z'
- Practice business sense questions (e.g., 'Why might Uber's revenue drop on a Tuesday?')
- Send cold messages to analysts on LinkedIn for informal chats and referrals
Data Analyst के बारे में लोगों के सवाल
समय, ज़रूरी योग्यता, वेतन और पढ़ाई के तरीकों पर साफ़ जवाब।
Data Analyst बनने में कितना समय लगता है?
यह रोडमैप 5–9 months का अनुमान देता है। इसमें 5 चरण और 13 कदम हैं, “Excel & Spreadsheets” से “Portfolio & Job Hunt” तक।
Data Analyst कैसे बनें?
5 चरणों को क्रम से पू रा करें, पहले चरण “Excel & Spreadsheets” से शुरुआत करें। आपका पहला काम: Given a massive, unformatted raw export of sales data, use XLOOKUP and SUMIFS to create a summary table answering 'Total revenue per region'. Use IFERROR to catch missing regions gracefully.
Data Analyst कितना कमाते हैं?
वेतन देश पर निर्भर करता है। इस पेज का वेतन बॉक्स मेन्यू में चुने गए देश के लिए DraftMyCareer का अनुमान, वहाँ की मुद्रा में, दिखाता है।
शुरू करने से पहले मुझे क्या चाहिए?
यह रोडमैप बताता है: Comfort with spreadsheets; Basic math skills।
Data Analyst के लिए कौन-से कौशल चाहिए?
यह रोडमैप इन्हें सिखाता है: SQL, Excel, Python, Data Visualization, Statistics, Communication।
करियर बदलें: इस भूमिका में आने और यहाँ से आगे जाने के रास्ते
सारे बदलाव देखें →यहाँ से आगे बढ़ने और दूसरी भूमिकाओं में जाने के रास्ते
- Data Scientist
Transition from backward-looking reporting to forward-looking predictive modeling and algorithmic decision-making.
⏱ 4–7 months🧭 Moderateआप क्या सीखेंगेAdvanced Python (Scikit-Learn, SciPy) · Statistical Modeling & Probability · Machine Learning Algorithms
कदम-दर-कदम योजना देखें
- Month 1–2: Advanced Statistical Inference Master probability distributions, regression diagnostics, and experimental A/B testing.
- Month 3–4: Core Machine Learning Build predictive supervised and unsupervised models with feature selection in Python.
- Month 5–7: Real-world Modeling Projects Develop end-to-end churn prediction, recommendation systems, and model interpretability (SHAP).
- AI & ML Engineer
Step into the highest-growth tech domain building transformative AI agents and intelligent systems.
⏱ 6–9 months🧭 Challengingआप क्या सीखेंगेDeep Learning (PyTorch) · Natural Language Processing & LLMs · FastAPI & Microservices
कदम-दर-कदम योजना देखें
- Month 1–2: Software Engineering & Python Learn OOP, algorithms, asynchronous programming, and clean code principles.
- Month 3–4: Deep Learning Foundations Study neural network architectures, backpropagation, and PyTorch tensors.
- Month 5–7: LLM System Architecture Construct production RAG architectures, model fine-tuning, and semantic search APIs.
- Month 8+: MLOps & Deployment Automate model registry, tracking (MLflow), and inference pipelines on GPU clusters.
दूसरी नौकरियों से इस भूमिका में आना
- कहाँ से: Digital Marketer
Technical data analysts enjoy stronger job security, clear career advancement into data science, and analytical mastery.
⏱ 3–5 months🧭 Beginner-Friendlyक्या साथ जाता हैGoogle Analytics / GA4 · Conversion metrics & ROI analysis · Spreadsheet modeling
कदम-दर-कदम योजना देखें
- Month 1–2: Advanced SQL Mastery Practice complex aggregation, window functions, and subqueries on business datasets.
- Month 2–3: BI Visualization Dashboards Design automated executive dashboards tracking sales, retention, and funnel drop-off.
- Month 4–5: Python Data Wrangling Automate marketing data extraction via APIs and perform statistical correlations.