Ali Pirouz

Data Analyst skilled in SQL, Tableau, Cognos Analytics & Python

Data Cleaning
in SQL

In this project I take Nashville raw housing data and transform it in SQL Server to make it more usable for analysis.
(using join, substring, case statement, CTE and window functions)

Data Exploration
in SQL

In this project I use SQL Server to explore uptodate global COVID 19 data from "Our World in Data" website.
(using joins, CTE, temp tables, windows functions, aggregate functions and data convertion)