BA
Professional Business Analytics + Job Placement — syllabus 2026
Business analytics thinking on top of the full analyst toolkit — Excel, SQL, Power BI, Python and AI — plus Jira for project work and complete placement preparation.
Module-wise syllabus
Tap a module to see every topic. The same syllabus is used in our classroom and live online batches.
01Business Analytics Concepts5 topics
- What business analytics is and how it drives decisions
- Collecting & analysing business data
- Descriptive, diagnostic, predictive & prescriptive analytics
- KPIs, metrics & business questions
- Discovering insights & trends; data-driven decision making
02Excel & Advanced Excel5 topics
- Formulas: XLOOKUP, INDEX-MATCH, SUMIFS, IFS
- Pivot Tables, slicers & dashboards
- What-if analysis: Goal Seek, Scenario, Solver
- Power Query for data cleaning
- Business MIS reports
03MS Access & SQL5 topics
- Relational databases, tables & relationships
- Access queries, forms & reports
- SELECT, joins, GROUP BY, subqueries
- Window functions & CTEs for analysis
- SQL for KPI & business reporting
04Power BI4 topics
- Power Query & data modelling
- DAX measures & time intelligence
- Interactive business dashboards
- Publishing, sharing & Row-Level Security
05Python for Business Analytics4 topics
- Python basics for analysts
- Pandas & NumPy for data analysis
- Charts with Matplotlib & Seaborn
- Statistics for business decisions
06VBA / Macros3 topics
- Recording & editing macros
- Automating repetitive reports
- Data splitter, consolidation & auto-email projects
07ChatGPT & AI for Analysts3 topics
- Prompting for formulas, SQL & summaries
- Copilot in Excel & PowerPoint
- AI-assisted analysis & reporting
08PowerPoint & Data Storytelling3 topics
- Management presentations & executive summaries
- Linking Excel charts into PPT
- Presenting insights to stakeholders
09Jira — Project Management4 topics
- Projects, issues & workflows
- Agile basics: backlog, sprints & boards
- Tracking tasks & reporting progress
- How business analysts work with project teams
10Business Case Studies & Projects4 topics
- Sales & profitability analysis
- Customer & marketing analytics
- HR & operations dashboards
- End-to-end business analytics project
11Interview Preparation & Placement4 topics
- Business analyst interview questions & case rounds
- Resume & LinkedIn profile building
- Mock interviews (technical & HR)
- Placement assistance & company drives
Projects & practice
Sales & profitability dashboardCustomer segmentation analysisKPI report in SQL + Power BIJira project board for an analytics projectExecutive insight presentation
Programmes that include Business Analytics
| Programme | Duration | Fees |
|---|---|---|
| Professional Business Analytics + Job Placement | 8–10 months | ₹40,000 |
Frequently asked questions
Can I download the Business Analytics syllabus as a PDF?
Yes. Use the “Download syllabus PDF” button on this page — enter your name and mobile number and the PDF opens instantly.
How long does the Business Analytics course take?
It is taught inside our programmes: Professional Business Analytics + Job Placement (8–10 months, ₹40,000). Module-wise batches are also possible — ask the counsellor.
Is it online or classroom?
Both. Classroom batches run at our Dwarka, Uttam Nagar and Janakpuri branches, and live online batches are available.