In this project, I have performed the following tasks:
- Fetching data from APIs
- Dump it into the cloud (Databricks folder)
- Start cleaning the data, transforming from json to data frame, correcting data types, dropping unwanted observations
- Gathering the different stocks in a single dataset, joining and calculating some indicators like moving averages and Relative Strength Index (RSI)
- Sending the data to a PostgreSQL database for consumption
- Connecting with Power BI and creating a final report for insights.
For full description of the project, step-by-step, visit the Medium Post.