Solar Project

A data project showcasing my skills in SQL, R, and Tableau

About

This is a personal project I started on my free time to demonstrate my technical abilities. In this project, I source a large public dataset from Kaggle, utilize MySQL to prepare the data, R Studio to conduct statistical analysis, and Tableau to visualize my results.

The Data

I sourced my data from Kaggle, and used the Solar Power Generation Data set.

Caption photos easily. On the left, a road goes through a tunnel. Middle, leaves artistically fall in a hipster photoshoot. Right, in another hipster photoshoot, a lumberjack grasps a handful of pine needles.

Clean Up and Exploratory Analysis

I used excel and sql to clean and streamline the data

This image can also have a caption. It's like magic.

You can also put regular text between your rows of images, even citations (Einstein & Taub, 1950). Say you wanted to write a bit about your project before you posted the rest of the images. You describe how you toiled, sweated, bled for your project, and then… you reveal its glory in the next row of images.

You can also have artistically styled 2/3 + 1/3 images, like these.

The code is simple. Just wrap your images with <div class="col-sm"> and place them inside <div class="row"> (read more about the Bootstrap Grid system). To make images responsive, add img-fluid class to each; for rounded corners and shadows use rounded and z-depth-1 classes. Here’s the code for the last row of images above:

<div class="row justify-content-sm-center">
  <div class="col-sm-8 mt-3 mt-md-0">
    {% include figure.liquid path="assets/img/6.jpg" title="example image" class="img-fluid rounded z-depth-1" %}
  </div>
  <div class="col-sm-4 mt-3 mt-md-0">
    {% include figure.liquid path="assets/img/11.jpg" title="example image" class="img-fluid rounded z-depth-1" %}
  </div>
</div>