Data Cleaning in SQL
This project looks at raw housing data and transform it in SQL Server to make it more usable for analysis.
Data Analyst, versatile in SQL, Python, Tableau and Power BI. @JSOAnalytics
This project looks at raw housing data and transform it in SQL Server to make it more usable for analysis.
In this project, three different datasets; university towns, olympics and flickr images datasets, were cleaned up using Python.
In this project we look at what variables effect the gross revenue from movies.
In this project we scrape data from Amazon to analyze price data for products.
These are the data analytics projects planned for the coming months/years:
This project will look at available gun violence data across the U.S. and bring out insights and inferences though data visualization and analytics.
This data analyst took an existing dataset on American universities in 2013 from Kaggle and used it to explore what makes students prefer one university over another.
Can happiness be predicted using World Happiness Report of 2021?
In the Analyze Your Runkeeper Fitness project, we will import, clean, manipulate, and analyze the seven years of Runkeeper’s training data. It is a perfect sample project for learning complex data filtering, transformation, and processing. Furthermore, we will analyze the data and present a detailed summary report.
For the Real-time Insights from Social Media project, we will use various statistical tools to dive deep into Twitter’s hot trends. We will understand local and global patterns and common trends and perform frequency and language analysis.
In the Analyze International Debt Statistics project, we will write SQL queries to explore and analyze international debt using the World Bank dataset. We will use SQL as the most popular and essential tool for performing data analytics on the go. In the project, you will be finding the: Distinct countries Distinct debt indicators Total amount of debt owed by the countries Country with the highest debt Average amount of debt across indicators The highest amount of principal repayments The most common debt indicator
John Olaobaju
Frisco, Texas 75033 | 469-844-8774 | john800j@gmail.com | https://jsoanalytics.github.io