Bridging the gap between data and business requires tools and strategy. This course empowers participants to combine data modelling, storytelling, and interactive dashboards using Power BI. They will gain applied skills by working with real-world datasets and building custom solutions.
Learning Outcomes:
Develop advanced Power BI dashboards using DAX and custom visuals
Implement data modelling techniques for performance and scalability
Apply filters, slicers, and bookmarks for dynamic storytelling
Optimise visuals and layouts for clarity and user experience
Key Topics:
Power BI data preparation and transformation
Advanced DAX calculations and time intelligence
Visual design best practices and interactivity features
Report performance tuning and optimisation
FUNDING INFORMATION
SkillsFuture Singapore (SSG)
Funding is available on Course Fee. Please see below for the eligibility categories available.
| Self-sponsored | Singapore Citizen & PR aged ≥ 21 years | Up to 50% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding | |
| Company Sponsored (Non-SME) | Singapore Citizen & PR aged ≥ 21 years | Up to 50% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding | |
| Company Sponsored (SME) | Singapore Citizen & PR aged ≥ 21 years | Up to 70% funding |
| Singapore Citizen aged ≥ 40 years | Up to 70% funding |
SSG Funding Requirements
- Trainees must scan their attendance twice daily using the SingPass application.
- Trainees must attain at least 75% attendance.
- Trainees must pass the in-house assessment to be eligible for funding.
- Trainee and/or sponsoring company is/are required to meet all SSG-mandated eligibility criteria and requirements for funding. For more information, please refer to SkillsFuture homepage.
Appeal Policy and Procedure
- As a candidate in this course assessment, you may appeal your results if you disagree with them.
- To do so, submit your written appeal request via email to esv_comat_cse@stengg.com within 3 working days from date of assessment.
Cancellation, Postponement and Refund Policy
- Request for cancellation or postponement must be submitted in writing more than 4 weeks before the class start date to avoid any charges.
- Written notice for cancellation or postponement received 2 to 4 weeks before class start date will incur Late Cancellation Charge - 50% of course fee.
- Written notice for cancellation or postponement received less than 2 weeks before class start date will incur Late Cancellation Charge - 100% of course fee.
- If payment has been made and ST Engineering e-Services Pte Ltd accepts the trainee's written notification to cancel or withdraw from the course, ST Engineering e-Services Pte Ltd will issue a refund, less any applicable Late Cancellation Charges.
Feedback Policy and Procedure
- You may submit feedback via email to esv_comat_cse@stengg.com or your servicing Account Manager.
- Any formal feedback will be handled within 10 working days from receipt with a written reply given. An interim reply will be provided should more time be required.
Module 1. Data Preparation In Power BI
- Upload Data from A Folder
- Import PDF Data
- Query from a Database
Module 2. Advanced Data Transformations
- Merge Queries
- Append Queries
- More On ETL (Extract Transform Load) Tool
Module 3. Modelling Data
- Model Relationship In Power Bi Desktop
- Configure Tables
- Cross Filter Direction
Module 4. Create DAX (Data Analysis Expression) Calculations
- Create Calculated Columns
- Create Measure Tables
- Create Date Table
- Relationship Functions
- Aggregation Functions
- Date And Time Functions
- Time Intelligence Functions
- Using Quick Measures
Module 5. Customize Visuals To Present Data
- Create AI Visuals
- Apply conditional Formatting
- Sync Slicers
- Enhance Visual Interactions
- Apply Themes
- Use Bookmarks & Buttons
Module 6. Reveal Insights with Power BI
- Publish Reports to Power BI Service
- Creating Dashboards
- Sharing Dashboards
- Schedule Refresh Data
- View data insights on Dashboard tiles
