Business Intelligence: Power BI

A core component of analytics that answers the

question “What will likely happen in the future?

• Descriptive

• Diagnostic

• Predictive

• Prescriptive

What’s the main difference between the role of a

Business Analyst and a Data Analyst?

• The data that they are using for their analysis

• The way they use the data

• The are the same

Whose responsible for profiling, cleaning and transforming data?

• Data Analyst

• Data Engineer

• Data Scientist

• Database Administrator

Which of the following is not a task of a Data Analyst?

• Data Modelling

• Preparing the Data

• Securing the flow of data from various data sources

• Data Visualization

Where does a Data Analyst starts in creating a report in Power BI?

• Power BI Desktop

• Power BI Service

• Power BI Mobile

Which of the following are building blocks of Power BI?

• Tiles and Visualization

• Semantic Models and Reports

• Semantic Models and Visualizations

A type of storage mode that allows you to create a local Power BI copy of your semantic models from your data source.

• Import

• Direct Query

• Dual

You can use parameter to create a dynamic report for multiple values.

• True

• False

What service enables you to connect data source to Power BI and perform transformation if needed?

• SQL Server

• Azure Cosmos DB

• Power Query Editor

Which of the following data source allows you to establish live connection?

• SQL Server

• Azure Analysis Services

• Sharepoint List