Ritik Raushan

Data Analyst

Data Analytics
1roles
18skills
1education
1credentials

About

Data Analyst with a strong foundation in SQL, Python, Excel, and Power BI, skilled in data cleaning, analysis, visualization, and dashboard development.

Experience

Data Analyst Intern

Edunet Foundation

Feb 2025 – Apr 2025 · Hybrid

Cleaned and analyzed 3+ real-world datasets using SQL and Excel, reducing data inconsistencies by 40%; automated data cleaning using Python (Pandas), reducing manual preprocessing time by 30%; performed data transformation and validation to ensure accurate MIS reporting and reliable business dashboards; conducted exploratory data analysis (EDA) to identify trends and support business reporting. Tools: SQL, Excel, Power BI, Python.

Education

Acharya Institute of Graduate Studies

Bachelor of Computer Applications (BCA)

Graduated: 2025

CGPA: 8.33 / 10

Skills

SQLSQL JoinsSQL Window FunctionsPythonPandasExcelAdvanced ExcelPivot TablesVLOOKUPPower BIDAXPower QueryTableauData AnalysisData CleaningMIS ReportingData VisualizationKPI Development

Projects

Customer Churn Analysis Dashboard

Analyzed 7,043 records and found that 88% of churned customers were on Month-to-Month contracts. Developed KPIs including Total Customers (7,043), Churn Rate (26.54%), and Churned Customers (1,869). Built an interactive Power BI dashboard with filters across contract type, tenure band, and risk category. Identified 52.94% churn among customers with 0–6 month tenure versus 17.13% for 12+ months. Technologies: Python, SQL, Power BI. Duration: Dec 2024 – Jan 2025.

Sales Performance Dashboard

Wrote 30+ SQL queries using joins to extract revenue, customer, and sales insights. Identified Pune as the top revenue city and Tea as the highest-selling product with 427 units across 1,000 orders. Developed KPIs including Total Revenue (INR 16.45L), Average Order Value (INR 1,645), and Total Quantity (3,067). Built a Power BI dashboard with dynamic slicers. Technologies: SQL, Power BI, Excel. Duration: Feb 2025 – Mar 2025.

Amazon Prime Video Content Analysis

Analyzed 9,655 titles from 1920–2021 across 25 content ratings, 519 genres, and 5,771 directors. Cleaned and transformed data using Power Query. Found that Movies represented 80.82% of titles and TV Shows 19.18%. Identified Drama and Comedy as the most popular genres and 13+ as the most common rating. Built an interactive Power BI dashboard featuring country-wise distribution, release trends, genre filters, and content rating analysis. Technologies: Excel, Power BI. Duration: Mar 2025 – Apr 2025.