Tag: Financial Analytics

Power BI Tips & Techniques For Accounting & Finance

Power BI Tips & Techniques For Accounting & Finance

When completing financial reporting analysis in Power BI, it is highly likely that you will need to integrate data from many different tables into a format or data structure that works well within the Power BI data model setup. Getting your data model right is essential. To get your data model right for financial reporting

Continue reading

Calculating Percent Profit Margins Using DAX in Power BI

Calculating Percent Profit Margins Using DAX in Power BI

Working out your profit margins in Power BI with a basic data set can seem like it requires a few steps. Maybe you think you need to use calculated columns to get the result. Well, you certainly don’t need to do that – there is a much simpler way. Using measures, you can start with

Continue reading

Deep Dive Into Data Outliers – How To Discover And Analyze In Power BI Using DAX

Deep Dive Into Data Outliers - How To Discover And Analyze In Power BI Using DAX

Today, we’re going to work through some advanced logic. We’ll look to analyze just the outliers in our data. It’s not just the outliers we want to see, we also want to delve deeper into these outlier results to enable us to understand why they are so. This is where you can take your Power

Continue reading

How To Set Up Your Financial Reporting Data Within Power BI

How To Set Up Your Financial Reporting Data Within Power BI

Getting your financial reporting or financial analysis working well with Power BI requires your data to be set up in a particular way. Many times when you get data out of a financial system, be it from the revenue side, the expense side or the balance sheet side; you need to re-arrange it in such

Continue reading