Overview This project focuses on analyzing the performance of various car models based on key metrics such as Duty Counts, Total Revenue, Total Hours, and Total Kilometers. It also includes calculations for averages of these metrics to derive valuable insights into the operational efficiency and revenue contribution of each car model.

Key Features All Cars Duty Count and Revenue Performance:

Summarizes the performance of all cars in terms of: Duty Counts: Total number of duties performed. Total Revenue: Overall revenue generated by each car. Total Hours: Total hours spent in operation. Total Kilometers: Total distance covered by each car. Highlights top-performing cars based on revenue and usage metrics. Individual Car Revenue Performance: Allows a detailed review of performance for a selected car. Metrics include: Duty Counts Total Revenue Average Revenue Shows trends in average revenue, hours, and kilometers. Interactive Time-Based Filtering: Provides the ability to analyze performance data for specific months.

Insights Derived Identification of high-performing cars with significant revenue contributions. Trends in operational metrics such as duty counts and kilometers over time. Comparative analysis of cars' efficiency and revenue generation. Tools and Techniques Used Microsoft Excel: For data organization, visualization, and interactive analysis. Dynamic Dropdowns: To enable car selection and month-wise filtering.

File Contents The Excel file contains: A summary table for all car performance metrics. A detailed performance dashboard for individual car analysis. Interactive slicers for month-based filtering.

How to Use Open the Excel file in Microsoft Excel (2016 or later recommended). Use the slicers on the dashboard to filter data by car or month. Explore key metrics to gain insights into car performance and revenue trends.

Future Enhancements Integration with Power BI for advanced visualizations. Addition of predictive analytics to forecast future trends.