Week 1 · Days 1–5
Data questions and quality
- Define a business question and metric
- Inspect CSV columns and data types
- Find missing values and duplicates
- Use basic spreadsheet summaries
Weekly deliverable
A cleaned dataset and short data-quality log.
AI & Data · Beginner
Data Analytics with SQL & Power BI
One month. A practical start.
Clean a small dataset, answer questions with SQL and create an interactive Power BI report with clearly explained findings.
- 4 weeks
- one focused course
- 20 days
- 2 guided hours per day
- 20 hrs
- independent practice
- 1 project
- to build and demonstrate
Your starting point
Is this course
right for your batch?
Students from engineering, commerce, management and science with basic spreadsheet familiarity.
What students should know
- Spreadsheet rows, columns and simple formulas
- A Windows lab computer for Power BI Desktop
- Basic percentages and averages
Tools & lab setup
- SQLite
- DB Browser for SQLite
- Power BI Desktop on Windows
- CSV datasets
- Spreadsheet software
Your one-month learning plan
A milestone
every week.
Each week has five teaching days: 10 guided hours and 5 hours of independent practice. The last week includes project review and the final demonstration.
Week 2 · Days 6–10
SQL for analysis
- SELECT, WHERE and ORDER BY
- Aggregate with GROUP BY
- Join two related tables
- Check totals and export query results
Weekly deliverable
An annotated SQL file answering five analysis questions.
Week 3 · Days 11–15
Build the report
- Import and transform with Power Query
- Create a simple table relationship
- Write basic DAX measures
- Choose charts, slicers and readable labels
Weekly deliverable
A two-page interactive Power BI report.
Week 4 · Days 16–20
Validate and communicate
- Reconcile report totals with SQL
- Document metric definitions
- Explain findings and limitations
- Package the report and present recommendations
Weekly deliverable
A validated report file, SQL queries and a concise insight brief.
Your final project
College workshop participation dashboard
Analyse synthetic workshop and registration data by department, topic and attendance. Deliver a local Power BI report with three supported findings and a data dictionary. Cloud publishing is optional and depends on the college licence.
How learning is assessed
Data-quality log, independently checked SQL queries, report accuracy and an individual explanation of the final insights.
Students should explain their own decisions, show their work and document limitations. Any certificate conditions are agreed with the college before the batch begins.
Keep learning
Official learning resources.
References for preparation and continued practice. These resources support the syllabus; their publishers do not endorse this training.
Explore another direction.
View all 12 courses ↗For departments & placement cells
Bring practical training
to your campus.
Share your students’ background, preferred course and dates. We’ll help shape a one-month batch around your college’s timetable and lab facilities.
Batch size, delivery arrangements, fees and any completion certificate requirements are agreed with your college before enrolment.