Explore a selection of my personal projects
August 11, 2022
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…
February 22, 2021
Automatic collection of exchange rates from Riksbanken to Excel
VBA script for automatic collection of exchange rates from Sveriges Riksbank to Excel
February 5, 2021
Tableau stock price analysis – Apple
I’ve built a stock price analysis dashboard in Tableau.
January 11, 2021
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…
February 13, 2021
Customer segmentation project in R
Customers segmentation is one of the applications of unsupervised machine learning algorithms. Its…
March 7, 2021
SCB (Statistics Sweden) live dashboard
In this Power BI desktop project, I will explore data from Statistics Sweden's (Sw:…
January 7, 2021
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…
February 13, 2021
Sentiment Analysis Project in R
Sentiment Analysis is a text analysis process that aims at categorizing words in text data. In this…
March 4, 2021
Weekly streams from Spotify
In this Python and Tableau project I will scrape and visualize weekly streaming data from Spotify.
December 15, 2020
Interactive Python Web App Dashboard
Interactive Python Web App Dashboard built using the Plotly and Dash libraries and deploy using the…
November 25, 2020
The Battle of Neighborhoods in Queens
This project was the final assignment of the IBM Data Science Professional Certificate, in which…
November 26, 2020
Stock Market Analysis
Analysis of technology stocks, including change in price over time, daily returns, and stock…
January 30, 2021
Machine learning – Customer Churn Prediction
In this python project, I'll use fictive customer data from a bank to construct a machine learning…
July 14, 2021
Convert SIE4 to Excel with VBA
VBA macro to import and convert SIE4 files into structured Excel files.
January 5, 2021
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…
December 25, 2020
Data Cleaning with Python
Apply different techniques to clean and prepare a data set in order to do some data analysis and…
February 5, 2021
Three-statement financial model and DCF – Apple
Three-statement model with connected discounted cash flow model ("DCF model") of Apple Inc.
January 13, 2021
Waterfall/bridge charts in Excel
I have uploaded a sample workbook to my GitHub repository with some of my favourite waterfall…
March 2, 2021
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…
April 11, 2021
Price-Volume-Mix analysis on Apple
The Price-Volume-Mix analysis, let us see how individual factors, such as price changes, sales…