Hi, I’m Gokul Jujgar
Data Analyst & Business Insights Specialist
I analyze and interpret complex datasets to help organizations make data-driven decisions. Skilled in SQL, Python, and Power BI.
About Me
A passionate data analyst with a strong foundation in analytical tools and techniques, focused on delivering actionable insights and driving data-informed decisions.
Professional Summary
Data Analyst with hands-on experience in SQL, Python, Excel, and Power BI. Adept at transforming raw data into clear insights and impactful dashboards. I’m passionate about solving business challenges using data-driven strategies and teamwork.
Key Achievements
Accenture Data Analytics Project
Completed a real-world simulation analyzing 7 datasets for a social media client, delivering insights through PowerPoint and recorded presentation.
Certifications
Certified by Jason School, Oneroadmap, Accenture, Deloitte, HP Life, and HackerRank in Data Analytics and SQL.
Project Impact
Improved inventory tracking efficiency by 10% and increased promotion ROI by 15% using data-driven insights and reports.
Technical Skills
Skilled in modern data analytics tools and techniques with real-world project experience and multiple industry certifications.
Database Management
Relational Databases (MySQL, SQLite)
Advanced Excel
Pivot Tables & Formulas
Data Mining
Pattern Recognition & Analysis
Reporting
Interactive Dashboards & KPIs
Experience
Hands-on experience in real-world data analysis projects — transforming raw datasets into business insights and strategic recommendations.
Completed a comprehensive, real-world data analytics simulation with Accenture’s consulting division — delivering actionable insights for a social media client’s content performance strategy.
Data Processing: Cleaned, modeled, and analyzed 7 large datasets to uncover engagement trends and performance metrics.
Client Deliverables: Developed a professional PowerPoint deck and recorded presentation highlighting insights and business recommendations.
Strategic Impact: Recommended key data-driven strategies for optimizing audience engagement and ROI through content performance tracking.
Featured Projects
Real-world projects demonstrating technical skills and business impact through measurable insights and performance optimization.
Comprehensive database design and analysis project focusing on inventory management and customer behavior insights.
Key Achievements
- Designed and managed relational database with 20+ optimized SQL queries
- Achieved 10% improvement in inventory turnover tracking efficiency
- Identified Mystery as top-selling genre and Kim Turner as highest-spending customer
- Contributed to 15% increase in promotion Return on Investment
- Discovered peak order activity in November 2023 for strategic planning
Technologies Used
Advanced Power BI dashboard and data transformation project for comprehensive sales performance analysis.
Key Achievements
- Reduced report generation time by 30% through automated Power Query transformations
- Identified top 10% of products accounting for 50% of total revenue
- Guided inventory and marketing prioritization strategies
- Revealed regional/seasonal return rate patterns for quality control
- Achieved 15% reduction in returns through targeted initiatives
Technologies Used
Comprehensive analysis of 48K+ Airbnb listings to identify pricing patterns and factors affecting rental performance.
Key Achievements
- Cleaned and transformed 48K+ Airbnb listings using Python Pandas, NumPy
- Performed exploratory data analysis (EDA) to identify pricing, location, and availability patterns
- Built visualizations with Matplotlib & Seaborn revealing key pricing insights
- Discovered higher review scores and professional photos lead to 20–30% higher prices
- Provided actionable insights for hosts to optimize their listing performance
Technologies Used
Data cleaning and analysis of 20K+ electronics sales records to identify product performance and revenue trends.
Key Achievements
- Cleaned and standardized 20,000+ electronics sales dataset using Python Pandas
- Mapped SKU codes to product names and normalized feature formats for clarity
- Identified smartphones as highest-revenue category through EDA
- Highlighted underperforming items (headphones, tablets) for targeted promotion
- Recommended strategic adjustments for Quarter 4 sales recovery and revenue optimization
Technologies Used
Interactive Excel dashboard analyzing three-store coffee chain performance with traffic and product insights.
Key Achievements
- Created interactive sales dashboard in Microsoft Excel for three-store chain
- Visualized daily & hourly footfall revealing peak traffic patterns
- Identified Mondays, Thursdays, Fridays as peak days and mornings as highest sales
- Found Barista Espresso as most popular product across all stores
- Recommended discount strategies for underperforming merchandise and flavored items
Technologies Used
Power BI dashboard integrating multiple datasets for comprehensive deal tracking and customer segmentation analysis.
Key Achievements
- Built interactive Power BI dashboard integrating multiple datasets with Power Query & DAX
- Enabled comprehensive tracking of deals, revenue, and customer segmentation
- Identified 'GTX Plus Pro' as best-selling product and analyzed deal loss patterns
- Found ~28% overall lost-rate with spikes in May & August requiring attention
- Achieved ~48.2% conversion rate through targeted growth strategies
Technologies Used
Education & Certifications
Strong academic foundation in computer science, supported by industry certifications in data analytics and visualization from global organizations.
Bachelor of Science in Computer Science
Dr. Babasaheb Ambedkar Marathwada University (BAMU), Aurangabad
Data Analytics
Jason School Pvt Ltd, Pune
Data Analyst
Oneroadmap
Data Analytics & Visualization
Accenture
Data Analytics
Deloitte
Data Science & Analytics
HP Life
SQL
HackerRank
Continuous Learning: Dedicated to expanding expertise through professional certifications and industry-recognized programs from leading organizations.
Get In Touch
Ready to collaborate on data-driven projects or discuss opportunities in analytics? Let's connect and explore how we can work together.