From the course: Introduction to Career Skills in Data Analytics

Unlock this course with a free trial

Join today to access over 25,100 courses taught by industry experts.

Using built-in functions

Using built-in functions

From the course: Introduction to Career Skills in Data Analytics

Start my 1-month free trial Buy for my team

Using built-in functions

“

- [Instructor] There are a lot of people who don't enter into the field of data because they're intimidated by math. It's important to recognize that one of the powers of these tools is that it performs all types of math from basic to complex mathematical computations for us. We don't have to manually create every function we need. The tool provides us a lot of calculations. For example, in this Power BI dashboard, let's take a look at the fields, look at Quantity and UnitPrice and even Discount. Do you see how they have the sigma shape? It's because it recognizes them as numbers, and this means it will automatically aggregate them for us and summarize them. Let me show you what I mean. I'll go ahead and add a table, and I'll go ahead and expand orders. I want to bring in the order ID. I also want to take a look at the product name. Now let me expand this. I want to be able to see as I ad fields in. I'll go ahead and bring…

Contents