Hello.

I am Richard Ogoma, a Microsoft and Google Certified Data Analyst.
I am skilled in using SQL, Spreadsheets, Power BI, Tableau and R programming to make data more valuable.
@Richard Ogoma.

June 30, 2022

Cleaning Data
in SQL

Data is typically dirty. So what do we do when we have to work with dirty data? Clean. Clean. Clean.
Join me on an interesting journey with SQL, as I use the statistical interquartile range (IQR) method to wrangle and transform exchange rate data scraped from CBN's website to make it more usable for analysis.

June 30, 2022

Understanding Outliers in Data

What are outliers? Why do we have outliers? How can we handle outliers in our data? Join me in Tableau as I visualize exchange rate data scraped from CBN's website to understand what outliers in really mean.

June 30, 2022

Manipulating SQL
Databases with Python

In this project, we use Python to connect to a database, manipulate the data and extract the dataset in a format that can be ingested by data visualization tools, like Microsoft Power BI.