Portfolio - Soumik Agasti

Excel Project

Customer Performance Report

Designed sales and finance report that helped the sales team assess customer performance and comprehend their market position in relation to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

🎯Objective: Create a report that indicates Yearly and monthly Net Sales Performance, Market Analysis, Profit, and loss.

🛠️ Approach: Use pivot tables for smart reporting. Power Query for fast data conversion. Power pivot for strong data models.

📚Learnings

✅Business Knowledge
✅ Data Transformation
✅ Data Modeling
✅ DAX Measures
✅ Pivot Table Reports
✅ User Empathetic Report Generation

📊Insights: Empowered stakeholders with data-driven reports showing an overall of more than 300% increased net sales and a 36.45% gross margin.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardware, a fast-growing consumer electronics firm, aims to gain a competitive edge by harnessing data through a Power BI analytics solution, enhancing insights for informed decision-making, currently hindered by reliance on Excel reports.

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to create one report that could be used by stakeholders from the sales, marketing, finance, and executive teams. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

Learnings

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metric

Live Interactive Dashboard

PowerBI Project

HR Analytics Dashboard

Designed an HR analytics dashboard that helped HR with insights on presence %, sick leave%, and wfh% by date. This powerful tool provides real-time insight into the workforce, and helps by making data-driven decisions that benefit both the employees and the organization as a whole.

View Project
Engagement

This is the dashboard that shows various insights like sick leave, presence, and work-from-home percentage.

The table view shows the transformation which I have done as a part of dashboarding.

Project Details

In this project, the goal is to create one report that could be used by stakeholders from the HR teams. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

Learnings
Data Transformation and Modelling
Usage of DAX Formulae
Choosing the right visuals for formatting
Deploying in Power BI service

Live Interactive Dashboard

PowerBI Project

Atliq Hospitality Analysis

The problem statement was AtliQ grands is a chain of Luxury hotels and they are losing market share we need to build a dashboard that will help the stakeholders to find the cause of downfall and to help them take decisions to regain market share.

View Project
Engagement

It's the dashboard which I have created for analysis

This image represents the data view which shows connections with facts and dimension tables

Project Details

🏨 Title: AtliQ Hospitality Revival Analysis 📊🔑

🔍 Project Overview:
AtliQ Grand, a prominent 5-star hotel chain in India, is facing revenue challenges due to ineffective decision-making and fierce competition. They're seeking to leverage "Business and Data Intelligence" for informed decisions.

📋 Objectives:
This data analysis initiative aims to empower AtliQ Grand's Revenue Team with actionable insights from historical data. As a data analyst, my mission is to deliver key findings, establish metrics, construct an insightful dashboard, and provide actionable recommendations to enhance decision-making.

💡 My Achievements:
✅ I've fostered connections between various datasets.
✅ I've grasped essential metrics and terminology in the hospitality domain
✅ I've devised measures and KPIs to monitor revenue across different segments, including room types, booking platforms, and occupancy rates, enabling a detailed analysis of revenue performance.

Project video

Live Interactive Dashboard

SQL Project

Financial flows and Supply Chain Analysis using SQL

Atliq Store used Excel to store their data but due to increasing records it crashed hence they planned to switch to MySQL databases and wanted some insights about financial and supply chain data for increasing the forecast accuracy and analyse the monthly and yearly gross sales for decision making

View Project
Engagement

View Project
on GitHUB

Financial flows and Supply Chain Analysis using SQL

This is a snippet of the supply chain analysis where we used SQL queries to retrieve top and bottom customer according to forecast accuracy

This is a snippet of the financial analysis where we used SQL queries to assign market badges

Project Details

Let's delve into Finance and Supply Chain Analytics within AtliQ Hardwares, a leading provider of computer hardware and peripherals across global markets.In the realm of Finance Analytics, the organization utilizes insightful data analysis to steer strategic decisions, fine-tune pricing strategies, and fuel innovative product development initiatives. This proactive approach is geared towards securing sustainable profitability and asserting market dominance over the long term.
Meanwhile, Supply Chain Analytics empowers the company to bolster forecast accuracy, effectively manage risks, and streamline operational processes. By harnessing the power of data-driven insights, AtliQ Hardwares optimizes its supply chain operations, resulting in tangible benefits such as cost savings, heightened operational efficiency, and a strengthened competitive edge in the marketplace. In essence, the synergy between Finance and Supply Chain Analytics fostered a culture of informed decision-making

Hello, I am

Soumik Agasti

1

3

1

About

Key

My

Customer Performance Report

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

HR Analytics Dashboard

Atliq Hospitality Analysis

Financial flows and Supply Chain Analysis using SQL

Contact Me

Email

Github

Linkedin

Call

Soumik Agasti

Download Resume