SQL Data
Cleaning
SQL data cleaning. Use of Select, Alter Table, Update, Drop statements, along with CTE's.
Hi, I'm Aaron! I'm a Data Analyst based in Ann Arbor, Michigan skilled in Excel, SQL, Power BI, and Python.
Currently working towards Microsoft Power BI Data Analyst Professional Certificate Coursera
and taking the Exam PL-300: Microsoft Power BI Data Analyst.
15 years of e-commerce experience and 5+ years of experience as a Data Analyst. @aaronecruz
SQL data cleaning. Use of Select, Alter Table, Update, Drop statements, along with CTE's.
Exploring COVID data using SQL. Use of CTE's, Views, Temp Tables.
In this project I do some basic data cleaning of sample housing data using Python, Pandas and Jupyter Notebooks.
In this project I look at what variables effect the gross revenue from movies. Creating scatter plots and regression plots using Python, Pandas and Seaborn.
Additional Data cleansing in Python. Cleaning and standardizing phone numbers, addresses, two common things that need fixing in raw customer/sales data.