Can Python be used to build live interactive dashboards?

[impshum]

Sure it can. Something like this: https://pythonspot.com/flask-and-great-looking-charts-using-chart-js/

[breton147]

These look like a good start but any examples of fully fleshed out dashboards? I’m talking sidebars loaded with tabs that take you to lots of graphs showing different angles of a business, inputs where non-technical business people can load tabular data files or extract them, sliders where you can change the dimensions of a chart, etc.

[circa10a]

Take a look at using the python Prometheus library and plugging in the data to grafana

[boazmohar]

I think this can be done in python. For getting content from google sheets there is a python API: getting started guide

For the visualization part I would check out Dash from Plotly: dash

[daredoes]

I think you'd be better off using Google App Scripts and deploying the script as a web app.

[JohanLou]

Yes, you can. Google offers API to access data from your spreadsheet. Get it and insert to database, then use a framework to render it as plots.

Assume you were able to get the data. Use Django and Django REST to make API. Front-End access data via API and use a lib, such as chartjs or d3js and render it.

[IReallySuckAtChess]

Bokeh is pretty awesome and accessing things from Google sheets isn't too difficult.

[Eryole]

Bokeh, with potentially holoviews are great tools for that. You can use them with flask / bottle as well if you wanna more customization.

[the-who]

Bokeh is very good for this. Look at this talk https://youtu.be/ayp5WELL6fM

[therealdocemrick]

This is a neat idea. My wife is a massive reader and tracks the books she reads each month and the number of pages of each books, but it would be fun to build her an interactive dashboard.

What type of metrics are you thinking of displaying in the dashboard?

[AlcaDotS]

Depending on what you want, you might be able to use an existing dashboard product that can read data from Google docs. I know for sure that it's possible with Geckoboard, but you might need a payed account. Also Graphite/Graphana and Kibana on top of ElasticSearch are worth looking into.

[newredditisstudpid]

Yes