Power BI Analyst Quiz

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

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 Chart

• Bar Chart

• Line Chart

• Tree Map

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

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

• Visualize

• Manage

• Model

• Prepare

What is the primary purpose of the Power BI Service?

• Creating dashboards

• Data transformation

• Report sharing and collaboration

• Data modeling