by Nikolai Pavlov | Jan 11, 2021 | Articles
When it comes to analytics, finance is often the first department in a company to push for transformation. Business intelligence (BI) and analytics can improve operations and provide the distinct advantages to finance departments. In this article, we take a closer...
by Nikolai Pavlov | Jan 7, 2021 | Video
In this video, we discuss how to perform a scenario analysis in Power BI using DAX. This is the second part of the tutorial. We’ll build the measures to calculate a percentage change in total sales when certain sales channels are selected. The example shows how...
by Nikolai Pavlov | Dec 27, 2020 | Video
In this video, we discuss how to perform a scenario analysis using DAX in Power BI. In the first part of the tutorial, we analyze how a price change affects total sales. To do this, we’ll build a supporting table with different price values, connect the table to...
by Nikolai Pavlov | Dec 19, 2020 | Articles
How can business intelligence (BI) help banks and other merchant acquirers? Traditionally, merchant acquiring has been a pretty straightforward business. Acquirers processed payment transactions, provided authorization and the settlement of payments. Put it simply,...
by Nikolai Pavlov | Dec 17, 2020 | Video
In this video, you’ll see a few examples of using SUMIF and COUNTIF in Power BI. When Excel users come to Power BI, one of their first questions is “How do I use SUMIF?” Turns out, there are no SUMIF and COUNTIF functions in Power BI. However, with...
