Portfolio - Vipul kachave

Vipul kachave

Data Aspirant

Resume

1

PowerBI Project

1

SQL Project

1

Excel Project

About Me

Hi, I'm Vipul Kachave, an aspiring Data Analyst with a passion for transforming data into actionable insights. Proficient in Excel, Power BI, SQL, and Python, I leverage my problem-solving and decision-making skills to deliver meaningful results.

Key Contributions:

➞ Developing efficient warehousing strategies through detailed inventory analysis.
➞ Creating Profit & Loss (P&L) statements and Business Case Analyses (BCA) incorporating CAPEX and OPEX costs.
➞ Designing interactive dashboards in Power BI to track and present key business metrics.
➞ Ensuring data accuracy and uncovering insights by cleaning and analyzing datasets.
➞ Utilizing SQL for data extraction, manipulation, and reporting to support decision-making.

🔍 Explore my portfolio to see the projects I’ve worked on and the impact I can create. Let’s work together to drive growth with data-driven solutions!

Key Skills

Microsoft Excel

SQL

PowerBI

Python

Machine Learning

My Projects

Business Insights 360

Domain/Function: Supply chain domain

AtliQ_Supply Chain Analytics

Domain/Function: FMCG

Sales and Finance Analytics

Domain/Function: FMCG

My Experience

SS Supply Chain Solutions Pvt. Ltd., Mumbai November 2024 – Present

 Collaborating with clients to understand their needs and provide tailored data solutions that improve their supply chain operations.

 Analyzing and optimizing inventory levels to reduce costs and improve efficiency. Prepared P&L Reports, BCA reports incorporating both OPEX and CAPEX elements.

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/vipulkachave

Call Me

+91 7558730655

GitHub

https://github.com/vipulkachave

PowerBI Project

Business Insights 360

Domain/Function: Supply chain domain

AtliQ Hardware, a global manufacturer, tasked with extracting insights from their 1.8 million-entry dataset. Crafted reports and dashboards, enabling data driven decision making across diverse business domains such as Sales, Finance, Marketing, Supply Chain and Executive.

View Project
Engagement

View Project
on GitHUB

Designed an intuitive Homepage to enable seamless navigation across multiple Business domains.

Designed data model with 15+ tables using a Snowflake Schema, enhancing relationships for streamlined data management.

Project Details

AtliQ Hardware, a global company, is facing financial losses in its Latin American operations due to difficulties in making accurate, data-driven decisions. To closely monitor business operations, and strengthen its competitive position, AtliQ has implemented Power BI for advanced data analytics and more informed decision-making.

Tools/Methods:
● My SQL
● Power BI Desktop
● Power Query
● Snowflake Schema
● DAX
● DAX Studio
● Power BI Service

In addition to developing technical skills, this project provides a comprehensive understanding of key business concepts across various departments and expertise in stakeholder management. These skills are critical for ensuring smooth and productive processes, leading to effective and impactful outcomes.

Live Interactive Dashboard

SQL Project

AtliQ_Supply Chain Analytics

Domain/Function: FMCG

AtliQ Hardwares, a prominent computer hardware manufacturer, struggled with making data-driven decisions. To address this, a comprehensive report was developed to analyze business queries, leveraging SQL for data analysis and Power BI to deliver clear, actionable insights.

View Project
Engagement

View Project
on GitHUB

Ensures Data Integrity, reduces Query execution time, and enhances database performance using advanced SQL techniques.

Leveraged advanced SQL techniques to extract actionable insights, enabling data-driven decision-making and strategic business improvements.

Project Details

In this Supply chain Performance Enhancement project, I aim to empower decision-makers with actionable insights. Focused on boosting sales, key priorities included:

1. Executing In-Depth Data Queries
2. Informing Decision-Making Strategies
3. Enhancing Overall Sales Performance

Throughout this project, I developed the following skills:

1. Proficiency in SQL data querying, covering diverse business metrics.
2. Mastery of data interpretation and strategic decision support.
3. Selection of effective visualizations for clear data representation.
4. Successful implementation of SQL solutions in a business context.
5. Comprehensive analysis of key sales metrics for informed decision-making.

Excel Project

Sales and Finance Analytics

Domain/Function: FMCG

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
Engagement

View Project
on GitHUB

A customer performance report provides an overview of a customer’s performance including metrics such as net sale over fiscal year.

AtliQ’s Profit and Loss statement report shows the company’s financial performance over a specific period.

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.