Abhinav Ghosh

Data Analyst

[email protected]

Hello, I am

Abhinav Ghosh.

2

Excel
Projects

1

PowerBI
Project

1

SQL
Project

1

Python
Project

About Me

My journey began with a B. Tech in Mechanical Engineering, building and tinkering with machines. But my curiosity soon shifted gears, leading me to explore the fascinating world of data. Here, I discovered a hidden passion for uncovering stories whispered by numbers.
Now, as an aspiring data enthusiast, I'm eager to unlock the valuable insights buried within datasets. I possess a keen eye for data analysis and love crafting clear, compelling visualizations using tools like Excel, Power BI, SQL, and Python.
Although I haven't landed my first official role yet, I've honed my skills through several real-world business projects (check them out in my portfolio!). I'm a continuous learner, constantly refining my analytical mind and problem-solving abilities.
Let's turn the tide on data! I'm excited to bring my skills and enthusiasm to a team and collaborate on transforming information into actionable insights.

Key Skills

Data Visualization

Statistical Analysis

Data Cleaning & Preparation

Advanced Formulas & Functions

Pivot Tables & Pivot Charts

Power Query & Automation

Data Modeling

Data Transformation with Power Query

DAX for Advanced Calculations

Interactive Visualizations & Dashboards

Power BI Service & Sharing Reports

Advanced Querying

Aggregation & Grouping

Data Filtering & Sorting

Database Design & Normalization

Performance Optimization

Data Manipulation

My Projects

Unlocking Sales Potential: AtliQ Hardware's Data-Driven Path to Profitability.

Domain/Function: Consumer Electronics and Hardware Industry/Sales Analytics.

Unlocking Finance Potential: AtliQ Hardware's Data-Driven Path to Profitability.

Domain/Function: Consumer Electronics and Hardware Industry/Financial Analytics.

AtliQ Hardware: Empowering Business Decisions with 360° Analytics.

Domain/Function: Hardware Industry/Business Intelligence and Data Analytics.

The AtliQ Data Story: Unlocking Strategic Insights with MySQL Analytics.

Domain/Function: SQL Database Optimization/Financial & Supply Chain Analytics.

Python-Powered Revival: Driving Revenue Growth at AtliQ Grands through Data-Driven Strategy.

Domain/Function: Hospitality Industry/Revenue Management and Strategic Decision-Making

My Experience

Data Analyst Intern – AtliQ Technologies

Shield Insurance: Customer & Revenue Analysis [ Power BI | Excel | Canva ] Dec 2024 – Jan 2025

[GitHub Repo | Live Dashboard | Audio Presentation]

● Designed and implemented a Power BI dashboard analyzing customer growth, revenue trends, and sales channel performance, revealing a 20% drop in offline sales and identifying high-value customer segments.

● Provided actionable insights, forecasting a 15% revenue increase forecast and refining sales channel strategies for sustained growth, enabling more targeted marketing efforts and ensuring long-term profitability.

Telecom Analysis: Comparison Report [ Power BI | Excel | Canva] Nov 2024 – Dec 2024

[GitHub Repo | Live Dashboard | Video Presentation]

● Engineered a dynamic Power BI dashboard to assess the impact of 5G on KPIs (revenue, ARPU, active users, and competitive position), finding key performance obstacles.

● Delivered actionable insights, enabling Wavecon to regain 30% market share in 3 months by refining its 5G rollout strategy and addressing key performance bottlenecks.

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

Python: Beginner to Advanced For Data Professionals

Data Analytics Bootcamp 4.0: With Practical Job Placement Support + AI for Data Analysts

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/abhinavgh/

GitHub

https://github.com/SnorlaX0209

Excel Project

Unlocking Sales Potential: AtliQ Hardware's Data-Driven Path to Profitability.

Domain/Function: Consumer Electronics and Hardware Industry/Sales Analytics.

Crafted two impactful reports that equip the sales team with actionable insights to evaluate customer performance and assess market performance against targets.

View Project
Engagement

View Project
on GitHUB

Enhanced Customer Performance Report showcasing annual net sales performance for each customer, facilitating strategic insights and informed decision.

Dynamic Market Performance Report comparing yearly performance against targets, aiding stakeholders in strategic assessment and decision-making.

Project Details

In this project, I created a comprehensive sales report using Excel pivot tables, enabling businesses to determine effective customer discounts, facilitate consumer negotiations, and identify potential expansion opportunities in promising markets. These reports provide actionable insights and recommendations to optimize sales strategies, enhance customer satisfaction, and maximize revenue generation.

Key Learnings:

Pivot Tables
Power Query
DAX (Basics)
Conditional Formatting
Report Beautification
Sales Domain Metrics

Objectives:

Optimize Discounts
Facilitate Negotiations
Identify Market Expansion

Impact:

Enhanced Sales Strategies
Improved Customer Satisfaction
Increased Revenue

Overall, this project empowers businesses with crucial tools and insights to monitor, evaluate, and enhance sales activities. Leveraging sales data analysis unlocks new opportunities, drives growth, and ensures competitiveness in the dynamic market landscape.

Excel Project

Unlocking Finance Potential: AtliQ Hardware's Data-Driven Path to Profitability.

