Data & Operations
Data Analytics (Excel, SQL & Power BI)
Online4 months · 10 hrs/week
No feeThe listing, in plain words
Plain-language summary written by rules from the listing text; check the original wording
What you'll learn
You would finish able to: Clean and model data with advanced Excel functions (3 more listed)
From the listing “Clean and model data with advanced Excel functions”
Fee
Free: no fee to take this course
From the listing “Free”
Where & when
Online · runs 4 months · 10 hrs/week · start any time, self-paced
From the listing “4 months · 10 hrs/week”
Who it's for
Beginner level · no prerequisites listed
Read from the listing's details, not a sentence in it.
Also
Certificate: NSQF Level 4 — Data Analytics Associate · placement help offered
From the listing “NSQF Level 4 — Data Analytics Associate”
At a glance
- Fee
- Free
- Starts
- Start any time — self-paced
- Seats
- No seat limit
- Duration
- 4 months · 10 hrs/week
- Time per week
- ~10 hours
- Mode
- Online
- Where
- Anywhere with internet
- Language
- Course text follows your language setting; videos as recorded
- Before you start
- Nothing — this starts from zero
- You will need
- A phone or computer with internet
- Certificate
- Issued by Tech Mahindra SMART AcademyNSQF Level 4 — Data Analytics AssociateCarries a serial anyone can check on the verify page, no account needed.
- Assessment
- A final assessment. The certificate is issued on passing it — not on reaching the last lesson.
- Placement support
- Yes — the institute helps with openings after you finish
- Payment & refunds
- No payment is taken on स्वYAM. A paid course is settled with the institute directly, and its refund terms apply — ask before you pay.
Overview
The three tools most analyst job descriptions actually ask for. Clean messy data in Excel, query it properly in SQL, and build dashboards in Power BI that someone will use every morning.
What you'll learn
- Clean and model data with advanced Excel functions
- Write SQL joins, aggregations and window functions
- Build interactive Power BI dashboards
- Present findings to a non-technical audience
Curriculum
Hands-on projects
A sales performance dashboard
A SQL analysis of delivery delays
A cleaned survey dataset
Campus & labs
Your trainer
Vikram Desai
Analytics lead who has built reporting for retail and logistics operations teams.
Questions people ask
How do I enrol?
Press Enrol. A free course opens straight away. A paid one is settled with the institute — press Enrol, then arrange the fee with them directly.
Is the certificate real?
Every certificate carries a serial. Anyone can type it into the verify page and see the course, the assessment passed and the date — no account needed. It is issued by Tech Mahindra SMART Academy.
Can I do it in my language?
The interface and the course text follow the language you choose in Settings — 23 languages. Videos play as they were recorded.
What if I cannot pay?
Half the catalogue is free. Points earned by finishing lessons, passing assessments and teaching on SkillSwap turn into discounts, up to a paid course for nothing.
Do I need to be online?
For the lessons, yes. Every video has a text version for slow data.