A mission-critical data ecosystem designed to unify, normalize, and analyze sales performance across diverse business verticals: Mobility, Smart Home Security, FFH, and Health.
This engine automates the journey from raw sales leads to final executive revenue insights, providing a scalable infrastructure for commission accuracy and sales trend analysis.
The pipeline is structured into three specialized layers:
- Normalization Layer: SQL procedures that standardize different product units (e.g., fiber subscriptions vs. mobile devices) into a unified Sales Metric.
- Incentive Engine: Advanced BigQuery logic to calculate tiered commissions based on dynamic targets.
- Executive BI Layer: Optimized views for Looker Studio providing a 360° view of global sales health.
- Multi-Vertical Consolidation: Handling disparate CRM data schemas.
- Defensive SQL: High-integrity scripts using
SAFE_CASTandREGEXPfor data cleaning. - Apps Script Integration: Automated intake systems for real-time sales reporting.
Author: GIORH
Stack: Google BigQuery (SQL), Google Apps Script, Looker Studio.