Data Visualizer Dash

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

Project: dashboard made for specific analysis of the net promoter score.

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

This project works like this:

How to use

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

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

How the dashboard works

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.

How does the NPS calculation work?

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.