Regina Haley – Data Analytics and Software Development Portfolio. I’m learning both, with analytics as my foundation and software dev as my expansion and AI Software Engineer as my long term goal.
Welcome! I'm Regina and I am a self-driven professional transitioning into the field of data analytics and software dev. What began as a curiosity has grown into a real passion and purpose. This portfolio showcases hands on projects I’ve completed to demonstrate core competencies in SQL, Excel and Python as well as HTML, CSS and Javascript, each aligned with real-world business needs.
My goal: to land anapprenticeship or junior role where I can continue building skills through applied work, mentorship and collaborative problem-solving while working on my AAS for AI Software Engineering.
This project collection was created to demonstrate the foundational skills expected in entry-level roles and apprenticeships:
Data Analytics Foundations
- Working with real data (structured, incomplete, or messy)
- Querying databases using SQL
- Cleaning and analyzing data using Excel and Python
- Creating charts and dashboards
- Summarizing and communicating insights
Software Development Foundations
- Building small web projects with HTML, CSS, and JavaScript
- Using Python scripts to automate tasks and connect data to applications
- Learning version control with Git and GitHub (branching, commits, pull requests)
- Structuring projects into folders and files like a professional developer
- Serving and testing projects locally using PowerShell and Python’s built-in server
- Beginning to connect front-end (web) and back-end (databases, Python)
Explores customer demographics using pandas and SQLite. Generates summary statistics and visualizations to identify trends by age group and email domain.
Demonstrates intermediate SQL skills including JOIN, GROUP BY, HAVING, subqueries and CRUD operations on a structured database.
An interactive dashboard that connects an SQLite database with Python scripts and a JSON export, then visualizes the results in a web page using Chart.js. Tracks weekly study minutes, time by topic.
Analyzes team project workloads using PivotTables, charts and summary statistics in Excel to support resource allocation decisions.
Monthly dashboard showing revenue trends, category breakdowns and KPIs with slicers and charts.
- SQL: SQLite, DB Browser
- Excel: PivotTables, charts, data cleaning
- Python: Jupyter Notebook, pandas, sqlite3, pathlib, json
- Web Development: HTML, CSS, JavaScript, Chart.js
- Command Line: PowerShell for file management, running scripts and Git workflow
- GitHub: Version control, project organization and documentation
This portfolio reflects the skills and mindset I bring: resourcefulness, attention to detail and a hunger to learn by doing. I'm seeking opportunities to grow under mentorship while contributing to real-world projects.
📩 Let’s connect: LinkedIn