Monday, July 22, 2019

How To Create Formula (UDF) That Converts Number or Money Amounts to Words in Naira and Kobo or Dollars and Cents

›
The first time I was asked a question around this was in 2016 at a training I had for eHealth Africa in Kano. A couple of the finance mana...
7 comments:
Wednesday, May 22, 2019

Power BI DAX #5: SUMMARIZE

›
I once facilitated a Power BI training where the participants needed to generate a new table from the sales transaction data (that comes fro...
20 comments:
Wednesday, May 15, 2019

How To Automatically Pull In New Report Data Into Excel Using PowerQuery

›
One common situation most users of Excel face in making recurrent reports -- daily reports, weekly reports, monthly reports etc -- is that o...
1 comment:
Wednesday, May 8, 2019

Power BI DAX #4: CALENDAR, every sales/operations analyst friend

›
If there exists a book of ten commandments for Power BI, one of the commandments will be -- always have a date table. A date table is a ta...
Thursday, May 2, 2019

Power BI DAX #3: VALUES, another must know DAX formula

›
One common situation sales analysts face is capturing newly introduced products or SKUs or Region or Sales Rep in their reports. In Excel, y...
2 comments:
Friday, April 26, 2019

Power BI DAX #2: Meet the most popular DAX formula -- CALCULATE

›
Anyone wanting to do any serious data analysis with Power BI must be very good friends with CALCULATE.  Most books and online resources will...
2 comments:
Sunday, April 21, 2019

Power BI DAX #1: The Magic of CROSSJOIN

›
Last week I facilitated a training where the participants were staff of Nigeria Bottling Company (makers of Coca-Cola in Nigeria). After m...
15 comments: