Jan Dokoupil

Logo

Aspiring Data Analyst with hands-on experience in customer service, investment operations, and warehouse management. Proficient in Power BI, Excel, and Python, with growing expertise in SQL. Skilled in using data to drive informed decisions and eager to contribute to dynamic, data-driven teams.

View the Project on GitHub jdok8/portfolio

Data Analyst

Technical Skills: Power BI, Python, SQL, MS Excel

Multi-Tool Projects

View project here

This project combines the analytical capabilities of Python and Power BI to explore around 100,000 orders from the Brazilian e-commerce marketplace Olist. By leveraging Python for data preprocessing and Power BI for visualization, the project provides a comprehensive view of marketplace performance, including customer behavior, delivery performance, and sales trends.

Key Features:

E-Commerce Report

Python Projects

Sales Analysis: Evaluating Sales Strategies for Optimal Revenue

View project here

This project involves analyzing the effectiveness of different sales approaches (Email, Call, and Email + Call) using Python to optimize the company’s strategy. By evaluating the number of customers, revenue distribution, and overall performance for each method, the project provides data-driven recommendations on the most effective sales approach to maximize revenue while minimizing time and resource investment.

Tools & Libraries: Pandas, NumPy, Matplotlib, Seaborn Key Insights:

This project showcases data cleaning, exploratory data analysis (EDA), and visualization techniques, providing actionable insights based on customer sales data.

Power BI Projects

Personal Finance Analysis

View report here

This project facilitates in-depth analysis of family expenses by consolidating data from diverse sources, including CSV files from various bank accounts. Demonstrating advanced data visualization techniques within Power BI for educational purposes, the report showcases synthetic financial transactions. While the dataset contains multiple currencies, all values are uniformly presented in Danish Krone (DKK) in the visualizations unless explicitly stated otherwise. Offering insights into account balances, income, expenses, and investment trends over time, users gain comprehensive insights into their financial dynamics. The project consolidates data from CSV files representing transactions, ensuring seamless integration for ongoing analysis and optimization.

Personal Finance

Global Terrorism Analysis: Exploring Terrorist Incidents from 1970 to 2017

View report here

Global Terrorism Analysis is a project aimed at unraveling the complexities of global terrorism using interactive visualizations and data insights. Leveraging the extensive Global Terrorism Database (GTD), comprising over 180,000 recorded incidents, this project provides a comprehensive overview of terrorist activities worldwide. Through insightful analysis of attack types, geographical distributions, and temporal trends, stakeholders gain valuable insights into the multifaceted nature of terrorisms.

Global Terrorism

SQL Projects

As part of my SQL learning journey on DataCamp, I completed several projects involving data analysis. Here’s a brief summary of two key projects:

Impact Analysis of GoodThought NGO Initiatives

View project here

Evaluating of a Manufacturing Process

View project here

Analyzing Unicorn Companies

View project here

Education

Work Experience

Warehouse worker @ Salling Group (Jun 2022 – Present)

Investment Operations Officer @ FNZ Group (Apr 2021 - Feb 2022)

Customer Representative @ Zebra Technologies (Jun 2019 - Dec 2020)

Volunteering

Volunteer Teacher @ ReDI School of Digital Integration Aarhus (Mar 2025 – Present)

Licenses & certifications