I analyzed the relationship between penguin flipper length and body mass using the Palmer Penguin dataset, performing end-to-end data preparation, exploration, and modeling in Excel. After cleaning over 300 records, I built a linear regression model explaining ~76% of the variance (R² = 0.76) with an RMSE of 392 g, indicating strong predictive performance.

I then developed visualizations in Excel and designed an interactive Power BI dashboard featuring a regression plot, distribution histogram, and species-level comparisons, showcasing my ability to transform raw data into clear, actionable insights.

My analysis revealed:

• Strong positive correlation between flipper length and body mass.
• Regression model achieved an RMSE of 392 g, indicating reliable predictions.
• Gentoo penguins have the highest average mass (~5.1 kg), while Adelie and Chinstrap average ~3.7 kg.

Project Workflow:

• Cleaned and prepared the dataset in Excel.
• Explored variables and identified key relationships.
• Built a linear regression model.
• Created visualizations and summary statistics in Excel.
• Designed an interactive Power BI dashboard featuring:
  • Regression plot (trendline + RMSE)
  • Distribution histogram
  • Species comparison bar chart
  • Interactive slicer
• Refined presentation for clarity and visual consistency.