Explain and apply the core concepts across 9 structured modules.
E×T Under Edunivra Pvt Ltd & 369 Tesla
KBI-112Intermediate · Tamil and English
Power BI and Business Analytics
Turn operational data into trustworthy SQL, DAX and Power BI insights.
7Weeks
9Modules
19Classes
50Topics
Live learningTamil + English
Course projectPortfolio ready
Course overview
A complete, classroom-ready learning structure.
This course is organised as a guided sequence of concept classes, instructor demonstrations, hands-on labs, debugging sessions and project reviews. Every class produces visible learning evidence.
Recommended effort84 hours
Structured class time24 hours
Course fee₹9,999
CertificateCourse certificate
Learning outcomes
What you will be able to do.
Outcomes connect the syllabus to demonstrable skills, assessment evidence and the final course project.
Complete 19 guided classes covering 50 syllabus topics.
Use professional tools, debugging methods and secure development practices appropriate to the course.
Plan, build, test and present the course project: Build student, admission, fee and business-performance dashboards.
Complete syllabus
9 modules · 19 classes · 50 topics
Open any module to see its full class-by-class teaching structure and covered topics.
Theory
Guided lab
Workshop
01 Analytics Fundamentals2 classes · 5 topics · 3 hours
2 focused classes covering 5 curriculum topics through explanation, demonstration and guided practice.
Class 1: Data, Metrics
DataMetricsKPIs
Class 2: Business questions, Data quality
Business questionsData quality
02 Excel2 classes · 6 topics · 3 hours
2 focused classes covering 6 curriculum topics through explanation, demonstration and guided practice.
Class 1: Formulas, Lookups
FormulasLookupsCleaning
Class 2: Pivot tables, Charts
Pivot tablesChartsReports
03 SQL Analytics3 classes · 7 topics · 5 hours
3 focused classes covering 7 curriculum topics through explanation, demonstration and guided practice.
Class 1: Select, Where
SelectWhereGroup by
Class 2: Joins, Subqueries
JoinsSubqueriesCTEs
Class 3: Window functions
Window functions
04 Power Query2 classes · 6 topics · 3 hours
2 focused classes covering 6 curriculum topics through explanation, demonstration and guided practice.
Class 1: Import, Clean
ImportCleanTransform
Class 2: Merge, Append
MergeAppendRefresh
05 Data Modelling2 classes · 5 topics · 3 hours
2 focused classes covering 5 curriculum topics through explanation, demonstration and guided practice.
Class 1: Fact tables, Dimension tables
Fact tablesDimension tablesRelationships
Class 2: Star schema, Calendar table
Star schemaCalendar table
06 DAX2 classes · 6 topics · 3 hours
2 focused classes covering 6 curriculum topics through explanation, demonstration and guided practice.
Class 1: Measures, Calculated columns
MeasuresCalculated columnsFilter context
Class 2: Time intelligence, Ranking
Time intelligenceRankingPercentages
07 Visualisation2 classes · 6 topics · 3 hours
2 focused classes covering 6 curriculum topics through explanation, demonstration and guided practice.
Class 1: Charts, Cards
ChartsCardsTables
Class 2: Slicers, Drill-through
SlicersDrill-throughTooltips
08 Power BI Service2 classes · 5 topics · 3 hours
2 focused classes covering 5 curriculum topics through explanation, demonstration and guided practice.
Class 1: Workspaces, Publishing
WorkspacesPublishingSharing
Class 2: Refresh, Row-level security
RefreshRow-level security
09 Application Integration2 classes · 4 topics · 3 hours
2 focused classes covering 4 curriculum topics through explanation, demonstration and guided practice.
Class 1: Reporting views, API integration concepts
Reporting viewsAPI integration conceptsEmbedded reports
Class 2: Native dashboard fallback
Native dashboard fallback
Course project
Turn the syllabus into portfolio evidence.
Build student, admission, fee and business-performance dashboards.
1Plan2Build3Test4Present
Required evidence
- Requirement and architecture notes
- Working source-code repository
- Testing and security checklist
- Live demonstration and technical viva
Class structure
Every week moves from knowledge to proof.
The same repeatable cycle keeps classroom delivery consistent while giving learners enough time to understand, practise, build and review.
Learn
Concept class, visual architecture and instructor demonstration
Practice
Guided coding, exercises, code reading and debugging
Build
Feature implementation, module task and repository update
Test
Knowledge check, coding assessment and viva
Deploy
Documentation, security review and presentation
Seven-day rhythm
A balanced teaching, lab and portfolio schedule.
- Day 1 · Theory and concept class
- Day 2 · Instructor coding demonstration
- Day 3 · Student coding lab
- Day 4 · Real application development
- Day 5 · Assignment and debugging
- Day 6 · Revision, test and project review
- Day 7 · Self-learning and portfolio update
Under Edunivra Pvt Ltd & 369 Tesla
Create learner account
Ready to start KBI-112?
Join the complete advanced-diploma roadmap or begin with this focused course.