Who should attend
Business analysts, MIS executives, data analysts, managers and reporting professionals.
Prerequisites
Basic Excel and data concepts are helpful. No prior Power BI experience is required.
Learning outcomes
- Connect to files, databases and supported data sources.
- Clean and shape data using Power Query.
- Build a sound data model with relationships and measures.
- Create DAX calculations and interactive reports.
- Publish, refresh and share reports with appropriate permissions.
- Apply visual design and validation practices to dashboards.
Detailed curriculum
8 modules01Power BI ecosystem and data connection
- Power BI Desktop, Service and mobile overview
- Import, DirectQuery and live connection concepts
- Connecting to Excel, CSV, folders and relational databases
- Data source credentials and privacy levels
- Understanding query refresh and data gateway concepts
02Power Query and data preparation
- Power Query Editor and applied steps
- Changing data types, renaming and removing columns
- Filtering, replacing values and handling errors
- Merge and append queries
- Pivot, unpivot, split columns and custom columns
03Data modelling
- Fact and dimension tables
- Star schema and relationship design
- Cardinality, cross-filter direction and active/inactive relationships
- Date table and role-playing dates
- Model cleanup, naming and hidden technical fields
04DAX foundations and measures
- Calculated columns versus measures
- Row context and filter context
- SUM, COUNTROWS, DISTINCTCOUNT and iterators
- CALCULATE and filter modifiers
- DIVIDE, IF, SWITCH and variables
05Advanced DAX and time intelligence
- CALCULATE patterns and context transition
- RELATED, RELATEDTABLE and lookup patterns
- Time intelligence: YTD, MTD, QTD and prior-period comparisons
- Rolling averages, ranking and percentage of total
- Debugging measures and validating calculation logic
06Visualisation and report design
- Choosing appropriate charts and visual encodings
- Cards, tables, matrices, charts, maps and KPI visuals
- Slicers, filters, drill-down and drill-through
- Tooltips, bookmarks and navigation
- Accessibility, layout, colour contrast and mobile layout
07Publishing, refresh and governance
- Publishing reports and workspaces
- Semantic models and report permissions
- Scheduled refresh and gateway overview
- Row-level security concepts and testing roles
- Deployment pipelines and version management overview
08Dashboard project and quality checks
- Translate stakeholder questions into report requirements
- Build executive and operational dashboard pages
- Validate totals against source data and SQL
- Performance analyser and model optimisation basics
- Publish, document and present the dashboard
How you will practise
Learn through instructor-led sessions using realistic, live applications. Then apply each concept through guided assignments on a separate hands-on practice application, with feedback to help you build practical skills and confidence.
Practical exercises and labs
- Build a sales dashboard from Excel/CSV source files.
- Create a star schema and date table.
- Write DAX for revenue, margin, YTD and prior-period metrics.
- Configure slicers, drill-through and role-based visibility.
Capstone project
Create a multi-page business intelligence solution with data preparation, star schema, DAX measures, interactive report, refresh configuration and a documented validation checklist.
Tools and technologies
Power BI Desktop and Power BI Service account/licensing as available. Some sharing, refresh and governance features depend on tenant licence and administrator settings.
Assessment approach
- Module-wise knowledge checks or short practical tasks.
- Hands-on exercise review using an agreed checklist or rubric.
- Final project demonstration and explanation of design decisions, test evidence or outputs, as applicable.
- Completion criteria, attendance requirements and any certificate conditions must be separately approved and published by TrainingRite.
Schedule and fees
Upcoming batch schedules are shared by our TrainingRite team. Please submit an enquiry and our team will contact you by email or phone with the latest schedule. TrainingRite does not publish course fees or discounts on the website. Our counselling team will share the applicable course fee and other details with you by email or phone after you submit an enquiry.
Frequently asked questions
Who should join this course?
Business analysts, MIS executives, data analysts, managers and reporting professionals.
Do I need prior experience?
Basic Excel and data concepts are helpful. No prior Power BI experience is required.
Is the training online?
TrainingRite programmes are delivered online.
Will I get hands-on practice?
Sessions are instructor-led and use realistic applications. You then apply each concept through guided assignments on a separate practice application.
How can I enquire about fees and the next batch?
Fees and batch schedules are not published on the website. Submit the enquiry form on this page and our counselling team will share them with you by email or phone.