In this project, I conducted an Inventory Analysis for a beverage manufacturing company, focusing on improving inventory data and distribution processes.
๐๐ฒ๐ ๐๐ถ๐ด๐ต๐น๐ถ๐ด๐ต๐๐:
๐๐ฎ๐๐ฎ ๐๐ฐ๐พ๐๐ถ๐๐ถ๐๐ถ๐ผ๐ป: Used Google Cloud API to import inventory data from Google Drive into Jupyter Notebook.
๐๐ฎ๐๐ฎ ๐ฃ๐ฟ๐ฒ๐ฝ๐ฟ๐ผ๐ฐ๐ฒ๐๐๐ถ๐ป๐ด: Cleaned and prepared the data to ensure accuracy for analysis.
๐๐ฎ๐๐ฎ๐ฏ๐ฎ๐๐ฒ ๐๐ป๐๐ฒ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป: Connected the data to a MySQL server, allowing for structured storage and operations.
๐๐ป๐๐ฒ๐ฟ๐ฎ๐ฐ๐๐ถ๐๐ฒ ๐๐ฎ๐๐ต๐ฏ๐ผ๐ฎ๐ฟ๐ฑ: Built a Power BI dashboard to display key inventory metrics and trends in real time.
๐๐ฎ๐ฟ๐ด๐ฒ ๐๐ฎ๐๐ฎ๐๐ฒ๐ ๐๐ฎ๐ป๐ฑ๐น๐ถ๐ป๐ด: Worked with a dataset of 4.3 million entriesโmy first time managing data at this scale, which was a great learning experience.
This project enhanced my skills in data processing, database management, and dashboard creation for large datasets.
Dashboard :
