Shagun .

Shagun .

Data Analyst
India
English, Hindi
Available Now
Full-time Remote

About Me

Aspiring Data Analyst with hand-on experience in Excel, SQL, Python, Power BI, and Tableau. Skilled in data cleaning, dashboard creation, exploratory data analysis, and transforming raw data into actionable business insi…

Experience

Data Analyst Trainee

Yiron Technologies · Greater Noida , Uttar Pradesh , India
Feb 2026 - Jul 2026 · 4 months

<p>• Assisted in collecting, cleaning, and organizing data for analysis.</p><p>• Used Microsoft Excel to prepare reports and perform basic data analysis.</p><p>• Learned SQL to retrieve and filter data from databases.</p><p>• Supported the creation of simple Power BI dashboards and visualizations.</p><p>• Performed data validation to ensure accuracy and consistency.</p><p>• Helped maintain datasets and prepare daily/weekly reports.</p><p>• Worked with senior analysts to understand reporting requirements.</p><p>• Continuously improved knowledge of Excel, SQL, Python, and Power BI through practical tasks.</p>

PROJECTS

Customer Churn Analysis Project

self · https://github.com/Shagun-7898/Customer_Churn_Analysis
Duration : 10-Jul-2026 - 13-Jul-2026

<p>• Analyzed 7,043 telecom customer records to identify customer churn patterns and retention opportunities</p><p>• Used PostgreSQL, Python(Pandas, NumPy), and Tableau for data cleaning, analysis, and dashboard creation</p><p>• Developed an interactive Tableau dashboard with KPIs and visualizations for churn rate, contract type, payment method, tenure, and monthly charges</p><p>• Used AI tools (ChatGPT, Claude) to optimize SQL queries, troubleshoot Python scripts, validate insights, and streamline project documentation</p><p></p>

Sales Data Analysis Project

self · https://github.com/Shagun-7898/Sales-Data-Analysis
Duration : 09-Jul-2026 - 11-Jul-2026

<p>• Analyzed 525,000+ real sales records to identify top products and revenue patterns</p><p>• Used python ( Pandas, NumPy, Matplotlib) for data cleaning, analysis, and visualization</p><p>• Created charts showing product performance, country-wise sales, and market trends</p><p>• Used ChatGPT to optimize SQL queries, validate analysis, and improve reporting workflow</p>

Certifications

Introduction to SQL

Simplilearn · Ranchi , Jharkhand , India · 2026

Microsoft Excel using AI

Be10x · Ranchi , Jharkhand , India · 2026

AI & Data Science

UGCPL · Ranchi , Jharkhand , India · 2025

Skills

Analytics Business Analysis Data Analysis Professional Information Systems Management Data Mining Microsoft Access Microsoft Excel Microsoft Office Reporting Statistical Analysis System (SAS) Structured Query Language (SQL) User Acceptance Testing (UAT) Problem Solving Data Analysis Communication Data Representation Functional Testing Key Stakeholders Requirement Gathering Data Visualization Data Analysis Skills Power BI Statistical Analysis Tableau MS Excel VLOOKUP Pivot Tables Charts SQL SELECT JOIN GROUP BY Subqueries Python Pandas NumPy Matplotlib Tableau Power BI Basic Statistics ChatGPT Microsoft Copilot Google Gemini Prompt Engineering AI-assisted SQL Query Generation Data Cleaning Data Validation Data Visualization Reporting Exploratory Data Analysis Business Insights
Report this Profile?