GCM

Inspiration

Integrating GCP and MongoDB

What it does

1. Display current share value and PE ratio for randomly chosen 10 companies from SP500
2. Analyze last 6 month share values and display highest intraday share fall data. ## How we built it
   1. Yahoo finance as source pull stock data and push to mongodb as collection
   2. View data using Mongodb compass
   3. Aggregate the data using mongo shell
   4. Move aggregated data from Mongodb to Bigquery
   5. Covert json to normal data
   6. Connect looker and use the tables and build report

Challenges we ran into

Data processing at mongodb. Learning dataflow and looker/looker studio.

Accomplishments that we're proud of

The final product. The dashboards shows the data what i want.

What we learned

Integrating GCP and MongoDB

What's next for GCM

Real world projects

Built With

• atlas
• compass
• google-bigquery
• google-dataflow
• looker
• mongoshell
• pymongo
• python