-
Book Overview & Buying
-
Table Of Contents
Financial Modeling and Reporting with Microsoft Power BI
By :
The previous chapter explained how to build your suite of financial reports. One of the foundations of that chapter was the importance of making sure your data is correct. This chapter describes a core skill of a good data analyst: testing and fine-tuning your data, which can be difficult and time-consuming. Why is that?
Data from financial systems is complex, and it's often the case that the data you see onscreen has been manipulated, filtered, and calculated to provide the result based on data within the database.
Data tables from finance applications are complicated. For example, they'll include voided and cancelled transactions, so straight sums of data will also include everything. Ensuring your data is correct is an essential task that'll become an ever-present skill throughout your time developing Power BI reports. Reports that were correct one day can be incorrect the next, and understanding this and how to fix...