WorksheetsData Analysis Class Quiz 1
Total questions: 10
Worksheet time: 2mins
Which data role enables advanced analytics capabilities through reports and visualizations?
Data Analyst
B. Data Engineer
Data Miner
Data scientist
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
✑ Customer ID
✑ Customer Name
✑ Phone
✑ Email Address
✑ Address ID
Address contains the following columns:
✑ Address ID
✑ Address Line 1
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
✑ Postal Code
The Customer ID and Address ID columns represent unique rows. You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer. What should you do?
Merge the Customer and Address tables.
Transpose the Customer and Address tables.
Group the Customer and Address tables by the Address ID column.
Append the Customer and Address tables.
You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible. Which Data Preview option should you select?
Show whitespace
Column profile
Column distribution
Column Quality
When working with data in Power Query, what does it mean to 'unpivot' a table?
To transform columns into rows
To combine multiple tables into one
To filter out empty values
To sort the data in ascending order
In Power Query Editor, what is the purpose of the 'Column profile' Data Preview option?
To display statistical summaries of each column
To show whitespace characters in the data
To visualize the distribution of values in a column
To identify and remove duplicate values
When importing data into Power Query, what does it mean to 'append' tables?
To merge tables based on a common column
To combine tables vertically
To filter out rows with empty values
To sort the data in descending order
What is the purpose of the 'Data Analyst' data role in Power Query?
To perform advanced analytics through reports and visualizations
To optimize data storage and retrieval
To clean and transform data efficiently
To manage data security and access permissions
What does it mean to 'transform columns into rows' when working with data in Power Query?
To pivot the table based on a common column
To combine multiple tables into one
To filter out empty values
To sort the data in ascending order
What is a key benefit of data analysis?
Decisive analytics
Informed business decisions
Complex reports
Visualize Data
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?
Apply a transformation to extract the last 11 characters of the Logged column and
set the data type of the new column to Date.
Create a column by example that starts with 2018-12-31 and set the data type of the
new column to Date.
Change the data type of the Logged column to Date.
Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to whole number
