Query
Get the data you need.
Clean data in Excel, write SQL with joins and CTEs, and load data into pandas.
Professional Programmes · Data · 240 hours
AI and Data Analytics. Turn business data into decisions.
Rooman's Professional Programme in AI and Data Analytics is a 240-hour programme that takes you from Excel to SQL, Python, statistics and Power BI, then shows you how to use AI tools to clean data and write reports. You finish with capstone projects on real business data and earn the Rooman Certificate with NSDC recognition.
240 hours14 modulesPlacement driveCapstone project
What you'll be able to do
Answer business questions with data.
Data analysts collect, clean and analyse data, then present it so a business can decide. This programme teaches the tools analysts use every day and how AI tools speed up the work.
Analyse
Find what it means.
Explore data with Python, apply statistics and test hypotheses against business questions.
Present
Tell the story.
Build Power BI dashboards and use AI tools to draft insights and reports.
Skills covered
- Excel formulas, pivot tables and MIS reports
- SQL queries, joins and CTEs
- Python with pandas and NumPy
- Exploratory data analysis
- Statistics and hypothesis testing
- Power BI, DAX and dashboards
- Prompt engineering for data tasks
- Data storytelling
Who it's for
Built for your first analytics role.
The programme is for graduates of any stream with basic maths, and for professionals moving into data and AI roles. It starts from basics, so prior coding experience is optional.
Roles where these skills are used
- Data Analyst
- Business Analyst
- AI Data Analyst
- Power BI Developer
- MIS Analyst
- Junior Data Scientist
Entry requirements.
- Graduates in any stream, with basic maths or statistics
- Professionals moving into data or AI roles
- Beginners welcome; prior coding experience is optional
Not sure which course fits? Take the 10-minute career assessment, or talk to a counsellor.
240 hours · 14 modules
A curriculum that follows the analytics lifecycle.
Fourteen modules in the order analysts work: collect and clean in Excel and SQL, analyse in Python and statistics, visualise in Power BI, speed it up with AI, then capstone projects and job readiness.
01Foundations of data analytics12 hrs
What analysts do, and how data turns into decisions.
Topics covered
- What data analysts do, and how analyst, business analyst and AI analyst roles differ
- Structured, semi-structured and unstructured data
- The analytics lifecycle: collect, clean, analyse, visualise, decide
- KPIs, metrics and business questions
You produce: a set of KPIs for a business question.
02Excel for data analysis16 hrs
Cleaning and calculating with data in Excel.
Topics covered
- Data cleaning and formatting for analysis
- Advanced formulas: IF, COUNTIF, SUMIFS, XLOOKUP and INDEX-MATCH
- Sorting, filtering and conditional formatting
You produce: a cleaned dataset with formula-driven analysis.
03Excel reporting16 hrs
Summarising data into reports managers use.
Topics covered
- Pivot tables and pivot charts for reporting
- Professional MIS and summary reports
- Mini project: sales performance and revenue analysis
You produce: a sales performance and revenue analysis report.
04SQL querying20 hrs
Getting data out of relational databases.
Topics covered
- Database fundamentals and table relationships
- SELECT, WHERE, ORDER BY, GROUP BY and HAVING
- Joins: inner, left, right and full
- Subqueries and common table expressions (CTEs)
You produce: queries that join and summarise business tables.
05SQL for analytics16 hrs
Applying SQL to real analytics and interview problems.
Topics covered
- Query optimisation and analytics use cases
- SQL interview scenarios and case questions
- Project: customer and order analytics
You produce: a customer and order analysis in SQL.
06Python and pandas20 hrs
Loading and cleaning data in Python.
Topics covered
- Python fundamentals for data analytics
- NumPy arrays and pandas DataFrames
- Importing and exporting CSV, Excel and JSON data
- Handling missing values and duplicates
You produce: a clean pandas DataFrame from raw files.
07Exploratory analysis and visualisation20 hrs
Finding patterns in data and charting them.
Topics covered
- Exploratory data analysis (EDA)
- Data visualisation with Matplotlib and Seaborn
- Project: EDA on a real business dataset
You produce: an exploratory analysis of a real business dataset.
08Statistics for data-driven decisions20 hrs
Measuring, comparing and testing what the data says.
Topics covered
- Descriptive statistics: mean, median, variance and standard deviation
- Probability concepts for analytics
- Correlation, trend analysis and outliers
- Hypothesis testing, business inference and data bias
You produce: a hypothesis test on a business question.
09Power BI data modelling20 hrs
Connecting and modelling data for reporting.
Topics covered
- Connecting multiple data sources
- Data modelling and relationships
- DAX fundamentals
- Creating KPIs and metrics
You produce: a Power BI data model with KPIs.
10Dashboards and data storytelling16 hrs
Designing dashboards that lead to decisions.
Topics covered
- Designing interactive dashboards
- Storytelling with data and insights
- Project: executive dashboard in Power BI
You produce: an executive dashboard in Power BI.
11AI tools for analysis16 hrs
Using AI tools to clean and explore data.
Topics covered
- AI tools for data cleaning and analysis
- AI-assisted EDA and report generation
- Prompt engineering for data tasks
You produce: an AI-assisted exploratory analysis.
12AI-generated insights12 hrs
Automating summaries and using AI responsibly.
Topics covered
- Automating insights and summaries
- Ethical use of AI in analytics
- Mini project: AI-powered business insight report
You produce: an AI-powered business insight report.
13Capstone projects24 hrs
Analysing a full business problem end to end.
Topics covered
- Capstone options: retail sales and customer behaviour, or HR attrition and performance
- Capstone options: financial data analysis, or marketing campaign performance
- Project-based portfolio building
You produce: capstone analyses for your portfolio.
14Job readiness12 hrs
Getting ready for analytics interviews.
Topics covered
- Resume and LinkedIn optimisation
- SQL and Python interview questions
- Mock interviews and case studies
You produce: an interview-ready resume and LinkedIn profile.
Tools covered
The tools you'll work with.
You use the tools analytics teams rely on, plus AI tools that speed up the work.
| Tool group | Tools | What you use them for |
|---|---|---|
| Spreadsheets | Excel | Clean data, calculate and build MIS reports |
| Databases | SQL | Query and join business data |
| Programming | Python, pandas, NumPy, Matplotlib, Seaborn | Analyse and chart data |
| Business intelligence | Power BI, DAX | Model data and build dashboards |
| AI tools | OpenAI APIs, Hugging Face | Speed up cleaning, analysis and reporting |
Capstone
Pick a business problem. Then solve it with data.
Your capstone projects cover retail sales and customer behaviour, HR attrition and performance, financial data and marketing campaign performance. Each goes from raw data to a dashboard and a recommendation.
Most modules end with a project on a real business dataset.
What you finish with.
- A sales performance report in Excel
- A customer and order analysis in SQL
- An EDA notebook in Python
- An executive dashboard in Power BI
- An AI-powered business insight report
Your credential
Rooman Certificate.
The Rooman Certificate, with NSDC recognition. You earn the Rooman Certificate, recognised by NSDC, when you complete the programme and its capstone projects.
Placement support runs alongside the final modules: resume workshops, mock interviews, job referrals and Rooman's placement drive. Your capstone projects become the portfolio you take to interviews.
What's included
Everything you need to finish.
- Instructor-led sessions with hands-on labs
- Projects in every module and a capstone
- Generative AI built into the curriculum
- Resume workshops, mock interviews and job referrals
- The Rooman Certificate, with NSDC recognition
- A counsellor to guide you from enrolment to placement
Before you enrol
Questions future data analysts ask.
Can't find your answer? Call 080 6945 1000 or WhatsApp us.
Who is this programme for?
Graduates of any stream with basic maths, and professionals moving into data or AI roles.
Do I need prior coding knowledge?
No. The programme starts from basics and builds up gradually.
Which tools will I learn?
Excel, SQL, Python, Power BI, and AI tools such as OpenAI APIs and Hugging Face.
How is this different from other data courses?
It adds generative AI to the analytics workflow: you use AI tools to clean data, explore it and draft insight reports.
How much time does it take?
240 hours, including projects. Rooman runs evening and weekend batches.
Can I do this programme online?
Residential, online or hybrid. Rooman runs evening and weekend batches, and a counsellor will tell you which formats your batch offers.
What projects will I do?
A project in most modules, plus capstones on retail sales, HR attrition, financial data and marketing campaigns.
Is placement support included?
Yes. You get resume workshops, mock interviews and job referrals, and you take part in Rooman's placement drive.
Which certificate will I receive?
The Rooman Certificate, with NSDC recognition, and a portfolio of your analyses.
How do I find out fees and batch dates?
Talk to a Rooman counsellor on 080 6945 1000 or WhatsApp +91 97390 86029. They will share current fees, payment options and upcoming batch dates.
Related courses.
See all 5 programmes
240 hrs12 modulesGenerative AI and MLOpsBuild AI systems, then run them in production.
240 hrs12 modulesFull Stack Development with Gen AIBuild MERN apps with AI features inside.
240 hrs12 modulesCloud and DevOpsBuild, ship and run applications on AWS.For companiesTraining your whole team?Run any programme as a private batch for your team, with the same curriculum, labs and projects.Talk to usNext step
Start with a conversation.
Tell us your degree or current role, and a counsellor will call you with batch dates, fees and payment options.
- Call: 080 6945 1000
- WhatsApp: +91 97390 86029
- Email: hello@rooman.com
Course details reviewed on 25 September 2026.