Arpita Deb Email & Phone Number

India

In this Internship:- I completed two data analysis projects within a tight deadline: 1. Market Capitalization Data Analysis: Conducted in-depth analysis of Market Capitalization trends using Excel, Alteryx, and Power BI. 2. Sales Budget Data Analysis: Analyzed Sales Budget Data of a fictitious Multinational Company to gain insights into its revenue trends, product performance and customer preferences.- I leveraged Excel for Data Cleaning, Alteryx for Data Transformation, Power BI for Data Visualization, Google Slides to create Project Timeline and keeping track of progress, and Canva to create comprehensive Analysis Reports.- I cleaned and processed market capitalization data for top 500 Indian firms and AdventureWorks' Sales Data, consolidating over 50,000 data points using Excel and Alteryx.- Created 35 Power BI visualizations and 4 dashboards to deliver key insights and support strategic decision-making.- Automated data workflows in Alteryx, improving accuracy and generating 10+ new calculated columns.- In addition to that, I demonstrated strong Problem-Solving, Time Management, and effective Presentation Skills throughout the internship.

India

In this Internship:- I completed 3 data analysis projects within a one-month timeframe: Task 1: I created a short 1-minute video reel on Logical Operators in SQL. The goal of this task was to concisely explain this topic to non-technical audience. Task 2: In this task, I examined the trajectory of confirmed, dead, and recovered cases from COVID-19 across 121 countries from January 2020 to June 2021, shedding light on the varying impacts and responses observed globally. Task 3: In this task, I delved into the analysis of data related to the National Rural Employment Guarantee Act (NREGA) through the application of data analytics techniques. I aimed to gain valuable insights into the implementation and impact of this scheme across different states and districts in India.- To accomplish the goal and complete this internship successfully, I leveraged a suite of tools, including Excel, Microsoft SQL Server, Power BI, Google Slides, and Canva, for different phases of the Analysis process.- I developed SQL queries for exploration of 78,000+ data points for Covid-19 and 700+ for Indian Rural Employment Scheme Data.- Visualized critical trends through 36 Power BI charts, enhancing report clarity and stakeholder engagement.- Produced 3 dashboards and 2 detailed analysis reports to convey complex insights and support data-driven decisions.- Apart from technical skills, I showcased strong analytical abilities by dissecting the project into smaller components. I applied critical thinking to tackle the business problem, managed time effectively to meet deadlines, and skillfully presented and conveyed the analysis results following the best practices of Data Storytelling.