Skip to main content
Job course · Data

Data Analytics with AI

Become the person who turns a company's data into reports and dashboards: Excel, SQL, Power BI and Python, with AI to work faster.

Analyst and MIS roles test the same few skills in every interview: clean a messy sheet, write a correct SQL query, build a dashboard that still works next month and explain what the numbers mean. You practise each one on real business data, use ChatGPT and Copilot to speed up the work, and finish with a client project and a job-simulation test.

Free 20-minute counselling and a short skill check, in our classroom or on a call. See the full syllabus

Tools you'll use
  • Excel
  • Power Query
  • SQL (MySQL)
  • Power BI
  • DAX
  • Python (pandas)
  • ChatGPT
  • Microsoft Copilot
Design visualization of a laptop on the LearnPact hall table displaying a demo spreadsheet and analytics dashboard.

What you walk out with

  • Six portfolio projects: an MIS workbook, a SQL case study, two Power BI dashboards, a Python analysis and a client project
  • A project letter from Allied Biztech Solutions describing your client work
  • LearnPact certificate on passing the job-simulation test, plus preparation for Microsoft's PL-300 Power BI certification
  • A CV, LinkedIn profile and portfolio page built around your projects
  • Three mock interviews, including a live SQL and Excel test
  • 12 weeks of job-search help after the course
Synthetic preview: Trainer pointing at a SQL query on screen, learner at laptop.
Design visualization of a demo printed dashboard, memo and study notes on the hall table.
Sample project · simulated data

Jobs this prepares you for

  • MIS executive
    ₹3.0–3.3 lakh a year at 1–3 years' experience
  • Junior data analyst
    ₹3.7–4.1 lakh a year
  • Data analyst, the next step up
    ₹5.3–5.9 lakh a year at 1–3 years' experience
  • Power BI developer (junior)
  • Business analyst trainee

Typical Kolkata pay, from AmbitionBox. Pay varies with the employer, your experience and the interview. Kolkata job boards list hundreds of data analyst and MIS openings.

What Kolkata employers ask for

How often Kolkata job ads ask for each skill, and where the course covers it.

  • Excel (lookups, pivots)
    Covered in: Weeks 1–3
  • SQL
    Covered in: Weeks 4–7
  • Power BI
    Covered in: Weeks 8–11
  • Python
    Covered in: Weeks 12–14
  • Data from Tally, SAP or a CRM
    Covered in: Weeks 1–3
  • Tableau
    Covered in: Week 11, overview
  • AI tools (ChatGPT, Copilot)
    Covered in: Every module

Syllabus, week by week

Every block is taught live, practised with trainer help, then tested on a changed problem before you move on.

  1. Weeks 1–3
    1. Excel for business reporting
    • Formulas, IF/IFS, XLOOKUP
    • Text and date functions
    • Pivot tables and charts
    • Cleaning messy data
    • Power Query
    • Working with exports from Tally, SAP and CRMs
    • ChatGPT and Copilot to write and check formulas

    You build: A monthly sales MIS report that refreshes for a new month with one click.

  2. Weeks 4–7
    2. SQL for analysts
    • SELECT, WHERE, ORDER BY
    • GROUP BY and aggregates
    • JOINs across tables
    • Subqueries and CTEs
    • Window functions
    • AI to draft queries, and how to catch its mistakes

    You build: Answers to 20 business questions on an e-commerce orders database, checked against hand-calculated totals.

  3. Weeks 8–11
    3. Power BI dashboards
    • Power Query transformations
    • Data modelling (star schema)
    • DAX measures and time intelligence
    • Visual design and storytelling
    • Publishing, refresh and row-level security
    • Copilot in Power BI
    • Tableau overview: the same ideas in a second tool

    You build: A sales and operations dashboard for two kinds of user, refreshed on a schedule.

  4. Weeks 12–14
    4. Python, statistics and AI analysis
    • Python basics in Jupyter
    • pandas for cleaning and grouping
    • Charts with matplotlib
    • Averages, spread and A/B tests
    • Simple forecasting
    • ChatGPT data analysis and data-privacy rules

    You build: A customer-churn analysis notebook with a one-page recommendation.

  5. Weeks 15–16
    5. Client project and job preparation
    • Client brief and data handover
    • Dashboard and decision memo
    • Five-minute presentation
    • PL-300 practice questions
    • CV, LinkedIn and mock interviews

    You build: A dashboard and recommendation for a real business, presented to the client.

