Data Analytics Foundations
In Excel, what is the difference between "count" and "numerical count"?
"Count" will count everything, including text and numbers, while "numerical count" will count only numbers.
When you add two tables to a query window and you do not have a join type selected, what is created?
a cross join
Who is most likely responsible for processing, visualizing, and reporting from data to improve a business?
a data analyst
Which data has a type? all data data with numbers data with text data with strings
all data
Why should you only request access to the data you need?
to protect yourself and your organization
When you connect directly to the data, when does the data in your file get updated?
when the data and the source system are updated
Which function in Excel determines what happens if a condition is true or false?
IF
If you learn Power Query in Excel, in which other platform will you also know how to use it?
Power BI
How do you combine fields in Power Query?
Use Merge Columns on the fields.
What is a benefit of maintaining your original data?
You are provided with an audit trail.
Which function is used to create aggregated datasets in Power Query?
The Group By Function
Which tool can you use to find duplicates in Excel?
Attempted correct option Conditional Formatting
You're creating a PivotTable and a number field titled "ProductID" defaults to the SUM aggregate function. Which transformation can you apply so that it defaults to COUNT instead of SUM?
Change the value to COUNT in the Value Field Settings.
When you have a lot of ground to cover in a meeting, what can you use to stay on track?
Correct answer a slide deck
If your company says that you are not allowed to access existing data, what should you do?
Follow company rules.
On the Home tab in Power Query, what should you select if you want to merge your two datasets into one? Merge Datasets as New Merge Datasets Merge Queries as New Merge Queries
Merge Queries
Where can you go for assistance and examples regarding a program's syntax?
The HELP menu
Which tool in Excel lets you import or connect to external data, and then shape and analyze that data in ways that meet your needs?
Power Query
An "Orders" table has 30 columns, and the report only needs the order total by date. Which transformation should you perform?
Remove the other columns. Group by using the date column and aggregate the appropriate total field.
Which two basic SQL statements are needed for a select query?
SELECT and FROM
If you want to change a selected column from lowercase to uppercase, what should you select?
Transform
When you edit and clean a macro in Excel, you can also learn more about which programming language?
VBA
Combining the definitions of three words describes a data analyst. What are the three words?
data, analysis, and analyze
When you develop data for other people, you should ensure the copy that you are providing them is _____.
disconnected from that data
At what level of an organization do you find the key area of data?
entry level
You are starting a new data project. What is one of the best sources to help you begin?
existing reports
ETL, a critical process of data warehousing, stands for which three words?
extract, transform, and load
What is the biggest advantage of working with reusable datasets?
it saves time
When using queries to model your data, what else will you leverage to create the datasets you need?
joins and join types
What is an example of cleaning data? building pivots removing unnecessary columns connecting the data in the database
removing unnecessary columns
Why is it important to note where your source data comes from?
so you have a path to follow if something is off in your data
What is an example of a logical function? Select an answer: the all function the IF function the sum function
the IF Function
What does Power Query use to change to what it determines is the appropriate data type?
the first real row of data
If you are joining data with queries, what must you know in order to validate your dataset?
the record counts