Research Request - SLO RTA Data Discrepencies

[amandaha8]

Research Question

Single sentence description: SLORTA noticed the numbers on a Metabase graph  doesn't match the numbers shown when they export the results to Excel. Which numbers are the most accurate so SLO can split the money correctly between SLO RTA and SLO City?

How will this research be used?

SLO needs to know how their revenue is split so they can give the correct amount of money back to each agency.

Stakeholders & End-Users

SLO RTA

Data sources

• Payments Tables

• Remaining data source questions:

• Should we use the new fct_payment_aggregations to answer this instead of the SQL that lives in Metabase?

Deliverables

• The correct split for SLO RTA
• The Excel downloads match the numbers shown on the graph.

Slack Thread.

• Here.

[amandaha8]

I will download the original reconciliation query before any joins and join this in JupyterHub myself.

[amandaha8]

Anna has updated the underlying data warehouse tables so we can see the regional agencies and there is no need for any wild joins. . I am updating the tables to reflect Anna's updates.

[amandaha8]

Done creating the reconciliation dashboard showing the regional agency split using the updated fct_payment_aggregations table. . Waiting for Dima to update me about whether fct_payment_aggregations is ok since there are some slight differences between this table and Rebel's original SQL query.