Hi, I'm

Prajyot Yesankar

Data Analyst

Computer Science and Design graduate with two data analyst internships. I build interactive Power BI dashboards, data models and SQL solutions that turn raw data into clear business decisions. Open to Power BI intern and data analyst roles.

Hire MeDownload CVView GitHub

About Me

I'm a Computer Science and Design graduate (B.Tech, 2026) who enjoys turning messy data into dashboards that people can act on. In two data analyst internships I worked on SQL reporting, data validation and exploratory analysis. In my own projects I built Power BI dashboards with Power Query and DAX, and SQL Server solutions with views, stored procedures and triggers.

2Data analyst internships
3Projects on GitHub
1.48KEmployees analysed in HR dashboard
7.5CGPA, B.Tech

My Internships

Internship Experience

Apr 2025 - Oct 2025

Data Analyst Intern, Sancy Berhad

Domain: Healthcare

  • Worked with healthcare databases using SQL for data retrieval and reporting.
  • Assisted in database management, SQL querying and structured data processing.
  • Performed data validation, transformation and reporting using SQL.

May 2024 - Jul 2024

Data Analyst Intern, Intel Unnati Industrial Training Program

  • Cleaned, validated and analyzed structured datasets using Python and SQL.
  • Wrote SQL queries to retrieve, filter, aggregate and analyze business data.
  • Performed exploratory data analysis (EDA) and produced analytical reports.

Key Strengths

Data Analysis

Data Processing and Analysis

  • Cleaning and transforming data with Python, SQL and Power Query.
  • Exploratory data analysis and KPI reporting.
  • Building data models for reporting.

Visualization

Dashboard Development

  • Designing interactive Power BI dashboards.
  • Writing DAX measures for dynamic KPIs.

Database Management

SQL Development

  • Complex T-SQL with JOINs, CTEs and window functions.
  • Views, stored procedures, functions and triggers.

Projects

Analytics

HR Analytics Dashboard

A one-page dashboard on 1.48K employees: 238 leavers, a 16.1% attrition rate, average age 37 and average tenure 7 years. Attrition is broken down by education field, age group, salary slab, job role and years at company, with a department filter.

1.48Kemployees
238leavers
16.1%attrition
Power BIPower QueryDAXSQL
View on GitHub
HR Analytics dashboard in Power BI with KPI cards and attrition charts

Forecasting

Sales Performance Dashboard

A two-page Superstore dashboard. Page one covers sales by category, sub-category and ship mode, monthly profit and sales year over year, a state map and a region filter. Page two shows a 15-day sales forecast and sales by state, led by California and New York.

2pages
15-dayforecast
Power BIPower QueryDAXForecasting
View on GitHub
Super Store 15-day sales forecast dashboard

Database

Retail Sales Analytics

T-SQL analysis of retail sales data in Microsoft SQL Server using JOINs, CTEs, window functions, aggregate functions and subqueries, plus views, stored procedures, functions and triggers that automate database work.

SQL ServerT-SQLStored ProceduresTriggers
View on GitHub

My Skills

Business Intelligence

  • Power BI
  • Power Query
  • DAX
  • Dashboard Development
  • Data Visualization
  • Data Modeling

Databases and SQL

  • SQL Server and MySQL
  • JOINs and CTEs
  • Window Functions
  • Stored Procedures
  • Query Optimization

Programming and Analytics

  • Python
  • Machine Learning
  • Exploratory Data Analysis
  • KPI Reporting

Tools

  • Microsoft Excel
  • Git and GitHub
  • Visual Studio Code
  • Jupyter Notebook

My Journey

Education

Oct 2022 - May 2026

B.Tech in Computer Science and Design

Faculty of Engineering and Technology. CGPA 7.5 out of 10.

Jun 2020 - May 2022

Higher Secondary Certificate (HSC), Science

Indira Gandhi Vidyalaya and Junior College, Allipur. Grade: 62%.

Jul 2019 - Apr 2022

Secondary School Certificate (SSC)

Indira Gandhi Vidyalaya, Allipur. Grade: 81.60%.

My Certificates

Jan 2024 - Coursera

Programming for Everybody (Getting Started with Python)

University of Michigan

Coursera certificate: Programming for Everybody (Getting Started with Python), University of Michigan

Feb 2024 - Coursera

Python Functions, Files, and Dictionaries

University of Michigan

Coursera certificate: Python Functions, Files, and Dictionaries, University of Michigan

Jan-Mar 2026 - NPTEL

Cloud Computing and Distributed Systems

IIT Kanpur, Elite certificate, score 69%.

NPTEL Elite certificate: Cloud Computing and Distributed Systems, IIT Kanpur

Contact Me

Email

yesankarprajyot@gmail.com

For roles, internships and project discussions.

LinkedIn

Connect professionally

See my profile and background.

WhatsApp

+91 93225 51293

Message me for quick replies.

GitHub

yesankarprajyot123

Code for all my projects.