E Commerce Dashboard
Problem: An Online E-Commerce Company wants to design a Sales dashboard to analyze sales based on various product categories. The company wants to add user control for product categories, so users can select a category and can see the trend month-wise and product-wise accordingly.
Solution:
- Prepared a table of Sales and Profit month-wise in a working sheet.
- Prepared the sales table region-wise in the working sheet.
- Created User Control Combo box for Product Category.
- Created a Column Chart of a month-wise table and region-wise table.
- Linked the table with the combo box.
- Created a dashboard.
Contribution: 100% of my own contribution to this work.
Skills used:
- Data preparation.
- Data cleaning.
- Dealing with spreadsheets.
Resources used:
- Microsoft Excel.
Completion Date: 2022/07/15
Amazon stock price prediction
Problem: Investing firm wants to know how Amazon's stock price will behave in the upcoming month. to make their short-term investing strategy.
Solution:
- Acquired historical fundamental data – these are the features or predictors.
- Acquired historical stock price data – this will make up the dependent variable, or label (what we are trying to predict).
- Used a Python prophet model by Facebook to learn from the data.
- Backtest the performance of the prophet model.
- Acquired current fundamental data.
- Generated Amazon's stock price predictions for the upcoming 30 days.
Contribution: 100% of my own contribution.
Skills used:
- Python programming.
- Importing Python libraries.
- processing data with Python programming.
Resources used:
- Jupyter Notebook (anaconda3)
- GitHub
Completion Date: 2022/02/08