
Data Cleaning in SQL
In this project, raw housing data was taken and then transformed in SQL Server to make it more usable for analysis.
Who,
use strong business acumen, as well as an ability to communicate findings, and mine vast amounts of data for useful insights.
Use these insights to influence how an organization approaches business challenges.
Use combined knowledge of computer science and applications, modeling, statistics, analytics and maths to solve problems
Extract data from multiple sources.
Sift and analyze data from multiple angles, looking for trends that highlight problems or opportunities.
Communicate important information and insights to business and IT leaders.
Make recommendations to adapt existing business strategies.
In this project, raw housing data was taken and then transformed in SQL Server to make it more usable for analysis.
Using SQL, this project was more about exploring the data set of covid19 affecting various regions of the world in SQL server.
Using Tableau, data was visualized easily.
python was used to analyze movie data set using numpy, pandas, in jupyter notebook. In this the analysis was based on the rate at which the movie was seen, the highest revenue made from each movie, and the date for the movie release.
The data captured was from the first year students of Akwa-Ibom State University, Faculty of Arts, which have five departments. This data was captured primarily from the current students in the faculty.