Njung The Analyst

Hello, there! I am Njung. Passionate about using data to make the world a better place, by extracting and making meaningful insights

Skilled in SQL/BigQuery ,Tableau,Excel and R @NjungTheAnalyst

Data Cleaning In SQL

In this project we clean property house listing data using SQL Server, The following are steps i used to cleand and process NashvillHousing for analysis.

• Sale date format

• Populate the property address data

• Breaking out address into individual columns (City, state and address)

• Change Y And N To Yes and No in "Sold As Vacant"

• Removing duplicates

• Deleting unused columns

Skills used:Data Validation, Conditional formatting, Power Quary,Standadized formatting

  • View Project
    • April 29, 2024

    Data Exploration in SQL

    Data Exploration of Covid-19 Dataset in SQL.. In this tutorial, i was expected to answer the following question:

    • Total cases of covid-19

    • Total Deaths

    • Total cases Vs total population

    • Countries with the highest infection rate

    • Continent with highest deathcount population

    • Countries with highest deathcount per population

    • Total Population Vs vaccination

    Skills used: Joins, CTE's, Temp Tables, windowns Functions, Aggregate Functions and Converting data types

    Location

    13 St 3 Mohamed Bin Zayed City
    UAE, Abu Dhabi

    Phone

    (+971) 5252-94913

    Email

    njungnileen29@gmail.com

    Social