SQL Projects
A desire to win my Fantasy Football leagues led to a realization that I have a passion for Data Analytics. Creating this database provides 6 years of cleaned data to query and visualize for weekly analysis and preparation for the annual Fantasy Football draft.
​
Skills Demonstrated
-
DDL to create, alter, and insert values into tables
-
Quality Assurance checks to clean and validate data
-
Update Set to insert data into tables
-
HAVING clause to filter data
-
FILTER clause creating pivot tables to view data
We have all played with Lego's. A historical case study unveils how Lego's partnership with Star Wars resulted in a resurgence of production and popularity.
​
Skills Demonstrated
-
Joined multiple tables
-
Used CTEs and Sub Queries
-
Aggregated and Filtereddata
-
Window Functions
Follow along as we help Danny analyze sales at Danny's Diner to better understand customer trends.
​
Skills Demonstrated
-
Aggregated and Filtered data
-
Joined multiple tables
-
Window Functions
-
Dense_rank
-
CTEs
