Data and code companion to my financial writing on Medium. Covers banking, fintech, and African economic trends.
# Financial Writing Portfolio
**Name:** Lucy Wangui (Lucylight)
**Location:** Kenya
**Focus:** African finance, banking, and economic trends — backed by data
---
## About This Portfolio
While most financial analysis focuses on Western markets, critical stories about African economies often go untold. I write to change that — diving into Kenya's banking landscape, fintech trends, and economic patterns using real data. Every article I publish on Medium is paired with complete transparency here: the raw datasets, the SQL queries I ran, and the analysis that shaped my conclusions. Think of this as your invitation to audit my work, challenge my findings, or take the analysis in a new direction. Reproducibility isn't just nice to have — it's the foundation of credible financial writing. This repo exists so readers can move from "that's interesting" to "let me verify that myself" in seconds.
---
## Read My Articles on Medium
👉 (
medium.com)
---
## How to Use This Repository
Each article I publish on Medium has a companion folder in this repo. Inside each folder you will find the dataset used, the SQL scripts behind the analysis, and additional findings that did not make it into the article. Browse the folders to dig into the data yourself, replicate the analysis, or take it further.
---
## Tools & Data Sources
**Tools:** SQL · PostgreSQL · Python · Excel
**Data Sources:** Central Bank of Kenya · Nairobi Securities Exchange · Public company annual reports
---
## Also Explore
📊 Financial Analyst Portfolio — SQL, Excel, Power BI and Python projects on Kenyan financial data
---
*This portfolio is updated with every new article. Follow along — the data is just getting interesting.*