Portfolio - Gagandeep Singh

Gagandeep Singh

Financial Analyst

Resume

1

Excel Project

2

PowerBI Projects

About Me

Hi, I'm Gagandeep Singh — a Financial Analyst at Verve Advisory, passionate about transforming raw data into actionable insights that empower data-driven decision-making.

I hold a Bachelor of Computer Applications (BCA) degree and have developed strong skills in Excel, SQL, Power BI, and Python. I specialize in analyzing datasets, identifying key patterns, and creating clear visualizations that communicate insights effectively.

I've worked on real-world business and data analytics projects, applying analytical techniques to solve business problems, improve reporting accuracy, and uncover insights that support better decision-making.

I'm committed to continuous learning and applying data analytics to help organizations improve operations, monitor performance, and make smarter business decisions.

Feel free to explore my portfolio to see how I turn data into meaningful insights.

Let's connect and collaborate on data-driven solutions!

Key Skills

Advanced Excel

Power BI

SQL

Python

Data Analysis

Data Reporting

My Projects

AtliQ Hardware Sales & Finance Reports

Domain/Function: FMCG

Business Insights 360

Domain/Function: Brick & Mortar

Shield Insurance Analysis – Data-Driven Insights Using Power BI

Domain/Function: Insurance / Business Analytics

My Experience

Financial Analyst | Verve Advisory Pvt. Ltd.
October 2025 – Present | Remote

Analyze financial and business data to support performance monitoring and data-driven decision-making.
Prepare and validate R100 reports, ensuring accuracy and consistency across reporting periods.
Analyze retention, refund, and revenue metrics to identify discrepancies and maintain reporting accuracy.
Track KPIs across 10+ acquisition channels to support business performance analysis.
Use Google Sheets, Advanced Excel, SQL, and Google BigQuery to support reporting and data analysis workflows.

Awards & Certificate

Excel: Mother of Business Intelligence

SQL Beginner to Advanced For Data Professionals

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

Data Analytics Bootcamp 6.0: Job Placement Support + Your Own AI Analyst Agent

Google Data Analytics Specialization

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

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

GitHub

https://github.com/Gagan-Singh-1510

Excel Project

AtliQ Hardware Sales & Finance Reports

Domain/Function: FMCG

The goal of this project is to analyze AtliQ Hardwares' financial performance (2019-2021). The "Customer Net Sales Performance" and "Market Performance vs Target" reports identify revenue trends, top customers, market gaps, and target achievements to support data-driven decision-making and growth.

View Project
Engagement

View Project
on GitHUB

The Customer Performance Report analyzes sales from 2019 to 2021, highlighting revenue growth, top customers, and areas needing improvement.

The Market Performance vs Target Report analyzes sales from 2019 to 2021, comparing actual sales to targets and identifying gaps and trends.

Project Details

In this project, I've developed a dynamic sales report using Excel, providing businesses with critical insights into sales performance, customer trends, and market gaps. These reports deliver actionable recommendations, helping businesses optimize strategies, enhance customer engagement, and boost profitability.

Throughout this journey, I've honed skills in:

- Pivot tables
- Power Query
- Basic DAX functions
- Effective Conditional Formatting
- Report Presentation
- Sales Domain Metrics

The primary goal is to equip businesses with data-driven tools to monitor, evaluate, and enhance their sales efforts. Leveraging analytical insights, businesses can identify opportunities for growth, respond to market shifts, and maintain a strong competitive advantage.

PowerBI Project

Business Insights 360

Domain/Function: Brick & Mortar

AtliQ Hardwares, a consumer electronics company, is growing fast but struggles to keep up with competitors who use data effectively. Most reports are still in Excel, limiting efficiency. My aim is to implement a smart analytics system using Power BI to drive smarter business decisions.

View Project
Engagement

View Project
on GitHUB

Finance Insights: Unveiling key financial metrics and trends through an interactive analytics dashboard.

Power BI data model with 10+ tables, establishing key relationships for financial and sales analysis.

Project Details

In this project, the goal is to create a single report that can be used by stakeholders from sales, marketing, finance, and the executive team. The focus is on:

1. Robust Data Modeling
2. User-Empathetic Report Design
3. Deep-Dive Insights

I learned the following skills in this project:

- Power Query (Basic and Advanced Operations)
- Basic and Complex DAX Formulas
- Data Modeling with 10+ Tables
- Choosing the Right Visuals and Formatting
- Dashboard Designing Principles
- Using Bookmarks for Better Navigation
- Deploying Reports in Power BI Service
- Implementing Stakeholder Feedback
- Understanding Sales, Marketing, Finance & Supply Chain Metrics

Project video

Live Interactive Dashboard

PowerBI Project

Shield Insurance Analysis – Data-Driven Insights Using Power BI

Domain/Function: Insurance / Business Analytics

eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

View Project
Engagement

View Project
on GitHUB

eeeeeeeeeeeeeeeeeeeeeee

eeeeeeeeeeeeeeeeee

Project Details

eeeeeeeeeeeeeeeeeeeeeeeeeee

Project video

Live Interactive Dashboard

Already have an account? Sign in