Internship Roadmap Proposal
Industry-Oriented Internship on Data Science Using Advanced Excel, SQL, Python, Power BI &
Machine Learning
Domain: Data Science
Total Duration: 15 Hours (Short-Term Skill-Based Internship)
Mode: Offline / Hybrid
1. Internship Objective
Provide practical industry exposure by working on real-world datasets, analysis, visualization, and
model building.
2. Problem Statement
Organizations generate large volumes of data but struggle to extract meaningful insights for
decision-making.
3. Project Title
Customer Churn Prediction & Business Insights System
4. Project Description
Students will perform data cleaning, analysis, visualization, and build insights or predictive models
based on the dataset.
5. Tools & Technologies
• Advanced Excel
• SQL
• Python (Pandas, NumPy, Scikit-learn)
• Power BI
• Machine Learning (Regression, Classification)
6. Hour-wise Internship Roadmap (15 Hours)
Hours 1–2: Intro to Data Science
Hours 3–4: Excel Preprocessing
Hours 5–6: SQL Queries
Hours 7–9: EDA (Python)
Hours 10–12: ML Model Building
Hours 13–14: Power BI Dashboard
Hours 15: Presentation
7. Learning Outcomes
• End-to-end workflow understanding
• Data cleaning and analysis skills
• Visualization and reporting
• Practical project experience
8. Final Deliverables
• Project files
• Dashboard / Model
• Documentation & Presentation