Course Details
Course Details
What You'll Learn
Topic 1: Perform Data Analysis and Visualization with Google Sheet
Data types and data validation
Functions and formulas
Lookup and Index match
Data sort and filters
Pivot tables
Charts
Topic 2: Develop Dashboards and Reports with Looker Studio
Connect to data sources
Create tables and charts
Create dashboards and reports
Methods of aggregating data
Topic 3: Enhance Visuals with Interactive Dashboards
Slicer and visualization filters
Custom calculations
Case studies
Sharing and reporting
Assessment
- Written Exam
- Practical Exam
Course Info
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Year Group : 21-65 years old
Minimum Software/Hardware Requirement
Software:
You will need the following for this course:
Hardware: Windows PC or Mac laptop
Funding Eligibility Criteria
Self-sponsored learners (individuals)
- Singapore Citizens and Singapore Permanent Residents aged 21 and above.
- Up to 50% course fee funding. Singapore Citizens aged 40 and above receive up to 70% under the Mid-career Enhanced Subsidy (MCES).
- Singapore Citizens aged 25 and above can pay the remaining fee with SkillsFuture Credit.
Company-sponsored learners
- Singapore Citizens and Singapore Permanent Residents who are direct employees of the sponsoring company.
- Up to 50% course fee funding, or up to 70% for employees of SMEs (Enhanced Training Support for SMEs) and for Singapore Citizens aged 40 and above. An SME has no more than 200 employees or an annual turnover of no more than $100 million.
- Employers can also claim Absentee Payroll funding for employees who attend during working hours.
- Eligible companies can offset their out-of-pocket fees with SkillsFuture Enterprise Credit (SFEC).
Conditions for all funded learners
- Attendance is taken digitally with Singpass for every session, including the assessment.
- You must complete the course and pass all assessments (assessed as Competent).
- If these conditions are not met, the funding is clawed back and the learner or employer pays the full course fee.
- 9% GST is charged on the full course fee before funding.
- Promo and discount codes cannot be used on funded courses.
- Any balance after funding can be paid in cash, with SkillsFuture Credit, with PSEA (Singapore Citizens with a PSEA), or partly reimbursed by UTAP for NTUC members.
How to Apply SkillsFuture Credit Claim for Individuals
Singapore Citizens aged 25 and above can use their SkillsFuture Credit (base tier) to pay the course fee after funding. The $4,000 mid-career top-up cannot be used for this course.
- Register for this course as self-sponsored and tell us you will use SkillsFuture Credit. Do not pay the amount you plan to claim.
- We email you an invoice showing the course fee after funding.
- From 60 days before the course starts, and no later than the course start date, log in to MySkillsFuture with Singpass and click Claim credits.
- Click Submit a Claim and search for this course by its course code, TGS-2024049213.
- Select your class start date, enter the course fee payable after funding and the amount of credit to claim, then upload the invoice (PDF, JPG or PNG, under 4MB).
- Review, accept the terms and click Agree and Submit. The credit is paid directly to us; processing can take up to 14 working days.
Changing or withdrawing: cancel the claim on MySkillsFuture at least one day before the course starts. If your class date changes, cancel the claim and submit a new one with the new date.
How to Apply SkillsFuture Enterprise Credit (SFEC)
SFEC helps companies pay for employee training. The current SFEC ends on 30 November 2026, and a redesigned SFEC starts on 1 December 2026.
Current SFEC: classes ending on or before 30 November 2026
- Eligible companies received a one-off $10,000 credit, notified by letter to their Corppass administrator. Eligibility generally required at least 3 Singapore Citizen or PR employees and Skills Development Levy contributions.
- SFEC covers up to 90% of the company's out-of-pocket course fee after other subsidies.
- Check your company's SFEC eligibility and balance on EnterpriseSG.
- Register your Singapore Citizen or PR employee for a class that ends by 30 November 2026, as company-sponsored, and pay the course fee after funding.
- Your employee attends and completes the course. We submit the attendance and assessment results to SWDA.
- No separate claim is needed. SFEC is calculated automatically once the course fee grant is approved and is paid quarterly to your company's IRAS GIRO or PayNow Corporate account.
Any unused balance of the current SFEC expires on 30 November 2026.
Redesigned SFEC from 1 December 2026
Companies with at least 3 resident employees receive a fresh $10,000 in an online SFEC wallet that offsets out-of-pocket fees upfront at enrolment, instead of reimbursing them afterwards. SWDA has not yet published the support rates and claim steps; see OurWorkforce or our SFEC guide.
How to Apply UTAP (NTUC Members)
NTUC members can claim 50% of the unfunded course fee under the Union Training Assistance Programme (UTAP), capped at $250 a year (aged below 40) or $500 a year (aged 40 and above). The cap is shared with UTAP claims for AI tool subscriptions.
Eligibility: you must be an NTUC member paying full membership fees, with your membership paid up before and during the course and when you claim. The course must not be fully paid for by your employer or another source.
- Make sure your NTUC membership is paid up before the course starts.
- Register for this course with us and pay the course fee after funding and SkillsFuture Credit.
- Attend at least 75% of the course and sit all assessments.
- Within 6 months after the course ends, go to the NTUC U Portal, open UTAP under E-services, log in with Singpass and choose Course Fee Claim.
- Enter the nett course fee you paid (after all subsidies and SkillsFuture Credit, including GST), and upload your invoice or receipt and your certificate or result slip (PDF, JPG or PNG, up to 5MB each).
- NTUC usually pays the claim within 4 weeks of submission.
Read more in our UTAP guide.
How to Apply PSEA
Singapore Citizens with a Post-Secondary Education Account (PSEA), which stays open until around the year you turn 31, can use it to pay the course fee after funding for PSEA-approved courses. You can also use a sibling's PSEA after your own has been used up.
- Check that this course shows the PSEA tag on its MySkillsFuture page.
- Check your PSEA balance on MOE's Student Finance System with Singpass.
- Download and complete the PSEA withdrawal form, then submit it to us.
- We submit the withdrawal request to MOE. You (and your sibling, if you are using their account) authorise it in the Student Finance System. Nothing is withdrawn without this authorisation.
- MOE pays us directly. If you have already paid, we refund the amount covered by PSEA.
More details: MOE PSEA overview.
Appeal Process
If you disagree with an assessment decision, you have the right to appeal.
- When the assessor gives you feedback, say whether you agree with the outcome. If you agree, you and the assessor sign the Assessment Summary Record; if you disagree, do not sign it.
- Discuss the decision with the assessor or the assessment manager first.
- If you are still not satisfied, tell the assessor you intend to appeal. The assessor records this in the feedback section of the Assessment Summary Record and informs the assessment manager.
- Lodge your appeal within 7 days, giving your reasons, using the Candidate Appeal Form. The assessor can help you write and lodge it.
- An Assessment Appeal Panel reviews the information from you and the assessor and makes a decision. A record of the appeal and its outcome is kept.
- You will be told the outcome within 2 weeks of lodging the appeal. The panel's decision is final.
Trainers
Trainers
Dr. Alvin Ang is a data science consultant and trainer with deep expertise in analytics, visualization, and applied statistics. Holding a Ph.D. in Operations Research from Nanyang Technological University, he has trained learners in Python, Power BI, Tableau, and Excel Analytics at Tertiary Infotech and lectured extensively in universities such as SUSS and Curtin Singapore. His industry experience includes roles as a data science instructor at IBM and a principal consultant at Embrio Enterprises, where he designed and implemented analytics frameworks for large-scale data initiatives.
With a passion for democratizing data skills, Dr. Ang founded the DataFrens community to foster collaboration among data professionals. His instructional approach emphasizes clarity, problem-solving, and practical application of analytics concepts. In “Enhance Data Insights with Google Sheets and Looker Studio,” he brings his expertise in data visualization and dashboarding to help learners transform raw data into meaningful insights that drive business intelligence and storytelling.
Dr. Alfred Ang is the Founder and Chief Training Officer of Tertiary Infotech Pte Ltd, with over 20 years of experience spanning IT, data analytics, AI, and education technology. He holds a Ph.D. from the National University of Singapore, M.Eng and M.Sc degrees from NTU, and multiple certifications including DACE, ACTA, and GCWLP from IAL. As a curriculum developer and consultant, he has co-developed over 130 WSQ and IBF-accredited courses in analytics, finance, cybersecurity, and programming.
Dr. Ang is a pioneer in designing SkillsFuture and IBF-aligned data analytics programs, and his leadership has shaped training delivery standards in Singapore’s adult learning ecosystem. His broad expertise in data storytelling, visualization, and machine learning ensures that participants in “Enhance Data Insights with Google Sheets and Looker Studio” receive training that is both technically rigorous and industry-relevant, bridging analytics theory with practical, hands-on insight generation.
Review
Customer Reviews (10)
- Average Rating: 4.0/5 Review by Course Participant/Trainee
-
NA (Posted on 3/12/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 7/12/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - wiil recommend Review by Course Participant/Trainee
-
. (Posted on 7/11/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 4/30/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - will recommend Review by Course Participant/Trainee
-
. (Posted on 1/22/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses
- Related Courses