a data analyst turning raw data into clear, decision-ready insights
I'm Palak Rawat, also known as Palak Techie, a data analyst and Data Science undergraduate at IIT Madras. With hands-on experience in SQL, Python, Pandas, Excel, and Power BI, i focus on data cleaning, KPI analysis, and dashboards that turn customer and revenue data into decisions. Let's find the story in your data together!
Cleaning, preprocessing, and exploratory analysis of real-world datasets with Python, Pandas, NumPy, and Excel to surface customer behavior, spending patterns, and KPIs.
Business-oriented analysis in PostgreSQL and SQLite using CTEs, window functions, and aggregate queries across revenue, customer segments, channels, and churn.
Interactive dashboards built on star-schema data models with DAX measures and KPIs for churn, retention, revenue, and customer lifetime value.
Supervised regression and classification with feature engineering, Random Forest, and GridSearchCV tuning, compared across multiple algorithms.
Role-based Flask and SQLAlchemy applications with REST endpoints, relational schemas, and clean HTML5 and CSS3 front ends.
Python · Pandas · PostgreSQL · SQL · Power BI · DAX
15,000 customers analyzed, 15.32% overall churn, 3-page Power BI dashboard
Python · Pandas · NumPy · Scikit-learn
7 regression models compared, Random Forest validation R² of 0.9755
Flask · SQLAlchemy · SQLite · HTML5/CSS3
Role-based dashboards for Admins, Doctors and Patients across 8 entities
Palak Rawat is a data analyst and BS in Data Science and Applications student at IIT Madras (expected 2028). Palak works with SQL, Python, Pandas, Excel and Power BI on data cleaning, KPI analysis and dashboards that turn customer and revenue data into decisions.
Palak Techie is the online name of Palak Rawat, the data analyst and IIT Madras Data Science student behind palakrawat.xyz. Palak Techie and Palak Rawat are the same person.
Data analysis and business intelligence: cleaning and exploring real-world datasets in Python and Pandas, business analysis in SQL (PostgreSQL, CTEs, window functions) and interactive Power BI dashboards built on star-schema models with DAX. Palak also builds machine learning models with scikit-learn and web apps with Flask.
A customer churn and behavior analysis of 15,000 customers (15.32% churn, 3-page Power BI dashboard), a flight ticket price prediction model comparing 7 regression models (best validation R² of 0.9755) and a role-based hospital management system in Flask and SQLAlchemy.
Palak won Ship Happens 2026, a student hackathon organised by AWS Student Builder Group ADGIPS in Delhi NCR, and ranked All India 196 out of 15,000+ teams in the National Entrepreneurship Challenge at IIT Bombay.
Email palak23052004@gmail.com, or connect on LinkedIn and on GitHub as palak651.
Indian Institute of Technology Madras
BS in Data Science and Applications
May 2024 – Expected 2028 · CGPA 7.84 / 10
Lady Irwin College, University of Delhi
B.Sc. in Home Science
2021 – 2024 · CGPA 8.64 / 10
D.S. Science Academy, Gangapur City
Rajasthan Board (RBSE)
2019 – 2021 · Class XII 95.0% · Class X 88.8%
Data Analytics
Python, Pandas, NumPy, SQL, Data Cleaning, EDA, Statistical Analysis, KPI Analysis, Data Visualization
Business Intelligence
Power BI, DAX, Dashboard Development, Data Modeling, Star Schema, Dynamic Measures
Excel
Microsoft Excel, Pivot Tables, Lookups
Databases
PostgreSQL, SQLite, Advanced SQL, CTEs, Window Functions, Aggregate Queries
Machine Learning
Supervised Regression, Classification, Decision Trees, Random Forest, Feature Engineering, GridSearchCV
Development & Tools
Git, GitHub, Jupyter, Google Colab, VS Code, Flask API, SQLAlchemy, REST, HTML5, CSS3
© 2026 Palak Rawat · Palak Techie
