DATA CLEANING
IN SQL
In this Project I Cleaned Data in SQL Server, I Looked At Intermediate MySQL Concepts Like Joins, Unions, Partiton By, Aliasing and Creating Views e.t.c
DATA CLEANING
Data Exploration In SQL
Data Exploration of Nashville Housing Dataset In SQL Server, Here Analysed Nashville Housing Dataset Using MySQL...Data Cleaning For Visualisation in Power Bi/Tableau. I looked at Advanced MySQL Concepts Like Common Table Expressions, Subqueries, Temp tables, String Functions, Regular Expressins and Stored Procedures e.t.c
TABLEAU PROJECTS
DATA VISUALISATION
We Analyzed AirBnB Seattle Data, Came Up With A Dashboard Analyzing AirBnB Data In Seattle To Achieve Desired Business Objectives Like What Are The Peak Seasons For Listings on AirBnB In Seattle? Among Others
POWER BI
PROJECT
Looked At Data Professional Survey Breakdown Where We Conducted A Survey Amongest Data Analysts. Our Desired Objectives Were, What are Data Analysts Favorite Programming Languages?, What Are The Happiness Levels With Their Current Salary and Work/Life Balance? And What Are The Difficult Levels To Break Into Data?
Bike Sales
Dashboard
Worked With Advanced Excel, Mastering Concepts Like Pivot Tables, Drill Down, Conditional Formatting Where We Were Analyzing Bike Sales Dashboard. Looked At Business Objectives Like Average Income Per Purchase?, Customer Purchase Commute Distance