Data Visualization

Questions

  • How the service agreement with Tableau Server works

    • At what scale does cost of extracted data matter?

      • They DO have a nonprofit cost level (tableau.com/foundation)

      • Viewing licenses

    • Call a sales rep at Tableau and discuss our use case

    • Guest account on T.S. to access embedded views

  • How do we run Tableau Server? Or use it?

    • Server vs Online, which do need now or later

  • Understand how to embed view into pages with access control, see above link

    • And Federated Authn/Authz model for services access

  • Table design of the read only database

  • Creating airflow job to copy data to read only database

  • Visualizations may need to be released into production using partial staging.

First Experiment

  • Choose single dataset and visualization as proof of concept

    • Dataset: Captures x planter x organization

    • Verified captures by organization bar chart, on the main Greenstand Admin Panel Dashboard

  • Needs

    • Denormalized database table schema -> Nick

    • Read only database cluster to hold this database table -> Cloud Team Member

    • A job to copy/update data into this table -> Rushab(?)

    • A visualization workbook -> Rushab

    • Run tableau server / determine applicability of use case -> Zaven

    • Embed the view into admin panel -> Admin Panel Team

Denormalized Database Table Schema

Links

PreviousIngestion FlowNextUser Permissions

Last updated