Web Analytics Dashboard using Python and Streamlit to Visualize Sales Data of Excel file

most important thing today is to use the data you have as a source of business insights, decision and development by looking at where you are doing better in product sales and where you are not doing well. There are many Business Intelligent softwares that are used to prepare business reports such as MICROSOFT EXCEL and POWER-BI, along with those softwares, there is also a python library called Streamlit. Streamlit is special python Package for data science and machine learning and its advantage is that: it has the ability to create driven and interactive web dashboard that will be seen by many users in the company and also has the ability to work across the internet in this video I have tried to show how you will be able to create a web analytics dashboard for inventory business trends where you will look at the business trend by selecting the date range, city, or type of product to see where the efficiency is in that trend FULL PROJECT LIVE DEMO https://open-projects.streamlit.app/ FULL PROJECT ON GITHUB https://github.com/shamiraty/OPEN-STREAMLIT-PROJECTS/ TIMELINE: 0:00 introduction to this Analytics dashboard 0:03:29 download project source code 0:03:59 python dependencies installation 0:05:41 opening Visual studio code 0:06:40 start coding the site 0:07:38 import python dependencies 0:08:09 setting site page layout 0:08:17 run streamlit web 0:10:30 load CSS style to streamlit web 0:11:17 load csv dataset to streamlit web and print dataframe 0:11:44 streamlit date picker input for date range differences 0:13:37 streamlit sidebar with multi-selector 0:15:58 streamlit metric card with custom styles 0:20:46 streamlit Bar Chart 0:23:58 streamlit Progress Bar showing Percentage of Target Live Demo https://projectforce.streamlit.app/ Source Code https://github.com/shamiraty/streamlit-dashboard-with-date-filter-and-content-switch 🏆 OTHER PYTHON VIDEO SERIES *Business Analytics Dashboard Website using Streamlit Python and MySQL* live demo https://business-analytics.streamlit.app/ reference code https://github.com/shamiraty/Streamlit-Business-analytics-with-Excel_CSV Video tutorial https://youtu.be/sIqBA0PhzGQ *descriptive analytics website with MySQL* live demo https://intelligent-force.streamlit.app/ reference code https://github.com/shamiraty/Streamlit-Dashboard-Descriptive-Analytics-with-MYSQL Video tutorial https://youtu.be/pWxDxhWXJos *analytics dashboard with excel and graphs* live demo https://shamiraty-analyticsdashboard-with-excel-file-main-kkkk2a.streamlit.app/ Video tutorial https://youtu.be/-cg3qPhI74s *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/streamlit-dashboard-with-date-filter-and-content-switch Video Tutorial https://youtu.be/uDuPM4xfPlw *Streamlit Web Visualization Dashboard using Python and PygWalker Exploratory Library* Live Demo https://kanaries.streamlit.app/ Source Code https://github.com/shamiraty/pgwalker-with-streamlit Video Tutorial https://youtu.be/JeoYZkmeYTo *Decision tree model* live demo https://shamiraty-decisiontree-streamlit-home-y6z5z0.streamlit.app/ reference code https://github.com/shamiraty/DecisionTree-Streamlit Video tutorial https://youtu.be/s4pUqZrDOzw *Crosstabulation web* live demo https://shamiraty-crosstabulation-main-b2c61u.streamlit.app/ reference code https://github.com/shamiraty/CrossTabulation Video tutorial https://youtu.be/1fnq4CzezxQ *Add new Record to Excel file via Web Interface* live demo https://shamiraty-add-data-to-excel-streamlit-main-4mef19.streamlit.app/ reference code https://github.com/shamiraty/add-data-to-excel-streamlit Video tutorial https://youtu.be/-3q2rwuy99g *Percentiles, 5 number summary, Categorical data* live demo https://shamiraty-numbersummary-percentiles-main-bng7ov.streamlit.app/ reference code https://github.com/shamiraty/numberSummary_percentiles Video tutorial https://youtu.be/U7vf-DB_KmQ *Business Intelligent Analytics Web Dashboard Using PYTHON, HTML, CSS, STREAMLIT, MICROSOFT EXCEL* video https://www.youtube.com/watch?v=mDJ-sKB7DvE live demo https://python-business-analytics.streamlit.app/ reference code https://github.com/shamiraty/python_analytics_graph_excel *Business Analytics Web Dashboard Using Python, Html, CSS, Streamlit & Excel as Database | real Word* live demo https://python-bussiness-analytics-with-adddata.streamlit.app/ source code https://github.com/shamiraty/python_analytics_graph_excel-_with_add_data/ video https://youtu.be/rJzBNm0rb0g *Add Records to Microsoft Excel File by Web User Interface live demo https://add-data-excel.streamlit.app/ source code https://github.com/shamiraty/add-data-excel video not available contact: WhatsApp +255675839840 email: [email protected] plays tore: https://play.google.com/store/apps/dev?id=7334720987169992827&hl=en&gl=US