These projects showcases my expertise in SQL and my ability to work with complex data sets, and highlights my skills in data exploration, data visualization, and data analysis.
Sales Performance Analysis
This project analyzes sales data to identify trends, patterns, and performance metrics. It involves creating SQL queries to analyze the data and create analytical views, providing insights into sales performance across different dimensions. The analytical views were load into Power BI for visualization.
Global Freelancer Data Cleaning
This SQL data cleaning project involves processing and cleaning raw data using SQL queries. By utilizing a combination of data cleansing techniques and SQL functions, I transformed this messy data set into clean, organized, and structured data that can be easily analyzed and visualized. The project showcases my skills in SQL and data cleaning, as well as my ability to work with large datasets to extract valuable insights. The cleaned data was load into Power BI for data visualization.
Truck Express Merge Query
This project involves creating a SQL merge query to combine data from multiple tables in the Truck Express database using Views, CTEs, LEFT JOINs, and Subqueries. The merged data is then load into Tableau for visualization. Click here to view the project report.
End-to-End Fintech ETL Data Warehouse
Built an end to end fintech analytics solution using SQL Server and Excel, transforming messy transactional data into a structured model and developing an interactive dashboard to analyze revenue trends, operational reliability and customer behavior.