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
- Excel
- Power Query
- SQL (MySQL)
- Power BI
- DAX
- Python (pandas)
- ChatGPT
- Microsoft Copilot
- Award-winning institute
- Classroom + CloudVarsity® virtual classroom
- Fees include GST
- 3 monthly instalments, no interest
- Two-week refund
- Run by Allied Biztech Solutions Pvt Ltd · GSTIN 33AAHCA9065H1ZL
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
- 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
- SQLCovered in: Weeks 4–7
- Power BICovered in: Weeks 8–11
- PythonCovered in: Weeks 12–14
- Data from Tally, SAP or a CRMCovered in: Weeks 1–3
- TableauCovered 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.
- Weeks 1–31. 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.
- Weeks 4–72. 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.
- Weeks 8–113. 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.
- Weeks 12–144. 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.
- Weeks 15–165. 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 →
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?+
Will you get me a job?+
Do I need my own laptop?+
What is PL-300 and is the exam included?+
What if I miss a class?+
How do I pay?+
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.