Loomio
Tue 4 Jul 2017 8:40PM

Dashboard for the e-NABLE Social Media Ecology

EL Everton Lins Public Seen by 365

Thread dedicated to the creation of a dashboard for the e-NABLE Social Media Ecology that was proposed on this post: http://bit.ly/2tJ5Vjy

We count on the community participation to bring this initiative to life.

EL

Everton Lins Sat 8 Jul 2017 4:55PM

First test with the Power BI.

The final result will be a link like this embedded on a published web page.

Non-static and fully functional dashboard using the free version: http://bit.ly/2sRkNNC

JS

Jon Schull Sun 9 Jul 2017 9:11PM

Fantastic!

I've added these lines to the MediaMogul script I sent previously.

from pandas import DataFrame
DataFrame(articles).to_csv('articles.csv', header=True, index=False, encoding='utf-8')

and it generated articles.csv which I am attaching here in zipped form. Good luck!

EL

Everton Lins Mon 10 Jul 2017 9:25PM

After work on some bugs from Power BI, here it is -> https://goo.gl/6DLBTT

The first data import. We have 966 valid entries in the table.

In this first Dashboard we can see that there is a lot of blank data in the fields COUNTRIES, CITIES and PLACES.

The map takes a while to load the data but is accurate.
This is just a sample, now we can work on defining what KPIs can we get from this data and work on data structuration to adjust the blank and concatenated data on location fields and see if we can work on the dates to start analysing trends.

JS

Jon Schull Thu 27 Jul 2017 11:23PM

Everton, somehow I missed this. So sorry.

And you didn't grab me by the collar and shake me!

It looks really interesting!

EL

Everton Lins Fri 28 Jul 2017 9:46AM

Ha ha! No problem!
Now that we know that free Power BI works is just a matter of setting the goals for what information and KPIs you guys want to show and go for it. :thumbsup: