Big Data Foundation + Power BI

Welcome to your Big Data Foundation + Power BI - B1

Name

DOB (dd/mm/yyyy)

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

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?

Customer Name	Salesperson
Santa	Prem
Xun	Darren
Wei	Akmal
Claus	Narjes

Salesperson	Customer Name
Prem	Santa
Darren	Xun
Akmal	Wei
Narjes	Claus

Customer Name	Santa	Xun	Wei	Claus
Salesperson	Prem	Darren	Akmal	Narjes

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

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

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

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

37.

What does the icon above represent?

A. Funnel chart

B. Gauge chart

C. Card

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

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

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

34.

What are the required fields for scatter plot?

I. X-axis
II. Y-axis
III. Z-axis

A. I only

B. I and II only

C. I, II and III

D. I, III and IV

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

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

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

6. Which of the following is not a measure of dispersion?

A. Variance

B. Mean

C. Standard deviation

D. Range

None

What is the name of the visualization as shown above?

A. Area Chart

B. KPI

C. TreeMap

D. Line Chart

None

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

13. 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

24. 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 Visual
II. Insightful Information
III. 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

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

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 lengths
IV. 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

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

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

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

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

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

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

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

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

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

38.

What is this map above called?

A. Map

B. Field Map

None

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

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

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

3. What is the comparison operator for ‘less than or equal to’?

A. <

B. >=

C. <=

D. >

E. I don’t know this

None

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

5. Which function is best to use to combine strings with delimiters?

A. CONCAT

B. TEXTJOIN

C. CONCATENATE

D. COLJOIN

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

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

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

1. What is the comparison operator for ‘less than’?

A. =

B. >

C. <

D. <=

E. I don’t know this

None

1 out of 8

Time is Up!

Big Data Foundation + Power BI

Margin = round(sum(financials [Profit]) / sum(financials[Sales]),3)

Leave a comment

Cancel reply