Business Analytics • Data Storytelling • Technical Problem Solving

I like using data to find patterns, solve problems and build clearer reporting

Available to Relocate

I’m Julia Monson, a Business Analytics and Information Systems student at Eastern Illinois University building practical projects across Power BI, SQL, Python, and database systems. My portfolio is meant to show the projects, tools, and problem-solving skills I’ve built through coursework, internships, and independent work.

View My Work GitHub LinkedIn
SQL + Python + Power BI
Studying for AWS Certified Cloud Practitioner
ETL Developer/Data Analyst working with the Revenue Operations team in the Finance Department
D1 Cross Country & Track Athlete

Featured Projects

These projects highlight my strongest independent work, internship experience, and portfolio pieces that best show how I turn structured data into useful insight.

Border Crossing Power BI Dashboard

Power BI Data Visualization

Developed an interactive Power BI dashboard analyzing U.S. border crossing activity over time using Bureau of Transportation Statistics data. Used time-series analysis, regional comparisons, and crossing-type groupings to show patterns in trade and travel behavior.

  • Analyzed border crossing trends from 2016–2025
  • Identified seasonal patterns and regional differences
  • Applied regression modeling to understand drivers of high-volume crossings
Power BI Time Series Statistical Modeling
Border crossings dashboard screenshot showing long-run trend and annual totals

Overview page showing long-run border crossing trends and summary metrics.

Border crossings dashboard screenshot showing seasonality analysis

Seasonality page comparing monthly border crossing activity across years.

Border crossings dashboard screenshot showing crossing type and geographic differences

Geographic and crossing-type breakdown highlighting top ports and border regions.

Border crossings dashboard screenshot showing high-volume crossing indicators

High-volume crossing page showing indicators tied to traffic intensity.

Scroll through the dashboard screenshots to view trend analysis, seasonality, geographic differences, and high-volume crossing indicators.

View Project Review
SQL Data Cleaning Project

Data Cleaning & Transformation in SQL

Cleaned and standardized raw Nashville housing data using SQL by handling null values, removing duplicates, correcting inconsistent values, and transforming columns into more usable formats. This project shows my ability to clean raw data and prepare it for analysis and reporting.

SQL Data Cleaning Transformation
View Code View Dataset
COVID-19 Data Analysis

COVID-19 Vaccination & Mortality Analysis | SQL & Tableau

Used SQL to clean and join global COVID-19 death and vaccination datasets, then built Tableau dashboards to explore how vaccination rollout correlated with shifts in death rates across countries and time periods. Currently extending the project with primary survey data collected via Qualtrics.

  • Cleaned and transformed multi-table datasets using SQL joins, window functions, and aggregations
  • Used CASE statements to segment data into Pre-Vaccination (2020), Early Vaccination (2021), and Expanded Vaccination (2022+)
  • Found case fatality rates dropped in 4 out of 5 countries after vaccination rollout (India: 1.45% → 0.71%, China: 4.99% → 0.96%)
  • Built a CTE to calculate cumulative vaccination rollout by country over time
  • Applied a 7-day rolling average to smooth daily death reporting spikes
  • Ranked countries by deaths per 100,000 using RANK() for fair comparisons
  • Identified data limitations such as reporting inconsistencies and time-lag effects
  • Collecting primary data via Qualtrics to complement quantitative analysis
Death rate ranking query

Countries ranked by COVID-19 death rate per 100,000 population using RANK() window function

Case fatality comparison

Case fatality rate comparison across vaccination eras using CASE statements for five key countries

Vaccination rollout CTE

Cumulative vaccination rollout trajectory using CTE and SUM window function

Rolling average deaths

7-day rolling average of new deaths using AVG with ROWS BETWEEN frame

SQL Data Analysis Qualtrics Tableau
View Code View Dashboard View Survey Instrument View Dataset (Deaths) View Dataset (Vaccinations)

Internship Experience

My internship work focused on revenue operations, system mapping, workflow troubleshooting, data cleanup, and cross-functional problem solving across business systems.

ETL Development/Data Analyst-Revenue Operations Team

SalesRabbit Internship

