I'm Gokul Jujgar
Name: Gokul Laxman Jujgar
Job Role: Data Analyst
Experience: Fresher
Address: Pune,Maharastra,India
Skills
SQL 90%About
About Me
I am a Computer Science graduate with a strong passion for data analytics and delivering actionable insights through data. I have built hands-on experience working with tools such as SQL, Python, Excel, Power BI, and Tableau. I specialize in exploring data to uncover patterns, trends, and opportunities that drive smarter business decisions. My particular interest lies in data visualization transforming complex datasets into clear, insightful, and decision-ready visuals. I am actively seeking opportunities to apply my analytical skills, grow professionally, and contribute to a dynamic, data-driven team.
- Profile: Analytics
- Education: B.sc Computer Science
- Language: English, Hindi, Marathi
- BI Tools: Microsoft Power BI,& Tableau
- Interest: 🎧 Enjoying music, podcasts, and insightful YouTube videos for fun and learning.
8 + Projects completed
Resume
Resume
I Am a dedicated professional with a strong passion for Data Analysis.
Experience
May 2025
Data Analytics & Visualization | Virtual Internship
Accenture | Remote- Completed a simulation focused on advising a hypothetical social media client as a Data Analyst at Accenture. Cleaned, modelled and analyzed 7 datasets to uncover insights into content trends to inform strategic decisions. Prepared a PowerPoint deck and video presentation to communicate key insights for the client and internal stakeholders.
July 2025
Data Analytics | Virtual Internship
Deloitte | Remote- Completed a real-world job simulation focused on data analytics and forensic investigation. Analyzed employee compensation and gender equality metrics using Excel to classify and interpret scores. Built an interactive Tableau dashboard to visualize factory-wise machine downtime and device-level issues. Developed actionable insights from raw data to support decision-making in a simulated client environment.
Dec 2024- July 2025
Data Analytics Training
JASON SCHOOL PRIVATE LIMITED, PUNE- where I gained hands-on experience through practical learning and real-world projects. The training focused on key tools such as Excel, SQL, and data visualization. During this program, I worked on multiple projects that involved data cleaning, analysis, and creating dashboards to generate actionable insights. Designed and developed interactive dashboards and visualizations using tools like Power BI to track sales trends, and support data-driven decision-making across various departments.
Education
Jun 2022 - Jun 2025
B.sc Computer Science
Dr.Babasaheb Ambedkar Marathwada UniversityCGPA : 7.18
2021-2022
Higher Secondary School
Higher Secondary school,Sambhajinagar BoardPercentage : 69.67%
Projects
Projects
Online Books Store - SQL
This project focuses on analyzing an online bookstore database using advanced SQL. Built and optimized queries to analyze customer behavior. The dataset includes tables for books, customers, orders, and authors. Business questions were solved through SQL queries to derive insights such as best-selling books, monthly sales trends, top customers, and author performance.
CRM Sales - Power BI
Analyzed a CRM sales dataset to evaluate deal progress, sales rep performance, and customer segmentation. Created interactive Power BI dashboards to track conversion rates, deal value by region, and pipeline status. Applied DAX measures to calculate KPIs such as Conversion Rate, Average Deal Size, and Stage-wise Drop-off Rates. Identified top-performing sales reps, high-potential industries, and bottlenecks in the sales funnel. Delivered actionable insights to improve sales strategies and boost CRM efficiency.
AirBnB Listing - Python
Conducted end-to-end exploratory data analysis using Python to uncover insights on listing prices, room types, availability, and geographic trends. Performed data cleaning, transformation, and exploratory analysis on an Airbnb listing dataset using Python. Analyzed trends in pricing, availability, and geographic distribution of listings. Used pandas, matplotlib, and seaborn to generate insights and visualizations.
Electronic Sales - Python
A comprehensive exploratory data analysis project using one year's worth of electronic store sales data. Built with Python, Pandas, Matplotlib, Seaborn it answers key business questions and uncovers actionable insights. Sales analysis helps understand which products sell well, guide inventory management, assess sales force impact, and evaluate overall performance
Maven Movies Rental Business - SQL
Captures crucial business domains: actors, films, customers, staff, stores, inventory, rentals, payments, categories, locations, and more. A full-fledged SQL-driven analysis of the Maven Movies (a DVD rental store) database aimed at uncovering insights on customer behavior, inventory optimization, rental trends, revenue drivers, and operational efficiency
Adventure Works Sales - Power BI
The Adventure Works Sales Dashboard provides strategic insights into the performance of a fictional bicycle company over the period 2020–2022. Built using the Adventure Works dataset, it integrates data from sales, customers, products, and returns to deliver a comprehensive view of business operations. The dashboard highlights key metrics such as customer behavior, product performance, regional sales distribution, and return patterns. Through dynamic visualizations and KPIs, it supports data-driven decision-making and uncovers trends that drive strategic business growth.
Starbuks Coffee Sales - MS Excel
Created a professional sales dashboard in Microsoft Excel to analyze Starbucks coffee product performance. Utilized pivot tables, slicers, charts, and conditional formatting to generate dynamic visuals and insights into product-level sales, profit, and revenue trends across multiple cities and months.
Amazon Sales - MS Excel
This project analyzes Amazon sales data using Microsoft Excel, focusing on sales performance, profit trends, regional contribution, and product-level analysis. Discovered that high-priority orders contribute ~35% of total profit. Found that Europe and North America are the most profitable regions. The goal is to generate actionable business insights through dashboards, pivot tables, and charts.
0
Certificates
0
Projects
0
Cups of coffee
Contact
Contact Me
Below are the details to reach out to me!
ADDRESS
Pune, Maharashtra, India