Home/Courses/AI & GenAI
AI & GenAI · New program

Data Analytics with AIData analytics course in Chennai · classroom & live online

Become a job-ready data analyst with Excel, SQL, Power BI, Python and AI assistants.

12 WeeksBeginnerProgramClassroom + Online⚡ Fast-track available
Request syllabus →Interview prep →
7modules
34lessons
7hands-on labs
60hours

What you'll learn in this Data analytics course

Analyse data quickly in Excel
Query and analyse data confidently with SQL
Draw sound conclusions from data
Build interactive dashboards decision-makers use
Clean, analyse and visualise data with Python
Use AI assistants to analyse data faster, safely
Present your skills confidently to employers

Who this Data analytics course is for

🎓

Students & fresh graduates

Start a tech career with skills employers ask for.

🔁

Career switchers

No prior experience needed: we start from zero.

💼

Working professionals

Add an in-demand skill alongside your job.

✓ Basic computer skills✓ No prior experience needed✓ Curiosity and regular practice

Data analytics course for beginners: it starts from the fundamentals and builds up step by step, with a mentor guiding you.

What you'll build

Data analytics course syllabus

7 modules · 34 lessons · 7 major labs · 60 hours

01

Excel for analysis

5 lessons · 1 lab
8 hrs+
  1. Formulas and functions
  2. Lookups (XLOOKUP)
  3. Pivot tables
  4. Charts
  5. Power Query
HANDS-ON LAB

Monthly sales report built from raw data

02

SQL essentials

5 lessons · 1 lab
10 hrs+
  1. SELECT, filtering and sorting
  2. Joins across tables
  3. Aggregations and GROUP BY
  4. Subqueries and CTEs
  5. Window functions
HANDS-ON LAB

Answer 20 business questions from a sales database

03

Statistics for data

5 lessons · 1 lab
8 hrs+
  1. Descriptive statistics
  2. Probability and distributions
  3. Sampling
  4. Hypothesis testing
  5. A/B testing
HANDS-ON LAB

Analyse an A/B test and make a recommendation

04

Power BI & Microsoft Fabric

6 lessons · 1 lab
12 hrs+
  1. Power Query
  2. Data modelling
  3. DAX measures
  4. Visual storytelling
  5. Fabric lakehouse basics
  6. Publishing and sharing
HANDS-ON LAB

Executive dashboard for a retail business

05

Python for data analysis

5 lessons · 1 lab
10 hrs+
  1. NumPy
  2. pandas
  3. Data cleaning
  4. Visualisation with matplotlib and seaborn
  5. Jupyter notebooks
HANDS-ON LAB

Exploratory analysis on a real dataset

06

AI for data analysis

4 lessons · 1 lab
6 hrs+
  1. ChatGPT, Claude and Copilot for analysis
  2. Asking data questions in plain English
  3. Automating reports with AI
  4. Checking AI output for accuracy
HANDS-ON LAB

AI-assisted insight report, fact-checked

07

Career launch

4 lessons · 1 lab
6 hrs+
  1. Resume and LinkedIn that get shortlisted
  2. Building your project portfolio
  3. Interview preparation and mock rounds
  4. Job search strategy
HANDS-ON LAB

Mock technical + HR interview with feedback

Your 12 weeks journey

WEEKS 1–2Excel for analysis
WEEKS 3–4SQL essentials
WEEK 5Statistics for data
WEEKS 6–8Power BI & Microsoft Fabric
WEEKS 9–10Python for data analysis
WEEK 11AI for data analysis
WEEK 12Career launch

Data analytics tools you'll use

ExcelPostgreSQLMySQLPythonPower BIMicrosoft FabricpandasJupyterChatGPTClaudeCopilotLinkedIn

Data analytics projects you'll build

PROJECT 01

Executive dashboard for a retail business

Hands-on project from the Power BI & Microsoft Fabric module.

PROJECT 02

Exploratory analysis on a real dataset

Hands-on project from the Python for data analysis module.

PROJECT 03

AI-assisted insight report, fact-checked

Hands-on project from the AI for data analysis module.

Data analytics course fees & batches in Chennai

Course fee

₹26,999 incl. GST

Save up to 12%: from ₹23,500. Ask an advisor about the offer for your batch.

Pay in full or in two instalments. Online learners outside India: see the fee in your currency on our worldwide page.

Get the fee & next batch →Ask on WhatsApp

What the fee includes

  • 60 hours of live, instructor-led classes
  • Hands-on labs and 3 portfolio projects
  • Session recordings for revision
  • 1:1 mentoring
  • Interview preparation: questions and mock tests
  • Placement assistance: resume reviews, mock interviews and referrals

