SQL Data Exploration and Tableau Visualization

Using open data set about COVID cases with the help of Microsoft SQL Server I have explored the data using such methods as: alter, group by, aggregation, joins, CTE, temp tables and views. The information I have returned using the queries above have been used to visualize the findings in Tableau.

Excel Project with Data Cleaning and Dashboard

Using bike sales dataset with the help of Excel I have cleaned the data (removed duplicates, replaced incorrect data, used if and nested if to categorize the data) and created pivot tables for further charts and dashboard visualization, where I added slicer to help client navigate the demographics.

Data Professional Survey Power BI Dashboard

Using online survey of data specialists I have cleaned the information In Excel to create a Power BI dashboard to highlight voters answers and opinions. This dashboard can be useful for aspiring data specialists and HR managers to make appropriate decisions and understand state of current affairs.

Movie Profit Correlation in Python

Using python, I have cleaned and formatted data for further exploration of what influences high gross profit of movies. I have used various Python libraries, such as Pandas, Numpy, Seaborn, Matplotlib. The analysis showed high correlation between gross profit, budget and audience's votes.