Microsoft Data Analyst Exam - 4. Clean, Transform, And Load Data in Power BI || Questions & Answers (Graded A+)

Microsoft Data Analyst Exam - 4. Clean, Transform, And Load Data in Power BI || Questions & Answers (Graded A+) Microsoft Data Analyst Exam - 4. Clean, Transform, And Load Data in Power BI || Questions & Answers (Graded A+) What could make the data unprepared for analysis? - ANSWER - - column doesn't display data it was meant to (e.g., numbers in a name column) - Several columns contain errors. - Some columns contain null values. duplications - data that should be in multiple columns is in 1 column Clean data has the following advantages: - ANSWER - - Measures and columns produce more accurate results when they perform aggregations and calculations. - Tables are organized, where users can find the data in an intuitive manner. - Duplicates are removed, making data navigation simpler. It will also produce columns that can be used in slicers and filters. - A complicated column can be split into two, simpler columns. Multiple columns can be combined into one column for readability. - Codes and integers can be replaced with human readable values. ______________in Power BI Desktop allows you to shape (transform) your imported data. - ANSWER - Power Query Editor Best practices for naming tables, columns, and values - ANSWER - - recommend that you use the language and abbreviations that are commonly used within your organization and that everyone agrees on and considers them as common terminology. give your tables, columns, and measures descriptive business terms and replace underscores ("_") with spaces. - be consistent with abbreviations, prefaces, and words like "number" and "ID. - removing prefixes or suffixes that you might use in table names and instead naming them in a simple format, you will help avoid confusion - Avoiding acronyms in values is also a good idea, provided that the text will fit on the visual steps to Clean, Transform, and Load data - ANSWER - tbd ___________is about studying the nuances of the data: determining anomalies, examining and developing the underlying data structures, and querying data statistics such as row counts, value distributions, minimum and maximum values, averages, and so on. - ANSWER - profiling data Difference between distinct vs unique - ANSWER - distinct in this table tells you the total count of how many values are present while unique tells you how many of those values only appear once. (True or False) The fixed decimal number data type stores values with full precision, and so requires more storage space than the decimal number. - ANSWER - True The maximum number of rows loaded as preview data for each query is... - ANSWER - 1000+