Enhance Data Insights with Google Sheets and Looker Studio
About This Course
This course is designed to help participants harness the full potential of Google Sheets and Looker Studio for data visualization and analysis. Learn to manipulate data using various functions, formulas, and pivot tables, and create visually compelling charts to present data trends and insights effectively. Gain hands-on experience in structuring data using sorting and filtering techniques, performing advanced data validation, and utilizing lookup functions for comprehensive analysis.
Participants will also master the art of developing dynamic dashboards with Google Looker Studio to address key stakeholder queries. Learn to connect to various data sources, build interactive tables and charts, and create impactful reports. The course will also cover designing interactive data displays with strategic mapping techniques and filters, applying custom calculations, and sharing insights through well-crafted, engaging dashboards.
What You'll Learn
LO1: Perform data visualization and analysis using Google Sheets to present data trends and findings.
LO2: Develop dashboards using Google Looker Studio to address key stakeholder questions.
LO3: Design interactive data displays with strategic mapping techniques for enhanced user experience.
Course Outline:
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
Entry Requirements
Knowledge and Skills
• Able to operate using computer functions
• 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 Age Group: 21-65 years old