Descriptive statistics is where most real-world analytics actually lives:
mean, median, mode : how to describe the center
variance and standard deviation : how spread out the data is
percentiles and quartiles : where specific values fall
frequency distributions : how often things happen.
if you can describe a dataset confidently and clearly, you can do 60% of the analytics jobs listed right now.
Don’t sleep on descriptive stats because it sounds “basic.”
Practice and study with chatgpt, i’m serious.
ask it to explain sql joins with an example using a dataset you choose.
ask it to review your excel formula and explain why it broke.
ask it to quiz you on data concepts until you get them right.
ask it to explain statistics terms in plain english.
ask it to help you practice explaining your analysis to a non-technical audience.
it’s not cheating, it’s using the best study partner available and it’s free.
If you’re down to join a group where we use AI to build businesses around our skills please indicate below👇🏽 Devs, marketers that are willing to sell AI solutions to the global market.
SIGNS OF JINN IN THE HOUSE.
Bismillahir Rahmanir Raheem ❤️
1) Disturbing the electricity: Muhammad (saw) said, “The jinn will play with the flame.”
2) Seeing small stones being thrown inside the house and the doors are closed
3) Moving objects
4) When plates are dropped from the hands of people or doors slamming:
Muhammad (saw) said, “If you hear the dog barking or the donkey braying in the night time do not go out of your house shut the door in the name of Allah (bismillah) cover the plates and the glasses.”
5) Things being stolen from the house to cause fitnah:
Something was stolen from the prophets house and Jibreel told him to seek refuge in Allah as the jinn were trying to cause fitnah between him and his wives.
6) Burning in the house
7) Strange sounds or voices in the home
8) Strong wind in the home and the windows and doors are closed
9) Whispering or moving of the tree in the home
That is the voice of the jinn.
10) Footsteps going upstairs and downstairs regularly and there is noone there
11) Hearing voices of the people in the household and there is no one there
12) Seeing snakes, cats (black cats/strange cat), or strange animals in the house
The jinn could take the form of a spider or ant or lizard, but not a mouse.
If you see an animal say, “Bismillahirahman arraheem three times and if it does not leave kill it because it is the shaytan.”
“A group of Jinn residing in Madinah have accepted Islam, so if any of you see any of these creatures (snakes/scorpions etc.) then he should warn it (to leave) thrice. If it still appears then kill it, for verily it is a Shaytan.
(Sahih Muslim: 2236)
Hafiz Ibn Taymiyyah (rahimahullah) states:
“Jinn can come in the form of black dogs. Similarly they can also come in the form of black cats”
(Majmu ‘ul Fatawa, vol. 19 pg. 52)
13) Strange human beings in the house
Top half human with strange legs, or part animal.
14) Different colour steam in the home on the windows and glass
So the FG Household Conditional Cash Transfer payment registration is ongoing, I saw people gathered in my area and then asked what was happening, people were checking if their names have been approved for the scheme or not, while those who are yet to be enrolled submitted their data.
So why is the media team of this administration not talking about it, if I had not bumped into them today I wouldn't have seen it.
The NGX Trillion Naira Cohort Expands To 26, and Market Capitalisation Crosses US$100bn, A Structural Turning Point For Nigeria’s Capital Market
On 17 April 2026, the Nigerian Exchange closed with 26 companies at or above N1 trillion in market capitalisation, and a total equity market value of N139.83 trillion, equivalent to US$104.07 billion at the NFEM rate. The ASI stood at 217,167.57, having breached 200,000 for the first time in March 2026, with a year-to-date gain of 39.56%. These are the numbers that inspired this Proshare #AnalystNote on the structural revaluation, sectoral composition, concentration dynamics, infrastructure catalysts, and forward directional intelligence in our market.
Proshare reads this moment as a structural turning point rather than a cyclical peak. The expansion of the cohort from 22 constituents in November 2025 to 26 in April 2026 has been produced by the convergence of the banking recapitalisation completion, the FTSE Russell frontier reinstatement of 2025, Pension Fund Administrator inflows, the NGX Invest capital formation platform, and a sustained earnings recovery across industrials, consumer goods, and energy.
The market has revalued, but the revaluation is concentrated. Eight mega-cap constituents account for 61.54% of total market capitalisation, and the sectoral composition, while broader than in 2008, still leans heavily toward ICT, industrial goods, and financial services.
The note that follows below sets out the milestone in context, reconstructs the causal timeline from 2000 to the present, anatomises the 26 company cohort, names the structural drivers of the rally, reads the infrastructure deepening signals, and closes with a risk aware and forward looking interpretation of what the moment invites from the regulator, the operator, the issuer, and the investor. We should acknowledge the work put in by all and take advantage of these good times.
Concluding Thoughts and Forward-Looking Market Interpretation
The directional intelligence framework that emerges from the milestone carries four forward observations. The cohort will expand further in the coming quarters, with two to three of the watchlist constituents expected to cross the threshold by Q3 2026, and with the Dangote Petroleum Refinery and Petrochemicals pan African listing of Junepan-African 2026 functioning as a standalone index reshaping event.
The concentration at the top tier will probably compress modestly as the cohort broadens, but the structural weight of ICT and telecommunications, industrial goods, and consumer goods will remain the anchors of the index.
The infrastructure deepening produced by T+1 settlement and the extended trading session will feed through into turnover, foreign participation, and institutional allocation over the two to three reporting cycles following implementation. The effect will be additive rather than immediate. The market will learn the new settlement cycle before it learns to trade it aggressively.
The regulatory architecture will continue to evolve. The @SECNigeria has correctly read the banking recapitalisation proof of concept. The NGX Regulation function has demonstrated enforcement credibility through the CMO-5 matter and the delisting decisions for DN Tyre and Greif Nigeria.
The path from here requires the Financial Services Regulation Coordinating Committee to be upgraded from its 1994 consultative form to a macroprudential coordinator with a defined mandate, a published meeting cadence, and a working-group architecture adequate for the five-front recapitalisation programme.
The @ngxgrp self-regulatory architecture has strengthened. Investor protection, risk-based supervision, and market innovation are the frontiers on which the next phase of institutional development will be judged.
Proshare’s role across this moment is to translate the data into meaning with the discipline that distinguishes market intelligence from market commentary. The numbers are a matter of record, but the interpretation is the work, as our research creed states. The reflective intelligence cycle that underpins the @proshare Economic & Market Intelligence Unit (EMIU) will carry the cohort as a standing coverage theme through 2026 and 2027, with each reporting cycle tested against the conditions set out in this note and each directional call published with the explicit triggers that would revise it.
The Nigerian Capital Market ecosystem has put in the work; we must acknowledge this and build on these consequential strides, and investors should take advantage of these good times.
READ MORE>>> proshare.co/articles/the-n… via @proshare
The data cleaning checklist you need to print and stick on your wall:
1. check for duplicates.
2. Identify missing values, don’t just delete them, understand WHY they’re missing.
3. correct data types ,that number column stored as text will ruin your analysis.
4. standardize text, “lagos”, “Lagos”, “LAGOS” are not the same in a computer.
5. validate values, does that 200 year old customer make sense?
6. check for inconsistencies , same product, three different spellings.
7. check for outliers,that ₦1,000,000 transaction might be real or might be an error.
8. document every change you make
Which data professionals are most often responsible for ensuring that data is available, secure, and backed up to prevent loss?
A. Data scientists
B. Data warehousing specialists
C. Data analysts
D. Data engineers
Skyway Aviation Handling Company, NAHCO, was today's biggest gainer at 10 percent, closing at 220 naira.
NAHCO handles ground operations for flights at Nigerian airports.
Every plane that lands in Nigeria needs NAHCO or a company like it.
As Nigerian air travel grows, as the Dangote refinery begins supplying jet fuel regionally, as the economy opens further, NAHCO processes more aircraft.
More aircraft means more revenue.
More revenue means more value for shareholders.
Sometimes the best investments are not the companies you see. They are the infrastructure behind the companies you see.
I prayed Tahajjud every night. Same du’as. Same tears. Same requests.
Nothing changed.
Until a scholar told me something that shook me:
“You’re talking to Allah but you haven’t stopped to let Him talk back.”
Data Analysts!!
The next time you’re looking for a dirty dataset to clean to practice your data cleaning skill, use this prompt to generate the data from Ai.
Save for later.
“You are a data generator simulating real-world datasets for data analysis practice.
Create a dataset with the following specifications:
1. Domain / Context:
- [INSERT DOMAIN: e.g., e-commerce, healthcare, banking, education, logistics]
2. Dataset Size:
- Generate [X] rows
3. Columns (with data types and meaning):
- Provide [10–20] columns including a mix of:
- Numerical (integers, floats)
- Categorical (nominal + ordinal)
- Text fields
- Dates/timestamps
- IDs (some structured, some inconsistent)
4. Intentional Data Quality Issues (VERY IMPORTANT):
Introduce realistic “dirty data” problems such as:
- Missing values (random + patterned)
- Duplicate rows and duplicate IDs
- Inconsistent formats (e.g., dates: DD/MM/YYYY vs MM-DD-YY)
- Typographical errors in categorical values
- Mixed units (e.g., kg vs lbs, USD vs NGN)
- Outliers and extreme values
- Invalid entries (e.g., negative ages, impossible dates)
- Inconsistent capitalization and whitespace issues
- Corrupted or partially truncated text fields
- Columns with mixed data types
5. Relationships:
- Include at least 2–3 meaningful relationships between variables
- Add some noise that weakens perfect correlations
6. Output Format:
- Provide the dataset as a table (CSV format preferred)
- Include column headers
7. Additional Context:
- Briefly describe what each column represents
- Mention key data issues intentionally inserted (but do not fix them)
8. Difficulty Level:
- Make this dataset suitable for intermediate to advanced data cleaning and exploratory data analysis
Important:
- Do NOT make the dataset perfectly clean
- Prioritize realism over neatness
- Ensure the dataset looks like something collected from real operations”
If you want to stand out as a Data Analyst, mastering SQL is non-negotiable.
Here are 5 SQL queries every analyst should know 🧵
1. SELECT & WHERE
The foundation of data extraction.
SELECT * FROM sales WHERE revenue > 1000;
2. GROUP BY
Summarize data for meaningful insights.
SELECT region, SUM(revenue)
FROM sales
GROUP BY region;
3. JOINs
Combine data from multiple tables.
SELECT customers.customer_name, orders.order_date
FROM customers
JOIN orders ON customers.customer_id = orders.customer_id;
4. WINDOW FUNCTIONS
Perform advanced analysis.
SELECT customer_id,
SUM(revenue) OVER (PARTITION BY customer_id) AS total_revenue
FROM sales;
5. CASE WHEN
Create conditional logic.
SELECT customer_id,
CASE
WHEN revenue > 1000 THEN 'High Value'
ELSE 'Low Value'
END AS customer_segment
FROM sales;
Master these SQL queries and you’ll be ahead of many aspiring analysts.
You see sugarcane on the roadside… you chew it, enjoy it, and throw away the fiber.
But what if I told you that this simple “sweet stick” is actually one of the most powerful plants on Earth — a crop that quietly runs sugar production, drinks, fuel, and even industry worldwide 😳
INTERESTING FACTS ABOUT SUGARCANE:
• Sugarcane comes from a plant called Saccharum officinarum, a tall grass that can grow like a mini jungle plant
• It is not a fruit — what you chew is the stem (stalk) packed with natural sugar juice
• The sweetness is stored inside the stem like a natural energy battery
• Sugarcane can grow up to several meters tall, sometimes taller than a full-grown human ×2
• It is one of the world’s main sources of sugar, not just a local crop
• One plant can produce stalks that are harvested and regrown multiple times
• Farmers don’t usually plant seeds — they grow it from cut stem pieces (like cloning the plant)
• When you chew it, you are only extracting juice — the leftover fiber is called bagasse
• That leftover fiber is not waste — it is used to make paper, animal feed, and even fuel
• Sugarcane is also used to produce ethanol (biofuel) in some countries
• The juice must be processed quickly because it can ferment naturally within hours
• It grows best in hot, tropical climates like Nigeria, Brazil, and India
• The plant stores so much sugar that it is harvested at a specific time when sweetness is highest
• Sugarcane juice is one of the oldest natural drinks — people have been chewing it for thousands of years
• Almost every part of sugarcane has a use — from food to energy production, nothing is truly wasted
Q: If the consensus candidate emerges within the ADC Coalition, will you step aside in the interest of unity?
Atiku: It is not about stepping aside, the first option in coalition is to work out a consensus. If that doesn’t emerge, then we go for direct primaries.