Data Visualisation

Data visualisation projects completed using python (Matplotlib, Seaborn, Plotly), R (ggplot2), and BI tools (Power BI, Tableau)

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 »

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 »

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 »

Decoding the Global Gaming Landscape: Insights through Data Visualization in Tableau

The global video game market has experienced exponential growth, fueled by technological advancements, evolving gaming platforms, and the rise of online gaming communities. Understanding the trends, patterns, and insights behind this massive industry is crucial for industry professionals, gamers, and enthusiasts alike. Through my project, I aimed to uncover hidden narratives within the vast dataset

Decoding the Global Gaming Landscape: Insights through Data Visualization in Tableau Read More »

Smooth Skies and Smiling Faces: Unveiling the Secrets of Airline Customer Satisfaction in Power BI

In an industry where experiences can be as diverse as the destinations themselves, customer satisfaction plays a pivotal role in shaping the success and reputation of airlines worldwide. Understanding the factors that contribute to passenger contentment has become an essential endeavor for airlines seeking to soar above the competition. In this project, I applied data

Smooth Skies and Smiling Faces: Unveiling the Secrets of Airline Customer Satisfaction in Power BI Read More »

Visualising company performance using an Excel dashboard

Introduction Kevin Cookie Company (fictional) conducts business in five countries, selling a variety of delicious cookies which include chocolate chip, fortune cookies, and oatmeal raisin. The company has lately been keeping records of sales, profits, and other metrics by country and product in Excel spreadsheets. They want me, as a data analyst, to make sense

Visualising company performance using an Excel dashboard Read More »