Kanika Rana

Aspiring Data Analyst

Chandigarh, India 0+ yrs exp 86 · Excellent

About

Aspiring Data Analyst with hands-on experience in SQL, Python, Power BI, Microsoft Excel, and Google Sheets. Skilled in data cleaning, exploratory data analysis, dashboard development, spreadsheet analysis, and problem solving to transform data into actionable insights and support data-driven decision-making.

Skills & Expertise (35)

Pandas Intermediate

8.1/10

0.5

Years Exp

SQL Queries Intermediate

8.1/10

0.5

Years Exp

Data Cleaning Intermediate

8.1/10

0.5

Years Exp

Data Visualization Intermediate

8.1/10

0.5

Years Exp

Power BI Intermediate

8.1/10

0.5

Years Exp

Python Intermediate

8.1/10

0.5

Years Exp

Microsoft Excel Intermediate

8.0/10

0.5

Years Exp

ETL Intermediate

7.5/10

0.5

Years Exp

NumPy Intermediate

7.5/10

0.5

Years Exp

MySql Intermediate

7.5/10

0.5

Years Exp

Git Intermediate

6.5/10

0.5

Years Exp

Tableau Intermediate

6.5/10

0.5

Years Exp

ChatGPT Exploratory data analysis Microsoft Copilot Prompt Engineering AI-assisted data analysis Joins Aggregations Subqueries Window Functions GitHub Database Management KPI Tracking Pivot Tables Dashboard Development Power Query DAX Google Sheets Spreadsheets Conditional Formatting Data Validation Data Modeling XLOOKUP VLOOKUP

Work Experience

Data Analyst Intern

Netmax Technologies Pvt. Ltd.

Jan 2026 - Jun 2026

Analyzed 10,000+ record operational datasets using Python (Pandas, Matplotlib) and SQL to extract business insights and identify process improvement opportunities. Built interactive Power BI dashboards and data visualizations with KPIs, slicers, drill-through, and DAX measures to support data-driven decision making. Wrote SQL queries (joins, aggregations, subqueries) and automated database management and automated data cleaning workflows using Python. Ensured data integrity and accuracy through validation checks; Collaborated with cross-functional teams to validate data, prepare reports, and deliver insights to stakeholders.