Checking and troubleshooting calculations Now that we have our calculations seemingly correct, it is important to take a closer look so that we can discover any anomalies or instances that might throw off the calculations. Boundary cases A common method of performing checks is to look at boundary cases, or the maximums and […]
Learn Power BI Checking and troubleshooting calculations Read More »
Creating calculations We now have a workable data model that contains all of the raw data we will need to report on utilization. Recall that, at the beginning of Chapter 4, Connecting to and Transforming Data, with the rollout of unlimited Paid Time Off (PTO), it is imperative that employee utilization be tracked closely. Utilization
Learn Power BI Creating calculations Read More »
Creating Data Models and Calculations Even though we have loaded in some data, having raw data loaded into separate tables is not enough to enable analysis and visualization. In order to facilitate analysis and visualization, we must create a data model by building relationships between the individual tables, as well as calculations that will aid
Learn Power BI Creating Data Models and Calculations Read More »
Verifying and loading data Now that we are finished connecting to and transforming the data, there should be three active queries and four intermediate queries listed in the Queries pane. The active queries include Budgets and Forecast, People, and Hours. These should not be italicized. These are the active queries that will create tables in
Learn Power BI Verifying and loading data Read More »
Merging, copying, and appending queries Now that we have cleaned up our data, we still require some additional data and transformations to occur to prepare our data for analysis. Specifically, we need to add our additional month data around hours billed to customers, as well as some additional transformations. In the following sections, we will
Learn Power BI Merging, copying, and appending queries Read More »
Connecting to and Transforming Data So far, we have learned about the basics of the Power BI interface. However, to truly unlock the power of Power BI, we need to expand our data model. To do that, in this chapter, we will learn about the Power Query Editor and how to relate multiple tables of
Learn Power BI Connecting to and Transforming Data Read More »
Adding analytics to your visualization We can add analytics to our visualization using the Analytics sub-pane in the Visualizations pane: Figure 3.11 – Analytics added to Number of Working Days by Month visual Your first visualization is now finished. Let’s move on to adding some additional visuals to the page. Creating and using a slicer
Learn Power BI Adding analytics to your visualization Read More »