Your portfolio and your certificate

Final project

A real business's sales or operations data, from raw files to a cleaned dataset, SQL analysis, a Power BI dashboard and a one-page decision memo, presented to the client.

Job-simulation test

90 minutes on a dataset you haven't seen: fix a join that double-counts revenue, write a cohort query, repair a broken measure and explain one limitation. The same tasks analyst interviews use.

Certificates

  • LearnPact Data Analytics certificate, issued within 7 days of passing the job-simulation test
  • Prepared for Microsoft PL-300 (Power BI Data Analyst Associate)
  • Project letter from Allied Biztech Solutions for your client project

The LearnPact promise

Written into your enrolment confirmation before you pay.

  • Two-week refund

    Attend the first two weeks. If the course isn't right for you, ask in writing before week 3 and get your full fee back.

  • A real client project for everyone

    Every learner works on a brief from a real business or organisation and receives a project letter from Allied Biztech Solutions describing the work done.

  • Small batches

    At most 20 learners in a batch, so there is time for your questions and your work in every class.

  • Never fall behind

    Every class is recorded. Re-attend any module in a later batch within 12 months at no extra charge, whenever a seat is open.

  • Career support you can count

    CV and LinkedIn rebuild, a portfolio page, three mock interviews and 12 weeks of job-search help after the course.

  • One fee, in writing

    One GST-inclusive fee, with the timetable and refund terms in your enrolment letter. Or three monthly instalments with no interest, never a loan.

Right for you if you are

  • Graduates (B.Com, BBA, BCA, B.Sc, B.Tech) aiming at analyst or MIS roles
  • People who already make reports by hand and want to automate them
  • Professionals returning after a break who need a current skill set

Probably not for you if

  • Anyone wanting a machine-learning or data-science research course; this is business analytics

Not sure this is the right course? Take the 2-minute course match →

Your trainer
Prateek Bera
Prateek Bera
Lead trainer, Data Analytics

Prateek leads the data analytics course. Every week you work through a real dataset, from cleaning it in a spreadsheet to querying it in SQL and presenting it in a dashboard, and you learn to check what AI tells you before you share it.

Questions people ask

Do I need coding or strong maths?+
No. Class 10 maths and everyday computer use are enough. A free 15-minute skill check at counselling shows whether you're ready or should start with AI & Excel Essentials.
Will you get me a job?+
No honest institute can promise that, and we don't. What this course gives you is the skill, a client project and portfolio that show it, a CV and LinkedIn rebuilt around them, three mock interviews and 12 weeks of help applying after the course. We publish each batch's results once the batch finishes.
Do I need my own laptop?+
Classroom sessions use our lab machines. For practice at home you need a Windows laptop, because Power BI Desktop runs only on Windows; the lab is open for practice if you don't have one.
What is PL-300 and is the exam included?+
PL-300 is Microsoft's Power BI Data Analyst certification, recognised by employers worldwide. The course prepares you for it; the exam itself is booked and paid directly with Microsoft (₹4,865 plus tax in India).
What if I miss a class?+
Every class is recorded, and your trainer runs a doubt-clearing hour each week. You can also re-attend any module in a later batch within 12 months at no extra charge, whenever a seat is open.
How do I pay?+
₹29,999 including GST, in one payment or in three monthly instalments with no interest, agreed in writing. We never sign you up for a loan. Attend the first two weeks; if it isn't right for you, ask in writing before week 3 for a full refund.

Come and see the classroom

Book a free 20-minute counselling session at our classroom or on a call. Try a short skill check and get the full fee, timetable and refund terms in writing before you decide.

₹29,999
Free counselling · 3 instalments, no interest
Book a call