The Analyst

347 posts

The Analyst banner
The Analyst

The Analyst

@dev_awizee

Data Analyst helping beginners master Excel, SQL & Python 💡 | Daily tips & roadmaps | DM for resources | Abuja | Lafia

Blue Earth, MN Katılım Şubat 2024
189 Takip Edilen34 Takipçiler
omotola
omotola@omotola295170·
Congratulations to me 2k followers
omotola tweet media
English
115
14
245
3K
Fondre
Fondre@UTDFondre·
Honest thoughts on Zirkzee. Sell, Keep or Loan?
Fondre tweet media
English
738
37
825
42K
tomi
tomi@oluwa_tomiii·
I’m a Man U fan. You?
tomi tweet media
English
59
28
158
2.5K
The Analyst
The Analyst@dev_awizee·
Sunday reminder to every beginner in Nigeria: You don’t need perfect NEPA light or MacBook to start Phone + free Google Sheets + consistent 1hr daily = better than 90% sitting down Your data journey starts with decision, not equipment Keep pushing #DataAnalysis #CareerAdvice
English
0
0
1
6
The Analyst
The Analyst@dev_awizee·
SQL Tip for beginners: Always use WHERE before GROUP BY. Wrong: SELECT State, COUNT(*) FROM sales GROUP BY State WHERE State = 'Lagos' Correct: SELECT State, COUNT(*) FROM sales WHERE State = 'Lagos' GROUP BY State Reply 'SQL' for free roadmap. #SQLTips #DataAnalysis
The Analyst tweet media
English
0
0
1
3
𝐋𝐔𝐌𝐀™
Submit your @ And follow 5 people who reply before you
English
211
43
128
4.3K
The Analyst retweetledi
Awell ™
Awell ™@awizee_1·
Just say “hello” and gain 150 mutuals here.
Awell ™ tweet media
English
1
1
4
19
𝐋𝐔𝐌𝐀™
Time to connect with verified accounts, share your usernames
English
223
35
147
2.3K
The Analyst
The Analyst@dev_awizee·
Hot take 🔥: Most fresh graduates wasting time learning Python before mastering Excel & SQL Excel still pays bills in 80% of Nigerian companies Master the basics first. Python is the girlfriend, not the wife yet 😂 Change my mind #DataAnalysis #CareerAdvice
English
0
0
1
10
Becky peck
Becky peck@impeculiar1b·
Say hello 👋 and gain 322 organic followers
English
95
25
65
2.6K
The Analyst
The Analyst@dev_awizee·
5. IF + AND (For bonuses, targets & logic) Example: Give ₦50,000 bonus if staff hit target AND worked full month. =IF(AND(Sales>=Target, Attendance="Full"), "Bonus Paid", "No Bonus") You can combine with OR too Very powerful for HR and sales reports
English
0
0
1
5
The Analyst
The Analyst@dev_awizee·
4. PivotTables (Turn chaos into beautiful report in 2 minutes) Steps: Select your data Insert → PivotTable Drag “State” to Rows Drag “Sales” to Values Change to Sum Instant sales by state, branch performance, or top customers. Best skill for any analyst in right now.
English
0
0
1
9
The Analyst
The Analyst@dev_awizee·
Be honest as a beginner: Which tool are you most scared of learning? Vote + reply why I go drop resources #DataAnalysis
English
0
0
1
4
The Analyst
The Analyst@dev_awizee·
3. TEXT Functions (Clean messy bank data) Common problem: Bank statements come dirty LEFT() / RIGHT() → Extract date or last 4 digits TRIM() → Remove extra spaces TEXT() → Format numbers as currency CONCAT() → Join First Name + Last Name Your data will finally look clean
English
0
0
1
17
The Analyst
The Analyst@dev_awizee·
2. SUMIFS (Filter and sum at the same time) Example: Sum all sales made in Lagos in January by Product A Formula: =SUMIFS(SalesColumn, StateColumn, "Lagos", MonthColumn, "January", ProductColumn, "A") Perfect for monthly branch reports Who needs this for work? 🔥
English
0
0
1
9
The Analyst
The Analyst@dev_awizee·
1. XLOOKUP(VLOOKUP’s smarter brother) Old VLOOKUP: =VLOOKUP(A2, Sheet2!A:F, 5, FALSE) New XLOOKUP: =XLOOKUP(A2, Sheet2!A:A, Sheet2!E:E) Works left or right No column number stress Handles errors better Use it to pull staff salary, customer name, or product price
English
0
0
1
11