Akong The Analyst

Akong The Analyst Digital Creator

Data Cleaning = getting messy raw data ready so your analysis doesn’t lie to you. "Garbage in = Garbage out" ✅ The 5 Key...
05/08/2026

Data Cleaning = getting messy raw data ready so your analysis doesn’t lie to you.

"Garbage in = Garbage out"

✅ The 5 Key Steps in Data Cleaning

📌 Handle Missing Values
- Problem: Blank cells, `NULL`, `NaN`

- Fix: Delete row, fill with mean/median/mode, or flag as "Unknown"

- Why: Missing data breaks calculations and skews results

📌 Remove Duplicates
- Problem: Same transaction/customer recorded 2-3 times

- Fix: Use `DISTINCT` in SQL or `df.drop_duplicates()` in Python

- Why: Duplicates inflate revenue, counts, and give wrong insights

📌 Fix Data Types + Format
- Problem: Dates as text, numbers as text, inconsistent formats `1/5/25` vs `2025-01-05`

- Fix: Convert to correct types: `date`, `int`, `float`. Standardize case: `Lagos` not `lagos`

- Why: You can’t sum text or filter dates if the type is wrong

📌 Handle Outliers + Errors
- Problem: Age = 250, Sales = -$5000, typo in category names

- Fix: Cap, remove, or investigate. Use IQR/Z-score or business rules

- Why: 1 outlier can ruin your average and dashboard

📌 Standardize + Validate
- Problem: `Nigeria`, `NG`, `Naija` all mean same country

- Fix: Create mapping/lookup table. Check ranges and logic rules

- Why: So joins, groupbys, and dashboards are accurate

✅ Line Summary
Data Cleaning: Find errors → Fix them → Make data consistent → So analysis is trustworthy

Rule of thumb: Analysts spend 60-80% of their time cleaning.

Building an Income and Expenses Tracker The tracker consist of four sheet but three are visible.✅ The first sheet is the...
03/08/2026

Building an Income and Expenses Tracker

The tracker consist of four sheet but three are visible.

✅ The first sheet is the setup; which is made of the business sources of income and expenses. It's simple and easy to get through.

✅ Second sheet is the Transaction; business transactions in the sheet carry the date, transaction type (income or expenses), amount and description.
The sheet is automated from the setup sheet and the 3rd hidden sheets.

This transaction sheet is where formulas are applied to automate the the entire tracker.
The formula are within date, transaction type, amount and the hidden ones use in the hidden sheets.

✅ The final sheet which is Monthly Overview (Dashboard); this is more technical..

This dashboard sheet is automated by some formula that makes it easier to interact with, ranging from the date, month, year, income, expenses balance, cash flow etc.

This tracker help as your business grows, keeping accurate financial records becomes increasingly important.

Many businesses struggle to answer key questions such as:

• How much profit did we make this month?

• Which expenses are reducing our profitability?

• Are we generating enough cash flow to sustain operations?

• Which product categories contribute the most to our revenue?

To help solve these challenges, I have developed a customized Income & Expense Tracker Dashboard specifically designed for businesses that help in making decisions.

Gain Better Control of Your Business Finances with an Automated Income & Expense Tracker.

The Church is the first institution for Transparency and Accountability.Every offering represents trust. Every expense r...
02/08/2026

The Church is the first institution for Transparency and Accountability.

Every offering represents trust. Every expense reflects stewardship.

Our Church Income & Expense Tracker helps you honor both by providing accurate financial records, automated reports, and easy-to-understand dashboards.

Spend less time compiling reports and more time focusing on ministry while maintaining transparency and accountability.

Reach out to me to get your tracker!

27/07/2026

🌅 Monday Restart

A new week is a new opportunity to grow, improve, and move one step closer to your goals. Don't focus on last week's setbacks—focus on today's possibilities.

Start strong. Stay consistent. Trust the process. Every small effort you make today builds a better tomorrow.

Happy Monday! Make this week count. 🚀📊

25/07/2026

Throughout the time we hear and see video clips of airplane crash and CNN will read the news and call numbers of people in the crash using the airport data.

The question is what is the major cause of the crash in the same locations, aircraft and model of the aircraft.

that's where turning raw data into insights that drives decisions by the airline stakeholders play a crucial part.

Why the use of SQL for data analysis when it can't visualize.This is a common and confusing question most data analyst f...
24/07/2026

Why the use of SQL for data analysis when it can't visualize.

This is a common and confusing question most data analyst first ask themselves and their instructor, even me I do ask.

Here's a short answer

SQL is not meant to visualize data. It's meant to retrieve, clean, transform, and analyze data efficiently. Visualization is typically done with tools like Excel, Power BI, Tableau, or Python after SQL has prepared the data.

✍️ Think of the data analysis workflow like this:

Database ↓SQL (Extract, Clean, Filter, Analyze)↓

Power BI / Tableau / Excel / Python ↓
(Charts, Dashboards & Reports)

✅ Why SQL is essential for data analysis

1. SQL works directly with large databases

A company may have millions of records. Instead of downloading everything into Excel, SQL lets you retrieve only the data you need.

Example:
SELECT Product, SUM(Sales) AS Total sales

FROM Sales

GROUP BY Product;

SQL finds the answers; visualization tells the story. That's why SQL remains one of the core skills for data analysts even though it doesn't specialize in creating charts.


Are you running a business without knowing your actual profit?My Income & Expense Tracker helps you monitor sales, expen...
22/07/2026

Are you running a business without knowing your actual profit?

My Income & Expense Tracker helps you monitor sales, expenses, and profits automatically.

✅ Benefits

Tracks cash flow accurately.

Identifies unnecessary expenses.

Measures business profitability.

Supports budgeting and forecasting.

Provides data for decision-making.

✅ For a Google Sheets tracker, a common setup is:

Transactions Sheet → Raw data entry.

Monthly Overview Sheet → Income, expenses, and profit summary.

Dashboard Sheet → Charts, KPIs, and trends.

This structure works well for businesses, shops, freelancers, startups, and SMEs.

✅ What We Offer

Our Income & Expense Tracker is a simple yet powerful business management tool designed to help you record, organize, and analyze your financial activities in one place.

Send "TRACKER" to get a demo.

21/07/2026

Data Analytics involves the collection of dataset from a source with a desire of identifying the necessary information in the data.

All the process happens with a Dataset and the aim to achieve a results that drives decisions and it involves tools and skills.

• Data Collection
• Data cleaning
• Data modeling
• Visualization
• KPIs
• Dashboard design
• Reporting
• Recommendation.

Data Analytics involves the collection of dataset from a source with a desire of identifying the necessary information i...
20/07/2026

Data Analytics involves the collection of dataset from a source with a desire of identifying the necessary information in the data.

✅ Trend or pattern, it can be....

📌 Descriptive (What happened?)

📌 Predictive(What might happen?)

📌 Diagnostic (Why did it happen?)

📌 Prescriptive Analysis (What should we do next?).

All the process happens with a Dataset and the aim to achieve a results that drives decisions and it involves tools and skills.

✅ Tools:

• Python
• SQL
• Power BI
• Excel
• Tableau
• Azure
• Google sheets
And many more...

✅ Skills:

• Data Collection
• Data cleaning
• Data modeling
• Visualization
• KPIs
• Dashboard design
• Reporting
• Recommendation.

Recommends the optimal course of action based on potential scenarios to maximize outcomes or mitigate risks.

Address

Ado-Ekiti
LEKKIPHASE1LAGOS

Website

Alerts

Be the first to know and let us send you an email when Akong The Analyst posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share