Sales Data Analysis and Dashboard Development
Budget: $10 – $30 USD
I need help analyzing our retail sales data to gain valuable insights. The data is currently stored in Excel files and is updated monthly.
Key tasks include:
Data Cleaning: Prepare the data for analysis.
KPI Extraction: Identify and calculate key performance indicators such as:
- Total daily and weekly sales
- Top-selling products
- Performance of different branches
Power BI Dashboard: Create an interactive dashboard with features like:
- Geographical sales distribution map
- Branch performance comparison
- Sales trends over time
Deliverables: Cleaned Excel file and Power BI report.
Ideal Skills & Experience:
- Proficiency in Excel for data manipulation
- Strong experience with Power BI for dashboard creation
- Background in data analysis, particularly in a retail context
- Ability to present data in a clear, insightful manner
Key tasks include:
Data Cleaning: Prepare the data for analysis.
KPI Extraction: Identify and calculate key performance indicators such as:
- Total daily and weekly sales
- Top-selling products
- Performance of different branches
Power BI Dashboard: Create an interactive dashboard with features like:
- Geographical sales distribution map
- Branch performance comparison
- Sales trends over time
Deliverables: Cleaned Excel file and Power BI report.
Ideal Skills & Experience:
- Proficiency in Excel for data manipulation
- Strong experience with Power BI for dashboard creation
- Background in data analysis, particularly in a retail context
- Ability to present data in a clear, insightful manner