Project ideas · Data Alchemy

7d ago (edited) in 💬 General

Project ideas

My goal is to get a job in something related to E-commerce, so I thought about doing 3 projects that could get me closer to my goal, I would like to know your opinion, the projects will go from simpler to more complex.

1) A simple payment, customer management and inventory system. It would consist of a sql database of no more than 20 - 30 tables with things like customers, employees, products, stock, payment methods, etc. and their respective transactions in stored procedures, triggers, security management to avoid sql injections etc, as well as views to filter sensitive customer information etc., and a simple streamlit web app that allows a person to simulate a purchase with their email, payment method (simulated), product, quantity etc. and returns an order detail that can be downloaded, and updates the database automatically. Maybe I could add something here

2) An in-depth analysis of an e-commerce site and generation of models, for things like predicting sales based on historical data, creating recommendation systems, looking for purchasing patterns, bottlenecks etc and analysis on the site, things like churn rate analysis, purchases by device, abandoned carts etc, that kind of thing.

Finally show all this in an interactive dashboard in power bi

3) An in-depth trend analysis using big data with pyspark and other tools.

Let me know what you think, is this a good idea or should I try something more innovative?

6 comments