@khaalidabdirahman
Khaalid Abdirahman portrait

Turning Data Into Decisions

I'm a data science student who turns data into clear insights and actionable solutions.

🟢 Open to work

Work samples

Dive into my projects where I apply data science principles to create impactful solutions.

  • Center for Improving Youth Justice Data Visualization
    Center for Improving Youth Justice Data Visualization
    Center for Improving Youth Justice logo

    Center for Improving Youth Justice · Aug 2026 · ✅ Verified by Extern

    Center for Improving Youth Justice Data Visualization

    A six-week externship with the Center for Improving Youth Justice focused on turning youth justice datasets into publication-ready visual stories using Flourish and Canva.

    DesignVisual Data StorytellingStrategic Communication
  • Designing a MySQL Relational Database for a Community Food Drive
    Designing a MySQL Relational Database for a Community Food Drive

    University of Minnesota · May 2025

    Designing a MySQL Relational Database for a Community Food Drive

    Gained hands-on experience applying MySQL to manage volunteers, staff, events, and donations Strengthened knowledge of database applications through scheduling, reporting, and community-use cases

    MySQLAdvanced QueryingRelational JoinsSQL Analytics

About me

I'm a data science student who turns data into clear insights and actionable solutions.

I am Khaalid Abdirahman, an Information Technology student at the University of Minnesota focused on Data Science. I combine hands-on data work, SQL and Python skills, and practical experience across analytics, IT support, and operations roles. I have translated justice datasets into publication-ready visual stories and built a MySQL relational database for small business use.

Externships

Center for Improving Youth Justice Data Visualization

Completed · Aug 2026

Experience

Extern

Center for Improving Youth Justice Data Visualization · 7/2026– 8/2026

Marketing Campaign Manager

Akiflow · 12/2025-2/2026

Budget Analyst

Minnesota Care Counseling Services, Minneapolis, MN · 6/2023 – 7/2025

IT Intern

FreeGeek Twin Cities, Minneapolis, MN · 9/2023 – 3/2024

Financial Analyst Intern

Quantum Pulse Consulting, Detroit, MI · 4/2025 – 6/2025

Front Desk Receptionist

Minnesota Care Counseling Services, Minneapolis, MN · 11/2021 – 6/2023

Education

University of Minnesota, Twin Cities

Bachelor of Applied Science, I.T.I with focus in Data Science · Class of 2027

Skills

PythonSQLMicrosoft ExcelGoogle SheetsMicrosoft WordPowerPointGoogle DocsWindowsMacOSLinuxData VisualizationData Storytelling

✅ Verified by Extern

Center for Improving Youth Justice Data Visualization

A six-week externship with the Center for Improving Youth Justice focused on turning youth justice datasets into publication-ready visual stories using Flourish and Canva.

DesignVisual Data StorytellingStrategic Communication

Overview

As a Data Visualization Extern for the Center for Improving Youth Justice, I analyzed performance data from 85 juvenile justice facilities to investigate whether isolating youth for misconduct reduces behavioral problems. Using Flourish and Canva, I built a visual data story, "The Isolation Paradox", presenting several charts to surface the relationship between isolation use and misconduct rates.

Center for Improving Youth Justice Data Visualization

What I've accomplished

I identified that high-isolation facilities had disproportionately higher misconduct rates than low-isolation facilities, while facilities with minimal isolation use showed stronger family/staff relationships and higher perceived fairness among youth. I compiled these findings into a slide presentation with data-backed recommendations to shift discipline practices away from isolation.

Project breakdown

View all work
Back to work

Designing a MySQL Relational Database for a Community Food Drive

Gained hands-on experience applying MySQL to manage volunteers, staff, events, and donations Strengthened knowledge of database applications through scheduling, reporting, and community-use cases

MySQLAdvanced QueryingRelational JoinsSQL Analytics

Overview

Gained hands-on experience applying MySQL to manage volunteers, staff, events, and donations Strengthened knowledge of database applications through scheduling, reporting, and community-use cases

Designing a MySQL Relational Database for a Community Food Drive

What I've accomplished

Designed and developed a normalized MySQL relational database for a community food drive volunteer management system. Created tables, primary and foreign key relationships, ER diagrams, SQL queries, views, KPIs, triggers, and stored procedures to support volunteer coordination, event management, inventory, donations, and resource distribution.

Outcome

Developed a normalized MySQL database that streamlined volunteer, event, donation, inventory, and resource tracking while supporting data-driven reporting and decision-making.

View all work