Analyzed rooftop solar potential across US states using Google's Project Sunroof dataset (Big Que...Analyzed rooftop solar potential across US states using Google's Project Sunroof dataset (Big Que...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Analyzed rooftop solar potential across US states using Google's Project Sunroof dataset (Big Query) to identify high-potential, low-adoption markets for solar investment.
Built SQL analyses across four progressive difficulty levels in BigQuery, then designed a multi-page Power BI dashboard (Overview, Adoption, Opportunity, Carbon Impact) with custom theming, DAX measures, and Shape Map visuals.
Key finding: states with high energy potential but the lowest adoption rates — like South Dakota (0.21% median adoption) — represent the greatest untapped opportunity, offering a projected 7.75M total realized offset.🎉
Post image
Post image
Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started