Learning routes / Data Analytics and Business Intelligence
Learning routeData Analytics and Business Intelligence
Excel, Power BI and AI-assisted analysis for real business questions. Students, graduates and working people who report numbers in Excel and want to analyse them properly.
- Length
- 20 weeks · 186 training hours
- Weekly effort
- About 8–12 hours a week
- Start with
- Basic Excel (entering data, simple formulas). No programming needed to start.
- Language
- Taught in English. Practice questions and explanations are in English.
What you will be able to do
Answers a defined business question with cleaned data, a Power BI dashboard, a short written summary and stated limitations.
Be clear: An analyst foundation. It does not make you a data scientist.
The route, step by step
- Start here
Advanced Excel + Power BI
Formulas, PivotTables, Power Query and a first Power BI report.
Portfolio Project: Validated sales and finance dashboard
How it is checked: Portfolio project output: Interactive business dashboard with validated measures and executive insights. Completion is subject to the course-specific proposed policy below; practical evidence is mandatory. Rubric focus: SQL/DAX/Excel checks + BI project rubric. Institute certificate only; external/vendor certification separate. Independent final check: Learner produces the same subject totals before and after reshaping and can explain why a duplicated join key increases rows. Proposed completion: 70% overall and 70% in the portfolio practical; critical accuracy, permission and privacy failures require correction and observed reassessment. This policy needs academic approval before use for awards.
- Then
Data Analytics & Power BI
SQL, data modelling, DAX and dashboards built around business questions.
Portfolio Project: Multi-Branch Business Intelligence Dashboard
How it is checked: Practical work is submitted in the platform as labs and assessments and graded 0 to 100 by a trainer against a published rubric: Excel and SQL practical assignments 20%, Power Query and Data Modelling 20%, DAX and dashboard assessments 25% (including the Power BI practical examination), the final portfolio project 25% and the practical viva 10%. To earn the ADIVAS certificate you need at least 70% overall, at least 60% in the Power BI practical examination, an approved portfolio project and a completed viva. Independent final check: An assessor reproduces key metrics from source files, tests permitted/denied viewer data and reconciles total scheduled minutes to 5400. Proposed completion: 70% overall and 70% in the portfolio practical; critical accuracy, permission and privacy failures require correction and observed reassessment. This policy needs academic approval before use for awards.
- Optional
AI-Assisted Business Data Analysis
Using AI to speed up analysis, with checks on every AI-produced number.
Portfolio Project: Verified business analysis report
How it is checked: For academic approval: 70% overall and 70% Portfolio Project. Correct critical evidence, privacy or permission failures and complete an observed reassessment. Shared responsible-use questions supplement, rather than replace, course-specific practical assessment.
Certificate
ADIVAS issues an institute certificate for each programme when its requirements are met: the course weeks, the graded quizzes and, where recorded, attendance. It is an ADIVAS certificate, not an external or vendor qualification, and anyone can check it with its code.
Career support
Placement assistance for college and working learners: resume builder, AI mock-interview practice, Skill Passport and openings shared with ADIVAS.
We prepare you for employment; we do not guarantee employment.
Batches
No batch for this route is scheduled on the website yet. A counsellor can tell you when the next one starts.
Questions
- How long does this route take?
- The required steps add up to 20 weeks and 186 training hours (about 8–12 hours a week). Optional steps are extra.
- What do I need before I start?
- Basic Excel (entering data, simple formulas). No programming needed to start.
- Will this get me a job?
- An analyst foundation. It does not make you a data scientist. Placement assistance for college and working learners: resume builder, AI mock-interview practice, Skill Passport and openings shared with ADIVAS.
- How much does it cost?
- Fees depend on the programmes and batch you choose. A counsellor shares current fees, batch timings and a suitable learning plan when you ask.
Curriculum outlines are drafts under academic review; a counsellor confirms what the current batch covers. Other routes: AI and Digital Explorer for Children, School AI and Coding Foundations, Software Development for College and Career Learners, Applied Generative AI and AI Development.