Your application

Please complete the following fields to be considered for this project.

Please fill in this required field.
Please fill in this required field.
Please fill in this required field.
Please fill in this required field.
Please fill in this required field.
How much commitment will you have to this project?
Please select an option.
Are you available to dedicate 1-2 hours per week to the Build Project?
Please select an option.
Your application has been 
successfully submitted!
Explore more projects
Close
You already submitted an application for this project.
Explore more projects
Close
There was an error submitting your form. Please try again later or contact us.
Oops! Something went wrong while submitting the form.

This project is no longer accepting applications. Subscribe to our newsletter to be notified of new projects!

Get updates
Analyze Solar Projects Development to Inform Business Expansion
Pavel Shteling
Pavel Shteling
Get updates
Register today
Apply now

Analyze Solar Projects Development to Inform Business Expansion

Perform an analysis of Interconnection Queue data to drive renewable company expansion strategy.

Register today
Apply now
Wednesdays
 at
4:00
P.M.
 ET /
1:00
P.M.
PT
8 weeks, 2-3 hours per week
Intermediate
No experience required
No experience required
Some experience required
Degree and experience required

Description

To understand which markets to focus on in the future, Ampion needs to analyze open-source data provided by power grids called Interconnection Queue. Ampion is one of the industry leaders in Community Solar, providing opportunities to participate in shared solar projects through a concept called Community Solar. Through a software platform, Ampion connects residents, businesses, and other types of consumers with clean energy facilities, primarily Solar Farms. Interconnection Queue is a compilation of power generation and transmission projects seeking connection to the power grid.  In this Build Project, you'll wear the hat of a Data Analyst/Business Intelligence Analyst and perform an analysis of Interconnection Queue data to drive Ampion's expansion strategy. Under the supervision of an experienced Project Leader, you'll become familiar with Structural Query Language (SQL), which is used by thousands of companies for communicating with and manipulating databases. You'll also learn how to translate big data into a visual story using Tableau, another tool popular in the industry. All this will happen in an environment that simulates the operations of a real Data Analytics team.

Session timeline

  • Applications open
    May 27, 2024
  • Application deadline
    June 23, 2024
  • Project start date
    Week of July 8, 2024
    Week of
    July 8, 2024
  • Project end date
    Week of

What you will learn

  • Understand Structural Query Language (SQL), which is used by thousands of companies for communicating with and manipulating databases.  
  • Translate big data into a visual story using Tableau.

Project workshops

1
Introductions
2
Understand the basics of SQL
3
Build upon the basics of SQL
4
Introduction to Tableau
5
Tableau Dashboard and Dashboard Actions
6
Tableau Data Storytelling
7
Final Project Requirements
8
Polish your project deliverables / Present

Prerequisites

  • Interest in learning how to build dashboards. Prior Tableau and SQL knowledge is not required.  
  • Good analytical and problem-solving skills: you should be able to assess provided information with a critical eye and independently troubleshoot obstacles before asking the Project Leader for help.
  • Other prerequisites: before the project starts, you'll need to have Google Cloud Account for Google Sheets and BigQuery access; Tableau Free Trial (Build Fellow will inform students when to install Tableau).

Sign up today

Get access to all of our Build projects, including this one, by creating your Build account!

Register today
Log in

Apply to

Pavel

's project today!

Get started by submitting your application.

Apply now

Stay updated!

Subscribe to our newsletter to be notified when projects reopen!

Please fill in this required field.
By clicking “Subscribe” you agree to our Terms of Services and Privacy Policy.

Thanks for subscribing!

We'll notify you when projects reopen. In the meantime, you can explore our resources and learn more about our Fellows.

Discover our articles
There was an error submitting your form. Please try again later or contact us.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
About the expert

Pavel Shteling

Business Intelligence Fellow
Open Avenues Foundation

Hi, my name is Pavel, graduated with a master’s degree in Business Analytics from Suffolk University. I’m currently working in a role of a Salesforce Administrator and Data Administrator at Ampion Renewable Energy. Ampion is one of the industry leaders in Community Solar. We provide opportunities to participate in shared solar projects through a concept called Community Solar. Through a software platform, we’re connecting residents, businesses, and other types of consumers with clean energy facilities, primarily Solar Farms. Outside work, I enjoy outdoor activities, rowing, paddleboarding and snowboarding.

Visit
Pavel
's Linkedin
More like this Project