Key dates
M1 - Initial POC Scaffolding & Data Exploration
Create scaffolding for initial POC and look into fetching data from snowflake. Result is here:
https://rad-mystery-customer-admin.discoveryeducation.com/
M2 - POC Prototype
Based on designs and documentation here:
https://discoveryed.atlassian.net/wiki/spaces/MS1/pages/4739268626/Admin+Dashboard+Prototyping+and+Testing
Will overwrite previous POC and be located here: https://rad-mystery-customer-admin.discoveryeducation.com/
USER MUST BE ON VPN TO ACCESS (for internal testing ... we'll remove this once customers are accessing for testing : )
M3 - Team Review Mystery Customer Admin with Team
Review Mystery Customer Admin with Team, make any adjustments needed iteratively.
M4 - Real services and data
From @Brittany Wolff : I have this Confluence doc and this miro board that detail the (more or less) current state of the usage dashboards. It is built on a series of materialized views which are not in Snowflake, but could probably be recreated there. Except it looks like we don't have teachings in Snowflake yet which is one of the base tables. You can find the SQL for the materialized views in the repo (db/views). I think the current versions would be: