Huynhthien.com

Marketing Intelligence & Decision System

Featured System Case Study

Marketing Intelligence & Decision System

A self-hosted business intelligence system connecting market research, paid media, sales, customer experience, service quality, and executive KPIs.

6 Dashboards
72 Analytical Cards
Self-hosted Data Stack
Synthetic / Anonymized Data
Explore the SystemView Dashboard Previews

Project Overview

From Fragmented Data to Connected Decisions

Marketing, sales, customer service, and management often work with separate reports and different definitions of performance. I built this system to connect those perspectives into a shared decision framework, from market awareness and paid acquisition to customer experience, root-cause analysis, and executive performance.

My Role

System concept, KPI framework, dashboard architecture, automation workflows, data organization, visualization, and AI/MCP experimentation.

Users

Marketing, Growth, Sales, CRM, Customer Experience, Operations, and Management.

Technology

n8n, APIs, PostgreSQL, Metabase, Portainer, and MCP.

Data Policy

All portfolio data is synthetically generated or anonymized to protect business information.

System Architecture

System Architecture

A self-hosted data flow designed to turn multiple operational sources into decision-ready dashboards.

Market Survey
Meta Ads
Orders
CRM & Messaging
CSAT
→
APIs & n8n Workflows
→
PostgreSQL
→ Metabase
→

Marketing · Sales · CRM · Operations · Executives

MCP / AI-assisted Analysis

Explore the System

Choose how to explore

Explore the data visually through six connected dashboards, or query the same data layer using AI-assisted analysis.

Interactive Dashboard System

Explore Six Connected Dashboards

Select a module to see its business purpose, users, KPIs, decision role, and interactive dashboard. All portfolio data is synthetic or anonymized.

Interactive demo · 6 connected modules

Best experienced on a tablet or laptop. The dashboard works on mobile, but filters and chart details are easier to explore on a larger screen.






 

 

 

Open Full Dashboard ↗

Business question

 

Used by

 

Decision support

 

Core KPIs and analysis

 

Skip to AI analysis ↓

Interactive dashboards are best viewed on tablet or desktop.Module 01 of 06




AI-ASSISTED DATA QUERYING

Ask the Dashboard

Query the same PostgreSQL data layer in English or Vietnamese and receive concise answers with metric definitions and source tables.

Live data
Start with the suggested KPI comparison. After the first answer, you can ask two follow-up questions in English or Vietnamese.

 
5 demo questions available
Powered by n8n · OpenAI · PostgreSQL



Build Details

How the System Works

01 · CollectMarketing, commercial, and customer experience data is collected through APIs and structured inputs.
02 · Automaten8n workflows handle synchronization, transformation, routing, and recurring operational tasks.
03 · Model & VisualizePostgreSQL provides the shared data layer while Metabase turns structured data into operational and executive views.
04 · ExploreMCP and AI-assisted workflows support natural-language querying, insight discovery, and reporting support.

Data Privacy

Data Privacy

All data displayed in this case study has been synthetically generated or anonymized. The dashboards are provided only to demonstrate KPI design, data organization, analytical thinking, and visualization capabilities. No confidential business or customer information is exposed.

Let’s Connect

Looking for a marketer who can connect growth, data, and automation?

I combine hands-on digital marketing experience with the technical ability to build measurable systems across acquisition, SEO, CRM, analytics, and automation.