In this project I take the raw global super store data, create a new database and schemas, normalize the data, engineer data objects for the purpose of analysis, utilizing T-SQL then run an analysis on the data with PowerBI.
Hostings
For this project, I use the AdventureWorks database to explore various functions of T-SQL.
Hostings
In this project, I use Snowpark's unique feature to leverage Python UDFs within a SQL UDF for utilizing Pthyon code directly into my Snowflake SQL scripting. An example with fuzzy matching.
