0% found this document useful (1 vote)
16 views3 pages

Interactive Data Visualization Project

The project involves creating an interactive data visualization dashboard using Looker Studio based on a provided dataset. Participants must explore, prepare, and visualize the data, including at least five meaningful visualizations and a summary slide with key insights. The final submission includes a PDF with a link to the dashboard and is due by July 25, with a presentation scheduled for July 26.

Uploaded by

sulianto.liang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (1 vote)
16 views3 pages

Interactive Data Visualization Project

The project involves creating an interactive data visualization dashboard using Looker Studio based on a provided dataset. Participants must explore, prepare, and visualize the data, including at least five meaningful visualizations and a summary slide with key insights. The final submission includes a PDF with a link to the dashboard and is due by July 25, with a presentation scheduled for July 26.

Uploaded by

sulianto.liang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Project Visualization

DSC-AI Batch 34 – Qarir Generator

Objective:

In this project, you will create an interactive data visualization dashboard using
Looker Studio based on the dataset assigned to you. The goal is to extract
meaningful insights and communicate them visually in a clear, engaging, and
informative way.

This dataset will also be reused later in your machine learning project, so use this
opportunity to get familiar with its structure and patterns.

What You Need to Do:

1. Explore and understand your dataset

o Review columns, data types, value distributions, and potential


issues (e.g., missing values).

o Identify potential questions the data can answer.

2. Prepare the data

o Upload the dataset to Google Sheets (or BigQuery, if you're

comfortable). o Clean or reshape the data if needed before connecting to

Looker Studio.

3. Create a dashboard in Looker Studio


Your dashboard must include:

o A clear title and short description of the dataset.

o At least 5 meaningful visualizations, using appropriate chart types


(bar, line, pie, table, etc.).

o Filters or controls (e.g., dropdowns, date ranges, categories) to


enable interactivity.

o Visuals that highlight interesting trends, patterns, or

comparisons. 4. Create a short summary slide (PDF)


o A 1–2 page slide with key takeaways or insights from your dashboard.

Think of it as a short executive summary for someone who doesn't


o
explore the dashboard themselves.
Suggested Analysis Ideas (can vary depending on your

dataset): • Trends over time

• Correlations between variables

• Distribution of key metrics by region, category, gender, etc.

• Outliers or anomalies worth investigating

Submission:

You will need to submit at Google Classroom:

1. A PDF slide containing a public view link to your Looker Studio dashboard
and your summary insight.

2. (Optional but encouraged) A link to the prepared Google Sheet or data source

Submission deadline:

Friday, July 25 at 23:59 WIB

You will also need to present your visualization project in live session on Saturday,
July 26.

Tips:

• Prioritize clarity and usefulness over decoration.

• Use chart types that match the message you're trying to convey. •

Make your dashboard understandable even for non-technical viewers.

Dataset Assignment
No Name Problem Dataset Link

1 Kholidin Regressio Anime Rating [Link]


Alkhalifi n Score estimation op popular-anime/data
Atmadinata

2 Vira Avianti Regressio Uber fares [Link]


n prediction es dataset

3 Sungkono Regressio Social Media [Link]


Eko n Engagement al media-engagement-dataset
Wibowo prediction

4 Muhammad Classificati Rain in Australia [Link]


Kamal Azmi on Prediction set rattle-package/data

5 Maysa Classificati Income category [Link]


Melda on prediction us income-analysis-and-modeling/input
An’umillah

6 Kevin n Diabetes Prediction [Link]


Foristian es health-indicators-dataset

7 Hennie Regressio Steam Games [Link]


n Download ng steam-games-of-all-time/data
Number
estimation

8 Muhammad Classificati Hotel [Link]


Lazuardi on Reservation tel reservations-classification-dataset
Rangkuti Prediction

9 Petra Classificati School Dropout [Link]


Sitanggang on Prediction ut survey-eda-and-prediction

Common questions

