Power BI R&A

How do we tranform data from excel into Power BI (Offline)

• 1. Get data (Excel)

• 2. 2. Get data (Web)

• Get data (SQL)

How many type of tranforming data from excel to Power BI?

• 3 types

• 4 types

• 2 types

Tranforming data from excel into Power BI has two types

• 1. 1.Online SharePoint, Offline , and SQL

• 1. 1. Online Sharepoint, Offline

• Both of them

If you want to calculate total, which one visualization do you need to use?

• Bar Chart

• Pie Chart

• Table

• Card

If you want to use Filter of month , day , year, which visualization do you use?

• Table

• Card

• Slicer

• Pie Chart

When you want to put the name in title , which part of visualization do you go to?

• Visual

• General?

If you want hide the hilight title? Which part do you go to hide?

• Title X

• Title Label

• Title Y

• Effect

Where you can chage color in Bar Chart?

• Data Label

• X

• Y

• Column

How to create Dim_Date ?

• Data-> Create New Table -> Dim_Date Formular

• Data-> Create New Table -> Create Relationship

What is full word of Dim?

• Dimensioned

• Dimension Table

• Dimension

• All of them incorrect