Learning Data
Analytics: Part 2
Extending & Applying
Core Knowledge with
100% correct answers
(latest update)
How can cards, such as multicards, provide you with cleaner visuals? -
answer They provide summary data and an easier way of sorting through
data.
You are compiling the top 50 customers from last year. You run a query in
Access for Customers along with an asterisk (*). What will be returned? -
answer all the fields in the Customer table
Your sales manager asks you to pull out the top 25 customers based on
order amount. You are allowed to set the business rule. Which business
rule makes the most sense with this ask? - answer Customers will be
ranked by the highest single order amount.
You do not want your soft filters to affect a particular visual on your
dashboard. How will you prevent this from happening? - answer Edit the
interactions.
You create both Wage Survey Reference and Wage Survey Duplicate data
sets from your Wage Survey data set. If you make changes to the Wage
, Survey data set, where else will the changes occur? - answer in the Wage
Survey Reference data set
You want to explore your data after you append a folder with the latest
data. Which load option will you select? - answer Combine and Transform
Data
Your company recently moved to a new data storage system. As part of
your monthly work, you check for any invoices that do not have a
CustomerOrderID. You find 10. What does this most likely mean? - answer
Some data from the old system did not move to the new system.
You want a list of the total number of orders for all customers, even those
with no orders. Your Customer and Order tables are in place. During your
query, why will you go into Join Properties? - answer to have all
customers returned
What is the first step in doing a custom sort in Power BI? - answer Create
a custom table.
You build a line total based on the Order Details table of OrderID,
UnitPrice, and Qty. If you add your Customer List table, can you run a
query for the top 50 customer orders? - answer No, because there is no
join line between the two tables.
After you append data for missing orders to your invoices table, you
notice 136 orders that were not invoiced. What is the most likely reason? -
answer They are recent orders that have not yet been invoiced.
Why is it often beneficial to unpivot data? - answer to have easy-to-read
data visualizations
You applied conditional formatting to Customer Order by Amount. After
you did this, a colleague changed the sort to Alphabetical. What will
happen? - answer Your conditional formatting will not be affected.
Analytics: Part 2
Extending & Applying
Core Knowledge with
100% correct answers
(latest update)
How can cards, such as multicards, provide you with cleaner visuals? -
answer They provide summary data and an easier way of sorting through
data.
You are compiling the top 50 customers from last year. You run a query in
Access for Customers along with an asterisk (*). What will be returned? -
answer all the fields in the Customer table
Your sales manager asks you to pull out the top 25 customers based on
order amount. You are allowed to set the business rule. Which business
rule makes the most sense with this ask? - answer Customers will be
ranked by the highest single order amount.
You do not want your soft filters to affect a particular visual on your
dashboard. How will you prevent this from happening? - answer Edit the
interactions.
You create both Wage Survey Reference and Wage Survey Duplicate data
sets from your Wage Survey data set. If you make changes to the Wage
, Survey data set, where else will the changes occur? - answer in the Wage
Survey Reference data set
You want to explore your data after you append a folder with the latest
data. Which load option will you select? - answer Combine and Transform
Data
Your company recently moved to a new data storage system. As part of
your monthly work, you check for any invoices that do not have a
CustomerOrderID. You find 10. What does this most likely mean? - answer
Some data from the old system did not move to the new system.
You want a list of the total number of orders for all customers, even those
with no orders. Your Customer and Order tables are in place. During your
query, why will you go into Join Properties? - answer to have all
customers returned
What is the first step in doing a custom sort in Power BI? - answer Create
a custom table.
You build a line total based on the Order Details table of OrderID,
UnitPrice, and Qty. If you add your Customer List table, can you run a
query for the top 50 customer orders? - answer No, because there is no
join line between the two tables.
After you append data for missing orders to your invoices table, you
notice 136 orders that were not invoiced. What is the most likely reason? -
answer They are recent orders that have not yet been invoiced.
Why is it often beneficial to unpivot data? - answer to have easy-to-read
data visualizations
You applied conditional formatting to Customer Order by Amount. After
you did this, a colleague changed the sort to Alphabetical. What will
happen? - answer Your conditional formatting will not be affected.
