Business Intelligence with Microsoft Power BI - with Material - Basic Number Functions

The video tutorial introduces basic number functions such as add, subtract, multiply, and divide using Power BI. It demonstrates how to import a dataset and perform calculations using button clicks in Power BI. The tutorial covers multiplication of sales, quantity, and discount, highlighting common errors and how to correct them. It also explains how to perform subtraction and rename columns, providing a comprehensive guide to using basic number functions in Power BI.

What are the basic number functions introduced in the video?

• Round, floor, ceiling, abs

• Add, subtract, multiply, divide

• Sum, average, count, max

• Concatenate, split, replace, trim

Which feature in Power BI is used to perform multiplication on selected columns?

• Model View

• Data View

• Report View

• Add Column

What mistake was made when multiplying sales, quantity, and discount?

• Forgetting to include the sales column

• Using addition instead of multiplication

• Multiplying all columns without adjusting for discount

• Using the wrong data type for multiplication

How can you correct the multiplication error involving zero discount?

• By adding a constant value

• By using a different dataset

• By modifying the formula to include 1 minus discount

• By changing the data type of the columns

What is the correct formula to calculate total sales considering discount?

• Sales * Quantity * Discount

• Sales * Quantity * (1 - Discount)

• Sales + Quantity - Discount

• Sales / Quantity + Discount

What is the process to rename a column in Power BI?

• Select 'Edit Queries' and rename

• Right-click and select 'Rename'

• Double-click the column header

• Use the 'Format' tab

How is the cost calculated in the video?

• Sales minus profit

• Sales plus profit

• Profit divided by sales

• Quantity times discount