What you will be able to doTum kya kar paoge
You will turn a business question into a data question, find the answer with Excel/Sheets and SQL, and present it with a clean dashboard and a 3-line insight.Business ke sawaal ko data ke sawaal mein badal paoge, Excel/Sheets aur SQL se jawab nikaal paoge, aur ek saaf dashboard aur 3 line ki insight ke saath present kar paoge.
Final projectFinal project
A full analysis of 3 months of an online shop's orders: SQL queries, a Looker Studio dashboard and a one-page report you can put in your portfolio.Ek online dukaan ke 3 mahine ke orders se poora analysis: SQL queries, ek Looker Studio dashboard aur ek page ki report, jo portfolio mein laga sako.
Course curriculumCourse mein kya hai
Every lesson has steps, an example, common mistakes, a practice task, a short quiz and a cheat sheet.Har lesson mein steps, example, aam galtiyan, practice task, chhota quiz aur cheat sheet.
Module 1: The analyst mindsetModule 1: Analyst ki soch
- What a data analyst really doesData analyst asal mein kya karta hai · 20 minFreeFree
- The right question and the right KPISahi sawaal aur sahi KPI · 25 min
- Understand your data: types, mistakes and a data dictionaryData ko samjho: types, galtiyan aur data dictionary · 25 min
Module 2: Analysis with Excel / SheetsModule 2: Excel / Sheets se analysis
- Total, average, median and growth %Total, average, median aur growth % · 30 min
- Business questions with pivotsPivot se business ke sawaal · 30 min
- Joining two tables: XLOOKUP and the idea of a "key"Do tables jodna: XLOOKUP aur "key" ka idea · 25 min
Module 3: SQLModule 3: SQL
- Starting SQL: SELECT, WHERE, ORDER BYSQL shuru: SELECT, WHERE, ORDER BY · 35 min
- GROUP BY, COUNT, SUM and HAVINGGROUP BY, COUNT, SUM aur HAVING · 35 min
- JOIN: two tables togetherJOIN: do tables ek saath · 35 min
Module 4: Dashboard and projectModule 4: Dashboard aur project
- A free dashboard in Looker StudioLooker Studio mein free dashboard · 35 min
- Writing and presenting insightsInsight likhna aur present karna · 25 min
- Final project and portfolioFinal project aur portfolio · 40 min
This course comes with the full AI kitIs course ke saath poori AI kit
- All 34 courses, in Hinglish and EnglishSaare 34 courses, Hinglish aur English mein
- Your personal plan: tools and prompts picked for your field and goalTumhara personal plan: field aur goal ke hisaab se tools aur prompts
- AI tutor, practice lab and mentor while you learnSeekhte waqt AI tutor, practice lab aur mentor
- 30-day challenge and verifiable certificates30-day challenge aur verify hone wale certificates
- No subscription. Try the first lesson free before you pay.Koi subscription nahi. Pay se pehle pehla lesson free try karo.
₹1999 ₹199 one-time · 90% off₹1999 ₹199 ek baar · 90% off
Questions about this courseIs course ke baare mein sawaal
Is the Data analysis course free?Kya Data analysis course free hai?
The first lesson is free after a short test (just your mobile number). The full course opens with the AI kit: a one-time ₹199 that opens all 34 courses. No subscription.Chhota test dene ke baad pehla lesson free hai (sirf mobile number chahiye). Poora course AI kit se khulta hai: ek baar ke ₹199 mein saare 34 courses. Koi subscription nahi.
Which language is it in?Kis bhasha mein hai?
Hinglish and English. Switch any time; every lesson exists in both.Hinglish aur English dono mein. Kabhi bhi badlo; har lesson dono mein hai.
How long does it take?Kitna time lagega?
12 lessons of 20-30 minutes, about 30 hours in all. One lesson a day finishes it in about 12 days.12 lessons, har ek 20-30 minute ka, kul lagbhag 30 ghante. Roz ek lesson karo toh lagbhag 12 din mein poora.
Do I get a certificate?Certificate milega?
Yes. Finish every lesson and you get a certificate with your name and a public verify link you can add to LinkedIn. It is not a government or university degree.Haan. Saare lessons poore karo, tumhare naam ka certificate milega jiska public verify link LinkedIn pe laga sakte ho. Ye sarkari ya university degree nahi hai.
Is a job or income guaranteed?Job ya kamai ki guarantee hai?
No. The course teaches the skill and makes you practise; results depend on your effort and the market.Nahi. Course skill sikhata hai aur practice karwata hai; nateeja tumhari mehnat aur market pe depend karta hai.
Related coursesIsse jude courses
Formulas, tables and reports every office usesFormulas, tables aur reports jo har office mein chalte hain
12 lessons · ~12 hoursghante →Build websites with codeCode se website bananaHTML, CSS and JavaScript from zero to a live siteHTML, CSS aur JavaScript, zero se live website tak
12 lessons · ~40 hoursghante →Digital marketingDigital marketingAds, SEO and social media that bring customersAds, SEO aur social media jo customers laaye
12 lessons · ~20 hoursghante →SEO: rank on GoogleSEO: Google pe rank karoKeywords, on-page, Search Console and local SEO that bring customers from GoogleKeywords, on-page, Search Console aur local SEO jo Google se customers laaye
12 lessons · ~12 hoursghante →Start with the free lessonFree lesson se shuru karo
Take the 5-minute test, then open the first lesson free. Your personal AI kit comes with it.5 minute ka test do, phir pehla lesson free kholo. Saath mein tumhari personal AI kit.