Jayagopal

Jayagopal

Data Analyst
India

About Me

Data analyst with experience in SQL, Tableau, Excel, Python, and R. Completed virtual internship projects in data visualization and data analysis, and holds a Master of Computer Application and a Bachelor of Science in C…

Experience

Data Visualization

TATA
Aug 2023 - Aug 2023

Came up with eight important questions that matched what the CEO and CMO were interested in.
Selected the right visualizations to tell each question's data story accurately and clearly.
Used Tableau for creating visualizations.
Applied filters to unit price and quantity with a minimum of 1.
Made a presentation and shared the valuable insights and analysis with stakeholders.

Data Analyst

ACCENTURE NORTH AMERICA
Aug 2023 - Aug 2023

Collaborated with a team of analysts to understand client objectives and project requirements.
Employed Excel as the primary tool.
Initiated the data cleaning process by eliminating null values and correcting misspelled words.
Combined three separate sheets using VLOOKUP to enhance outcomes and visualization.
Conducted analysis within Excel using SUMIF and COUNTIF to derive insights.
Developed impactful visualizations directly within Excel to present the data's storytelling effectively.
Created a PowerPoint presentation to effectively communicate findings to the client.

Skills

Asynchronous JavaScript and XML (AJAX) Microsoft Excel MySQL PHP: Hypertext Preprocessor (PHP) Python SQL Database Css3 Data Cleansing Data Extraction Data Modeling Data Representation JavaScript Presentations R Programming Language Data Analysis Skills HTML5 Power BI Tableau SQL SQL Server Excel VLOOKUP Conditional Formatting Pivot Tables Pandas NumPy Matplotlib Seaborn Tidyverse ggplot2 dplyr tidyr readr Git
Report this Profile?