Data Analytics with AI Course in Nagpur

Excel, SQL, Python and Power BI in twelve weeks, plus the AI tools that make analysts faster.

Duration
12 weeks
Fee
₹30,000 incl. GST
Mode
Classroom + live online
Batch size
Max 20 students
Certificate
Certificate of completion

Course Overview

Data analysts turn raw data into decisions. This course teaches the full toolkit in the order you will use it at work: Excel first, then SQL, Python and Power BI.

We also show how AI tools help analysts write formulas, queries and summaries faster, and how to check that their output is correct.

You finish with a portfolio dashboard built on a real dataset, which you present to the batch.

Who this course is for

  • Freshers from any degree who want a data analyst role
  • Working professionals who handle reports in Excel and want to do more
  • MBA and commerce graduates who want technical analytics skills
  • Anyone preparing for data analyst or business analyst interviews
See: AI courses for working professionals

Curriculum

  1. Weeks 1–2

    Excel for analysis

    • Formulas, lookups and cleaning data
    • Pivot tables and charts
    • A simple Excel dashboard
  2. Weeks 3–4

    SQL

    • SELECT, WHERE, ORDER BY
    • JOINs and GROUP BY
    • Subqueries and common business queries
  3. Weeks 5–6

    Python for analysis

    • Pandas for cleaning and reshaping data
    • Combining data from several sources
    • Automating a weekly report
  4. Week 7

    Visualisation

    • Choosing the right chart
    • Charts with Python
    • Telling a story with data
  5. Weeks 8–9

    Power BI

    • Loading and modelling data
    • DAX basics
    • Interactive dashboards
  6. Week 10

    Statistics for analysts

    • Averages, spread and distributions
    • Correlation and trends
    • A/B test basics
  7. Week 11

    AI tools for analytics

    • Using AI to write formulas and SQL
    • AI features in Excel and Power BI
    • Checking AI output
  8. Week 12

    Capstone and interview prep

    • Capstone dashboard on a real dataset
    • Presenting insights
    • Common analyst interview questions

Projects You Will Build

  • Excel sales dashboard

    Pivot tables and charts that answer how sales are changing by month and region.

  • SQL business questions

    Write queries on a retail database to find top customers, products and trends.

  • Automated report in Python

    A script that cleans new data and produces the same report every week.

  • Power BI capstone

    An interactive dashboard on a real dataset, presented with clear recommendations.

Tools Covered

  • Excel
  • SQL
  • Python
  • Pandas
  • Power BI
  • AI assistants

Fee & EMI

₹30,000

including GST

Ask us about payment options when you visit for the demo class.

What is included

  • Hands-on projects
  • Certificate of completion
  • Recorded session access
  • Doubt-solving sessions

The certificate of completion is issued by Webnetis when you finish the course. About our certificates

Batch Timings

Small batches of up to 20 students, so your trainer knows your name and your code.

  • Weekday morning

    9:00 – 11:00 AM

  • Weekday evening

    7:00 – 9:00 PM

  • Weekend (Sat–Sun)

    10:00 AM – 1:00 PM

Book a Free Demo Class

Meet the trainer, see the classroom and ask every question before you decide. Parents are welcome.

Every Saturday, 11:00 AM – 12:30 PM · Also bookable on weekdays by appointment

Data Analytics with AI: Frequently Asked Questions

Do I need a technical background?

No. We start with Excel and build up step by step. Comfort with basic computer use and simple maths is enough.

Can I attend online?

Yes. This course runs in the classroom in Nagpur and live online.

Is this the same as a data science course?

Not exactly. Data analytics focuses on reporting, dashboards and business questions. Data science goes further into machine learning, which is covered in the AI Job-Ready Program.

Do I need to bring a laptop?

Lab computers are available in the classroom, but we recommend bringing your own laptop so you can practise at home.

Which language is the class taught in?

Classes are taught in English, Hindi and Marathi. Trainers switch language whenever it helps you understand a concept better.

Can I attend a demo class before I pay?

Yes. The free demo class runs every saturday, 11:00 am – 12:30 pm. Also bookable on weekdays by appointment. Message us on WhatsApp at +91 84213 41253 to book a seat.

Other Courses in Nagpur

WhatsAppCall