Dynamic Data Profiling Dashboard with Streamlit and Google Sheets

Stay ahead with real-time insights by mastering dynamic data profiling dashboard creation.

  • Schedule

    23 – 25 July 2024

    18.30 – 21.30 (WIB)

  • Online-Interactive Learning

    Via Zoom

  • Investment

    Rp. 1.500.000

Course Summary

Data profiling and visualization play a crucial role in decision-making across various industries. However, the dynamic nature of data sources like Google Sheets presents challenges in maintaining real-time insight and efficient analysis. To address this, the integration of dynamic data into a streamlined dashboard using tools like Streamlit and Google Sheets become essential.

In this 3-day online workshop, participants will dive into the fundamentals of data profiling and dashboard creation. The workshop is designed for beginners, providing a step-by-step guide from data integration to advanced dashboarding techniques using Streamlit. By the end of the workshop, participants will be able to create dynamic data profiling dashboards that are integrate seamlessly with Google Sheets, enabling real-time updates and actionable insights.

Learning Outcomes

Upon completion of this workshop, you will be able to:

  • Work with Streamlit and Pandas to integrate dynamic data from Google Sheets into a dashboard
  • Understand the basics of data profiling for an informative dashboard
  • Develop a dynamic data profiling dashboard that provides real-time insights
  • Apply best practices in creating efficient and user-friendly dashboards


This is an optional material that will be delivered on the first day of the workshop. You can skip the first day if you have strong Python programming basics. What you will learn on the first day:

  • Setting up the project environment
  • Introduction to Python for data science
  • Working with Jupyter Notebook Environment
  • Understanding basic programming in Python
  • Basics of data profiling and visualization using ydata-profiling
  • Exploring data patterns and correlations
  • Further customization on ydata-profiling parameters
  • Introduction to Streamlit for interactive web applications development
  • Exploring Streamlit APIs for building dynamic apps
  • Connecting and integrating Google Sheets data with Streamlit
  • Developing dynamic data profiling dashboards
  • Deploying Streamlit apps for production
  • Best practices for maintaining and updating dynamic dashboards


This testimonial video is taken after our previous Online Data Science Series: Time Series Analysis for Business Forecasting.


Our learning format is online-interactive, you will feel the interactive experience as if you were present in a physical classroom. You can access the class using your Zoom account on pre-defined dates.


    Zoom recording, course Books (PDF & HTML files), the dataset for practice, reference notes, and working files are accessible through our Learning Management System account.


    Show current and prospective employers of your mastery in computer vision with a signed certificate of completion.


    Be a part of our data-passionate community with 5000+ members and 1000+ alumni.


Workshops in this series are tailored to casual programmers and non-programmers that are taking their first steps into data science. It assumes no prior knowledge or academic background, and attendees will be introduced to the beautiful art of writing R / Python code to produce data visualization and build machine learning models. The workshop has a gentle learning slope that is designed with non-technical professionals and academics in mind.

Yes, you can still attend the workshop as it is a beginner-friendly workshop.

Our system will send you an email containing a link and details to join a Google Classroom.

Online learning will be conducted via Zoom.us, Link to join the Zoom Class will be announced via Google Classroom.

Learning materials can be obtain via Google Classroom

Yes, you will receive a certificate of completion.


Dwi Gustin Nurdialit

Dwi Gustin Nurdialit is a Senior Data Science Instructor with over 3 years of experience using programming languages like R, Python, and SQL. She has excelled as a lead instructor in numerous corporate training sessions spanning diverse industries, including finance, retail, logistics, mining, and telecommunications. Dwi also plays a key role as a course producer, creating materials for corporate training programs, focusing on data visualization, machine learning, and Large Language Models (LLM). Her passion lies in making data science accessible and practical for everyone.