Big Data Foundation + Power BI – B3 Posted bymaster July 9, 2021 Leave a comment on Big Data Foundation + Power BI – B3 Welcome to your Certificate in Applied Big Data Analytics Name Email 1. Enter your DOB (dd/mm/yyyy) 2. 1. What are the fields that are required to click to show the measure progress in gauge? I. Margin II. Margin Target III. Tooltip IV. Country A. I only B. I and II only C. I, II and III D. I, III and IV None 3. 25. Which of the following statements are true? I. Categorical variables should be arranged alphabetically if there is no other logical way of arranging them II. Categorical variables must be illustrated through the use of a line chart III. Comparison between different categorical variables can be better displayed through the use of a bar chart as opposed to a pie chart IV. When attempting to visualize proportion-to-whole of categorical variables, it is generally preferred to use a Tree Map over a Pie Chart A. I only B. II and III only C. I, II and III D. I, III and IV E. I don’t know this None 4. 3. Where are this formula will be entered? Margin = round(sum(financials [Profit]) / sum(financials[Sales]),3) A. New Measure B. Quick Measure C. Correlation Coefficient D. Field List None 5. 23. Which of the following are reasons for the pie chart being an ineffective method of conveying information? Select all that apply. The human eye cannot perceive 2D-Area and angles very well thus making it difficult to compare the value associated with each slice Pie Charts are round, and humans prefer rectangular shape When there are too many slices (categories) the pie chart becomes difficult to read People are used to using pie charts and are bored of seeing them in presentations A. 1 and 2 B. 1 and 3 C. 2 and 3 D. All of the above None 6. 5. If you need to track a single measure in Power Bi, what is the best advance visualization? A. Scatter Plot B. TreeMap C. Area Chart D. Card None 7. 20. When designing good visuals, we like to consider the overall visual hierarchy. What does it mean? A. The visual design of an organizational hierarchy chart B. The order in which the audience will process the visual as determined by the importance of each bit of information C. The visual display of hierarchical clustering on a dendrogram D. The hierarchy of needs with respect to visual design E. I don’t know this None 8. 31. What is a tooltip? A. An elegant way of providing more contextual information and detail to data points on a visual. B. To show the options that are available in Power Bi C. Sort data and information based on some selected criteria None 9. 8. What is the name of the visualization as shown above? A. Area Chart B. KPI C. TreeMap D. Line Chart None 10. 9. What does the 3 represents in the formula? Margin=round(sum(financials [Profit])/sum(financials[Sales]),3) A. Factorization B. Round off C. Multiplication D. Addition None 11. 17. In the context of Data Storytelling, what is a call-to-action? A. It is a catchy header that grabs attention and sticks in the mind B. It is a calculable formula that defines the amount of call to the amount of action in a visual C. It is a statement that tells the audience what you need them to do or perform having viewed the visual D. It is a 20 seconds summary of findings from a given piece of analysis E. I don’t know this None 12. 35. The above diagram shows an advanced visualization. What it is called? A. Scatter Plot B. Tree Map C. Bar Chart D. Box chart None 13. 34. What are the required fields for scatter plot? I. X-axisII. Y-axisIII. Z-axis A. I only B. I and II only C. I, II and III D. I, III and IV None 14. 13. Which of these types of data does not have an implicit ordering? A. Nominal B. Ordinal C. Quantitative D. Character E. I don’t know this None 15. 14. What is a Power Bi report? A. An application for clean data B. A canvas C. Key-influencers D. Visuals that represent different findings and insights from that dataset None 16. 15. Which of the following is not a measure of central tendency? A. Variance B. Mean C. Mode D. Median E. I don’t know this None 17. 16.Which term refers to the most common observation in the distribution? A. Median B. Mean C. Mode D. Variance E. I don’t know this None 18. 17. What is the term describing when a cell indirectly or directly references itself? A. Cross References B. Absolute references C. Relative references D. Circular references E. I don’t know this None 19. 40. Which of this statements are true about Stacked Column Chart?I. A stacked column chart is to allow part-to-whole comparisons over time, or across categories.II. In a stacked column chart, data series are stacked one on top of the other in vertical columns.III. Stacked column charts can show change over time because it's easy to compare total column lengthsIV. Stacked column charts are good for showing one or two measure’s value across an axis which can be a category or time period. A. I and II B. I and IV C. I, II, and III D. All of the above None 20. 19. Which of the following visuals can be used to visualize proportions-to-whole? Tree Map Pie Chart 100% Stacked Bar Chart Donut Chart A. 1 and 3 only B. 2 and 3 only C. 2 only D. All of the above E. I don’t know this None 21. 20. Which of the following measures are used to evaluate the strength of a relationship between quantitative variables? A. Mode B. Variance C. Mean D. Correlation E. I don’t know this None 22. 21. Scatter plots are used extensively by the scientific community. Why might we use scatter plots? A. To visualize the relationship between two variables B. To illustrate the magnitude of one variable over time C. To show proportion-to-whole of subcomponents D. To provide easy comparison for a ‘before’ and ‘after’ E. I don’t know this None 23. 22. What is a concern when using a line graph to visualize categorical data? A. A line implies that categorical data is continuous B. Values at any point in the line are not obvious C. The forecasts we make with line charts are not great D. Categorical variables must be processed before they can be used for visualization E. I don’t know this None 24. 23. Which of the following set of variables represent zero correlation? A. age and hair B. ice cream and sunburn C. absence and grades D. speed and travel time None 25. 18. Good Data Storytelling is comprised of two main elements. What are the two main elements? A. Visual & Synopsis B. Story & Synopsis C. Voice & Story D. Visual & Story E. I don’t know this None 26. 25. Which of the following represents bivariate data? A. name and height of a person B. gender C. height and weight of a person D. age None 27. 26. “What has happened” aptly describes which of the following analytics? A. Descriptive B. Predictive C. Prescriptive D. Associative None 28. 27. Images, video and audio content are a type of __________ data? A. structured B. hybrid C. unstructured D. multi structured None 29. 28. Which of the following is not a measure of dispersion? A. Variance B. Mean C. Standard deviation D. Range None 30. 29. Which characteristics of Big Data represents handling of inconsistencies and uncertainty of data? A. Veracity B. Value C. Variety D. Validity None 31. 30. A food delivery service missed many orders processing and unable to cope with demands, which characteristics of big data does this neglect? A. Velocity B. Variety C. Volume D. Value None 32. 31. Market Basket Analysis is an example of which big data analytics technique? A. Association Rule Learning B. Classification Tree Analysis C. Regression Analysis D. Machine Learning None 33. 32. Financial Risk Analysis addresses the following risk except? A. Financial B. Conformance C. Strategic D. Operational None 34. 33. Data which are collected for business activities but never analysed is called ______ data? A. Valueless B. Functional C. Traditional D. Dark None 35. 34. What concept is being represented? What concept is being represented by the visual above? A. Show and Tell B. Point , Evidence and Explain C. Annotate and Explain None 36. 35. In building a persona to represent audience, which of the following is NOT considered? A. Who is this person? B. What is the pain point for this person? C. What position is this person having? D. How might this person resist? None 37. 36. You have imported a spreadsheet, but Power BI Desktop has not realised that the first row should be used as column heading. What option should you click on? A. Enable column titles B. Move titles above data C. Use first row as headers D. Promote top row None 38. 37. What is it called as? The above visual is used to provide adaptive visuals based on dataset, what is it called as? A. Q&A B. Line Chart C. WhatIf Viewer D. Key Influencer None 39. 38. What chart does the icon represent? The image above shows the icon of an advanced visualization. What chart does the icon represent? A. Line Chart B. Bar Graph C. Area Chart D. Card None 40. 39. What needs to be turned on What needs to be turned on, to view the outcome above in Power Query Editor? A. Column distribution B. Column quality C. Column profile None 41. 40. Which is a Fact table representation? Based on the Model view above, which is a Fact table representation? A. Product B. Sales C. Date None 1 out of 9 Time is Up!