In this project, I take sales data from AdventureWorks dataset to explore and extract data based on request
using SQL Scripts in SQLServer
then using Power BI tool to create dashboard for Sales Overview, Customer Details and Product Details
In this project, I first started learning about the baisc of data analysis and using Apriori Algorithm to find the most frequent symptoms compination .Then use the result of the Algorithm to diagnose future patients
In this project, I use the dataset of Coffee Sales to do data cleaning , create Pivot Table and create dashboard only using Excel
In this project, I mainly use SQL to clean data from the dataset in MySQL
In this project, I mainly use SQL to extract and find the metrics of Pizza Sales then I use Power Bi to visualize the results into 2 different sheets. The first one is the summary of the Pizza Sales and the other one is to show Top 5 Best Sellers and Top 5 Worst Sellers