Data Analyst with less than a year in SQL, Excel, and Power BI for business intelligence and reporti
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Analytical and detail-oriented Data Analyst fresher proficient in Excel, SQL, and Power BI, with hands-on experience in building business intelligence dashboards, KPI tracking systems, and performance reports through academic and self-driven projects to deliver actionable business insights and support data-driven decision-making.
Lucknow Public College of Professional Studies (Lucknow University Affiliated)
Bachelor of Business Administration (BBA)
January 1, 2021 – January 1, 2024
Restaurant Sales Data Analysis
April 1, 2025 – September 1, 2025
Analyzed 21K+ customer orders and $817.9K revenue using SQL to identify sales trends and business performance drivers. Analyzed pizza sales data to identify top-performing categories, sizes, and flavours, with Classic pizzas leading at 14,888 units sold, while generating actionable insights on peak order hours, best-selling products, and revenue contribution to support business decision-making.
View ProjectFood Delivery Sales & Customer Insights Dashboard
November 1, 2024 – April 1, 2025
Evaluated 53.01M revenue, 197.43K orders, 268.51 average order value, and 4.34 average customer rating. Performed state-wise, city-wise, and customer behaviour analysis for business insights.
View ProjectE-Commerce Revenue & Sales Insights Dashboard
June 1, 2024 – November 1, 2024
Analyzed 59M+ in e-commerce sales data to identify regional and category-level performance trends. Identified discount impact (14.98%) and seasonal sales patterns for better business insights. Performed data cleaning and transformation to improve data accuracy and reporting efficiency.
View ProjectMeta Ad Campaign Performance Analysis
January 1, 2024 – June 1, 2024
Analyzed 216K impressions, 25.4K clicks, 29.3K engagements and 1.3K purchases. Tracked CTR of 11.76%, Engagement Rate of 13.56%, and Conversion Rate of 5.21% across Meta ad campaigns. Created dynamic visuals, slicers, and demographic insights for campaign performance analysis and reporting.
View ProjectCultural Fit Analysis
The candidate's academic projects cover diverse business domains (ad campaigns, e-commerce, food delivery, restaurant sales), indicating adaptability and a broad interest in applying data analysis to different industries. The focus on delivering actionable insights aligns with a results-oriented culture. As a fresher, the candidate's cultural fit will largely depend on their ability to collaborate and learn within a team environment, which is not explicitly detailed in the provided data.
Soft Skills & Operational Fit
The candidate's project descriptions indicate an ability to work with diverse datasets and translate raw data into business insights, suggesting good analytical problem-solving and data storytelling skills. The academic nature of all projects means direct operational fit in a professional setting is yet to be proven, but the foundational skills are present.