Akong The Analyst

10/06/2026

SQL Import Data Error

This error usually happens when you're trying to open a file or data with a character encoding that doesn't match what the system expects. In SQL Workbench, it might be a file or a query result that has special characters.

A common solution is to explicitly set the encoding. For example, if you're opening a file, you can try opening it with UTF-8 encoding instead of the default. Or, if you're connecting to a database, ensure your connection settings or queries specify the right encoding.

Let share how you where able to overcome this challenge.

09/06/2026

08/06/2026

Essential data analysis terminologies every Data Analyst should know:

Terminology & Meaning

1. Dataset: A collection of related data organized in rows and columns for analysis.

2. Data Cleaning: The process of identifying and correcting errors, duplicates, missing values, and inconsistencies in data.

3. KPI (Key Performance Indicator): A measurable value used to evaluate how effectively an organization is achieving its objectives.

4. Data Visualization: The graphical representation of data using charts, graphs, dashboards, and maps to communicate insights.

5. ETL (Extract, Transform, Load): A process of collecting data from different sources, transforming it into a usable format, and loading it into a database or data warehouse.

6. Correlation: A statistical measure that shows the relationship between two variables. Correlation does not necessarily imply causation.

7. Outlier: A data point that significantly differs from other observations in a dataset and may affect analysis results.

8. Aggregation: The process of summarizing data using calculations such as SUM, COUNT, AVG, MIN, and MAX.

9. Data Warehouse: A centralized repository that stores large amounts of structured data from multiple sources for reporting and analysis.

10. Dashboard: An interactive visual interface that displays key metrics, trends, and insights in real time.

Bonus Terms Every Data Analyst Should Learn

SQL (Structured Query Language)
Pivot Table
Data Modeling
Regression Analysis
Normalization
Business Intelligence (BI)
Machine Learning
Data Governance
A/B Testing
Predictive Analytics

Understanding these terms will help you communicate effectively with stakeholders, perform better analyses, and build a stronger foundation in data analytics.

Which one did you learn today with me?

07/06/2026

Must-Know Data Abbreviations & Terms Every Analyst Should Know 📊

Whether you're learning Excel, Power BI, SQL, or Python, you'll constantly come across these terms:

→ API — Application Programming Interface
→ SQL — Structured Query Language
→ ETL — Extract, Transform, Load
→ KPI — Key Performance Indicator
→ BI — Business Intelligence
→ CRM — Customer Relationship Management
→ JSON — JavaScript Object Notation
→ CSV — Comma-Separated Values
→ ML — Machine Learning
→ AI — Artificial Intelligence
→ ROI — Return on Investment
→ OLAP — Online Analytical Processing
→ DBMS — Database Management System
→ NoSQL — Non-Relational Database
→ Big Data — Large, Complex Datasets
→ Data Warehouse — Centralized Data Repository
→ DAU — Daily Active Users
→ CPA — Cost Per Acquisition
→ RFM — Recency, Frequency, Monetary
→ DAX — Data Analysis Expressions
→ EDA — Exploratory Data Analysis
→ A/B Testing — Comparing Two Versions for Optimization
→ YOY — Year-over-Year
→ MTD — Month-to-Date
→ YTD — Year-to-Date
→ MoM — Month-over-Month
→ GDPR — General Data Protection Regulation

Which abbreviation did you learn today? 👇🏽

06/06/2026

John Obidi is an important figure in the 21st century and this digital age.

He is the Founder of Heads Start Africa, a community of global mind assisting businesses, investors and small startup in technology.

ChatGPT encouraged me to apply his principles in data analysis and learn from him.

05/06/2026

The roles of Data Analyst are stated clearly but it actually goes beyond only using the tools to achieve impactful results.

Other unannounced skills needed...

- Thinking abilities
- Time management
- Pressure control
- Collaborative skills
And many more problems solving abilities.

04/06/2026

Explore Excel Shortcut

04/06/2026

Dashboard Report

A dashboard report is a visual, one-page summary that shows key metrics + trends at a glance.

✍️ Purpose: Help managers and stakeholders make fast decisions without digging through raw data or long spreadsheets.

✍️ Key parts:
1. KPIs: The 3-5 most important numbers - e.g. Revenue, Active Users, Conversion Rate. Usually shown as big numbers/cards at the top.

2. Charts/Visuals: Line charts for trends, bar charts for comparisons, pie/donut for splits. Turns data into patterns you can see in 3 seconds.

3. Filters: Date range, region, product, etc. Lets users slice the same dashboard for different views without new reports.

4. Refresh cycle: Shows when data was last updated Daily, Weekly, Real-time.

✍️ Why analysts use it: Instead of sending 10-page Excel reports, you build 1 interactive dashboard in Excel, Power BI, or Tableau. Stakeholders self-serve answers.

✍️ Rule of thumb: If someone can’t understand the main story in 10 seconds, the dashboard is too busy.

Want me to break down how to structure one for a “Data Analysis Facilitator” role? Like what KPIs to include for a training team vs sales team?

03/06/2026

Since morning the PIVOTBY FUNCTION was not working on some Excel version especially 2021 that I use, I just have to try the Excel that is in my phone and behold the almighty PIVOTBY work on Android phone.

The PIVOTBY function in Excel allows you to instantly generate dynamic summary reports by grouping data across both rows and columns.

04/03/2024

Happy Monday! Embrace the new week with positivity and enthusiasm. Let's make today amazing with smiles, laughter, and small victories along the way!