SQL PROJECTS
I have queried databases on several SQL projects, with applications like PostGREsql in pgAdmin4 and SQL Server Management Studio from Microsoft. projects including a DVD rental DB, Covid DB and International brewery DB, Which i created the database from scratch.
Projects
Data visualization using Tableau
This is a visualization for a Netflix dataset, which this dashboard was able to show a report of total movies by country and year, top 10 genre, distribution and finally a drop down button on type and title, of either movies or tv shows to display its features such as description, genre date added, rating etc, at a switch of the drop down parameters.
Data visualization using PowerBI
This is a dashboard created from a data set on data professional survey, where extraction was done to MS excel, transformation using power query to clean the data set, ranging from creation and removal of columns , splitting of columns for easy and important use, then loading for visualization on several reports for decision making.
Data visualization using MS Excel
This is a visualization was done from a dataset and the first is the pivoted tables which brought about the dashboard below for reporting at a glace, which explains more on the top image table using charts, maps etc.
