Business Analytics Dashboard Website using Streamlit Python and MySQL

Streamlit is free Python Package for Data Science and Data visualization. in this video we demonstrate basic skills how to start streamlit project with mysql intergration

you will learn how to create an analytics website dashboard using Python and the Streamlit library. We will use a Excel database to store the data, and we will use Streamlit to create an interactive dashboard that allows us to visualize and explore the data.

1. python programming
2. MySQL Connection
3. Matplotlib and plotly
4. pie chart and simple bar graph
5. sidebar and multiselector
6. data filter
7. streamlit query
8. streamlit expander
9. custom Css
10. streamlit metrics

FULL PROJECT LIVE DEMO

FULL PROJECT ON GITHUB

source code : with MySQL

source code: with Excel Csv

live demo

BUSINESS ANALYTICS WEB SYSYEMS & MACHINE LEARNING USING PYTHON AND STREAMLIT LIBRARY

*Business Analytics Dashboard Website using Streamlit Python and MySQL*
live demo
reference code
Video tutorial

*descriptive analytics website with MySQL*
live demo
reference code
Video tutorial

*analytics dashboard with excel and graphs*
live demo
Video tutorial

*Decision tree model*
live demo
reference code
Video tutorial

*Crosstabulation web*
live demo
reference code
Video tutorial

*Add new Record to Excel file via Web Interface*
live demo
reference code
Video tutorial

*Percentiles, 5 number summary, Categorical data*
live demo
reference code
Video tutorial

*Business Intelligent Analytics Web Dashboard Using PYTHON, HTML, CSS, STREAMLIT, MICROSOFT EXCEL*
video
live demo
reference code

*Business Analytics Web Dashboard Using Python, Html, CSS, Streamlit & Excel as Database | real Word*
live demo
source code
video

*Add Records to Microsoft Excel File by Web User Interface
live demo
source code
video
not available
-------------------
contact: WhatsApp [phone]
telegram: [phone]

[BakLOLNews]

Can you please tell me if in the place of . plot-container in style.css I want to use the same thing for columns what keyword to use instead of plot??

[ArniFuentes]

Thank you so much!. I have a question, is it not necessary to use a api between the database end the Python application??

[sumanthchummi]

NameError: name 'view_all_data' is not defined ---- getting this error unable to run

[maudguy]

Thanks for the great video. I am struggling a bit, my dashboard refreshes when I filter and goes back to unfiltered. How do I correct this?

[arcanumYT]

Hello. I have various csv files. How do I use them for the SQL Database. Or could you share the one you're using

[BakLOLNews]

You have done a awesome job nice tutorial

[Adesola_Analyst]

What an interesting and educative tutorial. You really tried. How can get dataset you used in this project so that I can also practise along with you.