Kaif Bhati

Entry-level Data Analyst

Pilani, Jhunjhunu, Rajasthan, India 80 · Excellent

About

Entry-level Data Analyst with strong hands-on experience in SQL, Python, Power BI, and Excel, focused on data cleaning, analysis, and visualization. Experienced in analyzing large datasets (50k+ records) to identify trends, KPIs, and actionable business insights. Proficient in SQL querying, Power BI dashboards, and data modeling to support data-driven decision-making.

Skills & Expertise (28)

Power BI Advanced

7.5/10

Years Exp

Excel Advanced

7.0/10

Years Exp

Problem Solving Advanced

7.0/10

Years Exp

SQL Advanced

7.0/10

Years Exp

Data Visualization Advanced

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Business Insights Intermediate

6.0/10

Years Exp

NumPy Intermediate

5.5/10

Years Exp

Dashboard Reporting Postgresql VS Code Jupyter Notebook Charts Data-driven decision making VLOOKUP Pivot Tables Data Modeling ETL DAX Power Query Window Functions CTEs Subqueries Joins Seaborn Matplotlib

Work Experience

Data Analyst

E-Commerce Sales Performance Dashboard

Present - Present

Designed an interactive Power BI dashboard to analyze ₹7.53Bn total sales, YoY growth, profit margin, and regional performance. Built KPI cards, trend analysis, Top/Bottom product insights, and monthly sales tracking to support business decisions. Used DAX measures for Total Sales, Profit, Profit Margin %, and YoY Sales growth. Implemented slicers (Region, Category, Sales Channel) for dynamic filtering and drill-down analysis. Delivered business insights such as top-performing regions, high-revenue products, and seasonal sales trends.

Data Analyst

SQL Project – Online Bookstore Sales Analysis

Present - Present

Analyzed bookstore data using Books, Customers, and Orders tables. Used JOINs to establish relationships between multiple tables. Retrieved business insights using aggregate functions (revenue, quantity sold, stock). Identified top-selling books, high-value customers, and popular genres. Performed date-based analysis to analyze monthly and yearly orders. Used GROUP BY, HAVING, and subqueries to solve advanced business queries.

Data Analyst

SQL Project – Hospital Operations & Patient Analysis

Present - Present

Analyzed hospital data to evaluate patient volume, department performance, and medical costs. Performed aggregations to calculate total patients and average doctors per hospital. Used date functions to analyze length of stay and monthly expense trends. Identified high-cost hospitals and departments with low patient intake. Generated city-wise healthcare demand reports.

Data Analyst

Power BI Sales Analytics Dashboard

Present - Present

Developed an interactive Power BI dashboard to analyze sales performance across product categories and regions. Cleaned and transformed raw data using Power Query (data types, duplicates, validation). Created DAX measures to calculate total sales and quantity. Designed visuals including KPI cards, bar charts, line charts, pie charts, and matrix for business insights. Implemented slicers to enable dynamic filtering and drill-down analysis.