Let's keep it simple, we all wish we can show live data visualisation and not have to fork out £10+ on sub every month.
Thanks to Peter of Think Happy Customer, I discovered https://datastudio.google.com. I regularly use this to track my daily behaviour and life tracking - (more on this soon).
Here are some examples of what others have built:
This one by Atos Consulting on MailChimp campaign in my fav:
and, how it was created:
But let's start at the basic, you will find the following youtube tutorial a great starting point.