Duration: 2 days / 16.5 hours
Time: 9am to 6pm
Course Code: CRS-Q-0039318-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 Union Training Assistance Programme (UTAP) 

 

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

The demand for visual analytics in business processes, for quick and informed decision-making, is ever increasing. Data is produced at an incredible rate and the ability to collect and store the data is increasing at a faster rate than the ability to analyse it. Data visualization has proved its worth as a crucial tool in today’s data focused business world. When it becomes difficult to understand complex data, resorting to the uncomplicated language of data visualization helps simplify it to an easy grasp manner.

This two-days instructor-led course provides students with the knowledge and skills analyze data with Power BI. Use Power BI Desktop to connect to data (usually multiple data sources), shape that data (with queries that build insightful, compelling data models), and use that model to create reports (which others can leverage, build upon, and share). Power BI Desktop centralizes, simplifies, and streamlines what can otherwise be a scattered, disconnected, and arduous process of designing and creating business intelligence repositories and reports.

 

Statement of Attainment (SOA) from SSG

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

Module 1. Identify Self-Service BI Solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Labs

Module 2. Explore Power BI Data

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service
  • Labs

Module 3. Apply Shaping and Combining Data Techniques

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Labs

Module 4. Apply Modelling Data Skillset

  • Relationships
  • DAX queries
  • Calculations and measures
  • Labs

Module 5. Develop Interactive Data Visualizations

  • Creating Power BI reports
  • Managing a Power BI solution
  • Labs

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 30 mins
Total 90 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

  • Working knowledge of Microsoft Office Excel.

  • Participants must be able to perform the following in Excel:
    • Create PivotTable
    • Create Charts
    • Work with formulas such as SUM, AVERAGE, COUNT, MAX, MIN, SUMIF, VLOOKUP, etc.
  w/o GST w GST
Course Fee $1,000 $1,070
Singapore Citizen & PR aged ≥ 21 years $752.50 $822.50
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$175 $245

 

  w/o GST w GST
Course Fee $1,000 $1,070
Singapore Citizen & PR aged ≥ 21 years $752.50 $822.50
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$175 $245

 

  w/o GST w GST
Course Fee $1,000 $1,070
Singapore Citizen & PR aged ≥ 21 years $175 $245
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$175 $245

 


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.