Welcome to LookerStudio101, where you’ll learn to harness the power of Looker Studio (formerly Google Data Studio) to build stunning, interactive dashboards. Dive into two real-world labs—disaster analysis and healthcare data visualization—designed to sharpen your dashboard-building skills and transform data into insightful reports.
Explore the Looker Studio lecture slides for each lab:
🌟 Basic LookerStudio101 View Slide: Basic_LookerStudio101.pdf
🚀 Advanced LookerStudio101 N/A
Teerapong Panboonyuen (P’Kao), Ph.D.
In this lab, you’ll create a global disaster dashboard, exploring data on tsunamis, floods, and earthquakes. Your goal is to visually represent disaster occurrences around the world—map the locations, analyze the severity, and gain actionable insights to help address global challenges.
You can download the dataset for global disaster data here: Download Disaster Dataset (CSV)
In this lab, you’ll create a dashboard to visualize Thailand’s clinical resources. The focus is on mapping and analyzing healthcare facilities, resources, and their distribution across Thailand, helping users make informed decisions regarding the healthcare landscape.
You can download the dataset for clinical resources here: Download Thailand Clinical Resources Dataset (CSV)
For Assignment 1, you’re free to choose any public dataset (or your own, like YouTube analytics, Shopee/Lazada sales, etc.). The task is simple: ask 5 meaningful questions about your data and use Looker Studio to create a dashboard that visually answers them.
git clone https://github.com/kaopanboonyuen/LookerStudio101.git
cd LookerStudio101
Make sure to download the CSV files for the labs:
Sign in to Looker Studio and begin building your interactive dashboards. If you need assistance, consult the Lecture Slides.
For each lab, you will:
To further enhance your skills, refer to these resources:
We love contributions! Fork the repository, submit issues, and make pull requests. If you have suggestions for improvement, don’t hesitate to open an issue or reach out.
This project is licensed under the MIT License - see the LICENSE file for details.
The datasets and lecture materials provided in this repository are for academic use only, intended solely for classroom instruction. Some datasets may contain personal or sensitive information, and users must comply with all applicable data protection regulations, including the Personal Data Protection Act (PDPA). Any data scraped from platforms such as Twitter is for educational purposes only and must not be used for commercial or unauthorized activities.
Redistribution, modification, or public sharing of these materials without explicit permission is prohibited. By using these resources, you agree to follow these guidelines and understand that any misuse may result in academic or legal consequences.