Interactive Power BI Report for Car Dealership
Budget: $30 – $250 CAD
I need an interactive Power BI report for our family-owned car dealership in Ontario, Canada, using provided datasets. This report will be primarily used by our managers.
Data Files Provided (sample CSVs):
- Transactions.csv
- Products.csv
- Customers.csv
- Employees.csv
- Locations.csv
- Inventory.csv
Requirements:
- Build a clean data model with appropriate relationships.
- Create calculated measures using DAX:
- Total Revenue
- Total Profit
- Average Order Value
- Monthly Revenue Trend
- Design interactive visuals with filters/slicers for:
- Product Category
- Region (City level)
- Time Period
- Include visuals such as:
- KPI cards
- Bar/column charts
- Line charts (e.g., time trends)
- Matrix or table views
- Add at least 2 pages: Overview & Inventory
Ideal Skills & Experience:
- Proficiency in Power BI
- Strong DAX knowledge
- Data modeling expertise
- Experience in creating interactive dashboards
- Attention to detail and good visualization design skills
Looking forward to your bids!
Data Files Provided (sample CSVs):
- Transactions.csv
- Products.csv
- Customers.csv
- Employees.csv
- Locations.csv
- Inventory.csv
Requirements:
- Build a clean data model with appropriate relationships.
- Create calculated measures using DAX:
- Total Revenue
- Total Profit
- Average Order Value
- Monthly Revenue Trend
- Design interactive visuals with filters/slicers for:
- Product Category
- Region (City level)
- Time Period
- Include visuals such as:
- KPI cards
- Bar/column charts
- Line charts (e.g., time trends)
- Matrix or table views
- Add at least 2 pages: Overview & Inventory
Ideal Skills & Experience:
- Proficiency in Power BI
- Strong DAX knowledge
- Data modeling expertise
- Experience in creating interactive dashboards
- Attention to detail and good visualization design skills
Looking forward to your bids!