Power BI Quiz Pre

What is the right sequence of the tasks of a data analyst?

• Model – Prepare – Visualize – Analyze – Manage

• Prepare – Model – Visualize – Analyze – Manage

• Manage – Prepare – Model – Visualize – Analyze

• Visualize – Prepare – Model –Analyze – Manage

1.       Which among the following Power BI tool is used for the development of data models and reports?

• Power BI Service

• Power BI Desktop

•   Power BI Mobile

• Power BI Report Builder

  An analyst has the yearly sales data for the years 2021, 2022 and 2023 as three different tables. In order to consolidate these into a single table, which among the following functions should be used in Power Query Editor?

• Merge

• Append

• Replace

• Fill

Which of the following data sources is NOT supported by Power BI?

• Excel workbook.

• SQL Server database.

• Oracle Database

• Adobe Photoshop

You have 3 categories of Products. If you want to see the percentage share of sales of these categories. Which is the visual you will choose?

• Pie

• Bar

• Line

• Tree Map

A Power BI analyst wants to visualize the profit across 12 months in a year. Which among the following is the best visualization for this comparison?

• Pie Chart

• Funnel Chart

• Line Chart

• Table

In which tool inside Power BI do you transform the data?

• Power Query Editor

• Power Pivot

• Model View

• Table View

Which among the below combination is false?

• Data View – Transforming Data

• Report View – Creating Reports

• Model View – Creating Data Model

• Table View – Viewing Tables

What is the common flow of activity in Power BI?

• Create report in the Power BI service, share it to Power BI Desktop, and interact with it in Power BI Mobile.

• Create reports in Power BI Desktop, share it Power BI Service and view reports in Power BI Service and Mobile.

• Share the data model to Power BI service and create the reports on the Power BI Mobile

• Create report in Power BI Mobile and Share it Power BI Desktop

1.       Which among the data analyst task will impact the report performance directly?

• Visualize

• Manage

• Model

• Prepare