Document Entire Excel Workbook with the Click of a Button

Document Entire Excel Workbook with the Click of a Button

Why Document an Entire Excel Workbook You already know the story…. or do you…..? So the internal accountant produces a monthly pack for management, which contains financial information. These reports are fantastic.  Detailed Sales reports show sales against budget, against prior year, as a 12 month rolling total. They are also further sliced against sales […]

Decoding M – Exploring the YouTube Data API with Power BI

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 […]

Quickly gather statistics for your data using Excels Descriptive Statistics

Excels Descriptive Statistics will quickly allow you calculate a number of statistics from multiple columns of data at a time. The statistics include Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count In this video you will learn how to activate the Data Analysis tool pac in Excel and how […]

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 […]

stastics correlation coefficient excel

How to Calculate Correlation in Excel with the Data Analysis ToolPac

Correlation is a statistical measure that shows how two variable might move together.   For Example as the price goes down, the sales volume might go up, or as the weather gets warmer, sales volume might decrease.  These types of correlation might be obvious in some organisations, but looking at the correlation between different data sets […]

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 […]

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, […]

How to find the Nth Largest in Excel

Both MIN and MAX in Excel will return the Minimum or Maximum value from a list.  But what if you want to return a value that is the Nth smallest or the Nth largest in Excel? How would you go about this type of Ranking? You could use one of Excels Rank functions and sort by […]

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 […]