Skip to content
This repository has been archived by the owner on Jun 13, 2023. It is now read-only.

This repository contains the scripts used to wrangle exchange rate data using T-SQL

Notifications You must be signed in to change notification settings

richardogoma/sql-data-cleaning

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

37 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

About the Project

This is a data cleaning project, and the data to be cleansed is the Exchange Rate Data scraped from CBN's official website.

The dataset was extracted on the 15th of July 2022.

This purpose of this project is to demonstrate how data can be transformed from dirty to clean using SQL, and made valueable for analysis.

SQL Topics covered in this project

  1. Joins
  2. Temp tables
  3. Window functions
  4. Aggregations
  5. Descriptive statistics
  6. Subqueries
  7. Parametization (T-SQL)

References

See the References.txt

About

This repository contains the scripts used to wrangle exchange rate data using T-SQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published