O.T.P

Sales | Dietetics | AI

[Omoalhaja @omoalhajaabiola]

Currently studying and want to work with the UN?

Here are the UN organizations that match your course:

Economics / Finance / Stats: UNECA, UNDP, UNCTAD, World Bank, IMF

Agric / Food Science: FAO, IFAD, WFP

Geography / Environment: UNEP, UN-Habitat, FAO, WMO

Health / Nursing / Medicine: WHO, UNICEF, UNFPA

Education / Arts: UNESCO, UNICEF

Law / Human Rights: OHCHR, UNHCR, ICJ

IT / Computer Science: ITU, UNOPS, UPU

Gender Studies: UN Women, UNFPA

Check their careers sites. Vacancies are posted weekly.

The fastest way to get in is either UN volunteers or internships

[O.T.P @CAPABLE100]

@SirJarus I would be glad to be your personal nutritionist, free of charge!

[Talkative. @Arakunrin_emma]

If you invested $100m into Nigerian Skye Bank stocks in November 2005, it would be less than $1 today.

[Ezekiel @ezekiel_aleke]

Data Entry = Excel

Junior Data Analyst = SQL + Excel

Data Analyst = SQL + Excel + PowerBI

Data Scientist = SQL + Excel + Python + ML

Data Engineering = SQL + Python + AWS + Spark + ETL

The bare minimum✅

[Health & Nutrition Tips @healthnutritipz]

SIGNS YOUR BODY IS TOO ACIDIC:

(Chronic Acidity Can Disrupt Everything)

1. Frequent Fatigue → Cells struggling in acidic conditions

2. Joint Pain → Uric acid buildup or mineral leaching

3. Muscle Cramps → Mineral deficiency from acid overload

4. Frequent Heartburn → Stomach acid imbalance or reflux

5. Brittle Nails → Mineral depletion, especially calcium

6. Cavities or Tooth Sensitivity → Enamel erosion from acidity

7. Bad Breath → Acidic mouth environment or poor gut health

8. Skin Breakouts → Toxins trying to escape through the skin

9. Mood Swings → Brain inflammation or acidic chemistry

10. Trouble Sleeping → Low magnesium or poor pH balance

11. Sugar Cravings → Low blood sugar or blood sugar crash

12. White Tongue → Candida overgrowth from acidic gut

13. Bloating After Meals → Fermentation in acidic digestive tract

14. Hair Loss → Mineral depletion or poor circulation

15. Body Odor → Toxin accumulation from acid waste

16. Weak Immune System → Inflammation from acidic terrain

17. Inflammation Anywhere → Acidity breaking down tissues

18. Slow-Healing Wounds → Low oxygen and impaired repair

19. Dull Skin or Premature Aging → Cellular damage from acid stress

[Fit And Fortune @FitAndFortune]

YOU'RE EATING THESE AT THE WRONG TIME:

1. Rice - Avoid dinner (causes weight gain)
2. Red Meat - Eat lunch, not dinner (heavy digestion)
3. Chocolate - Avoid late night (sugar spikes)
4. Bananas - Don't eat on empty stomach (acidic)
5. Tomatoes - Don't eat before sleep (acid reflux)
6. Watermelon - Not at night (digestion issues)
7. Milk - Best at night, not morning
8. Oranges - Not on empty stomach (acidic)

[Itsede Okhai @Senior_Sley]

You bought the house for ₦500 million. Congratulations! Now meet your new landlord: the estate management company.

And service charge is only one part of the conversation.

Take electricity.

The Band A electricity tariff has been ₦209.50 per kWh. Yet in some estates in Lekki and its environs, residents reportedly pay upwards of ₦350 per kWh for electricity supplied through the estate's power arrangement.

You spend hundreds of millions of naira to buy a house. But you may discover that you cannot simply deal directly with the electricity distribution company like an ordinary homeowner. Electricity is supplied through the estate's infrastructure and management arrangement, and you buy your power from or through the estate management company at a significantly higher effective tariff.

So you own the house, but you don't necessarily have complete freedom over something as basic as how you power it.

Electricity is just one example.

There may be compulsory charges for water, sewage treatment, security, waste disposal, cleaning, landscaping, maintenance of common areas, recreational facilities and general facility management. Some of these services are obviously necessary. My problem is not with paying for services. My problem is being locked into expensive services, with little control over the provider, the price or how the money collected is spent.

Interestingly, some estate residents are beginning to challenge these arrangements.

I was in court recently in a matter involving an estate where the residents' association had terminated the services of the existing estate management company following complaints, including alleged failure to properly account for service charges collected over the years. The residents proceeded to constitute their own management structure.