Batches & mode

  • Weekday batches
  • Weekend batches for working professionals
  • Fast-track batches
  • Classroom at our Arumbakkam centre, Chennai
  • Live online from anywhere

Data analytics certification & exam cost

🎓
Certification this course prepares you for
Microsoft Fabric Analytics Engineer Associate (DP-600)

The exam is booked directly with the certification provider, and its cost is set by the provider for your country. Our advisors share the current exam cost and help you plan the right exam date, with mock tests beforehand.

SOTT Academy certificate of completion (specimen)
Specimen for illustration only. Not a valid certificate. © SOTT Academy
Awarded on completion

SOTT certificate of completion

Every learner who completes the Data analytics course is awarded the SOTT Academy Certificate of Completion, with your name, the course, the date and a unique certificate number.

  • Awarded when you complete the course
  • Unique certificate number
  • Add it to your resume and LinkedIn profile

Data analytics jobs & career path

With placement assistance: resume and LinkedIn reviews, mock interviews, 1:1 mentoring and referrals to openings where available.

Step-by-step guide: Data Engineer career path · Data Analyst career path · Python learning path · Power BI & data visualisation learning path

STEP 1Data / AI AnalystInsights and reporting
STEP 2ML / AI EngineerModels and AI features
STEP 3Senior AI EngineerProduction GenAI systems
STEP 4AI LeadTeams and roadmaps
STEP 5Head of AI / ArchitectStrategy and platforms
Free with this course

Interview prep: 3 levels, mock tests and model answers

Practise the questions real interviewers ask, from fresher to lead.

Fresher · 0–3 yearsMid-level · 3–8 yearsExperienced · 8–15 years
Start practising →

Data analytics course FAQ

Who is the Data Analytics with AI course for?+
It is designed for students & fresh graduates, career switchers and working professionals. Start a tech career with skills employers ask for.
Do I need prior experience?+
Not at all. The course starts from the fundamentals and builds up step by step, with a mentor guiding you. Basic computer skills are all you need to begin.
How long is the Data Analytics with AI course?+
12 weeks, about 60 hours across 7 modules, with a hands-on lab in every module.
What does the Data Analytics with AI syllabus cover?+
The modules are: Excel for analysis, SQL essentials, Statistics for data, Power BI & Microsoft Fabric, Python for data analysis, AI for data analysis and Career launch. The full lesson list is on this page.
Which tools and technologies will I use?+
Excel, PostgreSQL, MySQL, Python, Power BI, Microsoft Fabric, pandas, Jupyter, ChatGPT, Claude, Copilot and LinkedIn.
What projects will I build?+
Executive dashboard for a retail business, Exploratory analysis on a real dataset and AI-assisted insight report, fact-checked. Your mentor reviews them, and you can show them in interviews.
Which certification does it prepare me for?+
Microsoft Fabric Analytics Engineer Associate (DP-600). We guide your preparation, run practice tests and help you plan your exam; our advisors can share the current exam details.
Is it online or in the classroom?+
Both. Join us at our Arumbakkam centre in Chennai or live online from anywhere. Session recordings are shared with you for revision, so you can catch up if you miss a class.
Are there weekend and fast-track batches?+
Yes. We offer weekday, weekend and fast-track batches, so you can choose the schedule that suits you best.
What jobs can I apply for afterwards?+
Roles such as Data / AI Analyst, ML / AI Engineer, Senior AI Engineer and AI Lead.
Is there interview preparation for Data Analytics with AI?+
Yes. Practise free interview questions and timed mock tests for fresher, mid-level and experienced roles on our Interview prep page.
Do you help with placements?+
Yes. Our placement assistance includes resume and LinkedIn reviews, mock interviews, 1:1 mentoring and referrals to openings where available, so you go into interviews well prepared.
Can I attend a free demo class first?+
Yes. Book a free consultation and our advisor will arrange a demo session for you.
What are the fee and payment options?+
Our advisors will share the current fee, upcoming batch dates and payment options for the batch that suits you.
I have another question. Who can I ask?+
Our advisors are happy to help. Call or WhatsApp us, or send a message from the Contact page, and we will get back to you within one working day.
Keep exploring

Related courses

All courses →
Microsoft Azure AI Cloud Developer Associate Generative AI & RAG Engineering AI Agents with LLMs
Syllabus →Enquire now
Free download

Data Analytics with AI: Excel, SQL, Power BI & Python brochure

Tell us where to send it. We'll email you a 6-digit code to confirm.