Loomio
Tue 4 Jul 2017

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 Thu 6 Jul 2017

Hi @andrewbrow .
I see that you can help with troubleshooting and review and that will be great!

On this first step we need to better understand how this propose here http://bit.ly/2rRwaEE can help.
As you have some experience with Python can you help us evaluate the effort / technical knowlege involved in to develop something using this?

Thank you!

AB

Andrew Brow Thu 6 Jul 2017

@evertonlins I'm on it!

EL

Everton Lins Thu 6 Jul 2017

@jonschull @andrewbrow do you know Microsoft Power BI?

This tool is free (for a certain number of registers) and can be published.
*
This video explains how to use it: https://www.youtube.com/watch?v=h6AIAxMEDiw
* https://powerbi.microsoft.com/pt-br/pricing/

Based on Andrew's evaluation we can define if this is an option to help with data sanitation in parallel to the development or even an option to attend specific dashboard needs.

Here in Brazil many companies are using the free version for small databases.

AB

Andrew Brow Thu 6 Jul 2017

@evertonlins @jonschull Microsoft Power BI seems much more user friendly when it comes to building the dashboard. This would be a great place to start building in the features that we think are the most pertinent. From there, we can explore using Dash. Dash has seemingly endless options that are only limited by ones Python experience. I know a little and can surely learn more as I go along. After all, I did get a degree in "Critical Thinking" for a reason. I say we test our ideas out with the free version of Microsoft Power BI and either upgrade to Pro ($10/month for a single user) or move to Dash if we want to expand functionality. Moving forward we need to determine what kind of data we want to portray and, more importantly, how we will collect that data.

EL

Everton Lins Thu 6 Jul 2017

Thanks, @andrewbrow !

I believe that at this point the best path to follow is to create the business case with the assumptions, constraints and goals that will guide the project and use Power BI (free version) for prototyping the final solution. In this way, no coding/development is needed in this first phase.

And of course, if the prototype becomes good enough we can use this free version of Powe BI as the final solution if everyone agrees that is fit for use and also fit for purpose as well.

I'll start a proposal for this and after that, we can start planning the next steps.

EL

Everton Lins started a proposal Thu 6 Jul 2017

Do you accept to use Power BI (free version) to prototype final Dashboard solution? Closed Sun 9 Jul 2017

By using Power BI (free version) no coding/development is needed in this first phase and the team can focus on data acquisition, modelling and definition.

Agree - 3
Abstain - 0
Disagree - 0
Block - 0
3 people have voted (42%)
EL

Everton Lins
Agree
Thu 6 Jul 2017

I think is the easiest way to start.
"Dream big. Start small. But most of all, start."

AB

Andrew Brow
Agree
Thu 6 Jul 2017

JS

Jon Schull
Agree
Fri 7 Jul 2017

I'm game! I'm not familiar with this but its an impressive video. Perhaps we should start with the media data corpus I created....?

EL

Everton Lins Fri 7 Jul 2017

@jonschull I already have the Power BI desktop version.
If you could share a sample of the data I can do some work over the weekend. The tool can import txt, csv, xls and xml.

EL

Everton Lins Fri 7 Jul 2017

About licensing,

I strongly believe that e-NABLE is eligible for a Power BI subscription for free.

Nonprofits Case studies
*
https://www.microsoft.com/en-us/philanthropies/product-donations/casestudies

Eligibility
*
https://www.microsoft.com/en-us/philanthropies/product-donations/eligibility/

EL

Everton Lins Sat 8 Jul 2017

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

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

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

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

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: