cybercypherdev/E-commerce-Sales-Analysis_ ? reverse-engineered prompt

Build me a complete e commerce sales analysis project from the dataset in this repo.

I want the data cleaned, turned into a SQLite database, and then analyzed with SQL and Python so I can see the main business insights in a simple way. Please make sure the cleaning handles duplicates, missing ages, missing shipping status, and date formatting, then save the cleaned output. After that, run the analysis for regional sales, product category revenue, average shipping fee by region, customer age patterns, gender based product preferences, and order fulfillment. Create clear charts and save them in the results folders.

If it helps, look up current docs online for anything you need. Also make the scripts easy to run from the existing setup files, and keep the outputs organized so someone can open the project and understand the findings quickly. If there are any missing pieces for the Power BI dashboard, set them up as far as you can too.