Portfolio - Palatheerdham Aswin kumar

PowerBI Project

Business 360 - Brick & mortar and e-commerce

Created a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and an SQL database).

Get a P & L statement for any customer/product/country or aggregation of the above over any time period and More.

Analyze the performance of your customer(s) over key metrics like Net Sales and gross Margin and view the same in the profitability /Growth matrix.

Project Details

•Established data integration process, combining Excel/CSV and SQL sales data. Reduced manual data entry by 40%.
• Engineered data model and visualizations in Power BI. Optimized report with DAX studio to enhance performance by 5%.
• Visualized a multi-functional dashboard to analyze departmental sales trends. Led to a projected 10% revenue increase and 20% data-related expense reduction.

Live Interactive Dashboard

SQL Project

Executive Management - Consumer Goods

Successfully tackled a SQL challenge for a hypothetical role at Atliq Hardwares, a leading computer hardware company in India. This involved analyzing a PDF containing 10 ad hoc data requests, executing SQL queries to extract insights,

Answered the ad-hoc request on the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region in SQL and PowerBI

Answered the ad-hoc request on the percentage of unique product increase in 2021 vs. 2020?. in SQL and PowerBI

Project Details

• Conveyed critical insights on 10 ad-hoc business requests to the executive management team by precisely querying the million-row database using SQL.
• Insightful presentation has the potential to reduce overall operational costs by approximately 10%.

PowerBI Project

Supply Chain Data Analysis For AtliQ-Mart

Devised a comprehensive dashboard for AtliQ Mart to enhance service levels by tracking 'On-time', 'In-full', and 'OTIF' delivery metrics daily. Addressed key customer retention issues by offering actionable insights beyond initial stakeholder requirements.

dashboard with "Product Insights" and "Customer Insights," detailing order quantities, fill rates, and delivery delays for dairy products and customer

Bar graph tracking OTIF and key metrics performance over three quarters with a key for metrics below.

Project Details

• Strategically analyzed supply chain data, identifying key performance metrics for daily tracking of 'Ontime delivery (OT) %', 'In-full delivery (IF) %', and 'On-Time in Full (OTIF) %' for customer orders.
• Instituted performance metrics to benchmark target service levels set for customers, culminating10% uptick in customer satisfaction rates and retention.

Live Interactive Dashboard

PowerBI Project

Northwind Traders e-commerce business

BI Dashboard Development for Northwind Traders, showcasing sales trends, product performance, customer insights, and shipping costs to enhance strategic decision-making.

Analyze the performance of customer(s) over key metrics like Net Sales, Gross Margin

Analyze the performance of Shipping Companies and average days to Deliver

Project Details

• Engineered efficient sales trend dashboard using Power BI integrating data from two sources to monitor sales targets, hence halving reporting time and enhancing accuracy by 40%.
• Newly created dashboard projected to facilitate revenue growth by at least 10% in next quarter

Hello, I am

Palatheerdham Aswin kumar

3

1

About

Key

My

Business 360 - Brick & mortar and e-commerce

Executive Management - Consumer Goods

Supply Chain Data Analysis For AtliQ-Mart

Northwind Traders e-commerce business

Contact Me

Email

Github

Linkedin

Call

Palatheerdham Aswin kumar

Download Resume