Samrat Rai | Graduate student

Samrat Rai

Graduate student

Based in isleworth,uk

About

Aspiring data analyst, with a master's degree in Data Analytics and in my bachelor's I graduated with a business management degree. Currently, my time is consumed doing projects/honing skills in Python, tableau, SQL, Microsoft Excel and with a part-time job. I am looking for a data analytics/visualisation job and would be happy to learn any required new skills. I am passionate about data and have a hardworking ethic.

Skills

Projects

Live Covid-19 Vaccine Tracker

In this project, A live COVID-19 vaccine tracker was made from Tableau. This project helped me refresh my creativity using skills like - using calculative fields, dashboards, worksheet manipulation, filtering and sorting data. Data was gathered from https://ourworldindata.org/covid-deaths.

coffee beans sales excel

An end-to-end Excel project. The dataset was gathered through kaggle. The goal of this project was data visualization and creating a dashboard. This was done by manipulating the coffee beans dataset by creating new columns by using functions like IF, Nested IF, INDEX, Match, and SUM functions.

Python Bank transaction project

This project creates a personal finance tracker dashboard through using a bank transaction dataset which was created manually. It shows the summary of the bank transaction carried out like last month's expenses, savings etc. Jupyter Notebook was used to carry out this project.

Climbers Gym exploration

Tools: MySQL, MySQL Workbench Project Overview: Manually created datasets for a climbers' wall climbing gym in MySQL. Utilised MySQL Workbench for data exploration. Formulated and answered 12 questions related to tables

Impact of Population Trend on Developing & Developed Countries

MSc Data Analytics Dissertation Project. Conducted a comprehensive analysis on the Economic, Environmental, and Social impact of global population trends from 1990-2022 using Google Scholar and Science Direct.

Tip Calculator

I have created a Tip calculator using Python. Enjoy it and give it a test. Good People always Tips as said by someone's someone long ago.

Education

Sep 2018 - Jul 2021

Bachelor of Business Administration - BBA at University of the West of England

Accounting Information for Business (Business, International and Management), Operations and Supply Management, Design Thinking, Integrated Marketing Communications, International Trade and Multinational Business,Management Skills (Business and Management),Enterprise and Entrepreneurship,Managing People,Microsoft Office,Excel.

Sep 2022- Oct 2023

MSc Data analytics at London Metropolitan University

Data Analysis and Visualization, Data Warehousing and Big Data, Financial Mathematics, Programming for Data Analytics, Data Mining and Machine Learning, Statistical Modelling and Forecasting,MSc Project,Tableau,Google Collab,Python,R,SQL,Microsoft Office.