Happy Diwali Gift: Pre-book any course for just ₹49 · ₹49 is adjusted in your fee Ends in --d --h --m --s The Diwali ₹49 pre-booking offer has ended. New batches are open for enquiry. Pre-book ₹49
3rd Floor, Sahay Complex, Near IIM Tiraha, Lucknow | Admissions Open 2026–27
+91 82991 01616 WhatsApp Us Download Brochure
Data Analytics & Engineering High demand 2026

Data Analyst Pro (Excel + SQL + Power BI + Tableau + Python) Course in Lucknow & Online

From raw data to business decisions.

Course at a glance
Data Analyst Pro at BPST Academy, Lucknow is a 3 – 4 months beginner-friendly course covering Advanced Excel, SQL for Analysts, Statistics for Business, Power BI & DAX. It suits Graduates of any stream (B.Com, BBA, B.Sc, B.Tech, BCA), freshers and career switchers. Classes run in the Lucknow classroom and live online. Until Diwali (8 Nov 2026) you can pre-book a seat for ₹49, adjusted in the course fee.
Duration
3 – 4 Months
Level
Beginner friendly
Mode
Classroom · Online
Pre-book
₹49 till Diwali
Diwali gift
₹49

Reserve your seat in the next Data Analyst Pro batch. Adjusted in your course fee.

Pre-book this course
Enquire for next batch

What Is the Data Analyst Pro Course?

The complete job-ready data analyst program. Master Advanced Excel, SQL, statistics, Power BI with DAX, Tableau and Python (pandas), plus AI tools for analysts — and build a portfolio of dashboards on real business datasets.

Who is it for?

Graduates of any stream (B.Com, BBA, B.Sc, B.Tech, BCA), freshers and career switchers.

Prerequisites

None — starts from Excel basics.

Data Analyst Pro Syllabus — Module by Module

Module 01
Advanced Excel
  • Lookups (XLOOKUP, INDEX-MATCH)
  • Pivot tables & charts
  • Power Query cleaning
  • Dashboard design
Module 02
SQL for Analysts
  • SELECT, JOINs, GROUP BY
  • Window functions
  • CTEs & subqueries
  • Business case queries
Module 03
Statistics for Business
  • Descriptive statistics
  • Distributions & sampling
  • Hypothesis testing
  • A/B test basics
Module 04
Power BI & DAX
  • Data modelling & relationships
  • DAX measures
  • Interactive dashboards
  • Publishing & sharing
Module 05
Tableau & Storytelling
  • Tableau worksheets & dashboards
  • Calculated fields
  • Data storytelling
  • Executive presentations
Module 06
Python for Analysis + AI
  • pandas & NumPy
  • Matplotlib / Seaborn
  • Automating reports
  • ChatGPT/Copilot for analysts

Projects, Outcomes & Tools

Projects you build

  • Sales performance dashboard (Power BI)
  • HR attrition analysis (SQL + Tableau)
  • E-commerce customer segmentation (Python)

You will be able to

  • Clean, analyse and visualise business data
  • Write production-quality SQL
  • Build and present executive dashboards
  • Crack data analyst interviews

Tools & tech

ExcelPower QuerySQL Server / MySQLPower BIDAXTableauPythonpandasCopilot

Maps to Microsoft PL-300 (Power BI Data Analyst) and Tableau Data Analyst

How Is Data Analyst Pro Taught at BPST Academy?

Every batch follows our simulated software-company model: fundamentals first, daily hands-on coding, team formation with real roles, Agile sprints with daily stand-ups, code reviews, testing and live deployment — guided by working IT professionals who act as your project managers.

Daily hands-on practice

Write and debug code in every session, not just watch slides.

Mentor as project manager

Sprints, pull-request reviews and deadlines like a real team.

Live, demo-able projects

Your work goes on GitHub and a live URL recruiters can open.

Data Analyst Pro — Frequently Asked Questions

Data Analyst Pro runs for 3 – 4 Months. You can study in the Lucknow classroom (3rd Floor, Sahay Complex, Near IIM Tiraha) or join the same batch live online from anywhere in India.

Graduates of any stream (B.Com, BBA, B.Sc, B.Tech, BCA), freshers and career switchers. Prerequisite: None — starts from Excel basics.

The course fee depends on the duration and mode you choose and is shared with you on WhatsApp right after pre-booking. As a Diwali gift, you can reserve your seat for just ₹49 until 8 November 2026 (23:59 IST). The ₹49 is adjusted in your course fee.

Yes. Maps to Microsoft PL-300 (Power BI Data Analyst) and Tableau Data Analyst. You also leave with project work you can show to employers.

Yes — we provide job assistance: resume and LinkedIn/Naukri profile reviews, mock technical and HR interviews, and relevant interview opportunities. We do not make placement-guarantee claims; we make sure your skills and portfolio are genuinely job-ready.

Last updated 2026-09-25

Pre-book Your Seat for ₹49Enquire for the Next Batch

Diwali gift · ₹49 is adjusted in your course fee
₹49 only
Please enter your full name.
+91
Enter a valid 10-digit Indian mobile number.
Please enter your city.
Please choose a course.
Please accept to continue.
Secure payment Adjusted in fee Details kept private

Talk to admissions

WhatsApp about this course +91 82991 01616
All Data Analytics & Engineering courses
Industrial Training In demand

Generative AI & Agentic AI

Create | Automate | Augment | Build the Next AI Era

Learn the cutting-edge generation of AI with Large Language Models (LLMs), Retrieval Augmented Generation (RAG), autonomous AI agents, and intelligent workflows.

Key Technologies:
Prompt EngineeringLLMs (OpenAI, Gemini, Claude)RAG ArchitecturesVector DBs (Chroma, Pinecone)LangChain & LlamaIndex+3 more
45 Days · 3 Months · 6 Months Beginner friendly
View Syllabus & Roadmap Pre-book for ₹49 Enquire for this course