u/AbdulWajid007

Project Overview:

The goal of this project was to analyze retail data to uncover actionable insights for business growth. By examining transaction history, I identified which regions and product categories were the most and least profitable.

Data Source: upGrad

Dataset: Superstore Sales Data.

File Format: .xlsx.

Key Analytics & Features:

Data Cleaning: Organized raw retail data for accurate reporting.

Pivot Tables: Created summaries to compare sales performance across different Indian regions.

Data Visualization: Developed an Excel dashboard to track monthly sales growth and profit margins.

Tools Used:

Microsoft Excel: Data manipulation, Pivot Tables, and Visualization.

Git & GitHub: Version control and portfolio hosting.

Key Insights & Business Impact:

The analysis revealed critical drivers of both profitability and loss across 8 major regions.

1. The Growth Driver: Telephones and Communication

Performance: Telephones and Communication products are the primary profit engine for the business.

Consistency: This category consistently appears in the Top 3 most profitable sub-categories across 7 out of 8 regions.

2. The Profit Leak: Tables and Bookcases

Systemic Loss: The "Tables" and "Bookcases" sub-categories represent a consistent financial drain.

Regional High: The issue is most severe in Ontario, where a single category loss exceeds $42,000.

3. Proposed Strategy:

Optimization: By optimizing the logistics or pricing strategies for these two underperforming categories (Tables and Bookcases), the company could potentially recover over $200,000 in lost annual profit.

​I wanted to share a quick visualization I put together for a Q1 2026 financial report.

​The Story:

February was looking rough—revenue dropped by nearly 64% from January, and since expenses didn't scale down fast enough, we hit a net loss.

​The Fix:

In March, the strategy shifted. Revenue bounced back to ₹ 14,200 (a 215% increase over Feb), but the real "win" was the expense management. By cutting marketing and overhead down to ₹ 1,500, the Net Profit skyrocketed to ₹ 12,700.

​Tooling: Done entirely in Excel. I used a dual-chart approach to show the "Bottom Line" (Net Profit) alongside the "Drivers" (Revenue & Expenses) for better context.

​Feedback on the chart layout is welcome!

Ps- Here's my LinkedIn if anyone of you wants to connect: https://www.linkedin.com/posts/abdul-siddique-6753552ab\_dataanalytics-financialanalysis-excel-share-7457420231813017600-YG9N?utm\_source=share&utm\_medium=member\_android&rcm=ACoAAEqfznkBG4kNBONZug4YFttJc20njTkWUSg

​I wanted to share a quick visualization I put together for a Q1 2026 financial report.

​The Story:

February was looking rough—revenue dropped by nearly 64% from January, and since expenses didn't scale down fast enough, we hit a net loss.

​The Fix:

In March, the strategy shifted. Revenue bounced back to ₹ 14,200 (a 215% increase over Feb), but the real "win" was the expense management. By cutting marketing and overhead down to ₹ 1,500, the Net Profit skyrocketed to ₹ 12,700.

​Tooling: Done entirely in Excel. I used a dual-chart approach to show the "Bottom Line" (Net Profit) alongside the "Drivers" (Revenue & Expenses) for better context.

​Feedback on the chart layout is welcome!

PS- Since i could not post an image of my dashboard therefore, sharing a link to my LinkedIn post of the same.

Data vs. Opinion: Why Your UFC G.O.A.T. List is Factually Incorrect

​The "G.O.A.T." debate in MMA is usually a shouting match of subjective feelings. We talk about "aura," "legacy," and "I remember when..." But as a Data Analyst, I wanted to see what happens when you strip away the hype and let the numbers speak.

​I built a UFC Dominance Metric to find the objective greatest of all time.

​The Methodology (The "Science" of the GOAT)

​To qualify for this analysis, a fighter had to meet a strict "Prime Elite" threshold:

​Between 15 and 30 total fights (The sweet spot for peak performance).

​Fewer than 3 professional losses (The "Invincibility" filter).

​The Formula: I created a weighted scoring system:

​+5 Points per Win / -5 Points per Loss.

​+1 Point for every positive stat (Strikes landed, Takedowns, Accuracy %).

​-1 Point penalty for every Significant Strike Absorbed per Minute.

​Here are the Top 3 fighters in history who maximized efficiency while minimizing damage.

​#1. Georges St-Pierre (The Statistical King)

​Score: 410

​While many debate his "finishing" ability, the data reveals a different story: GSP is the most efficient human being to ever step into the Octagon.

​Damage Control: He averages only 1.4 strikes absorbed per minute. In a sport of car crashes, GSP was never there to be hit.

​Balanced Dominance: His Significant Strike Defense (72%) and Takedown Accuracy create a mathematical wall that no opponent could climb.

​The Logic: GSP doesn't just win; he dictates every single decimal point of the fight.

​#2. Khabib Nurmagomedov (The Perfectionist)

​Score: 398

​Khabib is the only fighter in the elite tier to completely break the "Losses" variable.

​Zero Penalties: By maintaining a 0-loss record, Khabib never suffered the -5 point deduction that drags down almost every other legend.

​Offensive Pressure: His Strikes Landed per Minute (4.1) is significantly higher than most wrestlers, proving that his "Smaul" style was backed by high-volume activity.

​The Logic: You can’t argue with a zero. Mathematically, Khabib represents the "Floor"—he simply never failed.

​#3. Islam Makhachev (The Modern Blueprint)

​Score: 396

​Islam is effectively the "2.0" version of the dominance metric. He is currently neck-and-neck with the legends.

​Defensive Prowess: Much like GSP, Islam absorbs very little damage (1.27 strikes per minute).

​Versatility: His Significant Striking Accuracy (60%) combined with his elite wrestling stats gives him one of the most well-rounded "stat sheets" in the database.

​The Logic: Islam is proof that the "New Guard" is statistically catching up to the pioneers.

​The Conclusion

​Sorry to the "MMA Experts," but the data is clear. Being the G.O.A.T. isn't just about how many people you knocked out; it’s about how much of the "math" you controlled during your time in the cage.

​When you weight for efficiency, striking defense, and the "Invincibility Filter," these three stand alone.

​Stats don't have a favorite fighter. They just have the truth.

​#DataAnalytics #UFC #MMA #Excel #DataScience #SportsAnalytics #GOAT

https://www.linkedin.com/in/abdul-siddique-6753552ab?utm\_source=share\_via&utm\_content=profile&utm\_medium=member\_android