I successfully implemented a Python-based automation solution for daily sales reporting across 28 pharmacy branches, streamlining the process and dramatically reducing the daily workload from 4 hours to just 15 minutes, thereby enhancing operational efficiency and allowing managers to make data-driven decisions more promptly.
I designed an automation solution for Excel dashboards, leveraging pivot tables to construct dynamic visualizations. Subsequently, I developed a script to seamlessly transfer these dashboards to Power BI, ensuring automated data refresh functionality for enhanced reporting efficiency.
"I developed an automation process to extract raw data from Excel, facilitating seamless implementation into a database. This involved creating a mechanism to edit the row data and generate SQL syntax for both insertion and updating, ensuring efficient data integration and maintenance within the database.
I developed an automation solution to streamline the collection of refund counts and types from 28 pharmacy branches. This innovative approach replaces the manual process of cleaning data in Excel and utilizing pivot tables, offering a more efficient and accurate solution implemented in Python
I implemented automation for Google Sheets, utilizing SQL queries and IMPORTRANGE function to dynamically fetch and populate data. Additionally, I incorporated dropdown menus that automatically populate based on selected values, enhancing user interactivity and data manipulation capabilities.