To find the sales analysis, focusing on month and year-wise trends.

Introduction: Sales analysis focuses on month and year-wise trends to uncover seasonal patterns, measure progress over time, and evaluate key metrics. This analysis delivers actionable insights to support informed decision-making in optimizing sales strategies.

 

Requirements:

 

Read the table sales_data_analysis'

 

Month and Year-Wise Analysis: Aggregates date(Sales_Date) by Year and Month.

 

Calculates total sales (Sales_Amount) and transaction count (Sales_ID) for each month and year.

 

Additional Yearly Insights: Summarizes total sales and transaction count by Year.

 

Final Output: Displays month-year-level and year-level sales summaries.

 

Write the Pyspark code without syntax error.

 

Unity Catalog details: sales_data_analysis