Case Study - Danny's Diner

Solved more than ten complex SQL queries with ease, applying joins, functions, row_number(), rank(), and the over clause with accuracy. Common Table Expressions (CTE) were used to improve performance and readability. This shows my knowledgeable approach to SQL problem-solving.

Sample Store Dashboard: Sales and Profit Analysis

For a sample store dataset, a dynamic Tableau dashboard featuring more than five charts was created. brings KPIs, year-over-year exploration, and in-depth insights. Making good choices based on graphical metrics is enabled by simple design.

Zomato order Analysis.

Created a tableau Dashboard with 4 charts to analysis Zomato's order dataset, including line chart, donut chart and radial bar chart. The dashboard gives insights about average price v/s No. of restaurant, different ranting of restaurant etc.

HR Dashboard

Created a dynamic HR Dashboard on tableau, include calculating different KPIs like Attrition rate, Avg Age of the employee, Education wise iteration, No. of employees group by age.

Growth Strategy

Achieving 5000 Sales for Cards Against Work (CAW) Without Advertising Budget. Our no-budget project targets 5000 sales for Plum's Cards Against Work. Precision marketing uses social media, employee networks, and local engagement, portraying CAW as a symbol of workplace joy.

Excel Case Study

solved more than 5 questions. Used excel formulas like countifs, sumifs, index, match, pivot table. Explanation is also given with all the questions.

Customer Complaint Dashboard

This dynamic dashboard features four charts and six KPIs, offering insights into: 1️⃣