Skip to content

sai-krishna-akkala/data-analysis-app

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📊 Data Analysis App

A Streamlit-powered interactive data analysis platform where anyone can perform EDA (Exploratory Data Analysis), data cleaning, filtering, and visualizationwithout writing a single line of code.

Whether your data is in SQL Server or a CSV file, this app lets you explore it in seconds with just clicks. Built using Pandas, Matplotlib, Streamlit, and custom CSS styling for an engaging experience.


🚀 Features

  • Upload CSV Files or Connect to SQL Server easily
  • Dynamic EDA — summary statistics, column info, and missing value detection
  • Data Cleaning Tools — handle nulls, remove duplicates, change data types, etc.
  • Filtering Options — filter rows based on conditions with a click
  • Interactive Visualizations — bar charts, pie charts, line charts, histograms, heatmaps, and more
  • Custom Styling — clean and modern UI with CSS enhancements
  • No Coding Skills Needed — everything is controlled by an intuitive interface

🛠️ Tech Stack

  • Frontend & Backend: Streamlit
  • Data Handling: Pandas
  • Visualization: Matplotlib
  • Styling: CSS
  • Database Support: SQL Server (via pyodbc)

📷 Screenshots

Home Page

Home Page

EDA

EDA

Filtering

Filter

Data cleaning

clean

Data Visuals

visuals


⚙️ Usage

  1. Launch the app in your browser (Streamlit will open it automatically)
  2. Upload your CSV file or connect to SQL Server by providing credentials
  3. Explore your data:
    • View summary statistics & data info
    • Clean missing values or duplicates
    • Filter data with easy dropdowns
    • Generate visualizations dynamically and customize them on the fly

📦 Installation

  1. Clone this repository
    1. git clone https://github.com/your-username/no-code-data-analysis.git
    cd streamlit-web-app
    2. **Install dependencies**
    ```bash
    pip install -r requirements.txt

Run

streamlit run app.py or python -m streamlit run app.py

Target Audience

  • Business analysts and data professionals who need to explore and visualize datasets quickly without extensive coding.

  • Decision-makers and managers who want clear insights from data to guide strategic planning.

  • Students and learners interested in understanding data analysis concepts through interactive visualizations.

  • Non-technical users who want user-friendly tools to analyze CSV files or SQL data without programming knowledge.

About

This is a streamlit web app that helps analysts to do analysis just by clicking the buttons and choosing options that they need

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages