Portfolio - Gautam Garg | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Gautam Garg

Data analyst

EMAIL

[email protected]

PHONE

+91 8755886104

About Me

I’m a self-taught data analyst with a strong foundation in SQL, Excel, Power BI, and Python. I specialize in transforming raw data into clear, actionable insights that support smarter business decisions. My work spans across sales, finance, and supply chain domains, with a focus on practical, results-driven analysis.

With an entrepreneurial mindset, I’m building toward offering data analytics, digital marketing, and financial support services to businesses. I value clarity, efficiency, and continuous learning — both in my professional work and personal growth.

I’m currently looking for opportunities to apply my skills in a dynamic, data-driven environment where I can contribute to growth and innovation.

1

Excel Project

1

PowerBI Project

Key Skills

Excel

Communication

Problem solving

My Projects

My Experience

Sofitra private limited

financial analyst (Full-Time) Sep 2024 - Dec 2024

Analyzed financial statements (income statement, balance sheet, cash flow) using Excel to identify key trends in profitability, liquidity, and solvency, reducing financial statement errors by 5%.
Developed and maintained financial models for forecasting revenue, expenses, and cash flow, increasing time efficiency in budget preparation by 9%.
Delivered insights that informed strategic client decisions and Developed operational efficiency by 15%.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

EF SET English Certificate

EF SET English Certificate

Let's Work Together!

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.

EMAIL

[email protected]

Call Me

+91 8755886104

LinkedIn

https://www.linkedin.com/in/gautam-garg-05ab55218/

GitHub

https://github.com/gautamgarg9359?tab=repositories

Excel Project

Sales_Analytics

Domain/Function: ecommerce

Analysis of sales data to identify top products, revenue trends, regional performance, and profit impact. Includes data cleaning, visualization, and insights using Excel, Python, SQL, and Power BI.

View Project
Engagement

View Project
on GitHUB

Sales_Analytics

Market performance vs target (2019–2021) by country in USD, highlighting sales gaps, growth trends, and % variance from targets.

Sales_Analytics

Top 5 and bottom 5 products by quantity sold, highlighting best and worst performers in sales volume.

Project Details

This project focuses on analyzing sales data to uncover valuable business insights. The dataset sales_analysis.csv includes details such as order dates, product categories, regions, sales revenue, discounts, and profit margins. The objective of the analysis is to explore trends in sales performance, identify top-performing products and regions, and understand the impact of pricing and discounts on profitability. Using tools like Python (pandas, matplotlib, seaborn), Excel, SQL, and Power BI, the dataset can be cleaned, transformed, and visualized to answer critical business questions. Key areas of focus include monthly and quarterly sales trends, product-wise and region-wise revenue distribution, customer segment performance, and profitability analysis. This project serves as a foundation for building dashboards, running predictive analysis such as sales forecasting, and creating data-driven strategies to improve business decision-making.

PowerBI Project

Insights 360

Domain/Function: ecommerce

Business Insight 360 is an executive-level Power BI dashboard delivering a 360° view of business performance across finance, sales, marketing, and supply chain. It consolidates P\L, net sales, gross margin, forecast accuracy, and risk metrics to enable fast, data-driven decision-making.

View Project
Engagement

View Project
on GitHUB

Power BI dashboard displaying Net Sales trends, Gross Margin %, and Profit & Loss statement with regional and product-wise breakdown for business insi

Power BI dashboard showing Net Sales, Gross Margin, and GM% by region and customer, with interactive filters and P\&L breakdown for business insights.

Project Details

Business Insight 360 is an executive-level analytics dashboard built in Power BI that provides a holistic view of organizational performance across finance, sales, marketing, and supply chain. The solution integrates multiple business dimensions into one interactive platform, offering executives and decision-makers real-time access to key metrics such as Net Sales, Gross Margin, Profitability, and Growth trends. It allows analysis of product, customer, and regional performance with P\&L statements, YoY comparisons, and profitability matrices. Forecast accuracy and risk profiling further strengthen decision-making by highlighting areas of concern such as excess inventory, out-of-stock risks, and net errors across customers, products, and geographies. The dashboard centralizes insights into an easy-to-navigate format, ensuring leadership teams can track performance, identify opportunities, and address challenges swiftly.

Live Interactive Dashboard