DownloadCreate AI Presentation

Building a Python Web App for Data Dashboard

Converting Excel Macros to Streamlit and Plotly

Introduction

  • Recreating an impressive Excel dashboard with Python
  • Collaborating with a financial data analyst
  • Exploring the power of Streamlit and Plotly
  • Combining data cleaning, SQL, and visualization
  • Building a streaming web app for live data updates

Setting Up the Environment

  • Configuring VS Code and Streamlit
  • Loading an Excel file using Pandas
  • Using Streamlit widgets for user interaction
  • Customizing the layout and appearance of the app

Data Loading and Preprocessing

  • Using Pandas to load the Excel file
  • Leveraging Streamlit's file uploader widget
  • Processing and cleaning the data for visualization
  • Applying SQL-like operations with DuckDB

Creating Interactive Plots

  • Using Plotly Express for simple line charts
  • Exploring customization with Plotly Graph Objects
  • Adding indicators and gauges for visual insights
  • Arranging and styling the plots in a grid layout

Further Enhancements and Deployment

  • Making the loaded data frame editable
  • Implementing real-time data updates
  • Exploring custom cross-filtering with Plotly
  • Deployment options for sharing the app with colleagues

Conclusion

  • Empowering users to create their own dashboards
  • Replacing VBA macros with Python and web technologies
  • Showcasing the versatility of Streamlit and Plotly
  • Encouraging exploration of the provided resources

Related Presentations

Understanding Meiosis: The Process of Genetic Variation

The Power of Asking the Right Questions

Exploring the Global Impact of Foreign Music

Explaining.RF: Delivering Reliable Information to Citizens

Building Your Dream Home

Mastering Advanced English Grammar

Other Free PPT Tools

Topic to PPT using AI

Generate engaging presentations quickly from just a keyword. Ideal for students and educators needing fast, content-rich slides.

Create PPT from Topic
AI

YouTube to PPT using AI

Turn YouTube videos into informative slide presentations. Excellent for marketers and creators looking to expand their video content's reach.

Create PPT from YouTube
AI

AI PitchDeck Generator

Turn Pitch Deck into informative slide presentations. Excellent for business and startup looking to present his business.

Create PPT from Pitch Deck
AI

Text to PPT using AI

Generate engaging presentations quickly from just a keyword. Ideal for students and educators needing fast, content-rich slides.

Create PPT from Text
AI

URL to PPT using AI

Effortlessly convert any web page into a comprehensive presentation. Perfect for professionals and researchers presenting web-based data.

Create PPT from URL
AI

PDF to PPT using AI

Convert PDF files to PowerPoint slides easily. Essential for analysts and consultants dealing with detailed reports.

Create PPT from PDF
AI