Domain/Function: Consumer Electronics and Hardware Industry/Financial Analytics.

Created 3 reports for the finance team which will help them to evaluate profitability by market, profitability by fiscal year & profitability by month etc.

View Project
Engagement

View Project
on GitHUB

Market Profitability Analysis This report dissects market-by-market profitability, illuminating revenue drivers, expense breakdowns, and their impact.

Unveiling Seasonal Trends This report dissects monthly P&L to reveal seasonal trends in revenue and expenses, aiding cash flow optimization.

Project Details

This project focused on creating a robust financial analytics report using Excel's powerful tools. It equips businesses to gain deeper insights into their financial health, identify areas for improvement, and make strategic decisions to achieve financial goals.

Key Learnings:

Pivot Tables
Power Query
DAX (Basics)
Conditional Formatting
Report Beautification
Finance Domain Metrics

Objectives:

Optimize Profitability
Enhance Financial Forecasting
Enhance Financial Forecasting

Impact:

Improved Financial Performance
Enhanced Risk Management
Increased Operational Efficiency

Overall, this project empowers businesses with the knowledge and tools to transform raw financial data into actionable intelligence. This enables better decision-making, drives financial performance, and ensures long-term sustainability in today's competitive landscape.

PowerBI Project

AtliQ Hardware: Empowering Business Decisions with 360° Analytics.

Domain/Function: Hardware Industry/Business Intelligence and Data Analytics.

AtliQ Hardwares, a rapidly expanding consumer electronics company, is striving to enhance its competitive edge. Currently reliant on Excel for reporting, the company aims to implement an advanced analytics solution with Power BI to gain valuable insights and drive informed decision-making.

View Project
Engagement

View Project
on GitHUB

User-Centric Landing Page as an integral part of dashboard design.

Data Modeling with Over 10 Tables.

Project Details

In this project, the objective is to develop a unified report accessible to stakeholders across sales, marketing, finance, and the executive team. The focus will be on:

1. Robust Data Modeling.
2. User-Centric Report Design.
3. Interactive Drill-Down Insights.

In this project, I gained expertise in:

1. Power Query (both basic and advanced operations).
2. Basic and Complex DAX Formulas.
3. Data Modeling with over 10 tables.
4. Selecting Effective Visuals and Formatting.
5. Dashboard Design Principles.
6. Utilizing Bookmarks.
7. Deploying Reports in Power BI Service.
8. Incorporating Stakeholder Feedback.
9. Metrics for Sales, Marketing, Finance, and Supply Chain.

Live Interactive Dashboard

SQL Project

The AtliQ Data Story: Unlocking Strategic Insights with MySQL Analytics.

Domain/Function: SQL Database Optimization/Financial & Supply Chain Analytics.

Implemented a MySQL solution to overcome Excel limitations, boosting strategic decision-making and operational efficiency. Key insights include top customer analysis, regional market dominance, and APAC market trends, all achieved through advanced SQL techniques and robust data integrity.

View Project
Engagement

View Project
on GitHUB

A database schema for “Database gdb0041” with connections to multiple datasets like dim_customer, dim_product, and various fact tables.

This SQL query forecasts supply chain quantities with detailed error metrics by customer and market for FY 2021.

Project Details

This project tackled Excel file size limitations, enabling AtliQ Hardware to streamline operations and enhance strategic decision-making via a MySQL-based analytics solution. Key steps included database optimization—transitioning from Excel to MySQL for higher analytical capacity, and designing data structures with user-defined functions, views, and stored procedures for effective data handling. Advanced SQL techniques, such as window functions, temporary tables, and indexing, ensured efficient data management. Data integrity was maintained through entity-relationship (ER) diagramming, aligning financial and operational insights.

Python Project

Python-Powered Revival: Driving Revenue Growth at AtliQ Grands through Data-Driven Strategy.

Domain/Function: Hospitality Industry/Revenue Management and Strategic Decision-Making

AtliQ Grands, a leader in luxury accommodations, partnered with data experts to enhance strategic decision-making. By leveraging historical data, predictive models, and real-time analytics, they optimized pricing, improved resource management, and accelerated revenue growth.

View Project
Engagement

View Project
on GitHUB

A mind map diagram showing AtliQ Grands business model, dividing properties into two categories: Luxury (AtliQ Exotica, Blu, Bay) and Business (AtliQ

A Jupyter notebook showing AtliQ Hotels data analysis, displaying pandas code to import and explore booking data with room categories RT1-RT4.

Project Details

AtliQ Grands, a leader in luxury and business accommodations, sought to strengthen its market position amid increasing competition by leveraging data-driven strategies. The project involved collaborating with data analytics experts to gain specialized insights and advanced tools. By analyzing historical data, the team identified trends in customer behavior and revenue, which were then used to develop predictive models for dynamic pricing and resource management. Real-time analytics dashboards were provided to empower teams with the ability to make data-driven decisions. The continuous monitoring of key metrics enabled ongoing strategy refinement, ensuring sustained growth and improved performance. This data-powered approach accelerated revenue growth, enhanced guest experiences, and solidified AtliQ Grands' leadership in the competitive hospitality market. Ultimately, the project laid the foundation for long-term success and sustainable growth.