Certificate Course in Business Analysis and Power BI
Turn raw business data into decisions using Power Query, data modelling, DAX and Power BI.
Includes the four-day Beginner to Advanced Excel course free of charge.
Programme snapshot
- Qualification
- Certificate
- Subject
- Data & Analytics
- Duration
- Two months
- Study mode
- Online live
- Medium
- Sinhala, with English technical terminology
- Schedule
- Live evening sessions, with all sessions recorded to the LMS
- Entry requirements
- No prior analytics experience required.
- Certification
- TVEC-approved Certificate awarded by Starliks Campus
- Course fee
- Rs. 20,000/- (normal fee Rs. 30,000/-)
40% discount for the current batch
What you will learn
- Clean and reshape data with Power Query — split, merge, unpivot, append and merge queries
- Build a well-structured data model: star schema, fact and dimension tables, relationship types
- Write DAX — calculated columns, measures, RELATED, time intelligence (YTD, QTD, MTD, PY) and iterators
- Design dashboards: charts, matrices, cards and KPIs, slicers, bookmarks, drill-through and maps
- Publish to the Power BI Service, schedule refresh, manage access and apply row-level security
- Use AI assistance to write DAX and speed up report building
Course structure
Taken from the official programme brochure.
Introduction & business analysis architecture
The Power BI ecosystem, Desktop, Service and Power Query, plus the course plan and installation.
Power Query
Data sources, data types, transformations, splitting and grouping, pivot and unpivot, appending and merging.
Power BI data modelling
Star versus snowflake schema, fact and dimension tables, and the relationship between Power Query, the model and DAX.
DAX
Calculated columns versus measures, aggregation and conditional logic, time intelligence and iterators.
Data visualisation
Visualisation principles, core visuals, advanced formatting, hierarchies, slicers, bookmarks, maps and mobile layout.
Publishing & the Power BI Service
Publishing, dataset management, subscriptions, scheduled refresh, gateways, sharing and row-level security.
Add-on features
The route to Microsoft Power BI certification and supporting tools for better dashboards.
Who this is for
- Working professionals
- Finance and accounting staff
- Career changers
- Managers who report on data
Where it can take you
Roles this qualification is designed to prepare you for.
- Business Analyst
- Data Analyst
- MIS Executive
- Finance Analyst
- Management Reporting Executive
Your lecturer
Power BI · Business analysis · Financial managementRelated programmes
Certificate Course in Beginner to Advanced Excel
Four intensive days that take you from the Excel ribbon to PivotTables, Power Query and macros.
Professional Certificate in Power Apps & Power Automate
Build solutions, automate work and drive efficiency on the Microsoft Power Platform.
Certificate in Agentic AI & Machine Learning
From ideas to intelligent solutions — learn, build and automate.
Ready to start your journey?
Apply now, or talk to us first — whichever suits you.