TellCo Company:: Telecommunication Data Analysis

Check Dashboard:

👉 https://tellcoanalysis.herokuapp.com/

Check Assessment Presentation:

👉 https://docs.google.com/presentation/d/1Opcogw0O2Rc155wQduEI-9VOYQvsopqz/edit?usp=sharing&ouid=101895458432385123273&rtpof=true&sd=true

Table of Contents

• TellCo-Data-Analysis
  • Overview
  • Scenario
  • Approach
  • Project Structure
    • data:
    • models
    • notebooks
    • scripts
    • root folder
  • Installation guide

Overview

In this repository I have analyzed a telecomunications dataset of a company called TellCo. This project is part of 10 academy's training week 1 challenge. The project's objective is to analyze opportunities for growth and make a recommendation on whether TellCo is worth investing.

Scenario

You are working for a wealthy investor that specializes in purchasing assets that are undervalued. The investor is interested in purchasing TellCo, an existing mobile service provider in the Republic of Pefkakia. You will analyze a telecommunication dataset that contains useful information about the customers & their activities on the network.

Approach

The project is divided and implemented by the following phases

1. User Overview analysis
2. User Engagement analysis
3. User Experience analysis
4. User Satisfaction analysis
5. Serving results of the analyses on a web dashboard

Project Structure

The repository has a number of files including python scripts, jupyter notebooks, pdfs and text files. Here is their structure with a brief explanation.

data:

• the folder where the dataset csv files are stored

models:

• the folder where trained ML model files are stored

tests:

• the folder where tests for the python scripts are written

notebooks:

• Data Eploration and Analysis.ipynb: a jupyter notebook that explores, prepares and performs a general data analysis
• User Overview analysis.ipynb: a jupyter notebook that analyzes general users' behaviours
• User Engagement analysis.ipynb: a jupyter notebook that analyzes the engagement of users
• User Experience analysis.ipynb: a jupyter notebook that analyzes users' network experience
• User Satisfaction analysis.ipynb: a jupyter notebook that analyzes the satisfaction of users

scripts

• data_cleaner.py: a python script for cleaning pandas dataframes
• data_information.py: a python script for selecting data from a pandas dataframe
• data_loader.py: a python script for loading csv and excel files to a dataframe
• data_manipulation.py: a python script for manipulating dataframes
• graph_utils.py: a python script for plotting dataframes
• multiapp.py: a python script for creating a multipaged streamlit app
• overview_to_satisfaction.py: a python script that performs analysis and saves results
• results_pickler.py: a python script for collecting and pickling data
• sql_utils.py: a python script for creating and manipulting sql database

root folder

• app.py: entry point for the streamlit application
• Dockerfile: a configuration file for Docker
• requirements.txt: a text file lsiting the projet's dependancies
• Procfile: a configuration file for Heroku
• .gitignore: a text file listing files and folders to be ignored
• travis.yml: a configuration file for Travis CI
• setup.py: a configuration file for installing the scripts as a package
• README.md: Markdown text with a brief explanation of the project and the repository structure.

Installation guide

git clone https://github.com/DePacifier/TeleCo-Analysis.git
cd TellCo-Analysis
pip install -r requirements.txt