Skip to content

This GitHub repo hosts a basic web application, integrating Azure SQL DB for data storage and Tableau for visualizations. Explore the app.py for app code, ./deps for DB setup, and for Tableau configurations

License

Notifications You must be signed in to change notification settings

yanurag994/KPI_Dashboard

Repository files navigation

KPI Dashboard

Setup

  1. Fork this repository.
  2. From the Azure portal or CLI, create a web app with Azure SQL Database.
  3. In the deployment center, authenticate and use the default actions to set up the deployment.
  4. Set up the Tableau dashboard using the files in the deps folder named tableau_dash_setup.twbx.
  5. Create a connected app in Tableau.
  6. Set up the Azure database tables using the files in the deps folder named azure_db_setup.sql.
  7. Whitelist the IP for your web app and Tableau dashboard.

Required

  • Azure portal or CLI
  • Tableau Desktop
  • Azure SQL Database

Credentials Required in WebApp

  • CONNECTED_APP_CLIENT_ID
  • CONNECTED_APP_SECRET_KEY
  • CONNECTED_APP_SECRET_ID
  • TABLEAU_USER
  • AZURE_SQL_SERVER
  • AZURE_SQL_DATABASE
  • AZURE_SQL_USER
  • AZURE_SQL_PASSWORD
  • AZURE_SQL_PORT
  • APP_COOKIE_SECRET

About

This GitHub repo hosts a basic web application, integrating Azure SQL DB for data storage and Tableau for visualizations. Explore the app.py for app code, ./deps for DB setup, and for Tableau configurations

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published