Duration: 2 days / 17 hours
Time: 9am to 6pm
Course Code: CRS-Q-0041581-ICT

Funding available for this course:

Enhanced Training Support for SMEs NICF-SF Post-Secondary Education Scheme (PSEA) SkillsFuture Credit SkillsFuture Mid-Career Enhanced Subsidy

 

What Will Be Taught For This Excel Advanced Power BI Training Course?

Take your Power BI knowledge to the next level with this Advanced Power BI, a powerful cloud-based service that helps analyst visualize and share insights from their data. Learn about advanced data visualisation techniques that can take your reports and dashboards beyond the basics. Know how the languages such as M can be used to extend that standard data extraction and transformation capabilities of Power BI.   

 

Statement of Attainment (SOA) from SSG

Participants will receive the SOA from SSG upon completion of training and assessment.

Module 1. Review data visualization tools and techniques

  • Working with PowerBI Desktop
  • Working with PowerBI.com
  • Publishing reports on PowerBI.com
  • Working with Dashboards in PowerBI.com
  • Pinning Visuals, Live Pages
  • Creating Dashboard
  • Sharing Contents among other users

Module 2. Leverage on Power BI Queries

  • Power BI Query Editor as an ETL tool (Extract, Transform, Load)
  • Power BI desktop queries - The Advanced Editor (Using M script)
  • Shaping Data
  • Common Data Shaping techniques
  • Combining Data
  • Append Queries
  • Merge Queries
  • Best practices for Shaping Data

Module 3. Develop Advanced Dashboard with Custom Visuals

  • Importing Custom Visuals of different types
  • Using Custom Visuals to enhance Power BI Reports

Module 4. Correlate Data Visualization with Advanced Modelling

  • Types of Relationships: One-to-Many, Many-to-One, One-to-One
  • Handling Many-to-Many relationships
  • Active-vs-Inactive Relationships
  • Cross-Filter Direction and Its effect on Results
  • Join Types
  • Creating Quick Measures
  • Working with DAX functions
  • DAX Functions categories
  • Time Intelligence Functions

Module 5. Discover trends for Data Visualizations

  • Good practices for creating Data Visualizations
  • Creating Power BI reports with suitable Data Visualizations
  • Working with properties of Data Visualization
  • Understanding and changing Interactions of Data Visualizations

Assessment is conducted at the end of the course. Participants must complete and be assessed as competent (Passed) for the award of SOA from SSG.

Assessment Format & Duration (only applicable for learner taking SF grant)

Assessment Mode Duration
Practical Performance Summative 60 mins
Written Assessment Summative 60 mins
Total 120 mins

Who Should Attend This Excel Power BI Training?

Business User, Data Analyst or Professional who needs to observe changes in data patterns, understand the performance of their investments and illustrate it through a dashboard.

Pre-requisite

  w/o GST w GST
Course Fee $1,700 $1,819
Singapore Citizen & PR aged ≥ 21 years $1,445 $1,564
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$850 $969

 

  w/o GST w GST
Course Fee $1,700 $1,819
Singapore Citizen & PR aged ≥ 21 years $1,445 $1,564
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$850 $969

 

  w/o GST w GST
Course Fee $1,700 $1,819
Singapore Citizen & PR aged ≥ 21 years $850 $969
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$850 $969

 


Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.







Please click on the course date to enrol.


  • CL: Classroom Learning
  • VILT: Virtual Instructor-Led Training
  • GTR: Guaranteed To Run
  • Sat: Saturday
  • Wkn: Weekend
Note: Courses are conducted via classroom unless stated otherwise beside the course dates.