
Detail-oriented Data Analyst with expertise in Microsoft Excel, Power BI, and data visualization. Proven experience in developing interactive dashboards and analyzing sales and delivery data to uncover actionable insights. Strong foundation in SQL and business analytics, driven by a passion for transforming raw data into strategic decisions that enhance business performance. Committed to leveraging analytical skills to support data-driven decision-making and foster organizational growth.
Collect, clean, and analyze data from multiple sources
Create dashboards using tools like Microsoft Excel, Power BI, or Tableau
Perform data analysis using SQL queries
Identify trends, patterns, and business insights
Generate reports for decision-making
Advance Excel
Power Bi Dashboard & Service
Sql
Python
Power App and Power Automate Develpoer
1.Sales & Delivery Dashboard / https://github.com/logesh030502-del/Excel-Sales-Delivery-Analysis
Tools Used: Excel
Tools & Technologies:
Microsoft Excel (Pivot Tables, Charts, Formulas, Data Validation)
Key Metrics (KPIs):
Total Orders
Total Sales Amount
Delivery Status (On-Time / Delayed)
Average Delivery Time
Customer Ratings (%)
Order Completion Rate
Project Link: https://github.com/logesh030502-del/Excel-Sales-Delivery-Analysis
2.Investment Portfolio Analysis & Dashboard (Power BI)
TOOL USED : POWER BI
Overview:
Developed an interactive Power BI dashboard to analyze and monitor a diversified investment portfolio including Gold, Provident Fund (PF), Mutual Funds, Government Bonds, and Fixed Deposits. The project focuses on evaluating portfolio performance, asset allocation, and risk-return metrics to support informed financial decision-making.
Tools & Technologies:
Power BI ,DAX, Microsoft Excel
Key Metrics (KPIs):
Total Portfolio Value
Return on Investment (ROI)
Portfolio Growth Rate
Asset Allocation (%)
Individual Asset Performance
Risk vs Return Analysis
Project Link: https://github.com/logesh030502-del/Investment-Portfolio-Analysis-Dashboard
INTERNSHIP COMPLETION OF 6 MONTHS
INTERNSHIP COMPLETION OF 6 MONTHS