Explore a selection of my personal projects

SIE4 to excel

Convert SIE4 to Excel with VBA

VBA macro to import and convert SIE4 files into structured Excel files.

queens python

The Battle of Neighborhoods in Queens

This project was the final assignment of the IBM Data Science Professional Certificate, in which…

Customer segmentation project in R

Customers segmentation is one of the applications of unsupervised machine learning algorithms. Its…

Tableau Sales Dashboard

I've built a sample sales analysis dashboard in Tableau.

Three-statement financial model and DCF – Apple

Three-statement model with connected discounted cash flow model ("DCF model") of Apple Inc.

SCB Power BI

SCB (Statistics Sweden) live dashboard

In this Power BI desktop project, I will explore data from Statistics Sweden's (Sw:…

stock price analysis python

Stock Market Analysis

Analysis of technology stocks, including change in price over time, daily returns, and stock…

VBA

My most useful Excel macros (VBA)

In this post, I have listed some of my most useful VBA codes examples to help you become more…

Apple net sales development

Price-Volume-Mix analysis on Apple

The Price-Volume-Mix analysis, let us see how individual factors, such as price changes, sales…

Weekly streams from Spotify

In this Python and Tableau project I will scrape and visualize weekly streaming data from Spotify.

Data Cleaning with Python

Apply different techniques to clean and prepare a data set in order to do some data analysis and…

Tableau stock price analysis – Apple

I’ve built a stock price analysis dashboard in Tableau.

Covid-19 US Tableau

COVID-19 pandemic for the US and individual states

In this Tableau desktop project, I will explore data from The COVID Tracking Project which contain…

World Economic Outlook, October 2020: A Long and Difficult Ascent

In this Power BI desktop project, I will explore data from the IMF WEO database October 2020…

Sentiment Analysis Project in R

Sentiment Analysis is a text analysis process that aims at categorizing words in text data. In this…

Machine learning – Customer Churn Prediction

In this python project, I'll use fictive customer data from a bank to construct a machine learning…

Waterfall/bridge charts in Excel

I have uploaded a sample workbook to my GitHub repository with some of my favourite waterfall…

Interactive Python Web App Dashboard

Interactive Python Web App Dashboard built using the Plotly and Dash libraries and deploy using the…

Macros from the internet will be blocked by default in Office

To help improve security in Office, Microsoft is changing the default behavior of Office…

Qlik Sense

Qlik Sense Sales Analysis App

Sample Sales Analysis App built in Qlik Sense.

World population estimates and projections from 1960 to 2050

In this Power BI desktop project, I will explore data from the Population Estimates And Projections…

VBA

Automatic collection of exchange rates from Riksbanken to Excel

VBA script for automatic collection of exchange rates from Sveriges Riksbank to Excel

Sales Analysis Dashboard

Sample Sales Analysis Dashboard built in Power BI.