Before building anything: interview end users, map how they use data today, agree the problem statement in their words, and identify the metric tree. Spend a full week here. The output is a problem statement two stakeholders sign, not a query.