{"id":3006,"date":"2026-10-27T16:50:59","date_gmt":"2026-10-27T16:50:59","guid":{"rendered":"https:\/\/dssd.in\/blogs\/?p=3006"},"modified":"2026-10-27T16:51:00","modified_gmt":"2026-10-27T16:51:00","slug":"data-analyst-roadmap","status":"publish","type":"post","link":"https:\/\/dssd.in\/blogs\/data-analyst-roadmap\/","title":{"rendered":"Excel to Power BI Roadmap 2027: Become a Data Analyst in 6 Months"},"content":{"rendered":"<p>Six months is enough to go from spreadsheet basics to a job-ready analyst portfolio \u2014 if you learn the tools in the right order. Most data analyst roadmap guides hand you a random list of ten tools and wish you luck. This one follows one deliberate arc \u2014 <strong>Excel \u2192 SQL \u2192 Power BI \u2192 Python basics<\/strong> \u2014 and tells you what to learn each month, what to build with it, and how to know when you&#8217;re done with each one. It assumes roughly 2\u20134 focused hours a day, and is honest about what six months cannot do. Still deciding whether the field fits you? Read our take on <a href=\"https:\/\/dssd.in\/blogs\/is-data-analytics-a-good-career\/\">whether data analytics is a good career<\/a>, then come back here.<\/p>\n<h2>Why This Order Works: Excel First, Power BI Before Deep Python<\/h2>\n<p><strong>Excel comes first<\/strong> because it is where analyst work \u2014 and analyst interviews \u2014 actually start. Almost every company in India still runs reports on spreadsheets, and Excel teaches you data thinking (rows, columns, logic, summaries) with zero setup. <strong>SQL comes second<\/strong> because real company data does not live in files someone emails you; it lives in databases, and analysts are expected to pull it themselves. <strong>Power BI comes before serious Python<\/strong> because Indian entry-level roles are dashboard-heavy: a polished, shareable dashboard is visible proof of skill you can show in an interview within four months. <strong>Python is a growth skill, not a gatekeeper<\/strong> \u2014 it makes you faster and opens better roles later, but no fresher should delay applying until their Python is &#8220;ready&#8221;.<\/p>\n<h2>Month 1: Excel \u2014 Learn to Think in Data<\/h2>\n<p>Your only goal this month is fluency: clean, summarise and chart any raw table without hesitation.<\/p>\n<ul>\n<li>Core formulas: SUMIFS, COUNTIFS, AVERAGEIFS, IF and nested IFs<\/li>\n<li>Lookups: XLOOKUP, VLOOKUP, INDEX + MATCH<\/li>\n<li>Pivot tables and pivot charts \u2014 the single most-used analyst feature<\/li>\n<li>Conditional formatting, data validation, filters, text and date functions<\/li>\n<li>Power Query basics: importing and cleaning a messy file<\/li>\n<\/ul>\n<p><strong>Project:<\/strong> Download a messy sales dataset from Kaggle, clean it in Excel, and build a monthly sales report with pivot tables and charts \u2014 totals by region, product and month.<\/p>\n<p><strong>Free practice:<\/strong> Microsoft Learn&#8217;s free Excel modules, Kaggle datasets for raw material, and YouTube walkthroughs for pivot tables and XLOOKUP.<\/p>\n<p><strong>Done looks like:<\/strong> You can take an unfamiliar spreadsheet and produce a correct summary table and chart in under 30 minutes.<\/p>\n<h2>Month 2: SQL \u2014 Pull Your Own Data<\/h2>\n<p>SQL separates analysts from report-formatters. Learn it in this sequence, typing every query yourself:<\/p>\n<ul>\n<li>SELECT, FROM, WHERE, ORDER BY, LIMIT \u2014 reading data<\/li>\n<li>COUNT, SUM, AVG with GROUP BY and HAVING \u2014 summarising data<\/li>\n<li>Joins: INNER, LEFT, RIGHT \u2014 combining tables (the most-tested interview topic)<\/li>\n<li>Subqueries and CTEs (WITH clauses) \u2014 structuring bigger questions<\/li>\n<li>Window functions: ROW_NUMBER, RANK, running totals<\/li>\n<li>CASE statements and basic date\/string functions<\/li>\n<\/ul>\n<p><strong>Project:<\/strong> Take an e-commerce dataset, load it into MySQL or PostgreSQL, and write 10+ queries answering real business questions \u2014 top customers, monthly revenue trend, repeat-purchase rate, best-selling categories.<\/p>\n<p><strong>Free practice:<\/strong> SQLZoo&#8217;s interactive tutorials, HackerRank&#8217;s free SQL track, and LeetCode&#8217;s database problems once basics are solid.<\/p>\n<p><strong>Done looks like:<\/strong> You can write a join with a GROUP BY and a CASE statement from memory, and explain what each line does.<\/p>\n<h2>Month 3: Data Cleaning, Statistics Basics, and Level-2 Skills<\/h2>\n<p>Real data is dirty, and this month teaches you to handle it \u2014 plus the small set of statistics analysts actually use every week.<\/p>\n<ul>\n<li>Cleaning: duplicates, missing values, inconsistent formats, outliers, typos in categories<\/li>\n<li>Statistics that matter: mean vs median, percentages and percentage change, standard deviation in plain words, correlation vs causation, percentiles<\/li>\n<li>Level-2 Excel\/SQL: combining sources, cleaning directly inside SQL queries, documenting your steps<\/li>\n<\/ul>\n<p><strong>Project:<\/strong> Pick a deliberately messy public dataset, clean it end to end, and write a one-page findings note: what was wrong with the data, what you fixed, and three insights the cleaned data reveals.<\/p>\n<p><strong>Free practice:<\/strong> Kaggle datasets (many are intentionally messy), and Khan Academy&#8217;s free introductory statistics lessons for the concepts above.<\/p>\n<p><strong>Done looks like:<\/strong> You can explain correlation vs causation with a real example, and your cleaning steps are documented well enough for someone else to repeat them.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/dssd.in\/blogs\/wp-content\/uploads\/2026\/10\/blog2-img1-7.jpg\" alt=\"Data analyst roadmap for six months - Excel and SQL first, then Power BI, Python and job preparation\" width=\"700\" height=\"466\"><\/p>\n<h2>Month 4: Power BI \u2014 Build Dashboards That Get You Interviewed<\/h2>\n<p>Power BI now gets its own full month, because this is the skill your portfolio will be judged on. Work through it in layers: Power Query for cleaning inside Power BI, data modelling (table relationships, the idea of a star schema), charts and slicers, then DAX basics \u2014 measures with SUM, AVERAGE and CALCULATE \u2014 and finally publishing to the Power BI Service so you can share a link.<\/p>\n<p>Power BI or Tableau first? For beginners in India, Power BI is the pragmatic first choice: it is free to learn, built on Excel-like logic, and asked for constantly in entry-level postings. Our <a href=\"https:\/\/dssd.in\/blogs\/power-bi-vs-tableau\/\">Power BI vs Tableau guide<\/a> compares the two in depth.<\/p>\n<p><strong>Project:<\/strong> Build an interactive sales dashboard on real data \u2014 KPI cards, a trend chart, slicers for region and category, and a drill-down page. Publish it and keep the shareable link.<\/p>\n<p><strong>Free practice:<\/strong> Microsoft Learn&#8217;s free Power BI learning path, the free Power BI Desktop app, and sample datasets from Kaggle.<\/p>\n<p><strong>Done looks like:<\/strong> A published dashboard link you can open in an interview, with at least ten DAX measures you wrote yourself.<\/p>\n<h2>Month 5: Python Basics for Analysts \u2014 Plus Bigger Projects<\/h2>\n<p>Now Python, kept strictly to what analysts use: Jupyter notebooks, loading CSVs with pandas, filtering, merging and grouping data, handling missing values, and charting with matplotlib or seaborn. Deliberately skip machine-learning frameworks and web-scraping deep-dives this month \u2014 they are later skills, and chasing them now is the most common way beginners stall.<\/p>\n<p><strong>Project:<\/strong> An exploratory analysis notebook on a Kaggle dataset: clean it in pandas, produce five or six charts, and write the insight under each chart in plain language. Then redo one of your Month 1 Excel analyses in pandas to feel the difference.<\/p>\n<p><strong>Free practice:<\/strong> Kaggle Learn&#8217;s free pandas and data-visualisation micro-courses, and the official pandas documentation&#8217;s beginner tutorials.<\/p>\n<p><strong>Done looks like:<\/strong> You can load, clean, group and chart a new dataset in a notebook without copying old code line by line.<\/p>\n<h2>Month 6: Portfolio Polish, Applications and Interview Prep<\/h2>\n<p>The learning phase ends; the proving phase begins. Polish your best three or four projects \u2014 not ten half-finished ones \u2014 and give each a short write-up: the business question, the data source, your cleaning steps, the findings and your recommendation. Put the SQL project, the Power BI dashboard and the Python notebook where recruiters can see them, update your resume and LinkedIn around them, and start applying \u2014 on Naukri and LinkedIn, and to internships and MIS\/reporting-analyst titles as well as &#8220;data analyst&#8221; ones, since those are common first steps in Delhi NCR. Our breakdown of <a href=\"https:\/\/dssd.in\/blogs\/data-analyst-jobs-in-delhi\/\">data analyst jobs in Delhi<\/a> shows what local employers actually ask for. Spend the remaining time on interview practice: timed SQL problems, Excel tests, and explaining your own projects out loud.<\/p>\n<p><strong>Done looks like:<\/strong> A live portfolio with at least three complete projects, weekly applications going out, and the ability to solve medium-level SQL problems under time pressure.<\/p>\n<h2>The 6-Month Data Analyst Roadmap at a Glance<\/h2>\n<table>\n<thead>\n<tr>\n<th>Month<\/th>\n<th>Focus<\/th>\n<th>Key Skills<\/th>\n<th>Project<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Excel<\/td>\n<td>Formulas, lookups, pivot tables, Power Query<\/td>\n<td>Monthly sales report from a messy Kaggle dataset<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>SQL<\/td>\n<td>Joins, GROUP BY, CTEs, window functions<\/td>\n<td>10+ queries answering e-commerce business questions<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Cleaning + Statistics<\/td>\n<td>Messy-data handling, mean\/median, correlation, outliers<\/td>\n<td>End-to-end cleaning with a one-page findings note<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Power BI<\/td>\n<td>Modelling, DAX basics, slicers, publishing<\/td>\n<td>Interactive sales dashboard with a shareable link<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Python Basics<\/td>\n<td>pandas, Jupyter, matplotlib\/seaborn<\/td>\n<td>Exploratory analysis notebook with written insights<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Portfolio + Job Prep<\/td>\n<td>Project write-ups, resume, interview practice<\/td>\n<td>Polished portfolio of 3\u20134 complete projects<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>DSSD Value Pick: The Same Roadmap, With a Mentor Watching<\/h2>\n<p>Everything above can be self-learned for free \u2014 and we mean that. What the free route cannot give you is feedback. Most self-learners stall in Month 2 or Month 4: an SQL join that almost works, a Power BI model giving wrong totals, and nobody to show them why. If you would rather follow this exact Excel \u2192 SQL \u2192 Power BI arc in a classroom, DSSD&#8217;s Data Analytics course in Rohini is built on the same sequence, with live projects, mentor review and job assistance at the end \u2014 see our <a href=\"https:\/\/dssd.in\/blogs\/data-analytics-course-in-delhi\/\">Data Analytics course in Delhi<\/a> page for what the program covers, and contact DSSD for the current fee and batch schedule. Whichever route you choose \u2014 self-study, a structured platform such as <a href=\"https:\/\/cuetacademy.online\/\" target=\"_blank\" rel=\"noopener\">CUET Academy<\/a>, or a classroom course \u2014 the roadmap itself stays the same.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/dssd.in\/blogs\/wp-content\/uploads\/2026\/10\/blog2-img2-7.jpg\" alt=\"Why the Excel to SQL to Power BI order works for data analyst beginners\" width=\"700\" height=\"466\"><\/p>\n<h2>An Honest Note: What 6 Months Can and Cannot Do<\/h2>\n<p>Six months will not make you a senior analyst, a machine-learning engineer or a data scientist, and any roadmap promising that is selling, not teaching. What six months can do \u2014 with daily, hands-on practice \u2014 is take you from zero to a portfolio that credibly qualifies you for entry-level analyst, MIS analyst and reporting roles, and to interviews where you can defend your work with confidence. If you are starting with zero Excel experience, aim for closer to eight months rather than six; if you already use spreadsheets daily, you may finish the tool arc in four and spend two on projects. The roadmap is a pace, not a deadline, and a slower finish with solid projects beats a fast finish with none.<\/p>\n<h2>Bottom Line<\/h2>\n<p>Follow the order \u2014 Excel first, then SQL, then Power BI, with Python basics at the end \u2014 build one project per month, and finish with a small, polished portfolio. That is the whole plan. The hardest part is not choosing tools; it is sitting down every day and doing the work.<\/p>\n<h2>Frequently Asked Questions<\/h2>\n<div class=\"faq-accordion\">\n<div class=\"faq-item\"><button class=\"faq-question\">Can I really become a data analyst in 6 months?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Yes \u2014 for entry-level roles, with consistent daily practice and a portfolio of complete projects. Six months will not make you senior, but it is enough to qualify for fresher and junior analyst positions.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">How many hours a day should I study for this roadmap?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Two to four focused hours a day is realistic for most learners. What matters more than the number is consistency \u2014 daily practice beats weekend marathons.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">Should I learn Excel or SQL first?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Excel first. It teaches data thinking with no setup, and it is still the tool most companies use for reporting. SQL follows naturally once you understand tables, filtering and summarising.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">Is Python necessary to become a data analyst?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Not for entry-level roles. Excel, SQL and Power BI are enough to start. Python is a growth skill that opens better roles later, so learn the basics after your dashboard skills are solid.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">Power BI or Tableau \u2014 which should a beginner learn first?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Power BI, for most beginners in India: it is free to learn, builds on Excel logic, and is asked for constantly in entry-level postings. Tableau is worth adding later if target roles ask for it.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">Do I need strong maths or statistics for data analytics?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>No advanced maths. You need percentages, averages, medians, percentage change and a plain-language understanding of correlation and variation \u2014 all covered in Month 3 of this roadmap.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">What are the best free resources to follow this roadmap?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Microsoft Learn (Excel and Power BI), Kaggle Learn (SQL and pandas), SQLZoo and HackerRank for SQL practice, and Kaggle datasets for every project. All are free.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">What projects should a fresher data analyst build?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>A cleaned Excel sales report, ten or more SQL queries on an e-commerce dataset, a published Power BI dashboard, and a Python exploratory-analysis notebook \u2014 three or four complete projects beat ten half-finished ones.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">I am a working professional. Can I follow this roadmap?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Yes \u2014 it is written for 2\u20134 hours a day, so most working professionals can follow it. Expect it to take closer to eight months if your weekdays are tight; the order of tools does not change.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">Do I need a certificate to get a data analyst job?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>No. Employers hire on portfolio and interview performance: a dashboard link, SQL answers and a project you can explain matter far more than a certificate. Certificates help structure learning, but they do not replace projects.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">Which job titles should freshers apply for besides data analyst?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>MIS analyst, reporting analyst, business analyst (junior), data associate and operations analyst. These roles overlap heavily with entry-level data analysis and are common first steps.<\/p>\n<\/div>\n<\/div>\n<div class=\"faq-item\"><button class=\"faq-question\">Can I follow this roadmap while in college or right after Class 12?<span class=\"faq-icon\">+<\/span><\/button><\/p>\n<div class=\"faq-answer\">\n<p>Yes. Starting in college or right after Class 12 is an advantage \u2014 you graduate with a portfolio. Just make sure your projects are complete and documented, since you will not yet have work experience to lean on.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><script>document.addEventListener('DOMContentLoaded',function(){document.querySelectorAll('.faq-question').forEach(function(btn){btn.addEventListener('click',function(){var ans=this.nextElementSibling;var icon=this.querySelector('.faq-icon');var open=ans.style.display==='block';document.querySelectorAll('.faq-answer').forEach(function(a){a.style.display='none';});document.querySelectorAll('.faq-icon').forEach(function(i){i.textContent='+';});ans.style.display=open?'none':'block';if(icon)icon.textContent=open?'+':'\u2212';});});});<\/script><script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"Can I really become a data analyst in 6 months?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes \u2014 for entry-level roles, with consistent daily practice and a portfolio of complete projects.\"}},{\"@type\":\"Question\",\"name\":\"How many hours a day should I study for this roadmap?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Two to four focused hours a day is realistic for most learners.\"}},{\"@type\":\"Question\",\"name\":\"Should I learn Excel or SQL first?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Excel first. It teaches data thinking with no setup.\"}},{\"@type\":\"Question\",\"name\":\"Is Python necessary to become a data analyst?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Not for entry-level roles. Excel, SQL and Power BI are enough to start.\"}},{\"@type\":\"Question\",\"name\":\"Power BI or Tableau \u2014 which should a beginner learn first?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Power BI, for most beginners in India.\"}},{\"@type\":\"Question\",\"name\":\"Do I need strong maths or statistics for data analytics?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No advanced maths. Percentages, averages, medians and percentage change are enough to start.\"}},{\"@type\":\"Question\",\"name\":\"What are the best free resources to follow this roadmap?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Microsoft Learn, Kaggle Learn, SQLZoo and HackerRank \u2014 all free.\"}},{\"@type\":\"Question\",\"name\":\"What projects should a fresher data analyst build?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"A cleaned Excel sales report, SQL queries, a published Power BI dashboard and a Python notebook.\"}},{\"@type\":\"Question\",\"name\":\"I am a working professional. Can I follow this roadmap?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes \u2014 it is written for 2\u20134 hours a day.\"}},{\"@type\":\"Question\",\"name\":\"Do I need a certificate to get a data analyst job?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"No. Employers hire on portfolio and interview performance.\"}},{\"@type\":\"Question\",\"name\":\"Which job titles should freshers apply for besides data analyst?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"MIS analyst, reporting analyst, junior business analyst, data associate and operations analyst.\"}},{\"@type\":\"Question\",\"name\":\"Can I follow this roadmap while in college or right after Class 12?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes. Starting early is an advantage if your projects are complete and documented.\"}}]}<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Six months is enough to go from spreadsheet basics to a job-ready analyst portfolio \u2014 if you learn the tools in the right order. Most data analyst roadmap guides hand you a random list of ten tools and wish you luck. This one follows one deliberate arc \u2014 Excel \u2192 SQL \u2192 Power BI \u2192 Python basics \u2014 and tells you what to learn each month, what to build with it, and how to know when you&#8217;re done with each one. It assumes roughly 2\u20134 focused hours a day, and is honest about what six months cannot do. Still deciding whether the field fits you? Read our take on whether data analytics is a good career, then come back here. Why This Order Works: Excel First, Power BI Before Deep Python Excel comes first because it is where analyst work \u2014 and analyst interviews \u2014 actually start. Almost every company in India still runs reports on spreadsheets, and Excel teaches you data thinking (rows, columns, logic, summaries) with zero setup. SQL comes second because real company data does not live in files someone emails you; it lives in databases, and analysts are expected to pull it themselves. Power BI comes before serious Python because Indian entry-level roles are dashboard-heavy: a polished, shareable dashboard is visible proof of skill you can show in an interview within four months. Python is a growth skill, not a gatekeeper \u2014 it makes you faster and opens better roles later, but no fresher should delay applying until their Python is &#8220;ready&#8221;. Month 1: Excel \u2014 Learn to Think in Data Your only goal this month is fluency: clean, summarise and chart any raw table without hesitation. Core formulas: SUMIFS, COUNTIFS, AVERAGEIFS, IF and nested IFs Lookups: XLOOKUP, VLOOKUP, INDEX + MATCH Pivot tables and pivot charts \u2014 the single most-used analyst feature Conditional formatting, data validation, filters, text and date functions Power Query basics: importing and cleaning a messy file Project: Download a messy sales dataset from Kaggle, clean it in Excel, and build a monthly sales report with pivot tables and charts \u2014 totals by region, product and month. Free practice: Microsoft Learn&#8217;s free Excel modules, Kaggle datasets for raw material, and YouTube walkthroughs for pivot tables and XLOOKUP. Done looks like: You can take an unfamiliar spreadsheet and produce a correct summary table and chart in under 30 minutes. Month 2: SQL \u2014 Pull Your Own Data SQL separates analysts from report-formatters. Learn it in this sequence, typing every query yourself: SELECT, FROM, WHERE, ORDER BY, LIMIT \u2014 reading data COUNT, SUM, AVG with GROUP BY and HAVING \u2014 summarising data Joins: INNER, LEFT, RIGHT \u2014 combining tables (the most-tested interview topic) Subqueries and CTEs (WITH clauses) \u2014 structuring bigger questions Window functions: ROW_NUMBER, RANK, running totals CASE statements and basic date\/string functions Project: Take an e-commerce dataset, load it into MySQL or PostgreSQL, and write 10+ queries answering real business questions \u2014 top customers, monthly revenue trend, repeat-purchase rate, best-selling categories. Free practice: SQLZoo&#8217;s interactive tutorials, HackerRank&#8217;s free SQL track, and LeetCode&#8217;s database problems once basics are solid. Done looks like: You can write a join with a GROUP BY and a CASE statement from memory, and explain what each line does. Month 3: Data Cleaning, Statistics Basics, and Level-2 Skills Real data is dirty, and this month teaches you to handle it \u2014 plus the small set of statistics analysts actually use every week. Cleaning: duplicates, missing values, inconsistent formats, outliers, typos in categories Statistics that matter: mean vs median, percentages and percentage change, standard deviation in plain words, correlation vs causation, percentiles Level-2 Excel\/SQL: combining sources, cleaning directly inside SQL queries, documenting your steps Project: Pick a deliberately messy public dataset, clean it end to end, and write a one-page findings note: what was wrong with the data, what you fixed, and three insights the cleaned data reveals. Free practice: Kaggle datasets (many are intentionally messy), and Khan Academy&#8217;s free introductory statistics lessons for the concepts above. Done looks like: You can explain correlation vs causation with a real example, and your cleaning steps are documented well enough for someone else to repeat them. Month 4: Power BI \u2014 Build Dashboards That Get You Interviewed Power BI now gets its own full month, because this is the skill your portfolio will be judged on. Work through it in layers: Power Query for cleaning inside Power BI, data modelling (table relationships, the idea of a star schema), charts and slicers, then DAX basics \u2014 measures with SUM, AVERAGE and CALCULATE \u2014 and finally publishing to the Power BI Service so you can share a link. Power BI or Tableau first? For beginners in India, Power BI is the pragmatic first choice: it is free to learn, built on Excel-like logic, and asked for constantly in entry-level postings. Our Power BI vs Tableau guide compares the two in depth. Project: Build an interactive sales dashboard on real data \u2014 KPI cards, a trend chart, slicers for region and category, and a drill-down page. Publish it and keep the shareable link. Free practice: Microsoft Learn&#8217;s free Power BI learning path, the free Power BI Desktop app, and sample datasets from Kaggle. Done looks like: A published dashboard link you can open in an interview, with at least ten DAX measures you wrote yourself. Month 5: Python Basics for Analysts \u2014 Plus Bigger Projects Now Python, kept strictly to what analysts use: Jupyter notebooks, loading CSVs with pandas, filtering, merging and grouping data, handling missing values, and charting with matplotlib or seaborn. Deliberately skip machine-learning frameworks and web-scraping deep-dives this month \u2014 they are later skills, and chasing them now is the most common way beginners stall. Project: An exploratory analysis notebook on a Kaggle dataset: clean it in pandas, produce five or six charts, and write the insight under each chart in plain language. Then redo one of your Month 1 Excel analyses in pandas to feel the difference. Free practice: Kaggle<\/p>\n","protected":false},"author":15,"featured_media":3007,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","_templately_pack_id":"","_templately_imported_at":"","_templately_source":"","_templately_import_session_id":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-3006","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"_links":{"self":[{"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/posts\/3006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/comments?post=3006"}],"version-history":[{"count":1,"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/posts\/3006\/revisions"}],"predecessor-version":[{"id":3009,"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/posts\/3006\/revisions\/3009"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/media\/3007"}],"wp:attachment":[{"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/media?parent=3006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/categories?post=3006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dssd.in\/blogs\/wp-json\/wp\/v2\/tags?post=3006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}