Objective
Train interns to turn raw business data into actionable insights: clean data, segment customers, forecast demand, and produce executive reports suitable for Alfido Tech stakeholders.
Features
- Data cleaning and validation
- Segmentation and RFM analysis
- Time-series forecasting and scenario planning
- Executive-level reporting with visuals and recommendations
Tools
Beginner Level Tasks
- Download any dataset and inspect for missing values, duplicates and inconsistent data types.
- Create a cleaned version and document the cleaning steps in a README.
- Produce 3 charts showing core business metrics and write a short insight for each.
Note: Complete any 3 tasks out of the 4 main tasks below.
Tasks (4)
Dataset
https://www.kaggle.com/datasets/kyanyoga/sample-sales-data
Goal
Clean the sales dataset, derive core sales KPIs and highlight data quality issues. Produce insights on sales by region, product and time.
Requirements
- Data cleaning: missing values, date parsing, inconsistent categories
- Compute KPIs: total sales, avg order value, top products, monthly trend
- Visualize sales trends and provide 5 actionable recommendations
Deliverables
- Cleaned dataset (CSV) and notebook/Excel with steps
- PDF summary with charts and recommendations
Dataset
https://www.kaggle.com/datasets/vetrirah/customer
Goal
Segment customers using RFM analysis or clustering and profile each segment for targeted marketing.
Requirements
- Compute RFM metrics and create segments or use KMeans clustering
- Profile segments by key metrics (avg order, frequency, recency)
- Recommend 3 targeted strategies for high-value segments
Deliverables
- Notebook or Excel with segmentation steps and output
- Slide or PDF with segment profiles and recommendations
Dataset
https://www.kaggle.com/datasets/robikscube/hourly-energy-consumption
Goal
Use the hourly time-series dataset to build a forecasting model (aggregate to daily/monthly if needed) and predict future demand or sales.
Requirements
- Prepare time-series (resample/aggregate) and handle missing timestamps
- Apply a forecasting method (Prophet/ARIMA/ETS) and evaluate using MAPĒ/MAE
- Provide scenario-based forecasts and confidence intervals
Deliverables
- Notebook with preprocessing, model and forecast plots
- Short report interpreting forecasts and suggested business actions
Dataset
https://www.kaggle.com/datasets/nuts17/business-insights
Goal
Create a polished business insights report combining visualizations and strategic recommendations tailored for Alfido Tech leadership.
Requirements
- Perform EDA and produce 6–8 high-quality visuals
- Write an executive summary with 5 prioritized recommendations
- Provide supporting data tables and assumptions
Deliverables
- PDF report or PPT with visuals and findings
- Notebook/Excel with analysis steps and raw outputs
How to Submit Your Tasks
-
For each task:
- Create a separate document (DOC, PDF) or notebook with code, visuals and a 1-page executive summary.
-
Upload artifacts:
- Upload notebooks & files to GitHub; dashboards to Tableau Public or Power BI; large files to Google Drive with public links.
-
Submit links:
- Go to the Task Submission page and paste your links, clearly mentioning the task numbers.
Tip: Use clear visuals, document assumptions, and link recommendations to measurable KPIs for Alfido Tech.