Grocery sales analysis using SQL
In this project I analize data related to grocery sales, I did queries to answer some business questions like sales perfomance by month, top products by revenue, customer purchase behavior, number of sales by sales worker, sales distributed across different cities. I also had to use Python to upload the big dataset sales and to do math operation to get the total price with the information of customers table.
Here is the link to the Github repository: https://github.com/t500zhuyu/Grocery_Sales_Database
In this project I did a research according with the official data from the Mexican gov. (INEGI) I did some analysis about the violence against the women using pivot tables and statistical analysis like logistic regression this project was for Prosociedad (development agency)
In this video I show a user form created in Excel Visual Basic to enter orders according the requirements of the client
In this project I created an user form using Excel VBA macros to facilitate the data entry for a personal customer, this helps to control the new entries according with information from the other sheets in the same workbook, the combo boxes are usuful for display the options available from the other sheets
I analized and created the data about the production of Electric light bulbs the data is about sales, returns, production quantity per year, etc.
Sales analysis dashboard using Google Sheets
In this dashboard I realized comparative information for the sales in different stores by supervisors, and managers. I analyze the sales per capita, the average sales, the share, etc.
Power BI Financial project
In this project I create a dashboard to show the different metrics about the sales about a store, here I show some graphs about profits, discounts, orders, sales, etc.