Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
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 »
Generating data Power BI Desktop is all about connecting to data, modeling that data, and then visualizing that data. Therefore, it makes sense that you cannot really do much within Power BI without data. So, in order to get started, we are going to create some data to familiarize you with basic operations within the
Learn Power BI Generating data Read More »
Up and Running with Power BI Desktop The first step to being able to do almost anything in Power BI is to get Power BI Desktop up and running and have some data loaded to use in creating visualizations. This chapter will get you up and running quickly with Power BI by showing you how
Learn Power BI Up and Running with Power BI Desktop Read More »
Planning Projects with Power BI Power BI projects are essentially the same as business intelligence projects involving alternative tools such as Tableau, Qlik, MicroStrategy, SQL Server Reporting Services (SSRS), or even Crystal Reports. In fact, all business intelligence projects follow, or should follow, a similar process, with only minor variations depending upon the specific technology
Learn Power BI Planning Projects with Power BI Read More »
