Back to Developers
Priyanshu Kumar

Priyanshu Kumar

Data Analyst

2+ yrs exp 84 ยท Excellent

About

Data Analyst with 2 years of experience in data analysis, business intelligence, KPI reporting, and data visualization using Power BI, SQL, DAX, Power Query, and Excel. Experienced in analyzing business data, developing interactive dashboards, building star schema data models, validating data quality, investigating KPI discrepancies, and translating business requirements into actionable insights. Proficient in SQL including joins, CTEs, window functions, subqueries, aggregations, and views using Databricks. Working knowledge of Python with Pandas and NumPy for data cleaning and analysis.

Skills & Expertise (31)

Interactive Dashboards Advanced
7.5/10
2
Years Exp
Joins Advanced
7.5/10
2
Years Exp
SQL Advanced
7.5/10
2
Years Exp
Semantic Models Advanced
7.5/10
2
Years Exp
Fact & Dimension Modeling Advanced
7.5/10
2
Years Exp
Star Schema Advanced
7.5/10
2
Years Exp
Data Modeling Advanced
7.5/10
2
Years Exp
Power Query Advanced
7.5/10
2
Years Exp
DAX Advanced
7.5/10
2
Years Exp
CTEs Advanced
7.5/10
2
Years Exp
Data Visualization Advanced
7.5/10
2
Years Exp
Power BI Advanced
7.5/10
2
Years Exp
Window Functions Advanced
7.5/10
2
Years Exp
Subqueries Advanced
7.5/10
2
Years Exp
Aggregations Advanced
7.5/10
2
Years Exp
Views Advanced
7.5/10
2
Years Exp
Excel Intermediate
6.5/10
2
Years Exp
NumPy Intermediate
6.5/10
2
Years Exp
Pivot Tables Intermediate
6.5/10
2
Years Exp
VLOOKUP Intermediate
6.5/10
2
Years Exp
Data Cleaning Intermediate
6.5/10
2
Years Exp
Python Intermediate
6.5/10
2
Years Exp
Pandas Intermediate
6.5/10
2
Years Exp
Exploratory data analysis Intermediate
6.5/10
2
Years Exp
Data Extraction Intermediate
6.5/10
2
Years Exp
Business Reporting Intermediate
6.5/10
2
Years Exp
Root Cause Analysis Intermediate
6.5/10
2
Years Exp
KPI Reporting Intermediate
6.5/10
2
Years Exp
Data Quality Intermediate
6.5/10
2
Years Exp
Data Validation Intermediate
6.5/10
2
Years Exp
Trend Analysis Intermediate
6.5/10
2
Years Exp

Work Experience

Data Analyst

Tata Consultancy Services

Oct 2024 - Present

Analyzed and validated business datasets using SQL in Databricks and SQL views connected to Power BI, supporting KPI reporting, trend analysis, and data-driven business decisions. Developed and enhanced Power BI data models using Fact and Dimension tables, star schema relationships, DAX measures, and Power Query to improve KPI calculation accuracy and report performance. Investigated data quality issues and KPI discrepancies by analyzing backend SQL queries and reporting data, identifying root causes and validating corrections through UAT testing. Collaborated with stakeholders to translate business requirements into KPI reports and dashboards, providing reliable reporting and improved visibility into business performance. Supported report deployment through PR approval workflows and validated post-change results to ensure data accuracy, consistency, and reporting reliability.

Education

Bachelor of Technology in Information Technology - Haldia Institute of Technology

2020 - 2024 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 9/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 84/100

Profile Overview

Member sinceOct 2026