Skip to content

dmortalla/project3-excel-dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

1 Commit
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

๐ŸŒ COVID-19 Data Trends (GCP Deployment)

End-to-end analytics pipeline using Google Cloud Platform, Python, and Power BI.

Workflow

  1. ETL pipeline pulls daily COVID-19 data from Our World in Data.
  2. Data stored in Google Cloud Storage and loaded to BigQuery.
  3. Power BI connects to BigQuery for interactive dashboarding.
  4. GitHub Actions automates the daily data refresh.
  5. Dashboard embedded on Hostinger portfolio.

Tech Stack

  • Python (pandas, google-cloud-storage, google-cloud-bigquery)
  • Google Cloud Storage & BigQuery
  • Power BI
  • GitHub Actions
  • Hostinger

About

COVID-19 trend analytics with automated Excel reporting and GCP integration.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages