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.

Tools you'll use
  • Excel
  • Power Query
  • SQL (MySQL)
  • Power BI
  • DAX
  • Python (pandas)
  • ChatGPT
  • Microsoft Copilot
Book free counselling See the full syllabus

Free 20-minute counselling and a short skill check, at our classroom or on a call.

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

Jobs this prepares you for

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

Pay: average self-reported salaries for Kolkata on AmbitionBox, seen 31 Oct 2026. On the same day Naukri showed 681 results for data analyst jobs in Kolkata and 660 for MIS executive. A reference, not a promise: pay depends on the employer, your experience and your interview.

What Kolkata employers ask for

From 14 Kolkata data job ads on LinkedIn, read on 31 Oct 2026.

  • Excel (lookups, pivots)12 of 14
    Covered in: Weeks 1–3
  • SQL10 of 14
    Covered in: Weeks 4–7
  • Power BI8 of 14
    Covered in: Weeks 8–11
  • Python5 of 14
    Covered in: Weeks 12–14
  • Data from Tally, SAP or a CRM5 of 14
    Covered in: Weeks 1–3
  • Tableau4 of 14
    Covered in: Week 11, overview
  • AI tools (ChatGPT, Copilot)3 of 14
    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, a named trainer

    At most 20 learners in a batch. You meet your trainer before you pay. If the trainer changes mid-course, you repeat the affected modules at no extra charge.

  • 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
Your trainer
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 on 31 Oct 2026).
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. Meet the trainer, try a short skill check and get the full fee, timetable and refund terms in writing before you decide.

Book free counselling Try a ₹99 Sunday Lab first

Other courses