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
2 courses · Lucknow & Live Online

Data Analytics & Data Engineering Courses

Excel, SQL, Power BI, Tableau and Python for analysts; Spark, Databricks, Snowflake and Airflow for data engineers — with real datasets and portfolio dashboards.

Quick answer
BPST Academy teaches data skills at two levels: Data Analyst Pro (Excel, SQL, Power BI, Tableau, Python — 3 to 4 months, beginner friendly) and Data Engineering (PySpark, Databricks, Snowflake, Airflow — 3 to 4 months, SQL required). Both include capstone projects on real datasets.
Pre-book any course ₹49 See all 2 courses Ask on WhatsApp

Courses in this category

Tap a course
Course 01 · From raw data to business decisions

Data Analyst Pro (Excel + SQL + Power BI + Tableau + Python)

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.

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

Pre-book ₹49 Full syllabus
Duration
3 – 4 Months
Level
Beginner friendly
Mode
Classroom (Lucknow) / Live online
Pre-book
₹49 till Diwali

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 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

Course 02 · Build the pipelines every data team depends on

Data Engineering (Spark, Databricks, Snowflake, Azure/AWS)

Learn modern data engineering: advanced SQL, Python and PySpark, warehouse modelling, Azure Data Factory / AWS Glue, Databricks with Delta Lake, Snowflake, Kafka streaming and Airflow/dbt orchestration — ending in a full lakehouse project.

Best for: Freshers with SQL basics, data analysts, developers and ETL/BI professionals.

Pre-book ₹49 Full syllabus
Duration
3 – 4 Months
Level
Intermediate
Mode
Classroom (Lucknow) / Live online
Pre-book
₹49 till Diwali

Syllabus — module by module

Module 01
Advanced SQL & Modelling
  • Window functions & optimisation
  • Star & snowflake schemas
  • Slowly changing dimensions
  • Data quality checks
Module 02
Python & PySpark
  • Python for data engineering
  • Spark architecture
  • DataFrames & Spark SQL
  • Performance tuning
Module 03
Cloud Ingestion
  • Azure Data Factory
  • AWS Glue & S3
  • Incremental loads
  • Orchestration patterns
Module 04
Databricks & Delta Lake
  • Lakehouse & medallion architecture
  • Delta Lake ACID tables
  • Unity Catalog
  • Jobs & workflows
Module 05
Snowflake & Streaming
  • Snowflake warehouses & stages
  • Snowpipe
  • Kafka fundamentals
  • Structured streaming
Module 06
Orchestration & Capstone
  • Apache Airflow DAGs
  • dbt transformations
  • CI/CD for data
  • Lakehouse capstone project

Projects you build

  • Retail lakehouse on Databricks (bronze → gold)
  • Real-time order stream with Kafka + Spark
  • Snowflake warehouse with dbt models

You will be able to

  • Design batch and streaming pipelines
  • Model data for analytics at scale
  • Work confidently on Azure/AWS data stacks

Tools & tech

SQLPythonPySparkDatabricksDelta LakeSnowflakeAzure Data FactoryAWS GlueKafkaAirflowdbt

Maps to Microsoft DP-700, Databricks Data Engineer Associate and SnowPro Core

Also consider

Related Industrial Training Tracks

Project-based 45-day, 3-month and 6-month tracks that pair well with data analytics & engineering.

Data Analytics & Engineering — Frequently Asked Questions

Choose Data Analyst if you want to answer business questions with dashboards; it is the easiest entry into data jobs. Choose Data Engineering if you enjoy programming and want to build the pipelines analysts depend on; salaries are typically higher.

Yes. Data Analyst Pro starts from Excel basics and needs no coding. B.Com, BBA and B.Sc graduates regularly move into analyst roles after the program.

Last updated 2026-09-25

Diwali gift: seat pre-booking for ₹49

Pick any data analytics & engineering course and lock your seat before Diwali, 8 Nov 2026. ₹49 is adjusted in your course fee.

Pre-book for ₹49 Enquire now