The role of both DAX SUM and SUMX functions is to add numerical data together. Yet both these functions are rather different. Let’s talk about the SUM function first. The SUM function is simple. It takes a column of data and adds the values to give a total. It works like the sum function in […]
CLICK HERE TO LEARN HOW TO DO THIS IN EXCEL WITH POWER QUERY Connecting to data sources and transforming data into a useable format can be complex, even when you are using a powerful tool like Power BI. I know many people that have started a transformation only to give up because they are not too sure […]
Sometimes it can be difficult to find a good data set to analyse. Kaggle offer data sets and run competitions on analysis and Microsoft also offer sample data sets such as World Wide importers. But sometimes a completely different data set is really cool to explore. Over the last few weeks I have been using […]
For some time now I have wanted to explore connecting Power BI with API’s, however the lack of knowledge of M, and time has held me back. But this week I got a chance to dig a little deeper with my idea. I decided to look at Google’s YouTube Data API. First I just want […]
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 […]
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 […]
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, […]
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 […]
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 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 […]