Business Intelligence Architect & Data Platform Leader

-- Querying my professional metrics
SELECT 
    p.name AS Consultant,
    COUNT(DISTINCT dm.model_id) AS DataModels,
    COUNT(DISTINCT pr.project_id) AS LongTermProjects,
    SUM(ft.fact_tables + ft.dim_tables) AS FactDimTables,
    COUNT(DISTINCT rp.report_id) AS Reports,
    AVG(cr.renewal_rate) AS ClientRenewalRate
FROM dim_professional p
LEFT JOIN fact_data_models dm ON p.person_key = dm.person_key
LEFT JOIN fact_projects pr ON p.person_key = pr.person_key
LEFT JOIN fact_table_development ft ON p.person_key = ft.person_key
LEFT JOIN fact_reports rp ON p.person_key = rp.person_key
LEFT JOIN fact_client_retention cr ON p.person_key = cr.person_key
WHERE p.role = 'BI Architect' AND p.experience_years >= 15
GROUP BY p.name;