Explore a selection of my personal projects
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…
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…
March 4, 2021
Weekly streams from Spotify
In this Python and Tableau project I will scrape and visualize weekly streaming data from Spotify.
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…
November 25, 2020
The Battle of Neighborhoods in Queens
This project was the final assignment of the IBM Data Science Professional Certificate, in which…
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 5, 2021
Three-statement financial model and DCF – Apple
Three-statement model with connected discounted cash flow model ("DCF model") of Apple Inc.
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 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…
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 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…
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…
November 26, 2020
Stock Market Analysis
Analysis of technology stocks, including change in price over time, daily returns, and stock…
February 13, 2021
Customer segmentation project in R
Customers segmentation is one of the applications of unsupervised machine learning algorithms. Its…
December 15, 2020
Interactive Python Web App Dashboard
Interactive Python Web App Dashboard built using the Plotly and Dash libraries and deploy using the…
July 14, 2021
Convert SIE4 to Excel with VBA
VBA macro to import and convert SIE4 files into structured Excel files.
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…