Charles | Data Analyst

Data never lies - I just help it speak 📈

@uadekola001 Nice but work on colors

@CasmirCodesData Still a student sha

Let’s see some of your Excel dashboard designs

@real_mno Sure… took me three days

@CasmirCodesData This is solid work 👏🏾👍🏾 May I ask how long it took you to finish this project Also I'd like to be mutuals

Numbers lied 42M in Revenue ❌ 29M in Revenue ✅ A clothing business recorded two years of sales data across 2023 and 2024. On the surface, the numbers looked promising 500 orders placed, products moving, customers buying. So when management sat down to review performance, they expected the revenue figure to reflect that activity. They expected a number that matched the energy of 500 orders. What they got instead was confusion. The revenue was lower than anticipated, and nobody could explain why. They had sold more or at least it felt that way but the money did not add up. The business was making decisions based on total order volume without understanding that a significant portion of those orders never actually converted into real income. Returned goods were quietly eroding revenue. Cancelled orders were inflating their order count without contributing a single naira. Pending transactions were sitting unresolved, neither confirmed nor lost. And nobody was separating these outcomes from the genuine completed sales. The numbers were not wrong. They were just being read without context. That is where the data analyst came in not just to organise the data, but to translate it. To answer the question the business had been asking without realising it: we sold a lot, so where is the money? Here’s what the data actually showed: → Real revenue: ₦29.4M from completed orders only → Denim Jacket was the #1 product in both sales and revenue → Outerwear alone generated ₦12.1M → Abuja was the strongest city at ₦7.3M → 40% of sales came from online → 90% of 341 customers never came back → 2024 made more money without selling more that’s the smart pricing strategy. Here’s what I told them to fix: 1. Find out WHY customers are returning goods ₦3.4M is recoverable 2. Follow up on 54 pending orders before they become cancellations 3. Build a retention system losing 90% of customers after one purchase is a leaking bucket 4. Push harder online lowest cost, highest return channel 5. Never let the Denim Jacket go out of stock The numbers were never the problem. Reading them without context was. What other insight or recommendations can you make out of this?

@__chisomm__ Thank you 🙏

@CasmirCodesData Too good 😍

@SiloLens Thank you 🙌🙌

@CasmirCodesData Nice job you've put out there brother

@AdegokeTaoheed Thank you

@CasmirCodesData Well-done

Added another dashboard 📌 Check out the post - x.com/casmircodesdat…

@vheeorji22 Thank you

@CasmirCodesData this is nice 😊

@DorcasAkins0 Nice work 👏

Y’all liked the previous one, so I had to bring in other ones 😁

@iam_daniiell Sure 🫡🫡

@CasmirCodesData Let’s leave this ones for the lil mans

@SiloLens That’s were the customer satisfactory rate comes in… this is a highlight to my analysis didn’t put all out here …..

@CasmirCodesData They should also try to understand why the 90% of the customers are not returning after their first purchase. Could it be because of product or poor customer service? The pending orders, could it be because of the payment system?

@OmobolajiI7450 Ok thanks

@CasmirCodesData The brand should focus and made the top 3 color preferences available always

@peller02 Thank you man

@CasmirCodesData Nice work Brother 🤞🔥

@Dare_0x Boss 🙌🙌

@CasmirCodesData Charles da 🐐

@__chisomm__ Thank my oga 🙌🙌

@CasmirCodesData Chef chef! This is so good. You can get answers from just looking at the dashboard

You will jam something on your journey in Data… and its name is imposter syndrome. That moment when you start thinking: “Am I actually good?” “Do I really know this thing?” Meanwhile, you’ve been doing the work. That feeling has made many people stop just before their breakthrough. That’s the painful part. Truth is… growth will always make you feel like a beginner again. That’s the price of leveling up. I’ve seen strong people almost quit because of it. The real move? Keep shipping. Keep learning. Keep showing up. Confidence doesn’t come first… it comes after proof. Have you felt it before? How did you handle yours?

@NwaliAdaobi Anticipating

A data analyst on LinkedIn posted an analysis on breast cancer patients, I picked interest in the dataset as a medical graduate and also about to niche down to health care analyst. Working on this dataset has taught me things I didn't know earlier. Stay tuned for the final result

@Stephobimdike Congratulations 🍾

So, I got an internship offer today😭🙏

@vheeorji22 Windows key + shift key + S

How to screenshot on a laptop???😭 This is really frustrating 😭

Check quote

Wrapped up, will be sharing in few minutes.