Star Jeans is a fictional company that was used as a case study, where two entrepreneurs named Eduardo and Marcelo are Brazilians and entrepreneurial friends who are starting in the US fashion retail area after several successful businesses. The initial idea is to enter the market with a specific product, which is jeans for the male audience, but even with the well-defined audience, they do not have experience in the fashion retail market, so they hired a data consultancy to answer some questions...
Eduardo and Marcelo need awser for this questions.
they are two entrepreneurs and they want to enter the menswear market but they are having some difficulties related to the start of the venture
What is the best selling price for the jeans pants?
How many types of pants and their cores for the initial product?
What raw material is needed to make these pieces?
What is a Retail?
It is a type of business model where the product is sold directly to the consumer, for example a market, it is a Retail, where it sells products according to demand and in small quantities directly to the consumer, where the money comes mainly from the quality of the service. face-to-face customer service, product exhibition, infrastructure quality, among others.
What is an E-Commerce?
It's a business model similar to retail, let's say, where I have a website that sells products online, in this style of business model, the consumer enters a funneling process, when the consumer knows the brand, registers on the site, order and purchase by becoming a customer. In this process, there are no employees or the infrastructure of the physical store does not exist, as sales are made automatically on the Website. Therefore, it is necessary to have a good website, with colors that match the brand, quality of online service, or in other words, the money comes with the experience and the purchase process.
- A database with some data to feed in a dashboard or app by type and color in the next 30 days.
- This dataset will feed a executable app and a product dashboard with some metrics.
- Make a ETL pipeline and run it for 30 days to full cloud database.
- In first week of ETL is possible to see some results.
- Complete WebScraping of H&M Jeans Website.
- Storing Daily data on Heroku Clound.
- Usind a API to Feed Data from Heroku on Two Apps.
- Streamlit is a Web Based Plataform for Web Apps.
- Executable TKinter App in windows or linux S.O.
- Need more Days to collect for better plots.
- Need Pagination products (Only 36 Daily Web Scraping).
- Add product name (The Produt Name is Just fit column, but withou 'Fit', Eg: 'slim_fit' => 'slim_jeans' in website)
Airflow ETL Pipeline of Webscraping to Dashboard
The first deployment is a Web App based on Streamlit at Heroku Cloud.
webapp.mp4
Second Deployment is a simple executable software (app based).