This project demonstrates a simple data pipeline using Snowflake and the classic Superstore dataset.
- Load and transform data using Python and SQL
- Analyze monthly sales, customer segmentation, and regional performance
- Optional integration with Power BI or Tableau
data/: Contains the raw Superstore CSV dataetl/: Python script to upload data to Snowflake and run SQL transformationsqueries/: Pre-written SQL analysis queriesdashboard/: (Optional) Power BI or Tableau files for visualization
- Update Snowflake credentials in
etl/upload_to_snowflake.py - Run the script to upload and transform data
- Use the SQL queries in
queries/to analyze the data