Solar Applications Data Analysis

Posted on Feb 1, 2020

Links: Github | Shiny App | Dataset 


Solar is a growing form of energy and is considered the cleanest and most abundant renewable energy source available1 in the world. I decided to analyze a solar applications dataset from the state of California to understand which companies stand to benefit from the secular rise of solar power production in the US.

Why this dataset?

California easily leads all 50 states in solar electricity production (enough to power 5.4 million homes), nearly 5x larger than the second largest state2. Therefore, “the Golden State” provides a great opportunity to gain insights into a growing US solar market. Additionally, I chose applications data in particular because an application needs to be submitted and approved before an actual installation occurs; therefore, analysis of this data could potentially be a forward-looking metric.

Then I focused on analyzing how much solar photovoltaic (PV) modules (e.g. solar power) are associated with each application and grouped this by Utility, Third-Party Installer, and Segment (e.g. Residential, Commercial, Industrial, etc).

Which companies?

There are several companies that can be tied to the solar applications on a megawatt (MWs) basis. Understanding the rate of change of solar applications in MWs could provide some insight to their operations in CA. Below are the companies:

California Investor Owned Utility Third-Party Installer
PGE: Pacific Gas and Electric SCTY: SolarCity (owned by Tesla)
SCE: Southern California Edison RUN: SunRun
SDGE: San Diego Gas & Electric SPWR: SunPower
  VSLR: Vivint Solar

Data Takeaways

  • According to the latest data update (as of October 2019), solar application growth for VSLR and SCE continued to accelerate in 3Q19 vs. prior quarters. Growth increased by 97% and 26% Y/Y, respectively, and these were the key winners from the Third-Party Installers and Utility groups of the data.
  • Meanwhile, SCTY continued to show meaningful Y/Y declines in the past two quarters (2Q19 to 3Q19), largely in-line with expectations as SolarCity continues to represent a smaller portion of Tesla's overall revenue (approximately 10% as of 3Q19). However, early reads into 4Q19 from October data showed SCTY application growth could accelerate vs. prior quarters.
  • Lastly, overall solar application growth in MWs continues to be driven by Residential customers in Southern California counties. This customer segment and region has driven the majority of application volume in recent years.

R Shiny Application

Below are some examples of how I visualized the data in Shiny, or click here to load the application.

Daily Applications in MWs by California Investor Owned Utility:

Relative Comparison Charts by Installer:

Quarterly Rate of Change by PGE:

Quarterly Rate of Change by SCTY:

2019 Total Applications in MWs by County:


About Author

Leave a Comment

launchpad solarcity app - CossFest Logins January 18, 2022
[…] Solar Applications Data Analysis | Data Science Blog […]
solarcity launchpad app - CossFest Logins January 18, 2022
[…] Solar Applications Data Analysis | Data Science Blog […]
solarcity launchpad app - Logins Mission December 31, 2021
[…] […]
launchpad solarcity app - Logins Mission December 30, 2021
[…] […]
launchpad solarcity app | Human System Logins December 29, 2021
[…] […]

View Posts by Categories

Our Recent Popular Posts

View Posts by Tags

#python #trainwithnycdsa 2019 airbnb Alex Baransky alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus API Application artist aws beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep Bundles California Cancer Research capstone Career Career Day citibike clustering Coding Course Demo Course Report D3.js data Data Analyst data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization Deep Learning Demo Day Discount dplyr employer networking feature engineering Finance Financial Data Science Flask gbm Get Hired ggplot2 googleVis Hadoop higgs boson Hiring hiring partner events Hiring Partners Industry Experts Instructor Blog Instructor Interview Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter lasso regression Lead Data Scienctist Lead Data Scientist leaflet linear regression Logistic Regression machine learning Maps matplotlib Medical Research Meet the team meetup music Networking neural network Neural networks New Courses nlp NYC NYC Data Science nyc data science academy NYC Open Data NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time Portfolio Development prediction Prework Programming PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn Selenium sentiment analysis Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau team TensorFlow Testimonial tf-idf Top Data Science Bootcamp twitter visualization web scraping Weekend Course What to expect word cloud word2vec XGBoost yelp