Duration: 2 days
Time: 9am to 6pm

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.

Self Sponsored

  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
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)		 $125.50 $195.50

  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
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)		 $125.50 $195.50

  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
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)		 $125.50 $195.50

Remarks:

COMAT is a business centre of e-Services, Electronics, ST Engineering.

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • This course is eligible for using PSEA funds.

Company Sponsored

  • Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
  • Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr
  • Absentee payroll claimable by companies (SMEs and Non-SMEs) sponsoring candidates under WTS Scheme: Up to 95% of hourly basic salary (no dollar cap)

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attain minimum 75% attendance and pass all assessment(s) within 3 months to qualify for funding.
  • Trainee undertakes to reimburse e-Services, Electronics, ST Engineering FULL course fees should he/she be ineligible for course fee grant. e-Services, Electronics, ST Engineering is not liable for any other funding not approved by WSG.
  • e-Services, Electronics, ST Engineering reserves the right to change the date or venue without prior notice.
  • e-Services, Electronics, ST Engineering reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.