Given an anonymized SQL Dump data from a telecom company over the years. Task here is to analyze and decide whether an investor should buy the company or not at the end.
The given data is an SQL dump file. It is about 180k rows of data.
- Load the sql dump file into postgres
- Write a script to read the database and make a dataframe
- Do basic EDA
- Clean data (remove duplicates, null values and normalize the distribution)
- Perform k-means clustering of the users by several metrics
- Report results and recommendations
Huawei B528S-23A
Apple iPhone 6S
Apple iPhone 6
Unknown
Apple iPhone 7
Apple iPhone Se
Apple iPhone 8
Apple iPhone Xr
Samsung Galaxy S8
Apple iPhone X
Most used device is a portable 4G router
- Apple
- Samsung
- Huawei
The company has a total of 107,000 users
- Gaming
- Netflix
- Youtube
For a company with a loyal user base, the firm seems to be capable of retaining its users at its current state. Since most users are gamers and they are young, they might find it easy if they see a minor issue in the QoS so you need to be careful. Proceed with care, gamers can destroy your reputation.