Ritik singh Rathore
@ritiksinghrathore
Data analyst specializing in Python, SQL, PostgreSQL, and Power BI dashboards for actionable insights.
IndiaWhat I'm looking for
I’m a Data Analyst focused on end-to-end data workflows—cleaning raw datasets, writing complex multi-table queries, and turning results into interactive BI dashboards. I build with Python and SQL (including PostgreSQL), then use DAX and Power BI to deliver insights stakeholders can act on.
In my Loan Analysis Dashboard, I created a 6-page interactive Power BI experience, authored 10 custom DAX measures, and modeled loan data with PowerQuery (including derived columns and a supporting DateTable). I also designed cross-page slicers so users can filter and drill down by key dimensions like Year and ApprovalStatus.
With my Superstore and Olist SQL projects, I’ve practiced rigorous EDA and advanced querying—resolving missing values, engineering features, and applying JOINs, CTEs, CASE-based segmentation, and window functions. I enjoy finding decision-ready patterns (like profit impacts from discounts) and presenting them clearly through charts and KPI-driven reporting.
Experience
Work history, roles, and key accomplishments
Analyzed a Brazilian e-commerce dataset using 20 structured PostgreSQL queries spanning revenue, customer behavior, seller performance, product categories, delivery logistics, and payment patterns. Wrote complex multi-table JOINs across 6+ tables and used CTEs, CASE segmentation, and window functions to produce customer tiers and ranked seller insights.
Conducted end-to-end EDA on a 9,994-record retail dataset to analyze sales trends, profitability patterns, and regional performance by product category and customer segment. Cleaned and engineered features, built a 6-panel Matplotlib/Seaborn summary dashboard, and identified that discounts above 20% consistently produced negative profit margins.
Built a 6-page Power BI loan analysis dashboard covering approval trends, applicant demographics, credit risk, loan financials, and income patterns. Authored 10 custom DAX measures, modeled data in Power Query, and implemented cross-page slicers to enable interactive filtering and drilldowns.
Education
Degrees, certifications, and relevant coursework
University of Jammu
Bachelor of Computer Applications (BCA), Computer Applications
2023 -
Currently pursuing a Bachelor of Computer Applications (BCA) program with a strong mathematical foundation.
J&K Board of School Education (JKBOSE)
12th Standard (Higher Secondary), Higher Secondary Education
Completed the 12th Standard (Higher Secondary) and passed the JKBOSE examination.
Tech stack
Software and tools used professionally
Availability
Location
IndiaAuthorized to work in
Social media
Job categories
Interested in hiring Ritik singh?
You can contact Ritik singh and 90k+ other talented remote workers on Himalayas.
Message Ritik singhFind your dream job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