Before buying the house, investigate who will control the estate after the developer has sold the houses.

This is because the business model in some developments does not necessarily end with selling you the property.

A developer acquires land, develops an estate and sells the individual houses. You receive your deed or other title documentation transferring the relevant interest in the property to you. But alongside the property documentation may be an estate management agreement, deed of covenant or similar arrangement regulating how the estate will be managed.

And sometimes the management company is affiliated with the developer.

The developer has made money from selling the houses, but an affiliated company may continue earning revenue from the same homeowners through service charges, electricity, water and other estate services for years afterwards.

There is nothing inherently wrong with that. The problem arises where the arrangement effectively converts homeowners into what I call "upgraded tenants."

You have bought the property, but somebody else may still determine who supplies your electricity, how much you pay for it, how your water is supplied, what services you must subscribe to, what annual service charge you pay and, depending on the contractual structure, how easily residents can replace the management company.

This is why anyone buying property in a managed estate should:

Read the estate management agreement.

Read the deed of covenant.

Ask who owns the management company.

Ask how long its appointment lasts.

Ask how it can be removed.

Ask who determines the service charge.

Ask whether residents approve the annual budget.

Ask whether the accounts are independently audited.

Ask whether electricity and water are compulsory.

Ask whether you can install solar or a borehole.

Ask what happens if you refuse a particular service.

Because paying ₦300 million, ₦500 million or ₦1 billion for a house is one thing. Discovering afterwards that you have bought yourself into an expensive management arrangement that will make you end up as an upgraded tenant is another.

- Chukwuemeka Michael Ugah #EstatePropertyInNigeria

[Joy Abiola @Legbetiofficial]

This will help, Ibukun Awosika said the culture should be used reasonably

Respect is key❗️Please watch.

[Engr Olami @Engr_Ashile]

File your car documents like this and see how policemen will respect you

[Michael Taiwo @AskMichaelTaiwo]

If you want to get the most out of ChatGPT for writing, reviewing documents, learning, and planning.

Then Copy and paste these prompts 🧵

[vivian @vheeorji22]

If you want to become a valuable Data Analyst, learning Excel, SQL, Python or Power BI isn’t enough.

You also need to speak the language of business.

Here are business terms every analyst should understand (and why they matter) 👇

[Lammy @Lammyisback]

Signs of AuDHD
(autism + ADHD overlap)

• Task paralysıs
• Time blindness
• Burnout cycles
• Noise sensitivity
• Decision Fatigue
• Difficulty Resting
• Strong inner critic
• Needing clear rules
• Pattern recognition
• Rejection sensitivity
• Emotional hangovers
• trouble with changes
• Trouble with small talk
• Masking automatically
• Strong justice sensitıvity
• Talking a lot or not at al
• Comfort obiects or rituals
• Intense interests that rotate
• Shutdowns after stimulation
• Feeling misunderstood often
• High empathy, low tolerance
• Need structure, reject control
• Feeling "too much" or "not enough"
• Hyperfocus and chronic distractior
• Sensory overload + sensory seeking
• Craving routine and resisting routine
• Intuitive - can feel things others can't
• Overexplaining and then withdrawing
• Forgetting hunger/thirst or not stopping
Emotional intensity, delayed processing
• Forgetting basics, but remembering details
• Difficulty starting and then difficulty stopping

[Femi The Analyst . @Femiforge]

This one-page guide will instantly improve your data storytelling.

[Rajat Jain - Data Analyst @rajatjain1107]

If I had to become a Data Analyst in the next 3 months from a non-IT background...

This is exactly what I'd do:

→ Month 1: Build the foundation
• Excel
• SQL
• Learn how databases work
• Practice with real datasets every day

→ Month 2: Learn to tell stories with data
• Power BI
• Data cleaning
• Data modeling
• DAX basics
• Build dashboards from scratch

→ Month 3: Become job-ready
• AI for Data Analytics
• Business thinking
• Solve real business problems
• Build portfolio projects
• Resume + LinkedIn optimization
• Mock interviews

The goal isn't to learn every tool.

The goal is to solve business problems with data.

That's what companies hire for.

Save this roadmap if you love this roadmap

[Rajat Jain - Data Analyst @rajatjain1107]

SQL Cheatsheet for data analytics

[Becky_Data Analyst @BukolaSalau2]

If you're learning SQL, don't scroll past this.

This is the kind of note you'll come back to again and again.

Save it for later.

[Becky_Data Analyst @BukolaSalau2]

If you're learning Power BI, this one's for you.

Bookmark it now you'll probably need it later.

