Comprehensive Multi-Tool Data Analysis

I have a collection of datasets that need to be explored from every angle. First, I want a clear descriptive snapshot that tells me what is happening in the data right now. From there, I need predictive models that forecast future trends, and finally prescriptive recommendations that translate those forecasts into concrete, data-driven actions.

You are free to move between Excel pivot tables, Python (preferably pandas, scikit-learn, and matplotlib or seaborn), and R (tidyverse, ggplot2, caret) as each step requires. The end goal is a versatile analysis that can power business decisions, support an academic write-up, and improve day-to-day operational efficiency.

Please include:
• Cleaned and well-documented datasets
• Reproducible Excel workbooks, Python scripts or notebooks, and R scripts
• Visual dashboards or charts that highlight key findings
• A concise report summarising insights, model performance, and action points

I will review the work based on clarity, statistical soundness, and the ease with which I can rerun or extend your code.