Grocery Delivery Sales Analysis and Predictive Modeling -- 2
Budget: $30 – $250 USD
Price: $50
Time estimate: 3 - 4 hours
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
3- 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
Skills Required
Data Visualization | Power BI | DAX | Predictive Modeling | Time-Series Analysis | Data Cleaning | Sales Analytics
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."
Time estimate: 3 - 4 hours
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
3- 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
Skills Required
Data Visualization | Power BI | DAX | Predictive Modeling | Time-Series Analysis | Data Cleaning | Sales Analytics
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."