[Ezekiel @ezekiel_aleke]

SQL ROADMAP
│
├─ 📁 Getting Started
│ ├─ 📁 What is SQL & Why It Matters
│ ├─ 📁 Installing PostgreSQL / MySQL
│ ├─ 📁 Understanding Databases
│ └─ 📁 Writing Your First Query
│
├─ 📁 Basic Queries
│ ├─ 📁 SELECT & FROM
│ ├─ 📁 WHERE (Filtering Data)
│ ├─ 📁 AND, OR, NOT
│ ├─ 📁 ORDER BY (Sorting)
│ └─ 📁 LIMIT & OFFSET
│
├─ 📁 Data Filtering & Functions
│ ├─ 📁 BETWEEN, IN, LIKE
│ ├─ 📁 IS NULL / IS NOT NULL
│ ├─ 📁 DISTINCT (Remove Duplicates)
│ ├─ 📁 UPPER, LOWER, TRIM, LENGTH
│ └─ 📁 DATE Functions (YEAR, MONTH)
│
├─ 📁 Aggregations & Grouping
│ ├─ 📁 COUNT, SUM, AVG, MIN, MAX
│ ├─ 📁 GROUP BY
│ ├─ 📁 HAVING (Filter After Grouping)
│ └─ 📁 ROUND & CAST
│
├─ 📁 Joins (The Heart of SQL)
│ ├─ 📁 INNER JOIN
│ ├─ 📁 LEFT JOIN & RIGHT JOIN
│ ├─ 📁 FULL OUTER JOIN
│ ├─ 📁 Self JOIN
│ └─ 📁 Joining Multiple Tables
│
├─ 📁 Subqueries & CTEs
│ ├─ 📁 Subqueries in SELECT & WHERE
│ ├─ 📁 Nested Queries
│ ├─ 📁 WITH (CTE Basics)
│ └─ 📁 CTE vs Subquery (When to Use)
│
├─ 📁 Advanced SQL
│ ├─ 📁 Window Functions
│ ├─ 📁 PARTITION BY
│ ├─ 📁 LAG & LEAD
│ ├─ 📁 CASE WHEN Statements
│ └─ 📁 UNION & UNION ALL
│
└─ 📁 Real World Practice
├─ 📁 Writing Clean, Readable Queries
├─ 📁 Solving Business Problems
├─ 📁 Practice on Real Datasets (Kaggle)
└─ 📁 Daily Query Practice Workflow

Tap ❤️ For More

[Oluwaseun Adeyemi @0luwaseun111]

10 Excel Functions Finance & Accounting Professional Should Know 👇🏼

1. SUM:
Adds numbers together.

2. IF:
Returns one value if a condition is true and another if it’s false.

3. XLOOKUP:
Finds and returns matching data from another table or range.

4. INDEX + MATCH:
A flexible way to look up values by combining two functions.

5. IFERROR:
Replaces error messages with a value or custom message.

6. COUNTIFS:
Counts cells that meet one or multiple conditions.

7. ROUND:
Rounds a number to the specified number of decimal places.

8. TEXT:
Converts numbers or dates into a specific text format.

9. EDATE:
Returns a date before or after a specified number of months.

10. PMT:
Calculates the periodic payment for a loan based on constant payments and a fixed interest rate.

[Becky_Data Analyst @BukolaSalau2]

New to Data Analytics?

Here are 20 essential terms every beginner should know 👇

1. Dataset – A collection of related data.
2. Database – A structured place where data is stored.
3. KPI (Key Performance Indicator) - A metric used to measure success.
4. Metric – A measurable value used to track performance.
5. Data Cleaning – Fixing errors and inconsistencies in data.
6. Data Visualization – Presenting data using charts and graphs.
7. Dashboard – A visual summary of important metrics.
8. Excel – A powerful spreadsheet tool for analyzing data.
9. SQL – A language used to retrieve and manage data from databases.
10. Power BI – A tool for creating interactive reports and dashboards.
11. Query – A request to retrieve specific data from a database.
12. ETL (Extract, Transform, Load) – The process of collecting, cleaning, and loading data.
13. Pivot Table – A feature used to summarize and analyze data.
14. Filter – Display only the data that meets certain conditions.
15. Sort – Arrange data in ascending or descending order.
16. Trend – The general direction in which data changes over time.
17. Outlier – A value that is unusually high or low compared to the rest.
18. Correlation – A measure of how two variables are related.
19. Insight – A meaningful finding that helps guide decisions.
20. Stakeholder – Anyone who uses or is affected by your analysis.

Save this for future reference.

Which of these terms would you like me to explain in more detail? 👇