Data Analyst Programme
An end-to-end analyst track: Excel, SQL, a BI tool and storytelling with data.
- ✓ Instructor-led live sessions, online or in Bengaluru
- ✓ Hands-on labs in every module
- ✓ Capstone project with trainer review
- ✓ Curriculum customisable for corporate teams
- ✓ Certificate of completion
Next batch: Sat, 19 Dec 2026 · 40 hours · 5 days
Data Analyst Programme
Duration: 40 hours · 5 days
Next batch: Sat, 19 Dec 2026
Format: Online live · Bengaluru classroom
Modules: 9 · Topics: 42
Level: Beginner to Intermediate
Fee: ₹17,999
Trusted by leading experts
Upcoming batches
Open batches for individuals; corporate batches on your dates.
| Programme | Starts | Mode | Schedule | Duration | |
|---|---|---|---|---|---|
| Data Analyst Programme | Sat, 19 Dec 2026 | Online live | Weekend (Sat) | 6 Saturdays | Enquire |
| Data Analyst Programme | Mon, 15 Feb 2027 | Bengaluru classroom | Weekday | 5 days | Enquire |
Soaring demand, and where it takes you
Data analyst roles remain among the most common entry points into data careers, and organisations reskill internal staff into them.
Become an expert
Roles this programme prepares you for:
Become a Data Analyst
Analyses data and builds reports.
- Analyse data in Excel with formulas and PivotTables
- Query databases with SQL
- Build dashboards in Power BI
About the course
A complete analyst track: spreadsheet analysis, SQL, a BI tool (Power BI), basic statistics and data storytelling, ending with a capstone analysis presented to stakeholders.
An end-to-end analyst track: Excel, SQL, a BI tool and storytelling with data.
Why should I attend?
Career-switchers within your organisation
Graduates
Business staff who work with data
Junior analysts
Prerequisites
None; basic computer skills
Level
Beginner to Intermediate
Delivery modes, duration and fee
Online live
Instructor-led virtual classroom; weekday (full-day) or weekend (Saturday) batches
Bengaluru classroom
In-person batches at our Bengaluru training venue
On-site at your office
Private corporate batch anywhere in India, scheduled around your teams
Blended
Live sessions plus guided self-paced labs and mentor check-ins
Duration: 40 hours · 5 days
Course fee (open batch): ₹17,999
Corporate / team batches: per-participant or flat batch pricing on request, based on group size, format and customisation.
What will you learn
- Analyse data in Excel with formulas and PivotTables
- Query databases with SQL
- Build dashboards in Power BI
- Apply descriptive statistics
- Define and track KPIs
- Tell clear stories with data
Skills you will gain
Tools
Analysis
Communication
Tools and platforms covered
PostgreSQLCourse curriculum
M01 The analyst role
- Business questions
- Data sources
- Analysis workflow
- Analyst toolkits
- Ethics and privacy
🧪 Hands-on: Scope an analysis
M02 Excel for analysis
- Formulas
- PivotTables
- Charts
- Lookup functions
- What-if analysis
🧪 Hands-on: Analyse a sales sheet
M03 SQL
- SELECT and filtering
- Joins
- Aggregations
- CTEs
- Window functions basics
🧪 Hands-on: Query a sample database
M04 Power BI
- Power Query
- Modelling
- Visuals
- DAX basics
- Publishing
🧪 Hands-on: Build a dashboard
M05 Statistics and KPIs
- Descriptive statistics
- KPI design
- Segmentation
- Cohorts
- Funnels
🧪 Hands-on: Define KPIs for a business
M06 Storytelling and capstone
- Narrative structure
- Visual best practices
- Presenting
- Executive summaries
- Q&A handling
🧪 Hands-on: Present a capstone analysis
M07 Python for analysts
- pandas basics
- Cleaning
- Charts
- Automating reports
🧪 Hands-on: Automate a weekly report with Python
M08 Data cleaning and quality
- Profiling
- Common errors
- Documentation
- Validation
🧪 Hands-on: Clean and document a messy sales dataset
M09 Capstone: analyst portfolio project
- Question
- Data
- Analysis and dashboard
- Presentation
🧪 Hands-on: Present a portfolio-ready analysis to a mock stakeholder panel
Hands-on projects
Capstone analysis
A full analysis from raw data to a presented dashboard and recommendations.
Why train with us
Built around your stack
Labs and examples adapted to the tools, cloud and data your team actually uses.
Practice-first
Every module ends in a lab, and the course ends with a reviewed capstone.
Practitioner-led
Delivered by Karthick Selvam and vetted specialist trainers from our network.
Visible progress
Attendance, lab completion and assessment results shared with your L&D team.
Certificate of completion
Participants who complete the labs and capstone receive a Learning Dots certificate of completion for Data Analyst Programme. [confirm certificate wording / sample image]
Learner reviews
“[Verified learner review for this course]”
“[Verified learner review for this course]”
Meet your trainer
Karthick Selvam
Founder · Data Engineering Corporate Trainer, Bengaluru
[Trainer bio, experience and areas of expertise]
Frequently asked questions
Is prior experience required?
No; basic computer literacy is enough.
Can the curriculum be customised for our team?
Yes. Modules, depth, duration and labs can be tailored to your stack and goals.
What delivery formats are available?
Online live instructor-led sessions, Bengaluru classroom, or on-site at your office.
How do we enquire or book?
Use the enquiry form on this page or the Enquire button next to any batch.
What does it cost?
The open-batch fee is ₹17,999 per participant plus GST. Corporate batches are priced on group size, format and customisation.
How long is the course?
40 hours · 5 days. Corporate batches can be split into half-day sessions.
A closer look
About this course
A complete analyst track: spreadsheet analysis, SQL, a BI tool (Power BI), basic statistics and data storytelling, ending with a capstone analysis presented to stakeholders.
What is Data Analyst Programme?
An end-to-end analyst track: Excel, SQL, a BI tool and storytelling with data.
Who this course is for
Career-switchers within your organisation, Graduates, Business staff who work with data, Junior analysts.
What you will be able to do
Analyse data in Excel with formulas and PivotTables. Query databases with SQL. Build dashboards in Power BI. Apply descriptive statistics. Define and track KPIs. Tell clear stories with data.
Career paths
Roles this course supports include Data Analyst, Business Analyst, Reporting Analyst. Data analyst roles remain among the most common entry points into data careers, and organisations reskill internal staff into them.
Related courses
Advanced SQL for Data Professionals
Window functions, CTEs, query plans, modelling for analytics and writing SQL that scales.
Power BI for Business Analytics
Data modelling, DAX, Power Query and dashboard design for decision-makers.
Analytics & BIPython for Data Engineering & Analysis
Python, pandas and automation for cleaning, transforming and moving data reliably.
Data & Analytics guides
Python vs SQL for Data Work: Which to Learn First?
SQL and Python solve different parts of data work. Most data professionals need both.
What Is Power BI?
Power BI is Microsoft's business intelligence platform for connecting to data, modelling it and building interactive reports.
What Is Data Science?
Data science combines statistics, programming and domain knowledge to extract insights and build predictive models from data.
Power BI vs Tableau: Which Should Your Team Learn?
Both are leading BI tools. The best choice usually depends on your existing ecosystem.