TABLEAU
Analysis of 5 years of Avocado Volume and Pricing by State
Analyzed 5 years of Avocado Board Data identifying 45% growth in volume
Identified source of growth due to 351% increase in sales of bagged avocados
Utilized VLOOKUP to incorporate 3rd party data into analysis
Analysis of 30 years UN Energy Data visualizing increase in Electricity Grid
Accessed and analyzed primary UN energy statistics, joined/blended data from 8 tables
Recorded 125% global total electricity growth
Highlighted China’s rise from ~7% to ~24% of global electricity displacing US from top spot
Analysis of 30 years of Global Energy Fossil Fuel and Alternative Energy
Analyzed 128 column energy dataset, with over 240 locations recording global trends
Created interactive dashboards visualizing global, historical and current KPI’s for fossil fuels and renewables
Identified global trend in coal reduction while observing China’s coal consumption is 54% of world coal consumption
EXCEL DASHBOARDS
Dynamic Dashboard that with filters sales data by region, product and year
Cleaned data to remove duplicates, create age groups.
Dynamic dashboard that filters sales data by region, education level, marital status.