Port Container Throughput Data Analysis

I have a spreadsheet that tracks container-throughput from the Port to the ICD over time. I need a clean, reader-friendly report that tells the whole story hidden in those numbers.

Scope of work
First, lay out a solid descriptive analysis that covers total throughput and the day-to-day movement patterns. Next, build a predictive model so I can see how volumes may evolve in the near future. Finally, compare key periods and parameters to uncover how performance differs across time frames or operational variables.

The descriptive section must highlight:
• Total throughput
• Daily trends
• Trends specifically linked to Containers Received and any relationships you uncover between variables

Deliverables
• A written report (Word or PDF) summarising findings from the descriptive, predictive and comparative perspectives
• Clear charts or dashboards (Excel, Power BI or similar) that illustrate total throughput, daily trends and your predictive forecasts
• A short methodology appendix explaining any statistical techniques or models used so results can be replicated

Acceptance criteria
The report should read smoothly for non-analysts, every chart must be clearly labelled, and the predictive component needs to include basic accuracy metrics (e.g., MAPE or RMSE).

If you are comfortable pulling insights from raw data with tools like Excel, Python (pandas, matplotlib, scikit-learn) or Power BI and can turn numbers into a story, I look forward to your approach and estimated timeline.