HAMZA RHACH

Accountant & Financial Data Analyst

Welcome to my portfolio, I am Hamza Rhach an Accountant & Financial Data Analyst well versed in MS Excel VBA, Power BI, and SQL

• Portfolio
• About
• Contact

1st Project

The "Mission Calendar Colorizer" is a robust Excel VBA project designed to enhance mission planning and visualization by automating the coloring of dates corresponding to mission start and end dates within a calendar interface. Leveraging the power of VBA (Visual Basic for Applications) and the versatile VLOOKUP function, this solution streamlines the process of highlighting critical mission timelines.🎨 Dynamic Coloring: Automatically highlights calendar dates based on mission start and end dates, ensuring clear visualization of mission timelines.🖌️ Customizable: Empowers users to adjust color schemes and formatting to suit specific mission requirements, enhancing clarity and readability.⏱️💼 Efficiency: Reduces manual effort and human error by automating the coloring process, saving valuable time and resources during mission planning and tracking.🔄 Scalability: Easily adaptable to accommodate varying mission durations and frequencies, providing flexibility for diverse operational needs.🔍 Integration: Seamlessly integrates VLOOKUP function to retrieve mission data, ensuring accurate and up-to-date information is reflected in the calendar view.The "Mission Calendar Automation" project simplifies mission planning processes, directly providing stakeholders with a clear and intuitive overview of mission timelines within Excel.

• Video

• Back

T

T

T

2nd Project

This project incorporates various functionalities aimed at improving the user experience. Here's a breakdown:⚙️ Task Management: Users can effortlessly add new tasks through a designated input field. Each task is accompanied by a "Complete check" button for easy task completion.🌐 Language Switch: A language switch feature has been implemented using VBA, allowing users to toggle between English, French & Arabic. This enhances accessibility for users of different linguistic backgrounds.⏲️ Timer Functionality: The integration of a timer feature assists users in tracking the time spent on tasks. They can initiate and halt the timer as needed, aiding in effective time management.• Technologies Utilized:
💻 Microsoft Excel
🖥️ Visual Basic for Applications (VBA)• Skills Exhibited:
💡 Proficiency in VBA programming for Excel
🎨 Designing user interfaces and interactions
🛠️ Incorporating dynamic features such as language switching and timersThe resulting To-Do List application provides a smooth and efficient task management solution within the familiar Excel environment. The inclusion of language switching and a timer enhances the tool's versatility, making it a valuable asset for users aiming for organized and time-conscious task management.

• Video

• Back

3rd Project

The "Excel Invoice Automation" project utilizes Excel VBA code to automate the creation of detailed invoices. This solution simplifies the invoicing process by dynamically generating professional invoices directly within Excel.📄 Automated Invoice Creation: Generates detailed invoices automatically, minimizing manual data entry and streamlining the billing process.🎨 Customizable Templates: Offers customizable invoice templates to suit various business requirements, allowing for branding and personalized formatting.📊 Dynamic Data Population: Populates invoice details such as client information, itemized charges, and totals dynamically, ensuring accuracy and consistency.💡 Flexible Calculation Logic: Utilizes VBA code to implement flexible calculation logic for taxes, discounts, and additional charges, adapting to diverse billing scenarios.🔗 Integration: Seamlessly integrates with Excel's functionality, enabling easy data import and export, as well as compatibility with existing spreadsheets and databases.The "Excel Invoice Generator" project empowers businesses to streamline their invoicing process, saving time and reducing errors associated with manual billing tasks, by automating invoice creation, it enhances productivity and accuracy, ultimately contributing to improved financial management and customer satisfaction.

• Video

• Back

T

T

T

T

4th Project

The "Excel HR Dashboard" offers a streamlined interface for inputting company staff information and presents key insights through interactive graphs and charts. Powered by Excel VBA code and VBA Userforms, this project simplifies HR data management and facilitates informed decision-making with dynamic visualizations.💻 Intuitive Interface: Provides a user-friendly interface for inputting and managing company staff information, enhancing data accessibility and usability.🗄️ Data Management: Streamlines employee data management processes, allowing for efficient data entry, editing, and organization within Excel.📈 Interactive Dashboard: Presents dynamic graphs and visualizations that offer insights into various HR metrics such as employee demographics, turnover rates…📊 Customizable Graphs: Offers customizable graphs and charts to visualize HR data according to specific organizational needs and preferences.🔍 Data Analysis: Utilizes Excel VBA code for in-depth data analysis, providing actionable HR insights for informed decision-making and strategic planningThe "Excel HR Dashboard" equips HR teams with efficient tools for managing and analyzing employee data. Through interactive visualizations, it facilitates informed decision-making and aids strategic efforts to enhance workforce management and organizational performance.

