Ali Pirouz

Data Analyst skilled in Excel, SQL, Power BI, 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 Visualization
in Power BI

In this project I use Power BI to analyze and visualize data of default payments, demographic factors and credit data of credit card clients from data available in UCI.EDU Machine Learning Repository.

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)