Power BI Enquiry & Sales Dashboard

I'm seeking a skilled freelancer to help us develop a comprehensive Enquiry and Sales Dashboard using Power BI for our automobile dealership business. Our goal is to centralize data from multiple sources, providing a real-time, clear view of our performance across all branches.

Key Requirements:
- Integrate data from Excel files into Power BI.
- Include enquiry data, sales data, and employee performance data.
- Develop a user-friendly dashboard that allows for easy monitoring and analysis.

Important KPIs to Track:
- Conversion rate
- Enquiries per source
- Enquiry source breakdown
- Enquiries by location/branch
- Status of enquiries
- Follow-up effectiveness
- Lead aging
- Lost enquiry reasons
- Total units sold
- Daily enquiry vs. sales funnel (lead to booking to delivery)
- Month-on-month (MoM) comparison
- Year-on-year (YoY) comparison
- Target vs. actual trendlines

Ideal Skills and Experience:
- Proficiency in Power BI and data visualization
- Experience with integrating Excel data into Power BI
- Strong analytical skills to design and implement KPIs
- Ability to create intuitive and interactive dashboards
- Understanding of sales and enquiry processes in the automotive industry

We will discuss detailed KPIs, trend comparisons, and design expectations during the project discussion phase.

We are excited to see how you can help us transform our data into actionable insights!