topic Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes! in Data Stories Gallery

Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

SamLester — Tue, 08 Nov 2016 00:17:31 GMT

Create your own personalized Twitter Analytics Dashboard in Power BI

When I do Tweet the most? What day and hour do my Tweets receive the most interactions and impressions? With Power BI, these questions are very simple to answer. In this blog, you’ll learn how to export your Twitter Analytics stats to use as a data source in a pre-built Power BI template provided here. Once you import the data into the template, you can explore many other interested metrics, such as the number of retweets, link clicks, profile clicks, and more.

The first step to creating this simple dashboard is to export your Twitter stats from http://analytics.twitter.com/.

Navigate to http://analytics.twitter.com/
Click on “Tweets” on the top ribbon
On the right, you’ll see a button that defaults to the “Last 28 Days”, change this to the data range for the past 90 days (maximum allowed), and click on “Export Data” to export the .csv

Next, download the Power BI Template from here and continue with the following steps:

Download and open the attached TwitterAnalyticsDashboardTemplate.pbit file and open it in Power BI Desktop
Click on “Edit Queries” in the top ribbon
On the right side, you’ll see “Applied Steps”. Click on the gear icon next to the first step titled Source.
Change the file path to point to your exported stats and click on OK
Click “Close & Apply” in the top ribbon bar and your dashboard will be populated with your exported stats

Enjoy,
Sam Lester (MSFT)

eyJrIjoiZDE3NTU1OTMtOGY3ZC00MjEwLWFiNjEtZDFkNTc4NDc3YjVmIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0NyIsImMiOjV9

Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

SivaSevala — Fri, 03 Feb 2017 06:22:13 GMT

when i connect to " http://analytics.twitter.com/ " it is only getting one table , i.e Document table.

i have attached a screen shot for your reference. please correct me where i did wrong.

siva.

Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

SivaSevala — Fri, 03 Feb 2017 06:26:28 GMT

when i connect to " http://analytics.twitter.com/ " it is only getting one table , i.e Document table.

i have attached a screen shot for your reference. please correct me where i did wrong.

siva.

Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

SamLester — Sun, 05 Feb 2017 21:44:08 GMT

SivaSevala Hi Siva, this dashboard is created based on the .csv file exported from analytics.twitter.com, so the Power BI data source is a .csv file as opposed to a web source. My guess is that you're seeing the error because you are trying to use "Get Data -> Web" and pointing to the URL. Instead, it's a two step process to 1) Export the stats to .csv from analytics.twitter.com, and 2) Update the source in the Power BI dashboard to point to the downloaded export file.

Please let me know if you have any other questions.

Thanks,
Sam Lester (MSFT)

Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

Anonymous — Wed, 24 May 2017 21:37:16 GMT

Hi Sam.,

I am trying to implement Twitter dashboard for my product based company and wanted to see like how many tweeted, retwetted, likes, followers etc..

I am not be able to login for my company twitter as I don't have credentials, is this only option what you have provided or do we have alternative approach.

Pls let me know any other approach to do more analysis.

Thanks,
Thimma

Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

vjnvinod — Fri, 25 May 2018 10:00:01 GMT

is this possible for linkdin?

Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

maalmerri — Tue, 21 Sep 2021 08:26:52 GMT

Hi,

I really like your report and theme layout! It look amazing, elegent and proffesional.

Is it possible to share the PBIX file & Proper steps to me via email maalmerri@scad.gov.ae?

Appreciate that!

Re: Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

Icad01 — Tue, 21 Sep 2021 10:58:45 GMT

Nice work 🙂