Dashboards You Will Build
A complete sales analytics dashboard in Tableau, an executive
KPI report in Power BI, and an Excel model with pivot tables
— all using real business datasets, deployed and
portfolio-ready.
Data Analytics Course Near You — In-Person & Online Training in Lucknow
Learn data analytics at our Jankipuram, Lucknow training lab
or join online with live mentor support. This course focuses on
practical skills companies actually use — SQL queries,
Excel modelling, Tableau visualisations, Power BI dashboards and
business storytelling with data.
Data Analytics Course Curriculum — SQL, Excel, Tableau, Power BI & Real Projects
01
SQL basics & database querying — SQL
fundamentals, SELECT statements, JOINs, GROUP BY, subqueries,
database retrieval on real datasets
02
Excel Advanced — VLOOKUP, INDEX-MATCH,
pivot tables, conditional formatting, charts, data validation
and analysis with formulas
03
Data validation & cleaning techniques
— Identifying dirty data, removing duplicates,
standardising formats, outlier detection and data quality checks
04
Handling missing data & transformation
— Imputation strategies, data type conversion, reshaping
datasets and preparing data for visualisation
05
Tableau dashboards & visualisations
— Connecting data sources, calculated fields, filters,
interactive dashboards and storytelling with charts
06
Power BI reports & KPI design — DAX
basics, data modelling, relationships, interactive reports and
executive KPI dashboards
07
Real-world analytics projects — Sales
performance analysis, customer segmentation, HR analytics and
e-commerce metrics using live business datasets
08
Data storytelling & interview preparation
— Presenting insights to stakeholders, portfolio
building, resume prep and analytics interview Q&A