Cape Town PowerBI May Meetup

Dear PowerBI Rangers,

Welcome back from all 4 day weeks in April. For this get together we will be doing some catch up with all that has happened in the last two months:

• Quick update on the official PUG site and a call to register on there.

• Power BI desktop new features – April Overview

• Power BI service new features – April Overview

• Power Bi Service – New Navigation

• Quick Measures

• Power BI data-set connector

• Power BI desktop new features – May Overview

PS – cash bar available as usual.

Looking forward to seeing you all there!


BI Intellicape April Meetup

Good Day Professionals!

This month’s agenda is as follows:

Session Type:
Interactive and Informal (please bring your questions and/or feel free to contribute to the discussion. The best way to learn is from each other)

Challenges and guidelines for introducing Power BI into your analytics organisation.

Are you still stuck in the chasm between “spreadmarts” and traditional BI? Did you think that business analytics tools like Power BI would make the pain go away?

We will chat about challenges and guidelines around the following- data culture- data organistion and roles- self-service lifecycle- data architecture

Toufiq has been practising data alchemy for more than 2 decades. He has a passion for turning data into business value using the Microsoft data platform. He is an untiring advocate of the durability of data design principles and processes which has survived technology evolution and the migration from on-premises to cloud.

We look forward to seeing you there.

The IntelliCape Team

PowerBI Campaign/Brand Management for Twitter

PowerBI has released a fantastic template for Twitter called Campaign/Brand Management for Twitter. After following the “wizard” you will have a complete report filled with sophisticated analytics.

In order to set this up, all you need is a twitter account and an Azure account. If you would like to play with this you can set up a trial Azure account.

To get started you can go to the following link
This will open the following page. Select install to start the “wizard”.

Next you will get a summary of what is needed to complete this Twitter template.

On the Login page you will connect to Azure. If you do not have a subscription there is a link to set up a free Azure trial. You will then select whether you have a personal or work Azure account.

If you are not sure what to put in the Azure Tenant section you can find this in the azure portal. If you hover over your icon on the top right hand corner it shall show you some details. It is the Domain details that you shall place in the Azure Tenant. It will have the “”

Once you click Connect to Azure you will need to accept that the Business Platform Solution Template can access your Azure account.

Once accepted you shall get a confirmation page that all was successfully validated and you can click on next to progress to the Source page.

On the Source page you will specify the database name to store the Twitter data, a username and a password. Make sure the password contains upper case, lower case and a special character.

Next you will need to check for availability, sometimes the database name you choose is already taken on another azure server.

Once validated you shall get the below screen and you can select next to go onto the Twitter page.

On this page you shall connect to Twitter. This will connect to your actual Twitter account. You can get data about any Twitter account using this. It is not limited to your own just because you are logging in. In this demo I take a look at the @MSPowerBI twitter account.

Complete your Twitter login details and authorize the Azure app to have access.

Once authorised you will get a screen to show you that your Twitter account has been validated and you can move onto the next page.

On the Search Terms page you can place in the twitter handles you would like to take a look at or the keywords you are keen on. You can do both by separating the two with the word OR.

Once validated you move onto the Twitter Handles page. This is where you can search all the Twitter handles you are interested in by separating them with a space. For this I took a look at @MSPowerBI and @Azure

After this you reach the Summary page. Once you click on run it starts to process all the data and build the report.

You then move onto the Deploy page where you can see the progress of the data being extracted and compiled in a report.

Once complete you shall get a notification and you can download your pbix file to view on your desktop.

BI IntelliCape February Meetup

Good day Professionals!

We are back from the festive season and ready to jump right back into the fire!

We’ve created a little PowerBI Dashboard so you can see information on the next meetup as well as a twitter account to help keep everyone up to date.

This month’s session is entitled : TOM and the CUBE

In this session we will look at using c# to create a tabular data model using TOM (Tabular Object Model).

We will investigate
• Defining a new Tabular Model
• Defining Columns and Hierarchies
• Defining Tables and Relationships

We will then hopefully deploy and process the new tabular model.

As usual please RSVP and tell your friends.

We look forward to seeing you there!

The IntelliCape Team