Sanket Savkar Kanse

DATA ANALYST | POWER BI DEVELOPER

[email protected] +91 8369619710

Resume

Hello, I am

Sanket Savkar Kanse.

1

Excel
Project

4

PowerBI
Projects

1

SQL
Project

About Me

I'm an aspiring data analyst who loves turning data into insights. Using tools like Excel, Power BI, Tableau, and MySQL, I can take complex data and make it easy to understand.

While I haven't worked in a company yet, I've completed several business projects that show what I can do. In my portfolio, you'll see examples of my work, from analyzing customer behavior to reviewing sales performance. These projects highlight my ability to find trends and present my findings clearly.

I'm excited to bring my skills to a professional setting and help a company succeed with data-driven decisions. I'm always learning and staying updated with the latest trends and tools in the industry, ready to make a positive impact.

Thank you for visiting my profile. I look forward to discussing how I can contribute to your team's success.

Key Skills

Tableau

MySQL

Python

Powerpoint

Mathematics

Statistics

Data Visualization

Data Mining

Data Modelling

Data Sceince

My Projects

Business Insights 360

Domain/Function: Sales and Marketing

Zomato Analysis

Domain/Function: Food and Restaurant

Mitron Bank Analysis

Domain/Function: Banking Sector

Excel - Sales Analytics

Domain/Function: Sales and Marketing

Festive Sales Insights

Domain/Function: Sales and Marketing

Business Insights with MySQL: Atliq Hardware Dataset

Domain/Function: Education

My Experience

Ai Variant – Data Analyst

Jan 2024 - Mar 2024

Developed interactive dashboards using MS Excel, Power BI, and Tableau to visualize key performance metrics.
Executed SQL queries in MySQL for data validation and integrity checks.
Conducted in-depth data analysis to identify trends and insights, supporting strategic decision-making.
Collaborated with cross-functional teams to ensure data accuracy and relevance.

RMB Knovatech PVT LTD – Senior Design Engineer

Jan 2022 - Dec 2023

Utilized 3D software tools such as SolidWorks and AutoCAD for design and modeling.
Conducted inspections and site visits to ensure project compliance and quality standards.
Collaborated with engineering teams to develop and refine design specifications.
Provided technical support and troubleshooting during the implementation phase.

Awards & Certificate

Data Analyst

Data Analyst Intern at AI Variant

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/sanket-kanse-3306192b3/

Call Me

+91 8369619710

GitHub

https://github.com/Sanket-K4nse

PowerBI Project

Business Insights 360

Domain/Function: Sales and Marketing

Business Insights 360 Project In this project, I analyzed AtliQ Hardware's sales data using Power BI, uncovering key business insights. I focused on sales trends, customer demographics, and product performance to drive strategic decisions and improve overall business efficiency.

View Project
Engagement

View Project
on GitHUB

The purpose of a finance report is to provide a comprehensive and accurate representation of an organization's financial performance.

The purpose of sales report is to empower businesses to monitor and evaluate their sales activities and performance.

Project Details

In the Business Insights 360 project for AtliQ Hardware, I leveraged Power BI to analyze and visualize key business metrics across multiple views:

Finance View: Examined revenue streams, cost structures, and profit margins to identify areas for financial optimization and ensure fiscal health.
Sales View: Analyzed sales performance by region, product, and time period, highlighting trends and uncovering opportunities for growth.
Executive View: Provided a comprehensive dashboard for executives, summarizing critical KPIs and enabling data-driven strategic decision-making.
Marketing View: Assessed the effectiveness of marketing campaigns and customer engagement strategies, providing insights into ROI and customer acquisition.
Supply Chain View: Evaluated supply chain efficiency, tracking inventory levels, order fulfillment rates, and supplier performance to streamline operations and reduce costs.

Live Interactive Dashboard

PowerBI Project

Zomato Analysis

Domain/Function: Food and Restaurant

In this Zomato analysis project, I used Power BI to evaluate restaurant performance, average ratings, and average cost for two patterns. The insights help Zomato optimize its restaurant listings, enhance user experience, and tailor marketing strategies for better engagement and growth.

View Project
Engagement

View Project
on GitHUB

Report View

Country Overview

Project Details

### Zomato Analysis Project

In the Zomato analysis project, I utilized Power BI to create comprehensive insights into restaurant performance.

