Vending machine sales report in Central New Jersey (four different locations)

The project aims to draw insights in optimizing vending machine sales, particularly those installed in New Jersey, based on their location. I got the data from Kaggle, and it is basically a sample of vending machine sales in four different locations in 2022. Using Pandas-Python and Excel, I managed to clean, fill in the missing data, and preprocessing. finally, through Power BI, i visualize important parameters and draw insights regarding the most profitable brands/products as well as the best selling price. Additionally, I have identified the pattern and relationship between the price and number of transactions.
hashtag#dataanalytics hashtag#dataanalysis hashtag#dataanalyst hashtag#businessanalytics hashtag#businessanalyst hashtag#businessintelligence hashtag#powerbi hashtag#datavisualization hashtag#datagathering hashtag#kaggle hashtag#python hashtag#pandas hashtag#aicommunity hashtag#datascience hashtag#salesoptimization hashtag#tableau hashtag#sql hashtag#mysql hashtag#sqlserver hashtag#sqlqueries hashtag#excel hashtag#datareporting hashtag#datadashboard