Financial Performance Analysis Project

Overview

This project focuses on conducting a comprehensive financial analysis, emphasizing the annual and quarterly performance metrics for the year 2021.

Project Highlights

• Analyzed monthly sales revenue, net sales, costs, net profit, and contribution margin.
• Developed insightful charts and visualizations to communicate key financial insights.
• Automated workflows to ensure consistent and accurate data entry, enhancing data quality.
• Conducted data transformation activities such as cleansing, scrubbing, and profiling.

Key Files

• financial_analysis.pdf: Pdf file containing the detailed financial data for the analysis.
• financial_report_yoy2021.md: Md file containing the detailed financial report for the year of 2021.

Usage

• Open financial_analysis.pdf to explore the detailed financial data and the visualizations showcasing performance trends.

Dependencies

• Excel: Used for storing, organizing and analyzing financial data.
• Data analysis: Utilized for processing and transforming data.