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

Excels Rank Functions

Using Excels Rank functions

Excels Rank functions have evolved over time, and give you the ability to ranks values in a list or column based on their value compared to other values in the same list or column. In Excel 2007 and previous versions, the function you would use to rank value is Rank and the syntax is: =RANK(Number, […]

Excel pimped with power

Excel Pimped with Power Tools

Excel is one of those tools that you just can’t live without.  It is used to store information, run calculations, carry out analysis, prepare report, visualizations and much more.  What’s just as important is the flexibility it gives to its +750 millions of users. This flexibility allows users create their own calculations and analysis, in […]

How to use SUMIF and SUMIFS in Excel

The SUM function in Excel is probably the most widely used function available.  In fact it is the only formula that has its own keyboard shortcut (Alt & =).  Therefore it should come as no surprise that this basic mathematical function has more powerful cousins available in Excel.  These functions are know as SUMIF and […]

Excel Power Trick – How to Combine a Folder of CSV Files

I previously published an article and video ‘Excel Power Trick – Save time without VBA’ which seems to have been very popular.  In this video we looked at using Power Query to get data from Excel sheets, format that data and then save the query for future use.  It’s amazing how much time 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 […]