krishnasharma8618137-cloud/Capstone_project-1 ? reverse-engineered prompt

Build me an end to end e commerce analytics project that shows how raw business data can be turned into useful insights and operational decisions.

I want a simple but polished setup where data is stored in MySQL as a warehouse, then analyzed in Python with Pandas and Matplotlib for exploratory analysis and clear visual reports. Please include a small automated pipeline that loads data, cleans it, runs the analysis, and generates charts so the workflow feels repeatable. I also want a basic risk modeling part focused on logistics and operations, something that helps identify likely bottlenecks or high risk areas in order fulfillment and delivery.

Make it easy to run, easy to understand, and presentation ready, with clean code and a good README that explains the flow from database to analysis to visuals. If you need to, look up current docs online for best practices.