tweets report

To explore the data that we stored in the cube we need to open an excel file and create a data connection to our cube. In order to do that we need to follow the next steps:

Go to the Data tab and in the “From other source” options choose From Analysis Services

Create data connection

Indicate the name of your server instance

Create data connection 2

Select the cube that you want to use

Create data connection 3

Now you can choose between insert a Pivot Table, a Pivot Chart or a PowerView Report, I will begin inserting a Pivot Chart

Create data connection 4

Using the right panel you can choose the measure and dimension you want to use in your charts.

Pivot Chart Options

These are some expamples of chart:

User more influents (base it in their amount of followers) that tweet about our search criteria

Chart 4

Number of tweets by month and year

Chart 2

Numbers of tweets by date

Chart 3

Numbers of tweets by location

Chart 4

We also can create a Power View report creating a Power Pivot Data Source, to do this go to the Power Pivot tab and click the Manage option.

Now we need to create a data connection

PowerPivot Connection

PowerPivot Connection 2

Click Design

PowerPivot Connection 3

Now drag and drop the measures and dimension properties that you want to use in your data source.

PowerPivot Connection 4

PowerPivot Connection 5

Click Finish

PowerPivot Connection 6

Now you can close the Power Pivot windows and in a new sheet go to the Insert tab and select Power View

PowerPivot Sheet

Use the right panel to indicate the measure and dimension that you want to use on the report.

This are some examples:

Evolution of tweets by day (Using the scatter chart)

Chart 5

Amount of tweets by location (Using the map chart)

Chart 6