تحليل بيانات مبيعات وإعداد تقرير تفاعلي (Dashboard) لعرض النتائج باستخدام Pivot table

We have a dataset of our sales performance, summarized in four main Excel files:

Total Sales by Product Category

Total Sales by Store

Total Sales by Gender and Country

Total Annual Sales by Customers

We are looking for a skilled data analyst to help us turn this data into actionable insights.

Your tasks will be:

In-depth Data Analysis: Analyze the provided data to identify key trends, patterns, and insights. For example:

Which product categories are our best and worst sellers?

Which stores are performing the best, and what are their annual sales trends?

Are there differences in purchasing behavior between genders across different countries?

What is the sales growth pattern over the years?