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

LogoEmbed Views into Webpagestableau
LogoTableau Server REST APItableau
LogoInstall Tableau Server on Amazon Web Servicestableau
PreviousIngestion FlowNextUser Permissions

Last updated

Was this helpful?