Grocery Delivery Sales Analysis and Predictive Modeling
Budget: $30 – $250 USD
We are seeking a skilled freelance data analyst with expertise in Power BI to develop an interactive report and predictive model for a grocery delivery app. The goal is to analyze historical sales data, create a forecast model, and validate its accuracy using provided training data, supporting app development decisions.
We request a Power BI (.pbix) report analyzing data from six tables, where 3 of them contain order data (orders, prior sales and training data). The analysis should focus on historical trends and predictive accuracy, with interactive dashboards for exploration. See detailed requirements below.
Deliverables:
A PowerBI (.pbix) with at least 2 dashboards:
1. Dashboard 1: Historical analysis
- With 3 visualizations or more
- Interactive filters and slicers for dynamic data exploration
2. Dashboard 2: Forecast model
1 page summary explaining data cleaning, transformation and any modeling assumptions made during the analysis.
Ideal Skills:
Proficiency in Power BI Desktop for interactive reports
Strong DAX knowledge for custom calculations and KPIs
Experience with predictive modeling and time-series forecasting
Ability to clean and transform datasets
Skill in designing clear, actionable, and visually appealing dashboards
Downloadable dataset:
https://github.com/taloc/grocery_delivery_service/blob/main/grocery_deliveries.zip
To download the file from GitHub:
There are 6 files in the zipped folder.
Click the download raw file button in the upper-right corner of the file preview.
Choose a save location on your device and click "Save."
Compensation: $50
We request a Power BI (.pbix) report analyzing data from six tables, where 3 of them contain order data (orders, prior sales and training data). The analysis should focus on historical trends and predictive accuracy, with interactive dashboards for exploration. See detailed requirements below.
Deliverables:
A PowerBI (.pbix) with at least 2 dashboards:
1. Dashboard 1: Historical analysis
- With 3 visualizations or more
- Interactive filters and slicers for dynamic data exploration
2. Dashboard 2: Forecast model
1 page summary explaining data cleaning, transformation and any modeling assumptions made during the analysis.
Ideal Skills:
Proficiency in Power BI Desktop for interactive reports
Strong DAX knowledge for custom calculations and KPIs
Experience with predictive modeling and time-series forecasting
Ability to clean and transform datasets
Skill in designing clear, actionable, and visually appealing dashboards
Downloadable dataset:
https://github.com/taloc/grocery_delivery_service/blob/main/grocery_deliveries.zip
To download the file from GitHub:
There are 6 files in the zipped folder.
Click the download raw file button in the upper-right corner of the file preview.
Choose a save location on your device and click "Save."
Compensation: $50