In this SQL AND Tableau project i compare the shooting percentages and over statistics between the best players in the sport and create a dashboard to easily view the information .
In this project i use microsoft excel and a coffee sales dataset to make an interactive dashboard to easily and efficiently view the data. I utilize functions like XLOOKUP, IFELSE, and MATCH to conjoin data to easily make my pivot tables.
Here i work with some very messy data and go through the process of cleaning and reformatting this data in RStudio aswell as provide insights after cleaning utilzing tidyverse and ggplot2.
In this project i utilize python to write a script to compile a list and make a table of the top 500 performing companies in the USA from a website using Pandas, BS4 and request and then import it into a csv for viewing purposes.