15 Created by AMZ ConsultingRaise Your Analytics Game 1 / 101) How is Business Intelligence (BI) useful for the organizations? BI can improve organization’s capacity to evaluate the contemporary consumer buying trends. It can help organizations identify the bottlenecks in the processes. It can help organizations to formulate strategic plans and identify new areas of opportunities. All above 2 / 102) Which of the following is a contextual menu (i.e., it appears only when calculations are involved) in Power BI? Home menu File menu Table tools Help menu 3 / 103) Data can be loaded into Power BI desktop from which of the following sources. File and data bases Azure and Power Platform Online services All of above 4 / 104) Power BI query editor can be used to all perform all the listed functions except: Remove extra columns Create graphs Remove errors Correct spelling mistakes 5 / 105) Relationships in a data model are established using: Primary key Foreign Key Primary key and Foreign key None of above 6 / 106) DAX formulas in Power BI are different from Excel formulas because: Row and Filter Contexts Exist Date and Time Functions Return an Integer Cell References are used to Define Calculation Supports Variant Data Type in Column 7 / 107) What are the properties of a Date table in Power BI? The date column should have only one date per row. All dates should be present with no gaps. The dates should be complete from 1st of January to 31st of December. All above 8 / 108) Which of the following default visual is created when a field is selected in Power BI desktop? Matrix Table Pie Chart Card 9 / 109) Which of the following visual is used for slicing the data: Line chart Bar chart Filter Funnel chart 10 / 1010) What is the difference between a report and a dashboard in Power BI Service? Dashboards can have only one page. Reports can have multiple pages. Slicers cannot be pinned on dashboard but can be used on reports. Dashboard’s visuals are not interactive by nature unlike the visuals on the report. All of above Your score isThe average score is 78% LinkedIn 0% Restart quiz Exit
AMZ Consulting