Clean Visualize Car Sales Data

I’m working with an Excel/CSV file that tracks car-sales figures, but the data is still raw: missing values, inconsistent labels, and scattered columns. I need the file cleaned, re-organised, and made ready for solid analysis.

Once the data is in shape, I’d like to see a clear story told through visuals. I’m open to every chart style that suits the numbers—column, line, pie, or any other graph that helps highlight trends in models, regions, sales cycles, and revenue. Use whichever mix of visuals makes the insights pop.

Deliverables
• A tidy, fully documented Excel workbook: no blanks in critical fields, accurate data types, and descriptive headers.
• Dedicated sheets or an in-workbook dashboard with interactive charts (column, line, pie, etc.) plus pivot tables where useful.
• A concise report (about one page) summarising key findings and notable trends.

Acceptance criteria
- All critical columns free of missing values; any assumptions clearly noted.
- Formulas, Power Query steps, or Power Pivot models refresh without errors.
- Each chart is labelled in English or Arabic and easy for non-technical readers to interpret.

Feel free to rely on native Excel tools, Power Query, or Power Pivot—whatever streamlines the workflow and keeps the file future-proof.