Exam PL-300 topic 2 question 7 discussion

Row label: Name Key column: ID Is featured table: Yes

Maybe a Row label must be a Name.

Row label: Chọn cột Name Key column: Chọn cột ID Is featured table: Chọn Yes

Cost Center ; ID; Yes for first one, since name can be duplicated , need to choose the unique identifier

ChatGPT answer: To make the table available as an organizational data type in Microsoft Excel, you need to configure the properties appropriately. Here are the correct selections for each field: Row Label: Cost Center: Since this is likely the unique identifier for each row in your data, it should be the row label. You might want to choose this as it identifies each entry distinctly. Key Column: ID: The "ID" field is typically a unique identifier for each row of data in your dataset, which is necessary for identifying the record and mapping data to Excel properly. Is featured table: Yes: To make the table available as an organizational data type, it should be a "featured table." Marking it as featured helps integrate it with Excel's data type capabilities for easier use. So, the configuration would be: Row Label: Cost Center Key Column: ID Is featured table: Yes

I just saw a video who gave the answer : A. Cost Center B.ID C.Yes https://www.youtube.com/watch?v=zEIiho0wmkw&ab_channel=GlobalTechLearn

I would also vote for Row Label to be "Name" instead "Cost Center" as it will be easier for the users in Exel to identify the row rather than the "Cost Center" which is usually a code. ID and Yes would be my vote for the second and third questions

Surely Cost Center is wrong and the name identifies the business to users??

correct answer is Name, ID and Yes

Row Label: Name Key column: ID Is featured Table: Yes

Shouldn't this be an Excel question rather than power bi?

this youtube video speaks the correct answer on its own! Row label: Name Key column: ID Is featured table: Yes

may I ask why we need a feature table here?

Row label: Name Key column: ID Is featured table: Yes The reason for "Row label" as Name is that the "Name" of a Business Unit would be more descriptive and recognizable to users than a numeric ID or a Cost Center code, making it easier to identify the Business Unit in Excel.

Name, ID, Yes. Name it will be a Business Unit Name.

Do experienced users of Power BI use this feature at all?

"Name", "Headcount" and "Yes" are correct answers. It is because in row label, we should choose the "Name" column as the row label because it is typically the primary identifier or name associated with the data in an organization data type. In column we should choose the "Headcount" column as the column because it represents a numeric value (presumably the headcount) associated with the organization data. Is featured table, we should select "Yes" to indicate that this table should be recognized as an organization data type in Excel.