Big Data Foundation + Power BI – B4 Posted bymaster September 12, 2021 Leave a comment on Big Data Foundation + Power BI – B4 Welcome to your Big Data Foundation + Power BI - B4 Name Email Enter your DOB (dd/mm/yyyy) 1. What is the comparison operator for ‘less than’? A. = B. > C. < D. <= E. I don’t know this None 2. 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 3. What is the comparison operator for ‘less than or equal to’? A. < B. >= C. <= D. > E. I don’t know this None 4. Which of the following functions returns the total of cells in a range that match some criteria? A. COUNTIF B. AVERAGEIF C. MAXIF D. SUMIF E. I don’t know this None 5. Which function is best to use to combine strings with delimiters? A. CONCAT B. TEXTJOIN C. CONCATENATE D. COLJOIN None 6. Which of the following is not a measure of dispersion? A. Variance B. Mean C. Standard deviation D. Range None 7. What is the difference between the third and first quartile called? A. Interquartile range B. Range C. Median D. Outlier E. I don’t know this None 8. 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 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 10. What function is used to generate random numbers between two values? A. RANDBETWEEN B. RAND C. RANDOM D. UNIFORM E. I don’t know this None 11. The above diagram shows an advanced visualization. What it is called? A. Scatter Plot B. Tree Map C. Bar Chart D. Box chart None 12. 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 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 14. Can you calculate a correlation if there is only one sample of data? A. Yes B. No C. I don’t know this None 15. Which of these tools are not used to explore relationships between two categorical variables? A. Cross-tabulation tables B. Conditional percentage tables C. Scatterplot D. Clustered column bars E. I don’t know this None 16. We want to look up for an exact match of Salesperson based on Customer Name. which of these lookup tables can you use VLOOKUP on? A Customer Name Salesperson Santa Prem Xun Darren Wei Akmal Claus Narjes B Salesperson Customer Name Prem Santa Darren Xun Akmal Wei Narjes Claus C Customer Name Santa Xun Wei Claus Salesperson Prem Darren Akmal Narjes D Salesperson Prem Darren Akmal Narjes Customer Name Santa Xun Wei Claus A. A B. B C. C D. D E. I don’t know this None 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 18. 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 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 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 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 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 23.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 24. 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 25. 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 26. When crafting a data story, it is important to think about the sequence in which we will present individual story points to the audience. One such sequence is to ‘Toe to Head’ approach; that is to start the story with the ending or conclusion. What is an advantage to using such an approach? A. The audience will trust you better and not question your findings B. The audience knows what to look out for throughout the rest of the presentation C. The audience naturally thinks from the ending to the beginning - thus helping them understand the story D. None of the above None 27. Enable column titles. You've imported a spreadsheet, but Power BI Desktop hasn't realised that the first row should be used as column titles. What tool should you click on? A. Enable column titles B. Move titles above data C. Use first row as headers D. Promote top row None 28. The above chart shows the financial sales of each region. What is the important field that needed to drag into location tab? A. Country B. States C. Profit D. Map Chart None 29. What type of variables do not take on numerical values? A. STRING B. CURRENCY C. DECIMAL D. LONG E. I don’t know this None 30. 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 31. 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 32. Hybrid titles are multi-functioning titles that play a variety of roles on a visual. Which of the following is included in a Hybrid Title provide? I. Color Legend for VisualII. Insightful InformationIII. Context of the visual A. II and III B. I, II and III C. I and III D. III only E. I don’t know this None 33. 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 34. 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 35. 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 36. 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 37. What does the icon above represent? A. Funnel chart B. Gauge chart C. Card None 38. What is this map above called? A. Map B. Field Map None 39. What is the name of the visualization as shown above? A. Area Chart B. KPI C. TreeMap D. Line Chart None 40. 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 1 out of 9 Your quiz is running out of time! few seconds are remaining. Time is Up!