+91-9774059892 | [email protected]
As a curious Data Analyst, I possess expertise in Spreadsheets, SQL, R, Python, and Tableau, coupled with strong communication, problem-solving and critical thinking skills. I thrive on adding value to my work and making a positive difference in the world through data-driven decisions. I approach challenges with humility and responsibility, always striving to improve and grow. This Portfolio showcases the Data Analysis and Data Science projects I have completed for my internships and self-learning purposes.
About me in 30 Seconds
-
Learn about me with this short video resume.
-
I've recently completed Data Analyst Internships at Unified Mentor and Mentorness.
-
My Data Analysis toolkit includes Excel, SQL, Python, Alteryx, Tableau, Power BI and R Programming Language.
-
I regularly write articles on LinkedIn and Medium.
-
I have a Bachelor's Degree in Electrical Engineering.
-
When I'm not analyzing data, I read, write, paint or learn new skills.
My working tools
![](https://camo.githubusercontent.com/69854ea8d7b1d92568fbe04f744003761204ff4e50d221c5ad7ce9e261731fe4/68747470733a2f2f7777772e766563746f726c6f676f2e7a6f6e652f6c6f676f732f6d6963726f736f66745f706f77657262692f6d6963726f736f66745f706f77657262692d617232312e737667)
![](https://camo.githubusercontent.com/cda60ac31dec8da0a73def7beb565881116d414a813457f574f2c133efb5a327/68747470733a2f2f74682e62696e672e636f6d2f74682f69642f4f49502e5a6f714b733936634749376f444d3641785552354167486148613f7069643d496d674465742672733d31)
![](https://camo.githubusercontent.com/a259a30c10caaf27db28c20766c39acf8fdecaf81cfd429ef2fe9079bfdf8d8d/68747470733a2f2f7777772e766563746f726c6f676f2e7a6f6e652f6c6f676f732f722d70726f6a6563742f722d70726f6a6563742d69636f6e2e737667)
![](https://camo.githubusercontent.com/fd87f00a4eedcf5884517d14f9e51a3e885f8a6c187e0cec5afc301537aedffc/68747470733a2f2f65372e706e676567672e636f6d2f706e67696d616765732f3531352f3930392f706e672d636c69706172742d6d6963726f736f66742d73716c2d7365727665722d636f6d70757465722d736572766572732d64617461626173652d6d6963726f736f66742d6d6963726f736f66742d73716c2d7365727665722d7365727665722d636f6d70757465722e706e67)
![](https://camo.githubusercontent.com/70a5ef7589e5449d1a8711964fb2a17822838db801fadb6fe245fb0e85b742d7/68747470733a2f2f7777772e766563746f726c6f676f2e7a6f6e652f6c6f676f732f707974686f6e2f707974686f6e2d617232312e737667)
![](https://camo.githubusercontent.com/3aa60bb5546d546b1561db863b986162acfd8e75f792be7535b7f340ba2baa86/68747470733a2f2f75706c6f61642e766563746f726c6f676f2e7a6f6e652f6c6f676f732f7461626c6561752f696d616765732f31313361333131612d366435642d346237652d393139332d3739383037653438343465332e737667)
Core Competencies
-
Methodologies Known: Data Wrangling, Data Cleaning and Transformation, Data Visualization, Exploratory Data Analysis(EDA), Statistics, Regression Analysis, A/B Testing, Customer Segmentation, RFM Analysis, Machine Learning, Artificial Intelligence, Data Architecture, Database Design and Normalization, NoSQL databases, Time Series Analysis.
-
Technical Skills: Excel, Pivot Tables, PostgreSQL, Microsoft SQL Server, Relational Database, R (Dplyr, Tidyr, Ggplot2), Python (Pandas, Numpy, Matplotlib, Seaborn, Scikit-Learn), Tableau, Datawrapper, Alteryx.
-
Soft Skills: Critical Thinker, Detail Oriented, Problem Solver, Strong verbal and written communication, Presentation Skills, Inherently Curious, Fast Learner, Independent and Self Motivated.
LinkedIn Analytics: Telling my LinkedIn Story with Power BI
In this project, I analyzed my historical LinkedIn Analytics data to gain insights into my LinkedIn Activity using Power BI, Power Query and DAX(Data Analysis Expressions) functions. I also created data visuals to tell a data story and to improve decision-making on post timing and content type for maximizing engagement.
Mapping MGNREGA - A state-level analysis of one of world’s largest Rural Employment Scheme
This project delves into the analysis of data related to the National Rural Employment Guarantee Act (NREGA) through the application of data analytics techniques. It aims to gain valuable insights into the implementation and impact of this scheme across different states and districts in India.
Epidemic Analytics: Evaluating COVID-19’s Global Footprint
This project examines the trajectory of confirmed cases, fatalities, and recoveries from COVID-19 across different countries during the critical period of 2020 to 2021, shedding light on the varying impacts and responses observed globally. This project is done as a part of Mentorness Internship.
AdventureWorks Sales Budget Analysis
In this project I've explored and analyzed sales data of a fictional manufacturing company AdventureWorks from 2014 to 2016 to gain insights into the company's revenue trends, product performance and customer preferences. Using Excel, Alteryx and Power BI, I analyzed Sales Budget for 2016, segmented the customers, performed RFM Analysis and created data visuals and dashboards.
Charting Progress: An examination of Market Capitalization in the Indian Corporate landscape in 2018
This assignment involves examining the competitive landscape to enhance the strategic positioning and performance of India’s top 500 firms for 2018. Using Excel, Alteryx, Power BI, Google Slides, and Canva I analyzed the data to provide a detailed view of India's corporate landscape. I’ve also discussed the project’s limitations and proposed some future directions.
Predictive Analysis of US Regional Sales Data using Excel, Power BI, and R
In this analysis, I employed Microsoft Excel and Power BI to probe into the regional sales in the United States for a certain fictional company, utilized Pivot Tables and Data Visualization, and applied R Programming Language for sales forecasting.
Netflix Data Analysis: A Deep Dive into Streaming Trends
Using Postgresql I analyzed and normalized the Netflix Streaming data, which contains information about the titles, genres, ratings, and countries of the streaming content. I then used Datawrapper and Tableau to create interactive and engaging visualizations of the streaming trends, such as the most popular genres, the distribution of ratings, and the growth of content over time.
Retaining Talents, Unleashing Possibilities - A study of Employee Retention in Salifort Motors
What makes an employee leave a company? The senior leadership team of Salifort Motors are worried about their employee turnover. Using Exploratory Data Analysis(EDA) and building different Machine Learning Models(Logistic Regression, Decision Tree, Random Forest and XGBoost) We'll help them predict employee turnover rate and retain their talents.
How can a Wellness Technology Company play it smart?
Analyzed smart device usage data from non-Bellabeat products to gain insights on how people are using these smart devices and then selecting a Bellabeat product to apply these insights to create high level recommendations for Bellabeat marketing strategy.
Navigating the Saline Waters: Sundarbans 2019
This interactive dashboard is designed to analyze the salinity levels of tube wells and rivers within the North 24 Parganas and South 24 Parganas districts, collectively known as the Sundarban Region of the Indian Subcontinent.
R You Ready for Christmas? : A Guide to Create Custom Cards with R
Inspired by an article about how to create a Christmas card in R, I've created my own Christmas Card using ggplot() in R Programming Language.
Merry Christmas All Around the World
This repository contains the documentation of my dashboard creation process as a part of the Romanian Data Tribe Challenge for 2023. Using the data, they've provided as well as some external data from other resources, I’ve designed a dashboard that displays the different ways of saying Merry Christmas across the globe, using Tableau and Canva.
From Spreadsheet to Database - creating database design and normalizing a csv file
Removing vertical representation and replication of data from a database, by normalizing it upto third normal form (3NF). Creating SQL script to automate the task of creating, reading, updating and deleting data from Books_Management database.
Car Price Prediction using Linear Regression
What affects the price of a car? Is it its engine size or the curb weight, or its horsepower, or a combination of many elements? Let's find out by using Linear Regression technique to predict the price of car models from 1985 Ward’s Automotive Yearbook.
London Bike Share - What do you need to know before heading out?
10 Billion Londoners rode out in 2016 on these popular bikes in and around London. What are the reasons of popularity of this public bike service scheme? Do seasons and weather have anything to do with it? Let's find out with a quick data analysis with Tableau.
Do I read all the books I buy?
Data Analysis of the collection of my books with Python and Tableau. Following the 6 phases of data analysis- Ask, Prepare, Process, Analysis, Share and Act - I've created the dataset on 184 books, cleaned them with Excel, transformed, manipulated and analysed with Python, created visualizations with Tableau and shared the insights.
Check out my Power BI and Tableau Dashboards here.
Check out my Medium Articles here.
Git Activeness
![arpita-deb](https://camo.githubusercontent.com/f56702ce74262af0f1d776a891a18a8355d2a445ee93e5bbd794cbe8ae8a3be8/68747470733a2f2f6769746875622d726561646d652d73746174732e76657263656c2e6170702f6170692f746f702d6c616e67733f757365726e616d653d6172706974612d6465622673686f775f69636f6e733d74727565266c6f63616c653d656e266c61796f75743d636f6d70616374267468656d653d636861727472657573652d6461726b)
![arpita-deb](https://camo.githubusercontent.com/439300bfe22bc82827efff6899f1a7c2718bb053754b2545aab936470b6415b0/68747470733a2f2f6769746875622d726561646d652d73746174732e76657263656c2e6170702f6170693f757365726e616d653d6172706974612d6465622673686f775f69636f6e733d74727565266c6f63616c653d656e267468656d653d636861727472657573652d6461726b)
![arpita-deb](https://camo.githubusercontent.com/44e71a9004b62fef5ab414aadef1f71a24bbb2a50a5b3b294d384406959588fe/68747470733a2f2f6769746875622d726561646d652d73747265616b2d73746174732e6865726f6b756170702e636f6d2f3f757365723d6172706974612d6465622673686f775f69636f6e733d74727565266c6f63616c653d656e267468656d653d636861727472657573652d6461726b)