Skip to content
View Arpita-deb's full-sized avatar
🎯
Focusing
🎯
Focusing
13 followers · 0 following

Block or report Arpita-deb

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Arpita-deb/README.md

Arpita Deb

Data Analyst

+91-9774059892 | debarpita1811@gmail.com

arpitadeblinkedin arpita deb tableau medium

As a curious Data Analyst, I possess expertise in Spreadsheets, SQL, R, Python, and Power BI, 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 while also enjoy the process. This Portfolio showcases the Data Analysis and Data Science projects I have completed for my internships and self-learning purposes.


side_sticker

 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




 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, 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 and Analytical Thinking skills, Problem Solving skills, Verbal and Written Communication, Attention to Detail, Fast Learner, Independent and Self Motivated.



Projects

Production Line Downtime Analysis

In this Maven Analytics data challenge, I analyzed the manufacturing downtime of a soda production company using Excel. I explored the key production issues and identified the root cause of production delays. Finally I shared the insights through tables, charts and graphs and provided actionable recommendations with a detailed report.




EventSphere Solutions: Event Management Database Design and Implementation

In this project, I designed and implemented an event management database in Microsoft Server for a fictional mid-sized event management company.




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.




Mini Projects:

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 - A Database for my Books Collection

Transforming an Excel file containing information about my collection of books into a PostgreSQL Database. Followed the best practices to normalize it upto Third Normal Form.




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.




Dashboards

Check out my Power BI and Tableau Dashboards here.

Articles

Check out my Medium Articles here.

Git Git Activeness

arpita-deb

 arpita-deb

arpita-deb

Pinned Loading

  1. Corona-Virus-Analysis Corona-Virus-Analysis Public

    Analyzing the global effects of Corona Virus from January 2020 to June 2021.

    TSQL 1

  2. AdventureWorks-Sales-Performance-Analysis-2014-2016 AdventureWorks-Sales-Performance-Analysis-2014-2016 Public

    1

  3. Books-Database-Normalization Books-Database-Normalization Public

    Creating database design in PostgreSQL of the collection of my books and normalizing it.

    1

  4. LinkedIn-Analytics LinkedIn-Analytics Public

  5. NREGA-Data-Analysis NREGA-Data-Analysis Public

    TSQL

  6. Power-BI-Dashboards Power-BI-Dashboards Public

    This repository holds all my Power BI dashboards done as a part of various Data Analysis projects.