Displaying data on a dashboard

In this tutorial, we’ll take a tour of Anvil, build a data dashboard, and deploy it on the web. We’ll start from a blank page, and we’ll build up a web app that displays data from:

  • Anvil’s built-in database
  • External SQL databases
  • and HTTP APIs.

And we’ll do it all with nothing but Python!

The final app will look something like this:

The techniques you’ll learn in this tutorial are fundamental to building any Anvil app, and mastering them will give you a good understanding of how Anvil works.

You don't need any prior experience with Anvil or web development to complete this tutorial.

All you'll need is a little bit of Python. If you’re new to Python, here are some resources to help you get started.


Chapters

In this tutorial, you'll:

Build your user interface

Build a dashboard UI using Anvil’s drag-and-drop editor.

Write client-side Python

Write client-side Python code that runs in the browser to display a simple plot.

Plot data from a Data Table

Store data in Anvil’s Data Tables database and plot it in the dashboard.

Plot data from a private database

Plot data from an external SQL database in a private network

Display headline figures

Display some headline statistics above the graphs.

Click the following link to clone the finished app and explore it in the Anvil editor.

If you prefer a more theoretical approach to learning, you can dive straight into the documentation.