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

Data Analytics & Data Science Course in Lucknow & Online

From Raw Data to Real Decisions.

Course at a glance
Data Analytics & Data Science at BPST Academy, Lucknow is a 45 days or 3 months · 6 months beginner-friendly course covering Advanced Excel, SQL for Analysis, Python for Data, Visualization. It suits students from engineering, computer applications, commerce, mathematics, and graduates seeking analytics roles. 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
45 Days · 3 Months · 6 Months
Level
Beginner friendly
Mode
Classroom · Online
Pre-book
₹49 till Diwali
Diwali gift
₹49

Reserve your seat in the next Data Analytics & Data Science batch. Adjusted in your course fee.

Pre-book this course
Enquire for next batch

What Is the Data Analytics & Data Science Course?

Turn raw data into actionable insights with industry tools, analytics methodologies, interactive dashboards, and real-world case studies.

Who is it for?

Students from engineering, computer applications, commerce, mathematics, and graduates seeking analytics roles.

Prerequisites

Basic computer skills. No prior math or programming background required.

What Does the Data Analytics & Data Science Course Cover?

  • Excel for Data Handling: Advanced formulas, pivot tables, lookup functions, data modeling
  • SQL: Database queries, aggregate functions, joins, subqueries, data extraction
  • Python: Python syntax, Pandas DataFrames, NumPy numerical operations
  • Data Analysis Techniques: Data wrangling, handling nulls, transformations
  • Statistics Basics: Descriptive statistics, probability distributions, hypothesis testing
  • Dashboards & Visuals: Power BI interactive reporting, DAX measures, storytelling
  • Insight Generation: Presenting analytical findings to business stakeholders

Data Analytics & Data Science Syllabus — Module by Module

Module 01
Advanced Excel
  • Formulas, lookups, XLOOKUP
  • Pivot tables & charts
  • Data cleaning
  • Dashboards
Module 02
SQL for Analysis
  • SELECT, joins, subqueries
  • Window functions
  • CTEs
  • Business queries
Module 03
Python for Data
  • NumPy arrays
  • Pandas DataFrames
  • Cleaning & transformation
  • EDA workflow
Module 04
Visualization
  • Matplotlib & Seaborn
  • Storytelling with data
  • Chart selection
  • Report writing
Module 05
Power BI
  • Power Query
  • Data modelling & DAX
  • Interactive dashboards
  • Publishing & sharing
Module 06
Statistics & Intro ML
  • Descriptive statistics
  • Probability & distributions
  • Hypothesis testing
  • Regression basics

What Will You Learn Week by Week?

Choose the format that fits your semester or career plan. Each roadmap ends with a deployed project.

Fast-track analytics fundamentals Hands-on data querying & chart building
Week 1
Excel + Data Basics
Formulas, sorting, filtering, pivot tables, data cleaning
Week 2
SQL for Data Analysis
SELECT queries, filtering, grouping, table joins, aggregations
Week 3
Python for Data
Pandas data loading, data frame filtering, summary statistics
Week 4
Analysis + Visualization
Matplotlib charts, exploratory analysis, chart interpretation
Final Phase
Dashboard Mini Project
Deliver an interactive business dashboard from raw CSV data
Build end-to-end data pipelines Real-world dataset case studies
Weeks 1–2
Excel / SQL Mastery
Advanced Excel modeling, complex SQL joins, subqueries, views
Weeks 3–4
Python for Data Analysis
NumPy arrays, Pandas manipulation, time-series operations
Weeks 5–6
Statistics & Data Cleaning
Statistical metrics, outlier detection, data standardization
Weeks 7–8
Exploratory Data Analysis
Correlation heatmaps, feature relations, insight reports
Weeks 9–10
Power BI / Visualization
Data modeling, DAX measures, automated reporting dashboards
Weeks 11–12
Capstone Project
End-to-end business analysis presented as an executive case study
Comprehensive Data Science & Analytics Production analytics & predictive modeling
Weeks 1–4
Data Foundations
Data architecture, data collection ethics, business metrics
Weeks 5–8
Advanced SQL / Python
Database performance, window functions, Python scripting pipelines
Weeks 9–12
EDA & Visualization
Advanced seaborn, interactive Plotly visualizations, storytelling
Weeks 13–16
Dashboards & Reporting
Enterprise Power BI administration, row-level security, schedule refresh
Weeks 17–20
Data Science Foundations
Supervised machine learning algorithms, Scikit-learn, regression & classification
Weeks 21–24
Project + Interview Prep
Real-world business case study portfolio, resume guidance, mock technical reviews

Projects, Outcomes & Tools

Projects you build

  • Sales performance dashboard
  • Customer churn analysis
  • HR analytics report
  • Retail Customer Retention & Churn Analysis
  • Hospital Operations Patient Flow Insights

You will be able to

  • Clean and analyse real datasets
  • Write business SQL queries
  • Build Power BI dashboards
  • Present insights to stakeholders

Tools & tech

ExcelSQLPythonPandasNumPyMatplotlibPower BI

BitProSoftTech training certificate; 6-month program includes an internship letter

Retail Customer Retention & Churn AnalysisSimulated Industry Sprint

Identifying high-risk churn customers and visualizing sales patterns in Power BI.

Power BISQLPythonExcel
Hospital Operations Patient Flow InsightsGuided Portfolio Project

Analyzing emergency room wait times, bed allocation trends, and department bottlenecks.

PythonPandasSeaborn

How Is Data Analytics & Data Science 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 Analytics & Data Science — Frequently Asked Questions

Data Analytics & Data Science runs for 45 Days · 3 Months · 6 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.

Students from engineering, computer applications, commerce, mathematics, and graduates seeking analytics roles. Prerequisite: Basic computer skills. No prior math or programming background required.

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. BitProSoftTech training certificate; 6-month program includes an internship letter. 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 Industrial Training courses