admin

Data modelling, sales and profitability analysis for a global company in Power BI

Overview I completed this project as part of my technical interview process for a data analyst role at one company. Having found the project fun and engaging, I thought it would be good to share it here as well. The process followed in data cleaning, modelling, and analysis is explained on the first page of […]

Data modelling, sales and profitability analysis for a global company in Power BI Read More »

Stock returns simulation and Financial Risk Analysis in R

This project was initially completed as part of a school assignment in Risk Analysis at Dalarna University. I collaborated with a colleague, Zarif Mahmud. The project involves conducting risk vs returns analysis on stocks of six US companies, and additional Monte Carlo simulations to simulate future prices, as well as a portfolio choice based on

Stock returns simulation and Financial Risk Analysis in R Read More »

Cyberattacks analysis and monitoring dashboard in Power BI

Introduction Cyberthreats are a growing concern for businesses of all sizes and across all industries. The global cost of cybercrime is estimated to reach $10.5 trillion annually by 2025, according to Cybersecurity Ventures. This staggering number reflects the direct and indirect costs of cyberattacks, including data breaches, ransomware payments, business disruptions, and reputational damage. Organisations

Cyberattacks analysis and monitoring dashboard in Power BI Read More »

Tracking global COVID-19 vaccinations with a Tableau Dashboard

Introduction In the wake of the unprecedented COVID-19 pandemic, humanity witnessed the remarkable mobilization of scientific innovation, global collaboration, and the indomitable spirit of resilience. The battle against the virus spurred an urgent need for effective solutions, leading to the development of vaccines at an astonishing pace. As the world rallied to combat the pandemic,

Tracking global COVID-19 vaccinations with a Tableau Dashboard Read More »

Flavours of Sentiment: Leveraging NLP for Restaurant Review Analysis

Introduction In today’s digital age, where opinions and experiences are shared at the click of a button, understanding customer sentiment has become more crucial than ever. As businesses strive to provide exceptional products and services, they turn to the wealth of customer feedback available online to gain insights into customer satisfaction, preferences, and areas for

Flavours of Sentiment: Leveraging NLP for Restaurant Review Analysis Read More »

A Machine Learning approach to predicting the likelihood of an accident insurance claim

Project Introduction Insurance companies face the challenge of accurately predicting the likelihood of policyholders filing claims, as it directly affects policy pricing and risk assessment. Understanding the factors that influence the possibility of an insurance claim is crucial for insurers to establish fair and competitive pricing structures. However, predicting claims is not a straightforward task,

A Machine Learning approach to predicting the likelihood of an accident insurance claim Read More »

Visualising results of survey of data professionals in Power BI

In 2022, Youtuber Alex aka Alex the Analyst conducted an online survey of data professionals across the world. The purpose of the project was to establish the extent of job satisfaction of various professionals in the data sector. In addition to this, the survey also asked data professionals about their salary range, favorite programming language,

Visualising results of survey of data professionals in Power BI Read More »

Employee attrition dashboard in TABLEAU

In this project, I utilized a dataset of employee information to analyze attrition patterns and develop insightful visualizations. By exploring various factors such as attrition by department, gender, age group, and education level, I aimed to provide valuable insights into attrition trends and identify areas where the organization can improve employee retention strategies. The following

Employee attrition dashboard in TABLEAU Read More »

Predicting wine types using Machine Learning in R: A comparison of algorithms

In this project, we delve into the world of wine classification using machine learning algorithms. We explore the wine quality dataset, aiming to predict the type of wine (red or white) based on several key factors. Through a comparative analysis of three popular machine learning algorithms, we uncover the strengths and weaknesses of each approach,

Predicting wine types using Machine Learning in R: A comparison of algorithms Read More »

Analysing telecommunications customer churn in Power BI

Understanding Customer Churn Customer churn refers to the phenomenon of customers discontinuing their relationship with a company or brand. It occurs when customers decide to terminate their subscriptions, contracts, or services, thereby ceasing their engagement with the business. Churn can have a significant impact on a company’s bottom line, as acquiring new customers is typically

Analysing telecommunications customer churn in Power BI Read More »