My Role
System concept, KPI framework, dashboard architecture, automation workflows, data organization, visualization, and AI/MCP experimentation.
A self-hosted business intelligence system connecting market research, paid media, sales, customer experience, service quality, and executive KPIs.
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.
System concept, KPI framework, dashboard architecture, automation workflows, data organization, visualization, and AI/MCP experimentation.
Marketing, Growth, Sales, CRM, Customer Experience, Operations, and Management.
n8n, APIs, PostgreSQL, Metabase, Portainer, and MCP.
All portfolio data is synthetically generated or anonymized to protect business information.
A self-hosted data flow designed to turn multiple operational sources into decision-ready dashboards.
MCP / AI-assisted Analysis
Each module answers a different business question while contributing to a connected view of performance.
Brand Awareness & Market Funnel
Where does brand awareness break down, and which audience segments or channels offer the greatest growth opportunity?
Brand Marketing · Market Research · Marketing Manager
Facebook Ads Performance
Which campaigns and Ads IDs generate qualified conversations, orders, revenue, and sustainable ROAS?
Performance Marketing · Growth · Media Buyer
Order & Customer Performance
Which channels, services, products, locations, and customer segments are driving commercial performance?
Sales · Commercial · Operations · CRM
Customer Experience & Messaging Operations
Are customer communication and feedback operations fast, cost-efficient, and capable of sustaining satisfaction?
CRM · Customer Experience · Customer Service Operations
Service Quality & Root-Cause Analysis
Which recurring complaints, service criteria, and response windows create the largest customer experience bottlenecks?
Service Quality · Operations · Customer Experience Lead
Executive KPI Performance
How do revenue, order quality, advertising efficiency, customer acquisition, and operational performance connect at management level?
Founder · CEO · Head of Marketing · Head of Operations
Interact with selected dashboard modules using synthetic data created for demonstration purposes.
Interactive dashboards are best viewed on tablet or desktop.
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.
I combine hands-on digital marketing experience with the technical ability to build measurable systems across acquisition, SEO, CRM, analytics, and automation.