November 17, 2022
How to Calculate Beta In Excel – All 3 Methods (Regression, Slope & Variance/Covariance)
0 Comments9 Minutes
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 applications to block macros in files from the internet.
0 Comments1 Minutes
July 14, 2021
Convert SIE4 to Excel with VBA
VBA macro to import and convert SIE4 files into structured Excel files.
0 Comments1 Minutes
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 volume changes and product mix changes impact your revenue.
0 Comments9 Minutes
March 7, 2021
SCB (Statistics Sweden) live dashboard
In this Power BI desktop project, I will explore data from Statistics Sweden's (Sw: Statistikmyndigheten SCB) Statistical database via their API.
0 Comments4 Minutes
March 4, 2021
Weekly streams from Spotify
In this Python and Tableau project I will scrape and visualize weekly streaming data from Spotify.
0 Comments1 Minute
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 daily data on the COVID-19 pandemic for the US and individual states.
0 Comments1 Minute
February 22, 2021
Qlik Sense Sales Analysis App
Sample Sales Analysis App built in Qlik Sense.
0 Comments1 Minute
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
0 Comments1 Minute
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 project, we will perform sentiment analysis on Amazon products reviews, using…
0 Comments1 Minute