Kartik Pant

Data Analyst
Haldwani, IN.

About

A detail-oriented and enthusiastic recent graduate with a strong foundation in data analytics, specializing in leveraging tools like Excel, SQL, and Power BI to transform complex data into actionable business insights. Successfully completed a data analytics mentorship program, demonstrating proficiency in data collection, organization, interpretation, and report generation. Eager to apply strong analytical thinking, meticulous attention to detail, and effective communication skills to drive data-driven decisions as a valuable Data Analyst.

Education

Amrapali University
Haldwani, Uttarakhand, India

Bachelors

Business Administration

Certificates

Data Analytics Mentorship Program

Issued By

WsCube Tech

SQL Fundamentals in 90 minutes

Issued By

WsCube Tech

GenAI for Data Analytics

Issued By

WsCube Tech

Skills

Data Analysis Tools

Excel, Power Query, SQL, Power BI, DAX, Generative AI.

Technical Skills

Data Collection, Data Processing, Data Modelling, Data Visualization, Report Generation, Business Intelligence.

Professional Skills

Problem Solving, Adaptability, Collaborative Teamwork, Leadership Abilities, Communication Skills, Analytical Thinking.

Projects

Swiggy Data Analysis Using SQL

Summary

Executed comprehensive SQL-based data analysis on Swiggy's customer, order, restaurant, and delivery datasets to extract actionable business insights and drive operational improvements.

Airbnb Data Analysis Using Power BI

Summary

Performed detailed data analysis and visualization of Airbnb listings, pricing, host performance, and reviews using Power BI to extract actionable market insights.

ITC Hotel Revenue Optimization Using Power BI

Summary

Designed and implemented an interactive, multi-page Power BI dashboard to analyze ITC Hotels' sales data, focusing on financial performance and booking behavior for revenue optimization.

Jenson USA Sales Analysis Using SQL

Summary

Conducted end-to-end SQL-based data analysis on Jensen USA's retail operations to derive insights on customer behavior, staff performance, inventory, and store efficiency.

McDonald's Sales Dashboard Using Excel

Summary

Developed an interactive sales dashboard for McDonald's, focusing on performance analysis to identify sales optimization opportunities and inform strategic planning.