Powered by AI

Trends over time can be effectively communicated using line charts and bar charts, which are useful for displaying changes over periods in a visually intuitive manner. Correlations between variables can be depicted using scatter plots which clearly show relationships and clustering of data points, or heatmaps that display correlation coefficients visually. These visualization methods help to highlight the association and patterns between different variables over specific time frames in the dataset .

Interactive controls like filters are important in a data visualization dashboard as they enable users to explore data more deeply, focusing on areas of interest without overwhelming them with information. These controls enhance user engagement by allowing customized views of the data through selections such as date ranges, categories, or specific data segments. This interactivity makes the dashboard versatile and useful for different analytical scenarios and audiences .

Presenting a data visualization project in a live session can enhance understanding and impact by allowing real-time interaction with the audience, explanations of complex insights, and dynamic demonstration of interactivity features. It also provides an opportunity to address questions and clarify misunderstandings immediately. The presenter can guide the audience through the narrative and decision-making process behind the insights, ensuring that the presented data is accurately interpreted and the intended message is conveyed effectively .

A summary slide of a data visualization project can highlight key trends, patterns, and anomalies discovered in the dataset. It could summarize correlations, provide forecasts or predictions, and underscore the most impactful variables or metrics observed. These insights help stakeholders understand the implications of data findings, facilitating strategic decision-making. The slide should distill complex data into clear and actionable information, serving as an essential communication tool for those not delving into the dashboard .

Approaches to preparing and cleaning data before visualization in Looker Studio involve first reviewing the dataset, including columns, data types, value distributions, and addressing potential issues like missing values. The dataset should be uploaded to a platform like Google Sheets or BigQuery. Data cleaning might require reshaping the data, handling missing data points, and ensuring consistent data formatting to facilitate seamless connection and interaction with Looker Studio .

Familiarity with a dataset’s structure and patterns before visualization can significantly benefit a subsequent machine learning project by identifying relevant features, understanding data distributions and anomalies, and preprocessing needs. This groundwork aids in selecting appropriate models and algorithms, by giving insight into feature engineering and variable selection. Recognizing underlying data patterns or anomalies early can lead to more accurate predictive modeling, avoiding pitfalls related to biased or incomplete data .

Challenges in overlaying different visualization components can include cluttered visuals, misinterpretation of data, and difficulty in maintaining coherence. To mitigate these issues, it is important to choose chart types that complement each other and to keep visualizations simple and purposeful. Ensuring that each chart answers a specific question without redundancy, maintaining uniform color schemes, and utilizing interactive features like filters to streamline data views can all aid clarity. Building narrative flow through proper layout and logical grouping ensures insights are effectively communicated .

In creating an interactive data visualization dashboard using Looker Studio, essential components include a clear title and a short description of the dataset, at least five meaningful visualizations using suitable chart types (e.g., bar, line, pie), and interactive features such as filters or controls (e.g., dropdowns, date ranges, categories). Additionally, the dashboard should visually highlight interesting trends, patterns, or comparisons, and a summary slide (PDF) with key insights should be prepared to aid those who might not explore the dashboard directly .

The design and presentation principles greatly influence a dashboard’s effectiveness for non-technical viewers. The use of clear and simple titles, succinct descriptions, intuitive layout, and appropriately chosen chart types are vital for readability and comprehension. Using a minimalistic design devoid of unnecessary decoration helps focus the viewer’s attention on the insights. Clear labeling and consistent color coding aid in visual clarity, ensuring that the dashboard is accessible and understandable without requiring technical expertise .

The selection of chart types critically influences the communication of data insights, as each type conveys different aspects of data effectively. Bar charts are useful for comparison, line charts for trends over time, and scatter plots for showing correlations. Pie charts can display proportions among categories. Selecting inappropriate chart types might obscure data insights and confuse viewers, whereas correct selections enhance clarity and impact by aligning the visualization with the data analysis goals and audience needs .

You might also like