Arshu Sheerin H M
Data Analyst | SQL | Excel | Power BI | Python
New to Contra
Arshu is building their profile!
• Built an interactive Power BI dashboard on Aadhaar enrolment trends across 49 states and 965 districts using 10.06L+ records from the official UIDAI API dataset. • Combined 3 CSV files using Power Query Append Queries; created DAX measures for Total Enrolment, Year, and Target Enrolment (10L) to track KPI performance. • Revealed key insights — September peak at 13.66L, 65.3% enrolments are children under 5, and December fell 12.1% below the 10L target.
1
15
Analyzed 1,000+ sales transactions across 3 branches and 6 product lines using SQL for data cleaning, feature engineering, and business analysis. • Engineered 3 new columns — time of day, day name, month name — using CASE, DAYNAME, and MONTHNAME; evaluated revenue (3.23L), COGS, VAT, and gross income. • Built a Power BI dashboard with KPI cards and trend charts; Branch C Naypyitaw led with 1.10L revenue; Food & Beverages was the top product line.
0
11
Analyzed 1,470 employee records across 3 departments using Excel and Power BI to uncover attrition patterns by age, gender, education, and job role. • Built DAX measures — Attrition Rate (16.12%), Active Employees (1,233), and Average Age (37) — using DIVIDE, COUNTROWS, FILTER, and AVERAGE functions. • Dashboard revealed R&D as highest attrition department (133 employees, 56%), age group 25–34 highest risk (112 left), and Lab Technicians most at-risk role (62).
0
11