analytics
Portafolio de Iván
Projects chevron_right Storytelling & Integration
workspace_premium Flagship project terminal SQL + Python table_chart_view Looker Studio public 5 regions

Visual storytelling case

Storytelling & Integration

A visual storytelling case built from trending_by_time.csv. The project cleans, structures, and visualizes trending videos by category, region, and date so a large dataset becomes a clear public-facing exploration experience in Looker Studio.

Trending videos

339,990

The dashboard summarizes the total visible volume analyzed across the selected time window.

Categories

18

Side-by-side category comparison makes it easier to spot dominance and publishing patterns.

Time span

7 months

From November 14, 2017 to June 14, 2018, with cross-reading by time and region.

dashboard Open dashboard code View repository arrow_back Back to Projects
auto_graph Interactive dashboard

Guiding question

"Which categories dominate the trends, and how do they change by region and time?"

Inputs

Trending video dataset, Python cleaning notebook, date conversion, and preparation for visual analysis.

Outputs

Public Looker Studio dashboard, support PDF, and an accessible reading flow for non-technical users.

Overview of the Storytelling and Integration dashboard in Looker Studio with time series, map, and summary card
Full dashboard view: main time series, regional map, and a side summary card that explains the reading flow.
dataset

Large dataset, simple reading

The core improvement is turning a wide, messy source file into an experience that is quick to understand even for a non-specialist audience.

lan

Real technical integration

It combines Python data preparation with a public Looker Studio delivery, closing the loop from raw data to navigable visual output.

person_play

Readable storytelling

The case does not stop at chart output. It orders regions, dates, and categories so the dashboard reads like a story rather than a pile of visual noise.

account_tree

Project flow

01

Load and clean

Notebook workflow to detect delimiters, normalize columns, remove duplicates, and prepare the base file.

02

Date conversion

Time standardization to support clean comparisons between 2017 and 2018.

03

EDA and visual structure

Quick exploration of nulls, categories, regions, and counts to decide which signals deserved to become visible.

04

Public Looker Studio delivery

A published Looker Studio dashboard with a time series, geographic map, and side explanation card in one guided view.

photo_library

Real dashboard captures

Full dashboard view of trending videos with time series, map, and summary card
Full Looker Studio dashboard with the main chart, regional map, and a side context block.
Dashboard section showing region analysis and trends over time
Regional and temporal views combined so users can compare how attention shifts across geography and time.
Side card of the dashboard with a summary of the case and its main reading
Explanatory card that summarizes what the dashboard measures and how the top chart and map work together.
Main dashboard chart showing trending videos by date
Primary chart used to track how trending-video activity evolves across the analyzed period.
code_blocks

Python notebook

Real notebook snippets used to load the CSV, clean columns, convert dates, and export the EDA that feeds the dashboard.

Python notebook code for path setup and loading the trending_by_time.csv file
Initial notebook setup, path definition, and base file loading to start the analysis.
Python notebook code for delimiter detection, column cleanup, and date conversion
Cleaning functions for delimiter detection, column standardization, duplicate removal, and date conversion.
Python notebook code for exporting null summaries, descriptive stats, and category counts
EDA block that exports null summaries, numeric stats, and top categories into CSV outputs.
insights

What the dashboard makes visible

Visual dominance

Entertainment

Entertainment clearly appears as the strongest category in the ranking shown by the dashboard.

Time comparison

2017 → 2018

The time series supports a compact reading of how category activity evolves across the visible two-year span.

Regional reading

5 regions

The map gives users a faster regional comparison than raw tables and supports interactive exploration by place.

deployed_code

Deliverables

Preparation notebook

A reproducible notebook for CSV cleanup, date handling, and basic EDA report generation.

Public Looker Studio dashboard

A public visualization that brings KPIs, geography, time, and categories into one readable flow.

Support PDF

A short support document explaining the dashboard goal and its value as an open exploration tool.

emoji_events

Why it leads the portfolio

It leads the portfolio because it combines data cleanup, visual judgment, and clear communication in a format that is easy to consume. It shows that I do not just analyze data, I can also turn it into an experience other people can use.