Power BI and Microsoft Cognitive Services to extract Key Phrases from Text

Power BI and Microsoft Cognitive Services to extract Key Phrases from Text

Extracting key phrases from text can be a key element of text analytics. It would be commonly used by brands when listening to what their customers are saying across social media, such as Facebook and Twitter comments and posts.  It’s also often used to analyse survey results.  In my example below, I have used Microsoft […]

Must Have Resource list to Master Power BI

The Must Have Resource list to Master Power BI

For those of you that know me or have followed me for some time, you will know that I have always been a lover of Excel.  When Microsoft introduced the Excel Power Tools, Power Query, Power Pivot and Power View I was in my element.In 2015 Microsoft released Power BI – A self-service business intelligence […]

Sentiment Analysis with Power BI and Microsoft Cognitive Services

Sentiment Analysis is the analysis of text to see if the overall sentiment is Positive or Negative. It would be commonly used by brands when listening to what their customers are saying across social media, such as Facebook and Twitter comments and posts.  It’s also often used to analyse survey results.  In my example below, […]

dial gauge power bi custom visuals

Power BI Custom Visuals – Dial Gauge

Power BI is equipped with many different visualization that you can use to tell the story of your data.  In addition to the standard visuals, Power BI also allows you to import custom visuals.  If you have experience with R then you are only limited to your imagination. Most of us however are not experienced […]

Power BI Custom Visuals - Using Text to Generate a Word Cloud

Power BI Custom Visuals – Using Text to Generate a Word Cloud

I have been asked a number of time how I created the word cloud in the Power BI Facebook analysis report shown in a previous video. So I thought it deserved a post on it’s own.  I tend to focus more on numerical data, so it is a nice change to show you how you can […]

forecasting in Power BI

Forecasting in Power BI

Forecasting in Power BI will allow you take a time series of data and make predictions or estimates about the future.  The forecasting tool is available in the analytics pane on Line charts.  At the moment it is only available in single value line charts.  And it is only available in Power BI Desktop and not services […]

Power BI Content Packs

Power BI Content Packs – Analyse Mailchimp and Google Analytics

Big data and the data trend is everywhere. But I know many small businesses believe all of this is out of their reach. the belief is that it costs too much and they don’t have the skill set. Let me introduce you to Microsoft Power BI services and their Content Packs – best of all, […]

Publish Reports from Power BI Desktop to Power BI Services

Publish Reports from Power BI Desktop to Power BI Services

When you create a report in Power BI Desktop there are a number of reasons you might want to publish it to Power BI services. Maybe you  want to share your report with others with in your organisation You might want to embed the report on a website You need to add reports to an App […]

manage measures in PowerBI

How to Manage Measures in PowerBI

So you have connected all of your data into PowerBI and you have transformed and shaped it.  Now all you need to do is create some calculations, know as measures, so you can begin to make some visualizations. Off you go and do the normal SUM, Count and Average DAX functions across a number of the tables […]