Data & Analytics
Power BIBasic to Advanced
Turn raw data into interactive business dashboards with Power Query, data modelling and DAX.
Course overview
Power BI is Microsoft's business intelligence platform, used by organisations of every size to report and analyse data.
You will learn the complete workflow — connecting to data, transforming it with Power Query, building a proper data model, writing DAX measures, designing reports and publishing them to the Power BI service.
Who is this course for?
- Students aiming for data analyst or BI roles
- Excel users who want to scale up their reporting
- Professionals responsible for business reporting
Prerequisites
- Basic Excel knowledge is helpful
- SQL knowledge is helpful but not required
What you will learn
- Connect Power BI to common data sources
- Clean and shape data in Power Query
- Model data using a star schema
- Write DAX measures and time intelligence
- Design clear, interactive reports
- Publish and share in the Power BI Service
Module structure
01Power BI Foundations
- Power BI Desktop overview
- Connecting to data sources
- Report basics
02Power Query
- Data cleaning and shaping
- Merging and appending
- Parameters
03Data Modelling
- Star schema
- Relationships
- Date tables
04DAX
- Calculated columns vs measures
- CALCULATE and filter context
- Time intelligence
05Report Design
- Visual best practices
- Drill-through and bookmarks
- Dashboard storytelling
06Publishing & Sharing
- Power BI Service
- Workspaces and sharing
- Scheduled refresh concepts
Module sequence and depth may be tailored to the batch level. Detailed syllabus available on enquiry.
Hands-on learning
- End-to-end dashboard on a business dataset
- DAX measure exercises
- Report design review
Tools & technologies
- Power BI Desktop
- Power BI Service
- Power Query
- DAX
Learning outcomes
01
Build clean data models
02
Write practical DAX measures
03
Design interactive dashboards
04
Publish and share reports
Duration, mode, batches & certificate
Duration
Shared on enquiry
Current batch schedule shared on enquiry.
Training mode
Online / Offline / Hybrid
Availability varies by batch.
Batches
Weekday & Weekend
Choose weekday or weekend (Sat & Sun) classes.
Certificate
Completion certificate
Issued on completing programme requirements.
FAQ
Power BI — FAQs
What is the batch size for Power BI?
Batches are kept small, so each learner gets focused guidance and time for questions.
Will I receive a certificate?
Yes. Learners who complete the programme requirements receive a verifiable course completion certificate from Sarng Infotech.
What is the duration and fee?
Batch schedules and fees are shared on enquiry, as they depend on the mode and batch you choose. Send us an enquiry and our team will share the current details.
Explore more courses
Ready to start Power BI?
Small batches. Better learning. Talk to us about the next batch.