sales Data Analysis Project

Job ID: 38345382

Budget: $30 – $250 USD

Attached are the monthly sales sheets for our six clinic branches (SABA1, SABA2, SABA3, SABA7, Tala, and Watanak).

Five branches are combined in the "SABA" sheet, and Watanak's data is in a separate sheet.
Please provide a deep analysis with graphs and visuals of the total cumulative 6-month sales for the Dermatology and Dental departments across all branches. This analysis should be based on the basic price only, ignoring homecare business data.

For more clarification, for Dermatology, I need the total sales for fillers, laser hair removal, and best-selling packages/offers, with a breakdown for each individual item. Similarly, for Dental, I require the total sales and a breakdown of the best-selling services.

Please deliver the results in organized Excel sheets and a PowerPoint presentation, including graphs, visuals, key findings, and recommendations for the best-performing offers and services.

or may be you can create a dynamic template for a dashboard where i can add data and get an instant visualization to it