Dealing with messy data is daunting. Therefore getting to deal with missing values, duplicate attributes, blank cells, wrongly coded attributes just to mention a few is paramount to prepare data for analysis. Hence in this housing project we use SQL to clean and alter housing data pulled from the United States Housing Database.
Data exploration of COVID-19 Data sets in SQL Server. In this project we explore the indepth capabalities of SQL in selecting data from databases, joining tables, appending data into tables, deleting and manipulating tables using various primary and foreign keys.
These Tableau projects give real world cases that firms go through in trying to make data driven decisions. Each Visualisation tells a story that is paramount to the success of stakeholder's goals and objectives. Take a deep dive into the dynamic and interactive dashborads and vizzes to get a feel of the whole story.
This Python project gives a real world case that a business would go through in trying to make data driven decisions on their sales and profits. In this project we explore the capabilities of Python Pandas, NumPy, Matplotlib to dig and unearth insights in our data. Drill down by clicking the the button below to view the whole project.