Skills/Data Analysis Fundamentals/Roadmap

1. Level 1: Beginner

   2 modules · 10 topics · about 1.5 hours of lessons

   1. Module 1: Data Kya Hai

      • Data analysis kya hota hai
      • Data analyst ka kaam kya hota hai
      • Data kahan se milta hai
      • Data ke types kya hote hain
      • Data analyst banne ke liye kya chahiye

   2. Module 2: Data Saaf Karna

      • Data cleaning kya hoti hai
      • Excel mein duplicate kaise hataayein
      • Missing value ko kaise handle karein
      • Data ko sahi format mein kaise laayein
      • Text to column kaise use karein

   After this level you canDraft — being reviewed

   • Explain what data analysis is and what a data analyst does
   • Identify where data comes from and its types
   • Explain what data cleaning is
   • Remove duplicates and handle missing values in Excel
   • Fix data formats and split text with Text to Columns

2. Level 2: Elementary

   2 modules · 9 topics · about 2 hours of lessons

   1. Module 3: Excel Se Analysis

      • Pivot table kaise banayein
      • VLOOKUP kaise use karein
      • Excel mein conditional formatting kaise lagayein
      • Excel mein data summarise kaise karein
      • Excel dashboard kaise banayein

   2. Module 4: Number Samajhna

      • Average median aur mode kya hote hain
      • Percentage aur growth kaise nikalein
      • Data mein trend kaise dekhein
      • Correlation kya hota hai

   After this level you canDraft — being reviewed

   • Build a pivot table
   • Use VLOOKUP
   • Apply conditional formatting and summarise data in Excel
   • Build a simple Excel dashboard
   • Calculate average, median, mode, percentages and growth
   • Spot trends and explain correlation

3. Level 3: Intermediate

   2 modules · 9 topics · about 2 hours of lessons

   1. Module 5: Chart Banana

      • Kaunsa chart kab use karein
      • Bar aur line chart kaise banayein
      • Pie chart kab galat hota hai
      • Chart ko saaf kaise banayein
      • Dashboard mein kya dikhana chahiye

   2. Module 6: Sawaal Poochhna

      • Data se sawaal kaise poochhein
      • Business problem ko data mein kaise badlein
      • Data se galat conclusion se kaise bachein
      • Findings kaise present karein

   After this level you canDraft — being reviewed

   • Choose the right chart for a question
   • Build clean bar and line charts and avoid misleading pie charts
   • Decide what a dashboard should show
   • Turn a business problem into a data question
   • Avoid wrong conclusions from data
   • Present findings clearly

4. Level 4: Advanced

   1 module · 5 topics · about 1 hour of lessons

   1. Module 7: Aage Ke Tools

      • Power BI kya hai aur kyun seekhein
      • Data analyst ke liye SQL kyun zaroori hai
      • Python se data analysis kaise shuru karein
      • Data analyst ka portfolio kaise banayein
      • Data analyst interview mein kya poochha jata hai

   After this level you canDraft — being reviewed

   • Explain what Power BI is and why to learn it
   • Explain why SQL matters for analysts
   • Describe how to start data analysis in Python
   • Plan a data analyst portfolio
   • Prepare for common data analyst interview questions

Lesson times are the lengths of the chosen video lessons, added up per level; practice and revision take longer. Learn at your own pace.