- **Report View**: Provides an interactive dashboard showcasing key metrics and trends.
- **Country Overview**: Highlights restaurant distribution, user demographics, and regional trends across various countries.
- **Analytical View**: Offers in-depth analysis of restaurant ratings, popular cuisines, and average cost for two, helping Zomato understand customer preferences and pricing strategies.
- **Executive View**: Summarizes key insights for executives, including top-performing restaurants, areas for improvement, and strategic recommendations for enhancing customer satisfaction and engagement.

This project enables data-driven decisions to optimize Zomato’s offerings and improve overall user experience.

Live Interactive Dashboard

PowerBI Project

Mitron Bank Analysis

Domain/Function: Banking Sector

In the Mitron Bank analysis project, I used Power BI to analyze a sample dataset of 4,000 customers. The project focused on customer analysis, income analysis, spending behavior, and utilization. These insights will help Mitron Bank tailor their new line of credit cards to meet customer needs.

View Project
Engagement

View Project
on GitHUB

Demographic Analysis

Income-Spending Analysis

Project Details

For the Mitron Bank analysis project, I utilized Power BI and Excel to analyze a sample dataset of 4,000 customers across five cities. The project involved several key aspects:

Customer Analysis: Understanding demographics, spending patterns, and preferences to tailor credit card offerings.
Income Analysis: Analyzing income levels to assess creditworthiness and potential market segments.
Spending Behavior: Identifying trends in online spending to inform product features and rewards programs.
Utilization Analysis: Evaluating how customers use existing credit lines to optimize the new credit card features.
This comprehensive analysis provided actionable insights to help Mitron Bank make informed decisions about their new credit card line, ensuring it meets customer needs and market demands effectively.

Live Interactive Dashboard

Excel Project

Excel - Sales Analytics

Domain/Function: Sales and Marketing

Generated actionable insights via robust sales and financial analytics within the FMCG sector. Enabled businesses with data-driven strategies, showcasing proficiency in ETL, Power Query, Power Pivot, DAX, and user-centric report design for optimal decision-making, growth, and expansion.

View Project
on GitHUB

Net Sales Comparison

P & L Month

Project Details

Steps in Making this Report-

1. ETL (Extract Transform Load) Process
Loaded and processed CSV files in Power Query, ensuring data integrity, uniqueness, and correcting errors before integrating into Power Pivot.

2. Data Modeling
Implemented a star schema, created dim_date table with a fiscal year perspective, ensuring seamless integration with other tables.

3. Pivot Table and Power Pivot Integration
Integrated the data model with a Pivot Table for quick analysis, utilizing Power Pivot for efficient data transformation and connectivity.

4. DAX (Data Analysis Expressions) Formulas
Developed 10+ new measures and columns using DAX, including Net Sales, Gross Margin, GM%, COGS, and applied a fiscal year perspective for deeper insights.

5. Conditional Formatting
Applied Conditional Formatting to enhance data presentation, highlighting key information, identifying trends, and improving overall data readability for effective analysis.

PowerBI Project

Festive Sales Insights

Domain/Function: Sales and Marketing

Atliq Mart, a retail giant with over 50 supermarkets, recently ran massive promotions during Diwali 2023 and Sankranti 2024 on their Atiq branded products. As the sales director wanted immediate insights into the success of these promotions.

View Project
on GitHUB

promotion type analysis

product and category analysis

Project Details

As part of the Codebasics Resume Project Challenge, my main task was to study how promotions affected Atliq Mart. This analysis aims to assist the sales director in determining the success of different promotions. By identifying which promotions were effective and which ones weren't, the sales director can make better decisions for future promotional campaigns.

Live Interactive Dashboard

SQL Project

Business Insights with MySQL: Atliq Hardware Dataset

Domain/Function: Education

In this project, I was given a challenging task to solve various MySQL-related requirements presented in a questionnaire format. This project aimed to test and enhance my database management skills.

View Project
on GitHUB

Perform Inner Join

Perform Joins

Project Details

Project Overview
Task Description:
In this project, I've utilized MySQL to explore and analyze the Atliq Hardware dataset, focusing on deriving actionable business insights. The goal is to assist decision-makers by creating various reports that highlight key performance indicators, sales trends, customer behaviors, and inventory management. By leveraging SQL's querying and data manipulation capabilities, this project delivers a set of data-driven reports that can inform strategic decisions and optimize business operations. Also created Views, Stored Procedures, Functions, Tables and Run queries using CTE all the works shown below in the screenshot.