During my Revenue Operations internship at SalesRabbit, I worked across multiple business systems including Planhat, Salesforce, Zendesk, Ordway, Rocketlane, Zapier, Notion, and BigQuery to improve data accuracy, system integrations, and workflow reliability.

I supported system mapping and integration efforts by defining field relationships, validating bidirectional sync logic, and troubleshooting data flow issues between platforms. I identified and resolved data inconsistencies, including diagnosing a major invoice discrepancy caused by incorrect ID mappings across systems.

Revenue Operations Systems Mapping Data Cleanup Cross-Functional Support Data Integration
Invoice workflow automation used during my SalesRabbit internship

Simplified workflow diagram (blurred to protect company data)

Workflow automation used to update invoice status based on Salesforce conditions, balance validation, and system logic.

Highlights

  • Mapped native integrations between Planhat, Salesforce, and Zendesk.
  • Investigated invoice duplication issues and identified swapped ID mappings as a source of discrepancies.
  • Validated bidirectional field mappings and helped troubleshoot task and contact sync issues.
  • Documented processes, system logic, and workflow issues for internal teams and vendor support.

Impact

  • Improving invoice and account data accuracy by 25%.
  • Improved data accuracy by identifying and resolving duplicate invoice issues across connected systems.
  • Strengthened workflow reliability through debugging and refining automation logic.
  • Improved visibility into system behavior by documenting workflows, mappings, and recurring sync issues.
  • Supported cleaner cross-platform data flow between Planhat, Salesforce, Zendesk, and Ordway.

Coursework Showcase

This section turns my academic work into a technical skills portfolio, highlighting the tools, methods, and problem-solving experience behind my coursework.

SQL Coursework

  • Joins, subqueries, sorting, and grouped analysis
  • Aggregate functions such as COUNT, SUM, AVG, MIN, and MAX
  • Query logic using WHERE, AND/OR, LIKE, and calculated fields
SQL Relational Data Query Design

Python Coursework

  • Built a Rock-Paper-Scissors Game
  • File-based analysis using gas price and population datasets
  • Object-oriented projects using classes, inheritance, and encapsulation
  • Interactive programs, string processing, and logic-based problem solving
Python OOP File Processing

Access Coursework

Developed relational database projects using tables, relationships, forms, reports, lookup fields, validation rules, and custom queries. This coursework built a strong foundation in database structure, data entry design, and reporting workflows.

  • Relationship modeling with referential integrity
  • Custom forms, subforms, and reports for business-style workflows
  • Validation rules, parameter queries, crosstab queries, and calculated fields
Access Database Design Forms & Reports

About Me

I’m building a career in analytics by combining technical skill, systems thinking, and a strong work ethic.

Julia Monson headshot

I’m a Business Analytics & Information Systems student at Eastern Illinois University with experience in SQL, Power BI, and data analysis. I enjoy working with real-world datasets to uncover trends and build meaningful insights.

Julia running

Outside of academics, I’m a long-distance runner, which has strengthened my discipline, consistency, and goal-oriented mindset.

As a Business Analytics and Information Systems student, I enjoy working with data, identifying patterns, and improving the systems behind business operations. My experience across SQL, Python, Power BI, databases, and revenue operations reflects both technical curiosity and a practical, business-focused mindset.

Beyond the classroom

Competing as a Division I Cross Country and Track athlete has required balancing a demanding training schedule with academic and technical work. Managing early mornings, travel, and consistent performance has strengthened my ability to stay organized, focused, and accountable over long periods of time. Outside of running and analytics, I'm usually picking up a new dataset to explore or figuring out how something works — I genuinely like the problem-solving side of this field.

  • Division I Cross Country & Track
  • Strong time management and accountability
  • Comfortable performing in high-pressure environments
  • Motivated by long-term growth and disciplined execution

Skills & Tools

A mix of analytics, programming, and database tools that support data-driven work.

Programming

  • Python
  • SQL

BI & Visualization

  • Power BI
  • Tableau

Databases

  • Microsoft Access
  • MS SQL Server
  • BigQuery
  • Oracle

Business Tools

  • Excel
  • GitHub
  • Salesforce
  • Zendesk
  • Planhat
  • Notion