Explore a selection of my personal projects

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…

VBA

Automatic collection of exchange rates from Riksbanken to Excel

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

Tableau stock price analysis – Apple

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

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…

Customer segmentation project in R

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

SCB Power BI

SCB (Statistics Sweden) live dashboard

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

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…

Weekly streams from Spotify

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

Interactive Python Web App Dashboard

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

Sales Analysis Dashboard

Sample Sales Analysis Dashboard built in Power BI.

queens python

The Battle of Neighborhoods in Queens

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

stock price analysis python

Stock Market Analysis

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

Qlik Sense

Qlik Sense Sales Analysis App

Sample Sales Analysis App built in Qlik Sense.

Machine learning – Customer Churn Prediction

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

SIE4 to excel

Convert SIE4 to Excel with VBA

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

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…

Data Cleaning with Python

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

Three-statement financial model and DCF – Apple

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

Waterfall/bridge charts in Excel

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

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…

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…

Tableau Sales Dashboard

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