👋 Hi, I'm Austin Rhodes Sorenson

Data Analyst | Data Specialist | Data Entry

📊 CNC Programmer Turned Data Analyst
💻 Excel, Tableau, SQL, Python
🧘 Meditation, Computer Building, Golf
📍 Durham, North Carolina USA


Technical Skills

  • Tableau

  • SQL

  • Excel

  • Python

  • R

  • Project Management

  • Data Analysis

  • Critical Thinking


Projects

🏎️ Hamilton vs. Leclerc: Analyzing F1’s Rivalry with Excel

Excel | Exploratory Data Analysis
◾ Created a custom dataset with over 15 columns and 50 rows of key performance metrics from the F1 official website
◾ Conducted data cleaning and transformation in Excel to facilitate accurate comparisons
◾ Utilized Excel for data visualization, including bar charts and line graphs to highlight performance differences
◾ Analyzed performance metrics to reveal Leclerc's significant improvement and competitive edge in 2024

.

📊 School Performance Insights with Tableau

Tableau | Data Visualization
◾ Developed an interactive dashboard to assess the performance of 1,800 schools across hundreds of metrics
◾ Utilized Scatter Plots, KPIs, Bar Charts, and Area Charts to highlight performance variations
◾ Delivered insights to stakeholders through a recorded video presentation

.

💵 SQL-Based Financial Analysis of World Bank Loans

SQL | Exploratory Data Analysis
◾ Analyzed 1.2 million real bank transactions to identify financial anomalies, trends, and patterns
◾ Utilized SQL queries with SELECT, WHERE, GROUP BY, AVG, MIN/MAX, SUM, and other key clauses for data exploration
◾ Compiled a detailed report summarizing key insights and findings

.

🏥 Analyzing Hospital Data with SQL

SQL | Exploratory Data Analysis
◾ Analyzed what affections hospital stay length in MySQL
◾ Created a histogram using SQL (weird, I know)
◾ Real data from over 101,000 hospital patients

.

🏀 Analyzing NBA Data with Tableau

Tableau | Dashboarding
◾ Analyzed 2022 NBA season data to identify key trends
◾ Created interactive visualizations, including Stacked Bar Charts, Heatmaps, Treemaps, and Bubble Charts
◾ Developed a Tableau story and presented insights in a comprehensive report

.