Sophia Dassen

Data Analyst Portfolio

End-to-end analytical workflows and practical solutions.

SQL Python Power BI Excel Statistics

Education

Data Analyst Training

Self-directed based on independent job market research

Aug 2024 – now

I analyzed 35+ job postings to identify the most in-demand Data Analyst skill set, then designed and executed a learning plan based on that analysis. I completed online courses and hands-on coursework, then applied my skills in practical, real-world projects.

Git & GitHub

To support collaboration, track changes, and maintain clean, transparent codebases.

REPOSITORIES:

Job Posting Skill Mentions ETL Pipeline
  • End-to-end Python extraction scripts managed with Git
  • SQL Server scripts for data transformation and loading managed with Git
Portfolio Website Development
  • Portfolio website published via GitHub Pages
  • HTML, CSS, and JavaScript source code managed with Git

Excel & VBA

To clean and analyze large datasets, automate workflows, and build dynamic reports.

PROJECTS:

Skill Standardization Pipeline
  • Skill standardization workflow built with Power Query and dynamic array formulas
  • Interactive dashboard for skill demand analysis
Course Progress Tracker
  • Course completion algorithm with automated progress tracking
  • KPI dashboard for learning progress monitoring

SQL

To query, filter, and combine large datasets, analyze trends, and turn raw data into high-impact findings.

PROJECTS:

Job Posting Skill Mentions ETL Pipeline
  • SQL Server database with staging and core schemas
  • Star schema supporting multidimensional skill demand analysis
Skill Demand Cluster Analysis
  • Complex SQL queries for identifying in-demand skill clusters

Statistics

To summarize data, test hypotheses, and analyze relationships for data-driven decisions.

PROJECT:

Hypothesis Test Result Visualization Module
  • Distribution plots with p-values and rejection regions
  • Explanatory notes for interpreting hypothesis test results
  • Seven supported hypothesis test types

University of Groningen

Bachelor of Arts in Art History

Sep 2018 – Jul 2021

Honours College

Apr 2019 – Jul 2021

Transferable Skills

Art History training has equipped me with several transferable skills that I apply in my data analysis projects:

  • Pattern recognition
  • Research & critical thinking
  • Attention to detail
  • Visual communication

Academic Profile

  • BA Art History (180 ECTS)
  • Honours Programme (45 ECTS)
  • Language of instruction: English
  • Weighted average grade: 8.1 / 10

About

Analytical mindset

My programming background has shaped my analytical thinking in several ways. Informed by error handling, I prioritize the early detection of data quality issues to produce accurate and reliable insights. I automate the analysis workflow wherever possible, focusing on reproducibility and long-term efficiency.

Programmatic problem-solving is a tool I use to develop a deep and thorough understanding of the underlying problem. I approach project execution iteratively, striving for correctness at every stage and treating incremental improvement as part of the process.

Decision making

I take a cautious approach to interpreting results, considering the variables that may be influencing the outcomes. As with hypothesis testing, I take the results as evidence at a given level of confidence, rather than as proof.

I apply the same standard when communicating findings, designing visualizations that enable users to explore the data and extract usable insights, without requiring deep familiarity with the raw data. I am looking forward to observing how experts in high-stakes environments make decisions despite analytical uncertainty.

Career goals

As a junior analyst, I understand my role as taking ownership of scoped analytical work with high standards of accuracy and reliability, contributing to the overall effectiveness of the team.

At this stage, I am comfortable working independently on foundational, end-to-end analytical tasks. The area where I expect to grow the most is domain knowledge, which is essential for working with more complex datasets and analytical challenges.