Nirosan Vijayakumar
DATA ANALYST -
PROJECTS & INSIGHTS

This is a showcase of my work, featuring projects in Excel, SQL, Tableau and Python

Your Name

About me

I am an Economics graduate focused on building my career as a Data Analyst. My expertise lies in Excel, SQL, Tableau and Python, which I leverage to clean, analyse and visualise data. I enjoy working on projects that involve exploring datasets to find actionable insights and create data-driven solutions. I am constantly developing my skills, and this website, along with my GitHub, serves as a growing collection of my work, reflecting my commitment to mastering the tools and techniques required in today's data-driven world.

Please navigate through my smaller projects using the headers.
Beneath is a collection of my larger projects:

Project 2
Airline Customer Data

KEY SKILLS: SQL Queries, Data Integrity, Standardisation, Null Handling, Dashboard Design

This project focuses on cleaning and preparing an airline customer dataset using SQL to ensure accuracy and consistency for effective analysis. It involves handling null values, removing duplicates, and standardising data formats while validating all records. The cleaned dataset is primed for comprehensive analysis, emphasising customer segmentation and lifetime value (CLV). Subsequently, Tableau is used for visualisation, revealing key metrics like flight frequency and customer demographics, thus facilitating data-driven decision-making in the airline industry.

Project 1
London Job Data

KEY SKILLS: Queries, Data Manipulation, Aggregation Functions, Trend Analysis, Data Visualisation

This project focuses on cleaning and preparing UK job data using SQL to ensure accuracy for insightful analysis. It involves crafting complex queries for data manipulation, removing duplicates, standardising formats, and handling null values, as well as using aggregation functions to derive insights about job distribution and salary trends. After cleaning, Tableau is utilised for dynamic visualisation, allowing exploration of relationships between jobs, salaries, and population size, ultimately providing valuable insights for data-driven decision-making.