-
Book Overview & Buying
-
Table Of Contents
Financial Modeling and Reporting with Microsoft Power BI
By :
In the previous chapter, we focused on an applied area when working with finance data: manual journal entries. In this chapter, we're going to change direction by focusing on some of our standard practices when shaping and managing the data we use for our semantic models.
When we think of Power BI, we need to think of two tools, not one. Power BI comprises Power BI and Power Query; the latter is launched by clicking the Transform data button from the Power BI ribbon and is used every time we work with Power BI. We're certain there will be some readers who haven't clicked Home | Transform Data to see what lies behind the button, and that's why we wrote this chapter to walk you through the basics of Power Query.
Power Query is an integral part of the Power BI process as an ETL tool.
Great – another acronym, and what does it mean? ETL stands for Extract, Transform, Load, and is a common term in the data world...