Kanishthiya Ranganathan

Kanishthiya Ranganathan

Aspiring Data Analyst
India
Tamil, English

About Me

Detail-oriented B.Sc. Computer Science graduate with hands-on internship exposure to data analysis at BEES Technology. Skilled in SQL, Advanced Excel (INDIRECT, Dynamic Arrays, Power Query), Tableau, and Power BI. Seekin…

Experience

Data Analyst Intern

Bees Technology

<p>Collected and cleaned a 500+ record structured dataset in MS Excel, identifying and correcting data inconsistencies, duplicates, and missing values to improve overall data accuracy by an estimated 30%.<br>
Performed data validation and quality checks using rule-based logic to flag anomalies, mismatched entries, and abnormal patterns across the dataset.<br>
Built an interactive KPI dashboard in MS Excel and Power BI using pivot tables, charts, and trend visualizations to monitor key performance metrics and business trends.<br>
Interpreted data trends and patterns to generate actionable insights, presenting findings to peers in clear, non-technical language to support data-driven business decision-making.</p>

Skills

SQL Advanced Excel INDIRECT Dynamic Arrays Power Query Tableau Power BI Python Business Analytics Pivot Tables Pivot Charts Slicers XLOOKUP COUNTIFS SUMIFS MS Office Suite Google Sheets INDEX/MATCH Data Cleansing Data Audit Exploratory Data Analysis Joins Grouping Filtering Database Management Systems Trend Analysis Performance Analysis
Report this Profile?