Instructions:

Instructions on Final Year Project: $[$Develop a webpage with DevOps Practice$](40\%)$

Scenario:

You are employed as a data analyst at XYZ Corporation, a leading financial services company. The company has provided you with a dataset containing financial information for the past fiscal year. The dataset is in Excel format and includes data on revenue, expenses, profits, and other relevant financial metrics for each quarter.

Task:

Your task is to leverage data cleaning and visualization techniques to analyze and present the financial data effectively. The company's management is particularly interested in gaining actionable insights to inform strategic decision$-$making.

Requirements:

Data Cleaning $(10\%)$: Begin by inspecting the dataset for any inconsistencies, missing values, or outliers. Clearly document and execute data cleaning steps to ensure the dataset is ready for analysis. Discuss the impact of any decisions made during the cleaning process.

Data Visualization $(30\%)$: Create a series of visualizations to effectively communicate key insights from the financial data. Consider using appropriate chart types for different types of financial metrics. Your visualizations should cover, but are not limited to:

Composition

Comparison

Trend

Distribution

Ensure that your visualizations are clear, well$-$labeled, and provide meaningful insights. Justify your choice of visualization types.

Submission Guidelines:

Submit a report that includes:

A detailed description of the data cleaning process, including any transformations or imputations.

Visualizations with clear titles, labels, and interpretations.

An explanation of how the visualizations contribute to understanding the financial performance.

Any assumptions made during the data cleaning and visualization processes.

Note: Your analysis should be focused on providing a clear and concise overview of the financial data, emphasizing insights that are relevant for strategic decision$-$making.

Once your task is completed, Make a Submission.