• Video

• Back

5th Project

This is a sophisticated solution tailored to efficiently compute the due time of invoices and assess their overdue status within Excel. This project employs advanced VBA code to generate insightful reports through two popup messages. The first message provides a comprehensive overview, indicating the proportion of due and overdue invoices relative to the total balance. The second one presents a refined analysis showcasing the 10 most overdue invoices, sorted in descending order by amount, offering invaluable insights into financial obligations.⏰ Due Time Calculation: Automatically computes the invoices due time based on predefined parameters, streamlining financial management processes.⏳ Overdue Assessment: Determines the overdue status of invoices precisely, enabling proactive management of payment obligations.💬 Popup Messages: Utilizes popup messages to deliver concise & actionable reports, enhancing accessibility & usability.📈 Comprehensive Overview: Offers a holistic view of invoice status by presenting the proportion of due & overdue invoices relative to the total balance.💰 Top Overdue Invoices: Provides a detailed breakdown of the 10 most overdue invoices by amount, facilitating focused attention on critical financial obligations.This project enhances financial decision-making by offering real-time insights into invoice status and overdue obligations.

• Video

• Back

T

T

T

6th Project

The Outlook Excel Data Reader is a sophisticated Excel VBA project meticulously crafted to efficiently extract data from Excel files received via Outlook from team members. By harnessing the power of VBA code, this solution automates the process of reading and analyzing data from each Excel file, enabling seamless integration with existing workflows and facilitating informed decision-making.🔄 Automated Data Extraction: Automatically reads data from Excel files received in Outlook from team members, eliminating manual intervention and enhancing productivity.📝 Customizable Data Parsing: Utilizes customizable VBA code to parse and extract relevant data fields from each Excel file, ensuring accuracy and flexibility.⚙️ Streamlined Workflow: Streamlines data retrieval processes, enabling quick access to crucial information and facilitating efficient analysis.🔗 Seamless Integration: Integrates seamlessly with Outlook and Excel, providing a user-friendly interface for streamlined data management and analysis.🚀 Enhanced Decision-Making: Empowers users with timely and accurate insights from Excel files, supporting informed decision-making and driving organizational success.The Outlook Excel Data Reader simplifies data extraction from Excel files received via Outlook, empowering teams with quick access to valuable insights for effective decision-making.

• Video

• Back

7th Project

The Power BI Formula 1 World Championship Dashboard is an immersive data visualization project that offers a comprehensive overview of the Formula 1 World Championship data spanning from 1950 to 2022. As an F1 enthusiast, I embarked on this project to leverage the rich historical data available on Kaggle, which aggregates all Formula 1 data from its inception in 1950 to 2022. This dynamic dashboard harnesses the power of Power BI to provide F1 new enthusiasts with visually compelling insights into key performance metrics, race results, driver standings, team statistics, and historical trends across decades of Formula 1 racing.📊 Historical Data Analysis: Analyzes Formula 1 World Championship data from 1950 to 2022, offering insights into the evolution of the sport over time.🏆 Driver Standings Over Time: Tracks drivers' performance across seasons, highlighting championship contenders and their standings throughout the years.📈 Interactive Visualizations: Presents race results, driver standings, team performances, and other key metrics through interactive charts, graphs…🔍 Customizable Filters: Enables users to tailor their analysis by applying filters based on specific seasons, races, drivers, teams…📉 Performance Trends: Tracks performance trends of drivers and teams over multiple seasons, allowing for deeper insights into their historical achievements and milestones.

• Video

• Back

T

T

About

Hello, I'm Hamza, an financial data analyst with a strong passion for data. I excel at transforming numbers into meaningful insights. With a meticulous approach and an enthusiasm for identifying trends, I specialize in interpreting financial data to support informed decision-making. Beyond the spreadsheets, I enjoy discovering how data can narrate stories and inform strategic planning.

• Curriculum Vitae FR

• Curriculum Vitae EN

• BACK