Data Analyst Skilled in SQL, EXCEL, PYTHON, TABLEAU, WEB-SCRAPPING and POWER BI @Joel The Analyst
In this project, we conduct data cleansing procedures on housing data within SQL Server. This includes tasks such as identifying and resolving inconsistencies, errors, and missing values, standardizing data formats, removing duplicates, correcting errors, validating data integrity, and performing transformations to facilitate analysis and derive meaningful insights..
Conducting thorough data exploration on the COVID-19 dataset within SQL Server, we meticulously analyze the intricacies of pandemic-related data. This process entails rigorous examination to unveil underlying trends, patterns, and insights crucial for informed decision-making and policy formulation in the face of global health challenges..
Explore my Tableau profile to view a comprehensive collection of data visualization projects, showcasing insightful dashboards such as those highlighting London bike sharing trends, road accident statistics, King County house sales analysis, and AirBnB insights.
Conducting an Exploratory Data Analysis (EDA) on the Boston Housing Dataset, our objectives include examining the impact of various variables on house prices, identifying and analyzing significant variables influencing house prices, predicting price ranges through regression analysis, developing a comprehensive linear regression machine learning model for house price prediction. Additionally, we aim to understand housing preferences within specific customer segments, such as people of color and individuals from lower socioeconomic backgrounds, assuming the study's application within a real estate business context. Furthermore, the analysis involves a brief exploratory study of inter-variable dependencies to gain deeper insights into the dataset's relationships.
Conducting a thorough Exploratory Data Analysis (EDA) of the bike store sales market, this study aims to provide comprehensive insights into various aspects of the industry. Through meticulous examination of sales data, customer demographics, and market trends, our objective is to gain a deeper understanding of key factors influencing sales performance and market dynamics. Additionally, this analysis seeks to identify patterns, opportunities, and challenges within the bike store market landscape, facilitating informed decision-making and strategic planning for stakeholders and industry players alike
China
Beijing,