Business Analysis and Programming (ICT917)

Assessment -2 brief

Telecom Customer Churn Analysis using Python

Overview: In this assessment, students will analyse a Telecom Customer Churn dataset using basic Python programming concepts. The objective is to apply simple programming techniques to solve a real-world business problem and provide managerial insights.

Students are expected to demonstrate:

• Understanding of Python basics
• Ability to perform input/output operations
• Basic data processing using loops and dictionaries
• Simple data visualization
• Strong business interpretation and strategic recommendations

Business Scenario:

A telecom company is experiencing increasing customer churn. Management wants to understand:

• What is the overall churn rate?
• Which contract types show higher churn?
• What is the revenue impact of churn?
• What strategic actions can reduce churn?

Students must analyse the provided dataset and generate insights to support managerial decision-making.

Dataset: Telco Customer Churn downloaded from Kaggle is available on Moodle

Task Requirements:

Students must complete the following tasks:

Part A: Data Handling and Python Basics (20 Marks)

• Import the CSV dataset using Python.
• Store data using appropriate data structures (lists/dictionaries).
• Convert numerical fields correctly (e.g., MonthlyCharges, Tenure).
• Display sample records.

Expected concepts:

• Variables
• Lists
• Dictionaries
• Loops
• Conditional statements

Part B: Business Calculations (30 Marks)

Using simple Python logic:

• Calculate total number of customers.
• Calculate churn rate (%).
• Calculate total monthly revenue.
• Calculate revenue lost due to churn.
• Identify churn count by contract type.

Clear printed outputs must be shown.

Part C: Data Visualization (15 Marks)

Using Matplotlib:

• Create at least ONE bar chart (e.g., churn by contract type).
• Properly label:
  • Title
  • X-axis
  • Y-axis

Graphs must be readable and professionally presented.

Part D: Business Analysis & Interpretation (25 Marks)

Students must write a structured business report including:

• Executive Summary
• Problem Statement
• Key Findings
• Revenue Impact Analysis
• Strategic Recommendations
• Conclusion

The analysis must clearly connect Python outputs to business decisions.

Part E: Code Quality & Structure (10 Marks)

• Code is clean and well-organized.
• Proper comments explaining logic.
• Meaningful variable names.
• No unnecessary complexity.
• Runs without errors.

Submission Requirements:

Students must submit:

• Python Script File (.py)
• Business Report (PDF or Word)1500–2500 words
• Graphs included
• Screenshots of code output (if required)

10. Technical Guidelines

Students must:

• Use simple Python
• Use csv module or basic file handling.
• Use Matplotlib for visualization.

The focus is on applying basic programming to business problems.

11. Academic Integrity

• This is an individual assignment.
• Plagiarism will result in penalties as per college policy.
• Code must be original.
• Proper referencing is required for external sources (Harvard as per college guidelines).

12. Assessment Expectations 

To achieve high marks (Distinction level), students should:

• Demonstrate clear linkage between analysis and strategy.
• Provide financially meaningful interpretation (e.g., revenue impact).
• Suggest realistic and implementable recommendations.

13. Suggested Report Structure

• Title Page
• Executive Summary
• Introduction
• Methodology (Python approach)
• Data Analysis & Results
• Visualizations
• Business Insights
• Strategic Recommendations
• Conclusion
• References

GOOD LUCK!