Health Score dashboard

I've done dashboards before, but for this particular task, I wanted to master the skill of data visualization. So I began researching on how to make an excellent dashboard design. I bought a book called "Information Dashboard Design" by Stephen Few to start my learning journey. The book blew my mind. For the first time, I realized that there were many reasons behind a good dashboard, and that my past designs had a lot of flaws. Soon after, I bought two more books on the same topic while I began my journey to make the best Health Score Dashboard that I could make.

I also wanted this dashboard to be easy to maintain. In my experience, one of the problems I had with dashboards was the long time it demanded to update the data.
I used Mysql to make the queries that would feed my dashboard. When I finished my queries, I began to study ways to optimize them. In doing so, I optimized some queries by almost 90%. I figured out many ways to optimize a query. For example, I discovered that, in some cases, using a left join versus a join could make a huge difference. Also, limiting the query results when necessary helped a lot in the performance.
Then, with a colleague's help, we managed to store this data in a Google Sheet using Appscript. This way, I could access data from every client and keep it in a sheet with just one click. It was a very cheap way of making this happen.

For the visualization, I began understanding the limits of the tools that Data Studio and Power Bi had to offer for the goal that I had in my mind.  I learned a lot using both tools, and I did two versions of the dashboard. Each of them had an advantage over the other, but both resolved the end goal efficiently.
Using this tool, I contacted the customers with the lowest scores and managed to help them improve it. In  6 months, I increased the overall score by more than 25%, and managed to save customers from churn.

This dashboard also helped us understand what customers with the best scores valued the most from our product.