About Me
Hello there! My name is Jonah, and I'm a passionate data analyst with a knack for turning raw data into meaningful insights. I have experience working with Python, Google Sheets, Tableau, and SQL, which allows me to harness the power of data and create compelling visualizations. When I'm not diving into datasets or crafting stunning dashboards, you can find me in the shop working on my latest CNC woodworking project. I believe that a balanced life is essential, and my hobbies keep me energized and excited to tackle new data challenges. Feel free to explore my projects and connect with me on LinkedIn. Let's create some data-driven magic together!
Contact Me
Feel free to connect with me on LinkedIn or GitHub:
You can also reach me by email at: macneill.jonah@outlook.com
Projects
Heart Failure Analysis
The primary objective of this analysis was to enhance the ability to predict the onset of heart failure in patients. Given that heart failure is the leading cause of mortality worldwide, it is imperative to continue investigating potential causes and prevention methods. Based on the findings of this study, it was discovered that elevated levels of serum creatinine and creatinine phosphokinase, as well as low ejection fraction, are indicators of increased risk of heart failure, particularly among individuals aged 10 to 50. As such, these metrics should be given priority focus within this age bracket. Additionally, the report outlines suggestions to enhance the accuracy of the dataset for more reliable outcomes.
Data Cleaning- Twitter Project
This project focused on cleaning Twitter data for analysis. Data was gathered from various sources, including a CSV file provided by Udacity, a TSV file containing animal predictions, and additional data from Twitter's API using Tweepy. The data was converted into a pandas dataframe and assessed both programmatically and visually to identify quality and tidiness issues. After the assessment, the data was cleaned and stored in a new CSV file. The cleaned data was then analyzed, demonstrating that it was ready for more in-depth analysis.
Tableau- Flight Cancellation Analysis
The dashboard provides an in-depth analysis of flight cancellations and delays in the United States. It reveals that weather is the most significant factor contributing to delays, with Chicago O'Hare International Airport (ORD) being the worst-affected in the country. To improve flight punctuality and reduce cancellations, the analysis suggests that airlines and airports should invest in better weather prediction systems, implement more efficient scheduling practices, and enhance communication with passengers during disruptive weather events..
Walmart Sales Dashboard
The Walmart sales dashboard provides an overview of the current month's sales compared to the previous year, along with the corresponding profit and margin. The dashboard features two graphs to compare the sales of different product categories and states, respectively. Overall, the dashboard allows for a quick and easy assessment of Walmart's sales performance, highlighting key trends and areas for improvement.