Getting data

Power BI is all about working with and visualizing data. Thus, we must incorporate some additional data into our model. In Chapter 2, Planning Projects with Power BI, we covered the data and data sources that Pam required and would be using. To emulate this data, we will use Excel files, so ensure that you have the Excel files from this chapter's Technical requirements section downloaded and that your LearnPowerBI.pbix file is open in Power BI Desktop.

In this section, you will create your first query and then add some additional data to your data model.

Creating your first query

To determine whether or not Personal Time Off (PTO) should be approved, it is important to understand where the company is concerning budgets and forecasts. Whether or not the company, department, and/or location is on target in terms of its budget can be an important consideration when approving or denying time off.

Unlike the calendar table from Chapter 3, Up and Running with...