VIPUL GOUR
Data Analyts
About Me
Welcome to My Portfolio!
I'm a passionate Data Analyst with 1.6 years of hands-on experience transforming raw data into meaningful insights that drive smarter and faster business decisions. I enjoy exploring complex datasets, uncovering hidden trends, and turning numbers into impactful stories through analytics and visualization. With expertise in SQL, Python, Excel, and Power BI, I specialize in data cleaning, automation, reporting, and building interactive dashboards that improve performance and support strategic growth.
For me, data is more than just information — it’s a powerful tool that reveals opportunities, solves business challenges, and creates measurable impact. I continuously work on real-world projects to strengthen my analytical thinking and technical skills while staying updated with evolving industry trends. This portfolio reflects my journey, curiosity, and passion for creating smarter, data-driven solutions.
1
Excel Project
Key Skills
My Experience
AtliQ Technologies — Data Analyst Intern
Remote (WFH) | April–May
- Cleaned and transformed business datasets using Microsoft Excel, SQL, and Power Query, resolving missing values, duplicates, and formatting inconsistencies to improve data quality and reporting accuracy.
- Performed ad-hoc analysis and variance analysis in Excel and Microsoft Power BI, identifying business trends, order fluctuations, and reporting anomalies to support strategic decision-making.
- Designed and optimized complex MySQL queries for data extraction, validation, and reporting, ensuring data consistency and analytical reliability.
- Automated client reporting workflows through Excel-based reporting solutions, reducing manual effort and improving turnaround efficiency.
- Analyzed 5G telecom performance data, tracking operational KPIs, revenue impact, and customer usage behavior to generate actionable business insights.
- Built an interactive Microsoft Power BI dashboard for Shield Insurance, enabling stakeholders to monitor customer acquisition, revenue growth, and key performance metrics through dynamic visual analytics.
Allied Engineers — Data Analyst
Delhi | Jan 2024 – Jun 2025
- Optimized reporting workflows using Advanced Excel and Python, achieving 99% data accuracy while supporting 12+ client projects across India, Kuwait, and Saudi Arabia.
- Conducted Level 1 & Level 2 site data analysis across 100+ locations, identifying operational risks and prioritizing corrective actions, reducing issue response time by 25%.
- Automated reporting workflows using Advanced Excel (VLOOKUP, Pivot Tables, lookup functions), reducing 2+ hours of manual effort daily and improving reporting efficiency by 30%.
- Developed and presented bi-weekly analytical reports on operational site performance, helping stakeholders identify the top 3 root causes of equipment failures, contributing to a 20% improvement in operational reliability.
- Collaborated with cross-functional teams on corrosion mitigation and asset integrity analysis, driving a 15% improvement in asset performance KPIs and strengthening compliance with safety standards.
Intervie Tech — Data Analyst Intern
Remote (WFH) | Dec 2023 – Jan 2024
- Cleaned and transformed 50K+ rows of raw data using Python (pandas) and Microsoft Excel, resolving inconsistencies and improving data accuracy to 98% for reliable business reporting.
- Built interactive dashboards in Microsoft Power BI to monitor sales performance, customer acquisition, and churn metrics, reducing reporting turnaround time by 40%.
- Performed Exploratory Data Analysis (EDA) on 50K+ records, uncovering trends, patterns, and 3+ actionable business insights that supported stakeholder decision-making.
- Partnered with marketing and finance teams to align analytical outputs with business objectives, improving cross-functional reporting accuracy and data-driven decision-making.
Awards & Certificate
Let's Work Together!
Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.