Home

Andrew Ruhnow | Data Analyst

Welcome I’m Andrew Ruhnow, a data analyst with 8+ years of experience in workforce planning and a strong foundation in Python, SQL, Tableau, and Excel. I recently transitioned into analytics after completing the CareerFoundry Data Analytics program bringing together deep operational expertise with technical skill to solve complex business problems through data.

Portfolio Highlights

  • NYC Citi Bike Strategy Dashboard
    Combined weather data, trip logs, and geospatial mapping to identify peak demand areas and recommend bike redistribution strategies using Python, Plotly, and Kepler.gl.
    View Project →

  • Instacart User Behavior Analysis
    Analyzed 30M+ grocery orders to uncover user segmentation by time of day, product pricing, and household status. Delivered insights via Excel dashboards and visual storytelling.
    View Project →

  • World Happiness Report: Cluster Analysis
    Used clustering and correlation heatmaps to explore global well-being drivers, such as GDP, social support, and life expectancy. Presented findings in Tableau story format.
    View Project →

  • CDC Influenza Mortality Forecasting
    Merged CDC flu death counts with Census data to forecast mortality patterns by age and state using Excel + Tableau, emphasizing seasonal trends and high-risk populations.
    View Project →

  • Rockbuster Stealth SQL Case Study
    Queried a film rental company database with PostgreSQL to generate marketing recommendations, customer segmentation, and business expansion strategies.
    View Project →

  • Summit Bank Customer Retention Analysis
    Identified key churn indicators among bank customers using Excel pivot tables and decision tree logic. Focused on inactivity, short tenure, high balance, and low product use.
    View Project →

Technical Skills

  • Languages & Tools: Python, SQL, Excel, Tableau, Jupyter, Git
  • Libraries & Techniques: Pandas, NumPy, Matplotlib, Seaborn, Plotly, Data Wrangling, Forecasting, Dashboard Design

Get in Touch

Thanks for visiting — feel free to explore the full portfolio or reach out to connect.