Data Portfolio

About Me

As a logical and rational thinker, I actively consider biases and heuristics that influence decision-making.

Discovering the world of data was an epiphany for me—I found my true passion. The ability to uncover insights and solve complex problems captivated me. Since then, I have continuously immersed myself in learning tools and theories to excel in this field.

With 2 years of experience working in large organizations and managing multiple freelance clients, alongside earning two advanced diplomas in data analytics and maintaining a dedicated data blog, I’ve developed strong expertise in solving real-world data challenges. I’m eager to collaborate with individuals and organizations looking to harness data for smarter, more informed decisions. Let’s work together to unlock insights and drive meaningful impact through analytics.

Tools I can work with: SQL, Python, Power BI, Tableau, Advanced Excel, AWS cloud

Recent Work

Ultramar inventory management system

Skills: Streamlit, Python, Pandas, Git, Automation, Gemini API


Made in less than a day, the project is used by a real convinience store in Toronto to track their inventory, saving valuable employee time. Simply upload PDF invoices and sales reports, and you get a detailed inventory excel file

Smart Job Tracker: Gmail + Gemini Automation

Skills: Google Cloud Platform, JavaScript, GeminiAPI, GmailAPI, GoogleAppsScript


The project leverages Google Apps Script to scan my Gmail inbox, using a large language model to extract key details from job applications, such as role, status, and location. For code and setup instructions, check out the GitHub repository linked in the Medium article

Spending tracker featuring LLMs

Data-stack: MSSQL (warehousing), Python, Huggingface (finetuned LLM for classification), Power BI


A comprehensive personal spending tracker designed as an end-to-end intelligence solution. Leveraged a fine-tuned pre-trained model for accurate transaction categorization, developed robust data pipelines for processing and analysis, established a scalable storage solution, and created interactive visualizations to gain actionable insights

Blog: How to think about and implement LLMs!


In this article, I share my personal journey of implementing AI models, focusing on practical insights and strategies for fine-tuning large language models. I discusss challenges encountered with resource-intensive models, the importance of creating a quality dataset, and so much more

Personal Health Dashboard

Languages: Python, Javascript and DAX


Made an automated ETL pipeline, combining data from 4 different sources, to create a comprehensive health dashboard using PowerBI

Blog series: I studied statistics so you don't have to!

A three part series that explains the fundamental concepts of statistics in relation to the current data science landscape

Bike sharing data analysis

Tools: SQL, Tableu


Analzed over 10 million rows of data with the help of SQL and Tableu, and subsequently, created a report to consolidate insights.

Market basket analysis

Tools: Python - Pandas, Numpy, Seaborn, Matplotlib


Conducted market basket analysis along with EDA on a superstore dataset.

Get In Touch

Like what you see?
I am available for lucrative job opportunities in the data analytics space.
I am always looking for interactions that can help me or somebody else learn.
Don't hesitate to reach out! Let's learn and grow together.

  • Address

    45 Silverstone Dr, Etobicoke,
    Toronto, M9V 4B1
    ON, Canada
  • Phone

    +1 (647)-614-2425
  • Email

    prayagpurohit1@gmail.com