Airtel Kenya Operations Cost Reduction Project: Business Analytics

This project report analyzes the operational costs of Airtel Kenya, aiming to identify opportunities for a 20% reduction, as requested by the Vice President of Operations. The project manager, after five years in the company, focuses on data analysis using SAS to evaluate costs across various departments, particularly highlighting high expenditures in the Sales department, including employee wages and error repair costs. The report presents findings through graphs and plots, revealing correlations between process errors and error repair expenses. Recommendations include strict monitoring and automation to reduce errors, particularly in the Sales department. The analysis suggests a need to redefine processes and operations to drive down expenses, ultimately aiming to improve profitability and efficiency through data-driven decisions and fact-based strategies.

Business Analytics
IP4
CTU
ABED AZZAM

TABLE OF CONTENTS
 ABSTRACT
 BACKGROUND OF DEPARTMENT
 INDUSTRY HIGHLIGHTS
 SAS
 FINDINGS OF PRELIMINARY RESEARCH
 CONCLUSION
 SUMMARY
 RECOMMENDATIONS
 REFERENCES

ABSTRACT
 Main objective of the project is to reduce the operation cost of
the Airtel Kenya.
 New vice president of operations want to reduce the operation
cost 20 %.
 Airtel Kenya is a leading communication service provider.
 The company provides cellular communication throughout the
country.

BACKGROUND OF DEPARTMENT
 I am Project manager of Airtel Kenya.
 I am working in the company since the last five years
 My roles and responsibilities
 Involves the process of design the operations
 Organize the needs for the operations
 Use the resource to make the final output
 Series of activities from supplier to customer

INDUSTRY HIGHLIGHTS
 Consider V-firm clothes manufacturing company.
 The company currently faces some issues
 Average output of clothes
 Higher production costs etc.
 Improve production rate and reduce the production cost by 20%

Solution
 Solutions they followed
 Automation process
 Adoption of the BI system and using the technologies for decision
making is more common.
 Use BI systems for data mining etc.
 Helps to the manager to make the right decision at the right time.
 Uses different data mining tools like SAS, SAP etc.

SAS DATA MINING
 SAS stands for Statistical Analysis System
 Used for advanced analytics, data management and multivariate
analysis etc.
 Helpful for analysing the dataset
 Excellent visualisation of the insights of the dataset

SAS TOOLS AND FEATURES
 Strong data analysis capabilities
 Highly flexible 4th generation programming language
 Supports different types of datasets for the analysis
 provides data security by data encryption algorithms
 Easy to learn interface

FINDINGS OF PRELIMINARY
RESEARCH
 SAS software is used for the data analysis
 Analyzed the previous year data related to the costs
 Contains information about the cost spent by the different
departments
 Results are shown as graphs and plots for easy understanding

Comparison of cost spent for
Labor wages and error repair
S a l e s Ma r ke ti n g Pr o d u c t
Ma n a g e m e n t
Or d e r p r o c e ssi n g T r a n sa c ti o n
p r o c e ssi n g
0.00
1,000,000.00
2,000,000.00
3,000,000.00
4,000,000.00
5,000,000.00
6,000,000.00
7,000,000.00
Labour costs error repair costs

Pearson correlation between
Process error and error repair
costs

Revenue generated by various
departments
61%17%
22%
Revenue
Sales Marketing Product Management Order Processing Transaction Processing