Skip to main content

Power BI Quiz 1

Quiz 1 : Basics of Power BI and Data Analytics




1. What is the common flow of activity in Power BI?
       A. Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service
       B. Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop
       C. Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile
       D. Bring data into Power BI mobile, create a report, then share it to Power BI Desktop


2. Which of the following are building blocks of Power BI?
       A. Tiles, dashboards, databases, mobile devices
       B. Visualizations, datasets, reports, dashboards, tiles
       C. Visual Studio, C#, and JSON files


3. A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI?
       A. The canvas
       B. Scheduled refresh.
       C. An app


4. Which data role enables advanced analytics capabilities through reports and visualizations?
       A. Data scientist
       B. Data engineer
       C. Data analyst


5. Which data analyst task has a critical performance impact on reporting and data analysis?
       A. Model
       B. Analyze
       C. Visualize


6. Which one of the following options is a key benefit of data analysis?
       A. Decisive analytics
       B. Informed business decisions
       C. Complex reports

Comments

Popular posts from this blog

ETL Process in Power BI

 We can make a data analysis process easy using the ETL process in Power BI Desktop.  What is ETL in Power BI Desktop ? ETL (Extract, Transform and Load) data is a process by which we can change the shape of our dataset. You can perform several operations in Power Query editor.  During the ETL process, data is extracted from a data source (raw data), then transformed, corrected and then loaded for the next step. You can do this process manually in Excel but it is time consuming process and at the end of the day, we don't want to do the same process for upcoming new data. It should be done by automation. If you have not read my last blog on Power BI then please go through the link  Blog We will start the ETL process step by step A. Extract Data  B. Transform Data C. Load Data A. Extract Data from a data source To extract data from a data source, click on Get Data. We will extract raw data from Excel sheet and then will connect the sheet with Power BI. You can ext...

Excel for Data Analysis

 Most important functions of Excel for data analysis Excel and google sheets are powerful tools for managing the raw data. There are many functions that can make your task easier.  As a Data Analyst, you use many functions like VLOOKUP, Pivot Tables, Conditional formatting, etc., So here, I have listed some most important functions of excel for data analysis : - 1. Pivot Table Pivot tables are a way to aggregate data to look at smaller subsets without using manual filters. Without it, you would use the manual filters on every column, check to see if they work, and then use [SUM] functions. All of that is built for you with a pivot table and pivot chart. You can set rows, columns, values and filters at the same at your level. You can use any aggregate function while creating a Pivot table.  In short, Pivot table gives you the summary of your data. We will see more detail in next blog. 2. VLOOKUP VLOOKUP stands for "Vertical Lookup", this means the act of looking up da...

Get started with Power BI Desktop

The very first question comes in mind is Should I use Power BI Desktop or Power BI Service to create a dashboard ? You should get started with Power BI Desktop. As I have already told in the first blog ( Blog 1 ) that the flow of creating a report is    Power BI Desktop > Power BI Service > Power BI Mobile