PRIME

2.7K posts

PRIME banner
PRIME

PRIME

@Prime_Analysis

Financial Analyst || Operations Analyst

Nigeria Katılım Eylül 2017
1.3K Takip Edilen1.2K Takipçiler
Sabitlenmiş Tweet
PRIME
PRIME@Prime_Analysis·
The best way to end the year 🥹😍 Didn’t deserve it I earned it
PRIME tweet media
English
160
244
5.4K
149.5K
Mukul Dekhane
Mukul Dekhane@dekhane_mukul·
Don't force children to take science if they interested in Arts Issued in public interest!! 😂😄🤣 #Wisdom
Mukul Dekhane tweet media
English
264
1.4K
9.6K
191.5K
Demilade 𝕏 🇦🇸
Demilade 𝕏 🇦🇸@Agunbiadesina1·
I challenged myself to design a modern, clean, and data-driven eCommerce dashboard UI
Demilade 𝕏 🇦🇸 tweet media
English
21
9
68
6.1K
PRIME
PRIME@Prime_Analysis·
Stop scrolling Get to learning
English
1
0
2
75
PRIME retweetledi
Splendor of SQL 🇬🇧💖
Data Analytics mistakes beginners should avoid: 1. Jumping Straight to Visuals - Skipping Data Cleaning (EDA) - Leads to incorrect charts - Clean and explore data first - Understand the "shape" of your data 2. Relying Solely on Excel - Limited with large datasets - Hard to automate complex tasks - Learn SQL for data extraction - Try to use Python/R for advanced analysis 3. Overcomplicating Visualizations - Too many colors and chart types - Confuses the end-user - Keep it simple and clean - Use the right chart for the right data 4. Ignoring the "Why" (Business Context) - Reporting numbers without meaning - Analysis doesn't solve a problem - Understand business goals first - Focus on actionable insights 5. Poor SQL Habits - Using SELECT * on huge tables - Writing unreadable, messy queries - Use aliases and formatting - Filter data early with WHERE 6. Missing Outliers and Distributions - Only looking at the "Average" (Mean) - Outliers can skew your results - Check median and standard deviation - Visualize distributions with histograms 7. No Documentation or Comments - Hard to reproduce your work - You’ll forget your logic in a month - Document your data sources - Comment your code and SQL scripts 8. Correlation vs. Causation - Assuming $A$ caused $B$ just because they moved together - Leads to false business advice - Look for underlying factors - Use A/B testing where possible 9. Not Validating Results - Trusting the output blindly - Logic errors in formulas/queries - Cross-check totals with raw data - Peer-review your findings 10. Poor Communication Skills - Great analysis, but poor presentation - Getting too technical with stakeholders - Tell a story with your data - Focus on the "So What?" for the audience
English
6
52
246
7.9K
PRIME retweetledi
Freedom | Excel Boss
This is where things got exciting. Raw data is useful, but visuals? That's where you see the real story. What I Added: Breakdown Table A dynamic summary table that automatically calculates: Total Income (MTD) Total Expenses (by category: Needs, Wants, Savings) Remaining Budget per category Percentage spent Visual Overview Progress bars using bar charts, they fill up as spending increases For Wants & Need .. Donut chart for Savings (work in progress) 3. Smart Alerts When spending hits 80% of a category budget → cell turns yellow When spending hits 100% →cell turns red with a warning message The Formula Behind It: excel =SUMIFS(Expense_Amount, Expense_Category, "Needs", Expense_Date, ">="&EOMONTH(TODAY(),-1)+1) This sums only this month's "Needs" expenses — clean and dynamic. What's Working Well Speed: Data entry takes seconds now Clarity – I can see at a glance if I'm overspending on Wants (spoiler: I am) Motivation – Watching the Savings bar grow is actually addictive No surprises – The alerts mean I adjust before I break the budget I'm planning to add: Monthly comparison reports (January vs. February) Goal trackers This project started as a simple tracker. But with each test, the mini calendar, the breakdown table, the visuals, it's becoming something I actually want to use. And when you enjoy using your budget tool? You stick with it. And when you stick with it? Your money starts behaving. Always building. Always improving. Tool: @msexcel #Excel #BudgetTracker #PersonalFinance #VBA #DataVisualization #Productivity
Freedom | Excel Boss@ObohX

You know that feeling when you're tracking your money on paper, and by day 3, you've already lost the receipt, forgotten where you put the notebook, and somehow spent $50 on "miscellaneous"? Yeah... me too. So I decided to build something better. I've been trying to follow the 50/30/20 rule with my finances: 50% for Needs (rent, food, bills) 30% for Wants (that third coffee, concert tickets, random Amazon purchases) 20% for Savings (future me will be so proud) But here's the thing, how do you know you're staying within those buckets if you're not tracking everything? You don't. And that's where the chaos begins. What I Built: A Budget Tracker That Actually Works I wanted something simple. No complicated apps. No syncing to my bank account (honestly, that scares me a little). Just a clean Excel sheet where I could: Log income when it comes in Log expenses as they happen Instantly see which category I'm spending in Know when to STOP spending in a category So I opened Excel and started building. The Features 🗓️ Mini Calendar Add-In Because typing dates manually is so 2010. Now I just click, and the date appears. Simple. Satisfying. Two Macro Buttons I hate repetitive work. So I created two buttons: Income Button – Click it, and your income gets logged instantly into the table below. Date, source, amount. Done. Expense Button – Same energy. Add what you spent, pick the category (Need, Want, or Savings), and it drops right into the expense tracker. No more copying and pasting. No more "I'll do it later" (spoiler: later never comes). Smart Category Tracking Every expense gets tagged: Needs – The non-negotiables Wants – The "treat yourself" moments Savings – The future fund Once I have enough data, I'll know exactly where my money is going. And more importantly, when to stop in a category before I blow the budget. I'm not stopping here. Always up to something.Today it's a budget tracker.Tomorrow? Who knows. But if it solves a problem and makes life 1% easier, it's worth building. What are you working on right now? Drop it in the comments, I'd love to see what other builders are creating. 👇 #Excel #Budgeting #PersonalFinance #AlwaysBuilding #MicrosftExcel #VBA

English
2
15
65
3.3K
PRIME retweetledi
Tunde Onakoya
Tunde Onakoya@Tunde_OD·
Senegal is our African champion 🇸🇳
English
160
4.8K
25.6K
187.6K