top of page

Data With Jas

Hi, I'm Jasmine!

Welcome to my corner of the web! Here on DataWithJas, I share my latest projects and helpful articles about the tools and techniques I use most, like SQL, Machine Learning, Power BI, and Pandas. Feel free to explore, and I hope you find something here that inspires you.

If you're looking to hire for a project, feel free to reach out! And if you’re a nonprofit or charity, I’d love to offer my support pro bono as part of my commitment to giving back.

Here are some of the areas I specialize in:

Database Query Design

Data Cleaning and Preparation

Python Development

Machine Learning Solutions

Dashboard and Visualization Design

Data Science Projects

SQL Training and Support

Advanced Data Analysis

Business Intelligence Solutions

Jasmine Abtahi

My Latest Projects

Comprehensive Analysis of Retail Sales Data

Comprehensive Analysis of Retail Sales Data

This project involves working with retail sales data to create interactive Power BI dashboards. It also focuses on data preprocessing, integrating multiple data sources, and optimizing DAX calculations using technologies like SQL, Pandas, Power BI and Python scripts.

Hands-On SQL Exercises

Hands-On SQL Exercises

This project focuses on solving and providing detailed explanations for 9 complex and unique SQL challenges for educational purposes. It leverages advanced techniques such as CTEs, Window Functions, Indexing, Subqueries, Joins, Aggregations, and Recursive Queries to showcase efficient and scalable SQL query development.

My Latest Articles

Understanding the “GO” Command in SQL Server

Understanding the “GO” Command in SQL Server

When writing SQL queries in SQL Server, you may have come across the GO command. But why do we use it? What purpose does it serve, and when is it necessary? In this article, we’ll explore how the SQL Server GO command works, why it’s needed, and provide examples to clarify its usage.

1384 - Total Sales Amount by Year [LeetCode]

1384 - Total Sales Amount by Year [LeetCode]

Write a solution to report the total sales amount of each item for each year, with corresponding product_name, product_id, report_year, and total_amount.

Mastering SQL: 12 Essential Tips to Optimize Performance and Secure Your Queries

Mastering SQL: 12 Essential Tips to Optimize Performance and Secure Your Queries

Writing SQL queries might seem simple, but creating ones that are both efficient and easy to maintain takes practice. By following best practices, you can make sure your queries run smoothly and quickly. In this article, we’ll explore some key tips for writing better SQL, with examples to help you along the way.

1127. User Purchase Platform [LeetCode]

1127. User Purchase Platform [LeetCode]

Write an SQL query to find the total number of users and the total amount spent using mobile only, desktop only and both mobile and desktop together for each date.

1645 - Hopper Company Queries II [LeetCode]

1645 - Hopper Company Queries II [LeetCode]

Write an SQL query to calculate the percentage of working drivers (working_percentage) for each month of 2020. The working percentage is determined by the ratio of drivers who accepted rides in a given month to the total number of drivers available during that month.

Mastering SQL: Identifying Customers with Consecutive Increasing Transactions

Mastering SQL: Identifying Customers with Consecutive Increasing Transactions

In this article, we will explore how to write an SQL query that identifies customers who have made consecutive transactions with increasing amounts over several days. We’ll cover the logic step-by-step, and I’ll guide you through a complex example that considers various edge cases.

2494 — Merge Overlapping Events in the Same Hall [LeetCode]

2494 — Merge Overlapping Events in the Same Hall [LeetCode]

Write an SQL query to merge all the overlapping events that are held in the same hall. Two events overlap if they have at least one day in common.

SQL CHALLENGE: Calculating the number of remaining inventories

SQL CHALLENGE: Calculating the number of remaining inventories

We want to generate an inventory age report which would show the distribution of remaining inventory across the length of time the inventory has been sitting at the warehouse. We are trying to classify the inventory on hand across the below 4 buckets to denote the time the inventory has been lying the warehouse.

Maximize Prime Item Inventory [Amazon SQL Interview Question]

Maximize Prime Item Inventory [Amazon SQL Interview Question]

Amazon wants to maximize the storage capacity of its 500,000 square-foot warehouse by prioritizing a specific batch of prime items. The specific prime product batch detailed in the inventory table must be maintained.

Solving a Complex SQL Challenge on HackerRank: “15 Days of Learning SQL”

Solving a Complex SQL Challenge on HackerRank: “15 Days of Learning SQL”

Julia conducted a 15 days of learning SQL contest. The start date of the contest was March 01, 2016 and the end date was March 15, 2016. Write a query to print total number of unique hackers who made at least 1 submission each day (starting on the first day of the contest), and find the hacker_id and name of the hacker who made maximum number of submissions each day. If more than one such hacker has a maximum number of submissions, print the lowest hacker_id. The query should print this information for each day of the contest, sorted by the date.

bottom of page