https://dashcx.felippefn.repl.co/

• Dashboard in Python language, styled in Css, created to visualize and process data
• obs: the project is in portuguese.

To use this dashboard, you just need to visit the link down below.

https://dashcx.felippefn.repl.co/

The python script found in the file main.py, reads a file in excel, extracts column by column the necessary information and computates it as a data model for visualization. After extracting the information, the NPS (Net Promoter Score) is calculated. In this way, the user can verify all the information of the conditions established in this topic:

You can choose the month, year and communication channel with the customer.

The NPS calculation is very simple. Percentage of Promoters - Percentage of Detractors (%Promoters - %Detractors).

The function of this calculation is that:

def nps_calculate(list_):
    detractor = []
    neutral = []
    promoter = []

    for item in list_:
        if item < 7:
            detractor.append(item)
        elif item > 8:
            promoter.append(item)
        else:
            neutral.append(item)

    total = detractor + promoter + neutral
    nps = ((len(promoter)/len(total))*100) - \
        ((len(detractor)/len(total))*100)
    if nps >= 0:
        nps = nps + 0.45
    else:
        nps = nps - 0.45
    return nps

particular recognition to
Vinicius (https://github.com/Vinicius-Santoro) who made this increadible README
Pedro (https://github.com/pedrokrivochein) who supported me with some bugs and problems.