CARLOS DAVID GONZALEZ VIVAS← BACK TO SELECTED WORK
SELECTED WORK / 02ANALYZE

DATA & ANALYTICS

From raw data
to something
people can use.

I work with data to answer practical questions: what is happening, who is engaging, where patterns are forming and what deserves attention.

That can mean building a model, connecting sources, automating a report or translating a large dataset into a dashboard that makes the important signals easier to see.

SQL · BIGQUERY · EXCEL · LOOKER STUDIO · APPS SCRIPT · AUTOMATION
02.1 — THE PIPELINE

Make the data
usable first.

Useful analysis usually begins before the chart. The work is in connecting, structuring and validating the information so the output can be trusted.

01SOURCESExports · APIs · Files · Platforms
→
02MODELExcel · SQL · BigQuery
→
03TRANSFORMClean · Join · Validate
→
04AUTOMATEApps Script · Scheduled flows
→
05REPORTLooker Studio · Dashboards
02.2 — SIGNALS

Numbers are useful.
Context makes them meaningful.

ILLUSTRATIVE VIEW · SYNTHETIC DATA

See the behavior
behind the traffic.

Across digital products, I use analytics to help clients understand who their audience is, how people arrive, what they engage with and how behavior changes over time.

USERS48.2K+12.4%
ENGAGEMENT63%+4.8%
RETURNING31%+2.1%
AUDIENCECONTENTBEHAVIORTRENDS
02.3 — CURRENT WORK

Models that keep
reporting moving.

My current analytics work includes connected reporting workflows rather than one-off charts.

01

Data Models

Working with Excel models and BigQuery to structure information for repeatable analysis and reporting.

02

Integrations

Exporting data and integrating it into models so information from different sources can work together.

03

Automation

Using Apps Script and repeatable processes to reduce manual reporting work and keep outputs current.

04

Dashboards

Building Looker Studio dashboards and reports that make complex information easier to explore and communicate.

FEATURED CONTEXTEUROPEAN UNIONGUATEMALA · PRESIDENTIAL ELECTION MONITORING

DATA IN A HIGH-CONTEXT ENVIRONMENT

Analysis during Guatemala's presidential election.

As part of a European Union election monitoring initiative, I worked with digital and social-media data during Guatemala’s electoral process — structuring information, analyzing signals and supporting reporting designed to make a complex information environment easier to understand.

The portfolio describes the nature of the work without exposing private datasets, internal reporting or sensitive client material.

DATAMONITORINGREPORTINGRESEARCHGT
2023
02.5 — THE POINT

A dashboard is not
the final answer.

“The goal is to make the information easier to understand, so the next decision can be better informed.”
QUESTION→DATA→STRUCTURE→SIGNAL→DECISION

ANALYSIS SHOWS WHAT IS HAPPENING. THE NEXT STEP IS TO MAKE IT BETTER.

From observing behavior
to improving the experience.

03 — IMPROVE →