Prantik Jati

Data Analyst

[email protected]

Resume

Hello, I am

Prantik Jati.

1

Excel
Project

2

PowerBI
Projects

1

Python
Project

About Me

Hi there! I'm Prantik Jati,

A Data Science Student with a passion for solving problems and finding insights through data.

I have skills in Python, MySQL, Math & Statistics, and Machine Learning, and I enjoy using these to analyze data, create predictive models, and visualize results.

I’m constantly learning and working on projects to sharpen my skills and apply data science to real-world challenges.

Let’s connect and explore how we can use data to make an impact together!

Key Skills

Microsoft Excel

Power BI

MySQL

Python

Problem Solving

Team Management

Business Analysis

Project Management

Data Integrity

Math

Statistics

Data Visualization

My Projects

Sales - Analytics

Domain/Function: Business

Business Insights 360 Dashboard

Domain/Function: Business

Revenue and Market Share Analysis

Domain/Function: Hospitality

Expense Tracking System

Domain/Function: Personal Finance Management

My Experience

INTERNSHIPS AND EXPERIENCES:

Data Science Intern – AtliQ Technologies Pvt. Ltd. (Jan 2025 - Present)

As a Data Science Intern at AtliQ Technologies Pvt. Ltd., I am gaining hands-on experience leveraging data to solve real-world business problems. My role involves working with large datasets, ensuring data integrity through cleaning and preprocessing, and deriving actionable insights to support strategic decision-making.
I actively develop predictive models and implement machine learning algorithms to identify trends and patterns that drive value for the organization. Using tools like Python and MySQL, I transform raw data into meaningful insights, creating visualizations and interactive dashboards to communicate findings effectively to stakeholders.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Certificate of Career Essentials in Data Analysis by Microsoft.

Certificate of Career Essentials in Business Analysis by Microsoft.

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/prantik-jati-63116922a/

GitHub

https://github.com/ScaryPnj

Excel Project

Sales - Analytics

Domain/Function: Business

Create a customer performance report and comprehensively compare market performance and sales targets. Empower businesses to monitor and evaluate their sales activities and performance. Identify sales patterns and track key performance indicators (KPIs).

View Project
Engagement

View Project
on GitHUB

This is the first page of the Customer performance report.

This is the Market performance vs target report page.

Project Details

The Sales-Analytics project aimed to provide businesses with data-driven insights to enhance decision-making and optimize performance. It involved creating a Customer Performance Report to assess how well customers performed against sales targets, identify sales patterns, and track key performance indicators (KPIs). This report empowered businesses to improve customer discount strategies, negotiate more effectively with consumers, and identify new market opportunities for expansion. Additionally, the project included a Profit and Loss (P&L) Report, which analyzed financial performance by fiscal year, month, and market segments. The P&L report helped businesses benchmark their performance against industry peers and previous periods, supporting budgeting and forecasting. Together, these reports enabled businesses to align their financial planning with strategic goals and gain confidence in their financial outlook. The overall purpose of the Sales-Analytics project was to monitor sales pe

PowerBI Project

Business Insights 360 Dashboard

Domain/Function: Business

AtliQ Hardwares, a growing electronics company, relied on Excel-based reporting, limiting data-driven decisions. I implemented a Power BI solution that provided actionable insights for stakeholders across sales, marketing, finance, and the executive team in a single, user-friendly report.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

Ms Excel

This is the Finance page.

This is the Sales page.

Project Details

AtliQ Hardwares, a fast-growing consumer electronics company, faced challenges in leveraging data for decision-making due to reliance on Excel-based reporting. I developed a comprehensive Power BI solution that integrated over 10 tables for robust data modeling and provided drillable insights across sales, marketing, finance, and supply chain. The user-centric report design ensured clarity and ease of use, allowing stakeholders from various departments, including the executive team, to explore data and make informed decisions. Key skills applied included Power Query for data transformation, DAX formulas for calculations, and dashboard design principles. The project outcome was an interactive, scalable solution that streamlined reporting and enhanced decision-making capabilities across the organization.

Live Interactive Dashboard

PowerBI Project

Revenue and Market Share Analysis

Domain/Function: Hospitality

This project focuses on analyzing historical hotel performance data for AtliQ Grands, a hospitality company. The primary goals include cleaning and organizing data, calculating key performance metrics, and creating a dashboard to provide valuable insights for decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

This is an image of Dashboard.

This is an image of the Revenue trends.

Project Details

I worked on a comprehensive data analytics project for AtliQ Grands, a five-star hotel chain, focused on driving revenue recovery and market share growth. The project involved cleaning and organizing historical hotel performance data to ensure data integrity. I developed key performance metrics, including Revenue Per Available Room (RevPAR), Average Daily Rate (ADR), and Occupancy Rate. Utilizing Power BI, I designed an interactive dashboard, enabling stakeholders to track KPIs and gain actionable insights into business performance across regions and customer segments. Based on trend analysis, I provided strategic recommendations on pricing, customer targeting, and marketing efforts to enhance overall business growth.

Live Interactive Dashboard

Python Project

Expense Tracking System

Domain/Function: Personal Finance Management

This Expense Tracking System is a Python-based application designed to help users efficiently manage their finances. Built with a focus on simplicity and functionality, this system allows users to log daily expenses, categorize them, and generate summaries to track spending patterns.

View Project
on GitHUB

This is the frontend of this Expenses Management System.

This is the analytics part of the expense management system.

Project Details

This Expenses Management System simplifies tracking and managing personal or business finances. The system features intuitive interfaces for logging expenses, categorizing transactions, and setting budgets. Users can generate detailed financial reports and visualizations to gain insights into spending patterns. Automated alerts help prevent overspending by notifying users of budget limits. The system also supports secure data storage and periodic backups to ensure data integrity. Ideal for individuals and businesses seeking to streamline their financial management, this tool leverages Python's flexibility to deliver a reliable and efficient solution for expense tracking.