Analytics Website Dashboard using Python and Streamlit Library with MYSQL database (Data Science)

Опубликовано: 23 Октябрь 2024
на канале: Swahili ICT Tutorials
75,084
1.3k

What is descriptive analytics?

Descriptive analytics is a type of data analytics that looks at past data to give an account of what has happened. Results are typically presented in reports, dashboards, bar charts and other visualizations that are easily understood.

Descriptive statistics provide simple summaries about the sample and about the observations that have been made. Such summaries may be either quantitative, i.e. summary statistics, or visual, i.e. simple-to-understand graphs. These summaries may either form the basis of the initial description of the data as part of a more extensive statistical analysis, or they may be sufficient in and of themselves for a particular investigation.

live demo
https://open-projects.streamlit.app/

source code
https://github.com/shamiraty/OPEN-STR...

video contents:

1. how to download and install Python
2. how to install streamlit
3. how to start a new project
4. how to upload Excel file to Mysql
5. how to connect streamlit and Mysql
6. how to print data to Dataframe()
7. how to compute central tendencies
8. how to plot graphs in streamlit
9. how to create sidebar in streamlit
10. how to create multi-selector to sidebar

references:

download python
https://www.python.org/downloads/

emoji
https://www.webfx.com/tools/emoji-che...

bootstrap icon
https://icons.getbootstrap.com/

OTHER PYTHON VIDEO SERIES

Analytics Web application Multiple Linear Regression Web Project using Streamlit and Python
live demo
https://business-analytical.streamlit...
reference code
https://github.com/shamiraty/REGRESSI...
Video tutorial
   • Analytics Web application Multiple Li...  

Python Web Dashboard using DashPlotly Framework and Dash Bootstrap Component
Demo 1
https://python13.onrender.com/
Demo 2
https://project-fpy1.onrender.com/
reference code
https://github.com/shamiraty/Python-W...
Video tutorial
   • Python Web Dashboard using DashPlotly...  

Business Analytics Dashboard Website using Streamlit Python and MySQL
live demo
https://business-analytics.streamlit....
reference code
https://github.com/shamiraty/Streamli...
Video tutorial
   • Business Analytics Dashboard  Website...  

descriptive analytics website with MySQL
live demo
https://intelligent-force.streamlit.app/
reference code
https://github.com/shamiraty/Streamli...
Video tutorial
   • Analytics Website Dashboard  using Py...  

Python Machine Learning Web App Multiple Linear Regression using Streamlit Python and MySQL
live demo
https://business-force.streamlit.app/
reference code
https://github.com/shamiraty/MULTIPLE...
Video tutorial
   • Video  

analytics dashboard with excel and graphs
live demo
https://shamiraty-analyticsdashboard-...
Video tutorial
   • Analytics Dashboard Website with Grap...  

Web Analytics Dashboard using Python and Streamlit to Visualize Sales Data of Excel file
live demo
https://projectforce.streamlit.app/
reference code
https://github.com/shamiraty/streamli...
Video Tutorial
   • Web Analytics Dashboard using Python ...  

Streamlit Web Visualization Dashboard using Python and PygWalker Exploratory Library
Live Demo
https://kanaries.streamlit.app/
Source Code
https://github.com/shamiraty/pgwalker...
Video Tutorial
   • Streamlit Web Visualization Dashboard...  

Crosstabulation web
live demo
https://shamiraty-crosstabulation-mai...
reference code
https://github.com/shamiraty/CrossTab...
Video tutorial
   • CrossTabulation Matrix data from Exce...  

Add new Record to Excel file via Web Interface
live demo
https://shamiraty-add-data-to-excel-s...
reference code
https://github.com/shamiraty/add-data...
Video tutorial
   • Add new Record to Excel file via Web ...  

Percentiles, 5 number summary, Categorical data
live demo
https://shamiraty-numbersummary-perce...
reference code
https://github.com/shamiraty/numberSu...
Video tutorial
   • Descriptive Analytics Web Dashboard  ...  

Business Intelligent Analytics Web Dashboard Using PYTHON, HTML, CSS, STREAMLIT, MICROSOFT EXCEL
video
   • Business Intelligent Analytics Web Da...  
live demo
https://python-business-analytics.str...
reference code
https://github.com/shamiraty/python_a...

Business Analytics Web Dashboard Using Python, Html, CSS, Streamlit & Excel as Database | real Word
live demo
https://python-bussiness-analytics-wi...
source code
https://github.com/shamiraty/python_a...
video
   • Python Analytics Dashboard with MySQL...  

Logistic Regression Analysis And Coefficient Of Correlation Using Python And Jupyter Notebook
reference code
https://github.com/shamiraty/Logistic...