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 :
