Sample Projects
A comprehensive collection of tutorials and sample projects that demonstrate my ability to effectively use Excel, SQL, Tableau, and other data analytics tools.
Tableau COVID-19 Tracker Dashboard
Complete walkthrough for creating a COVID-19 Tracker dashboard using Tableau
Create Charts and Graphs
Create Sets, Calc. Fields, Parameters
Use Mechanics of Sheet Swapping
Design Interactive Dashboard
Full Data Analysis Portfolio Exercise (SQL, Excel, Tableau)
Complete walkthrough for creating and analyzing a dataset
Create dataset using SQL
Create executive dashboard using Excel
Create executive dashboard using Tableau
SQL Section (Portfolio Exercise)
SQL query to pull necessary data from a database
Plan and design dataset
Write detailed SQL query
Review and error-check dataset
Excel Section (Portfolio Exercise)
Detailed Excel dashboard creation process
Connecting SQL dataset to Excel
Create PivotTables and PivotCharts
Create interactive dashboard