Analyzing Twitter Data using PowerBI

A popular software that can analyze data is Microsoft’s Power BI. Many people call it ‘Excel on steriods’, which is an easy way think of it.

I’ve been going through bootcamps/tutorials/courses to better learn PowerBI because I believe it is a great solution for businesses, which includes law firms and legal tech companies. We are in the midst of a data storm with more and more data being created every day. I’ve repeatedly heard people saying they know their company has (or produces) a lot of data, but it is “messy”.

Messy data is a whole other blog post. For now, I’m going to start posting examples of charts, tables, and dashboards I’ve created after analyzing data using PowerBI.

And the first one has to do with looking at data from my Twitter account, @SaraKubik.

Here is the final dashboard:

Here are the steps I took:

  1. In Twitter, go to <More, and then <Analytics.

You’ll be presented with a new page, and I encourage you to explore Twitter’s own activity measures. They are quite good. I want to download data from Twitter so the next thing I do is….

2. At the top of this page, click on <Tweets

3. I changed the button that says “Last 28 Days” to various months.

4. I then downloaded the data by clicking on the “Export Data” button and selected “By Tweet’. Remember where you’ve saved each of these csv files.

5. Now fire up PowerBI, or more specifically, PowerBI Desktop.

Power BI Desktop is part of the Power BI product suite. It’s free and available for download here:

6. Open Power BI Desktop and select <Get Data.

I’m not going to explain in detail what I did in Power BI Desktop. Overall, I imported the four csv files, merged them together, transformed the data, analyzed it, and created various charts, plots and text. I placed them on an interactive dashboard so a user can click on the charts and plots and drill down for more details.

My goal when creating any data visualization is to present material clearly. I’m not one of those designers who over designs. I want the users to be able to understand the visuals, not be intimidated by them, and be able to gleen answers and conclusions off of what I’ve created. I can talk geek all day long. But in the end, I believe visuals need to be easy to understand.

7. The final step I took was to publish the dashboard.

Here’s the thing, that’s not a free service. You’ll need to purchase Power BI Premium in order to publish your Power BI Desktop reports. There are other benefits when you purchase Power BI Premium, and it’s not terribly over-priced (I’m doing the $10/month plan).

I hope you’ve enjoyed this post. I’ve enjoyed making it because I love challenges and learning new things. I’m going to start posting more Power BI material soon.

Sara Kubik