Bash, the Crucial Exams Chat Bot
AI Bot
Data Preparation and Transformation Flashcards
Microsoft Power BI Data Analyst Flashcards
| Front | Back |
| How are errors in Power Query handled? | Identify error cells and use "Replace Errors" or transformation steps to handle them. |
| How can you add a calculated column in Power Query? | Use the "Add Column" tab and define a formula with Power Query's M language. |
| How can you load transformed data into Power BI? | Click "Close & Load" to import data into the data model or worksheet. |
| How can you rename a column in Power Query? | Right-click the column header and select "Rename." |
| How can you replace missing values in a dataset? | Use the "Replace Values" or "Fill Down/Up" features in Power Query. |
| How do you apply data sorting in Power Query? | Use the "Sort Ascending" or "Sort Descending" options in the column menu. |
| How do you change the data type of a column in Power Query? | Use the "Data Type" dropdown menu in the column header. |
| How do you filter rows in Power Query? | Use the "Filter Rows" option to include or exclude specific values or ranges. |
| How do you remove duplicate rows in Power Query? | Use the "Remove Duplicates" feature under the "Home" tab. |
| What does "Group By" do in Power Query? | Aggregates data into groups based on specified columns. |
| What does "Keep Top Rows" do? | Keeps a specified number of rows from the top of a dataset. |
| What does "Remove Columns" do in Power Query? | Deletes selected columns from the dataset permanently. |
| What does the "Split Column" feature do? | It splits text data into multiple columns based on a delimiter. |
| What does the "Transpose" feature do? | Converts rows into columns and vice versa. |
| What file formats can Power Query connect to? | Excel, CSV, JSON, XML, and text files, among others. |
| What is "Fuzzy Matching" in Power Query? | A technique for merging or matching data with approximate matches. |
| What is a delimiter? | A character used to separate data fields, such as a comma, space, or tab. |
| What is a Power Query step? | A recorded action or transformation applied to the data in sequence. |
| What is a query parameter in Power Query? | A dynamic input that can be used to filter or modify data queries. |
| What is the "Conditional Column" feature used for? | Creates a column based on conditional logic or rules. |
| What is the "Merge Queries" function? | Combines two tables based on a common column (key). |
| What is the "Pivot Column" feature used for? | Transforms rows into columns based on a specific value. |
| What is the "Reference" function in Power Query? | Creates a new query based on an existing one without altering the original. |
| What is the "Unpivot Columns" feature used for? | Converts columns into rows for more flexible data analysis. |
| What is the function of the "Append Queries" tool in Power Query? | It combines multiple tables or queries into a single table. |
| What is the importance of data preparation in analytics? | Ensures data quality, consistency, and accuracy before analysis. |
| What is the M language in Power Query? | The formula language used to create and edit query transformations. |
| What is the primary purpose of Power Query? | To clean, transform, and shape data before analysis. |
| What is the purpose of previewing data in Power Query? | To verify structure, detect issues, and ensure proper transformation steps. |
| Why should you document data transformation steps? | To ensure traceability and transparency for future review. |
Front
What does "Remove Columns" do in Power Query?
Click the card to flip
Back
Deletes selected columns from the dataset permanently.
Front
How are errors in Power Query handled?
Back
Identify error cells and use "Replace Errors" or transformation steps to handle them.
Front
What is the purpose of previewing data in Power Query?
Back
To verify structure, detect issues, and ensure proper transformation steps.
Front
What is the primary purpose of Power Query?
Back
To clean, transform, and shape data before analysis.
Front
How can you replace missing values in a dataset?
Back
Use the "Replace Values" or "Fill Down/Up" features in Power Query.
Front
How do you filter rows in Power Query?
Back
Use the "Filter Rows" option to include or exclude specific values or ranges.
Front
Why should you document data transformation steps?
Back
To ensure traceability and transparency for future review.
Front
What is the function of the "Append Queries" tool in Power Query?
Back
It combines multiple tables or queries into a single table.
Front
What file formats can Power Query connect to?
Back
Excel, CSV, JSON, XML, and text files, among others.
Front
What is a delimiter?
Back
A character used to separate data fields, such as a comma, space, or tab.
Front
How do you remove duplicate rows in Power Query?
Back
Use the "Remove Duplicates" feature under the "Home" tab.
Front
How can you load transformed data into Power BI?
Back
Click "Close & Load" to import data into the data model or worksheet.
Front
What is the "Pivot Column" feature used for?
Back
Transforms rows into columns based on a specific value.
Front
How do you change the data type of a column in Power Query?
Back
Use the "Data Type" dropdown menu in the column header.
Front
What is "Fuzzy Matching" in Power Query?
Back
A technique for merging or matching data with approximate matches.
Front
What is the "Conditional Column" feature used for?
Back
Creates a column based on conditional logic or rules.
Front
What does "Keep Top Rows" do?
Back
Keeps a specified number of rows from the top of a dataset.
Front
How do you apply data sorting in Power Query?
Back
Use the "Sort Ascending" or "Sort Descending" options in the column menu.
Front
What is a query parameter in Power Query?
Back
A dynamic input that can be used to filter or modify data queries.
Front
What is the "Reference" function in Power Query?
Back
Creates a new query based on an existing one without altering the original.
Front
What is the M language in Power Query?
Back
The formula language used to create and edit query transformations.
Front
What is the "Unpivot Columns" feature used for?
Back
Converts columns into rows for more flexible data analysis.
Front
What does the "Transpose" feature do?
Back
Converts rows into columns and vice versa.
Front
What is the importance of data preparation in analytics?
Back
Ensures data quality, consistency, and accuracy before analysis.
Front
How can you add a calculated column in Power Query?
Back
Use the "Add Column" tab and define a formula with Power Query's M language.
Front
What does "Group By" do in Power Query?
Back
Aggregates data into groups based on specified columns.
Front
What is the "Merge Queries" function?
Back
Combines two tables based on a common column (key).
Front
What is a Power Query step?
Back
A recorded action or transformation applied to the data in sequence.
Front
What does the "Split Column" feature do?
Back
It splits text data into multiple columns based on a delimiter.
Front
How can you rename a column in Power Query?
Back
Right-click the column header and select "Rename."
1/30
This deck focuses on the techniques for cleaning, transforming, and shaping data using Power Query and related tools in Power BI.