Financial Variance Data Analysis

I have a dataset of financial figures drawn from our internal systems, and I need a focused variance analysis that pinpoints where actual results diverge from plan. The task is squarely about data analysis rather than ETL work; however, you may do light cleaning if it helps you reach accurate conclusions.

Here is what I expect:
• A concise explanation of your methodology (tools such as Excel-Power Query, Python pandas, or R are all fine).
• A set of variance calculations broken down by the dimensions you recommend (e.g., period, cost center, product line).
• Visual aids—charts or dashboards—that make those variances instantly clear to leadership.
• A brief narrative highlighting the main drivers behind the largest positive and negative gaps.

I will share the raw financial data in CSV format once we start. Accuracy and clarity are paramount; the final file and an executive-style PDF summary will complete the engagement.