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

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,

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

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

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

Power BI DAX #1: The Magic of CROSSJOIN

Last week I facilitated a training where the participants were staff of Nigeria Bottling Company

How To Scrape Data From A Website Into Power BI (AbokiFX as an example)

Power BI is an amazing tool. I have used it to create amazing auto-updating dashboards

Comprehensive Financial Modelling and Financial Planning Training

Register for the upcoming hands-on Nigerian industry relevant Financial Modelling.Just 10 slots available! Our lead

Industry First (from UrBizEdge): Data Analysis As A Service. You’ll Love It!

We recently came up with this innovative solution for busy professionals. It is an industry

Join Us: Nigerian Excel Users 2018 Meetup on 1st September, 2018

Last year, we had a great time rubbing minds on the amazing things one could

SUMIF, SUMIFS, COUNTIF and COUNTIFS For Multiple Values of Interest At Once

In case you are not too familiar with SUMIF, SUMIFS, COUNTIF and COUNTIFS, they are