harnessing the power of data with power bi coursera week 2 answers
Self-Review: Dataset
1. What is the primary task assigned to you by Renee in the Assessing a data set case study?
- To list the products purchased from suppliers in ascending order by the Date Entered column.
- To track the price increase on a supplier basis from the past to the present for each product the company purchases from suppliers and detect any unusual price situations, if any.
- To sort and list the prices of all products, displaying them in descending order
- To list the products in ascending order by the Supplier and Date Entered columns, respectively.
2. In the Assessing a data set case study, which of the following columns need to be considered to track the price increase on a supplier basis from the past to the present for each product and detect anomalies? Select all that apply.
- Product name
- Date Entered
- Supplier
- Category
3. Based on your analysis of the data in the Assessing a data set case study, is this dataset suitable for the business need as determined by the task assigned to you by Renee?
- No
- Yes
Knowledge check: Data collection
4. Which product has strong reporting features and is typically used to begin a workflow in Power BI?
- Microsoft Power BI Apps
- Microsoft Power BI Service
- Microsoft Power BI Desktop
5. If you are given Microsoft Excel data and informed of a business need, what method would you use to determine if the data provided is compatible with the business need?
- Check if the Microsoft Excel data fulfills the business requirements by examining the source of the data.
- Check if the Microsoft Excel data fulfills the business requirements by examining its content and data types.
- Check if the Microsoft Excel data fulfills the business requirements by examining the format of the data.
6. You want to publish your report and share your data with others by creating dashboards. Which of the following products would you use to accomplish this?
- Microsoft Power BI Service
- Microsoft Power BI Apps
- Microsoft Power BI Desktop
7. True or False: The typical workflow in Microsoft Power BI starts with the creation of a report in Power BI Desktop.
- True
- False
8. What term is used to classify data such as word-processing files, images, video, and audio files?
- Unstructured data
- Structured data Semi-
- Structured data
Self-Review: Data storage and management
9. What is the main advantage of hybrid storage for Adventure Works?
- It is suitable for storing only structured data.
- It reduces the IT management overhead.
- It is the most affordable storage solution.
- It combines the benefits of on-premises and cloud-based storage solutions.
10. Which statement best describes structured data?
- Data that is not organized in a predefined format, consisting of data types that do not fit neatly into rows and columns.
- Data that is stored on physical hardware located within the company’s premises.
- Data that is easily searchable and analyzable, consisting of data types that can be neatly arranged in rows and columns.
- Data that is stored on remote servers managed by a third-party provider.
11. What data source mentioned in the case study is an example of unstructured data?
- Sales data
- Social media and online reviews data
- Financial data
- Manufacturing data
Knowledge check: Introduction to the ETL process
12. What is a benefit of on-premises storage?
- Full control over data and infrastructure.
- Easy scalability.
- Reduced IT management overhead.
- No need for physical hardware.
13. What is the primary purpose of the Transform step in the ETL process?
- To extract data from multiple sources.
- To load the transformed data into the final storage system.
- To clean, structure, and enrich the data to make it more suitable for analysis.
- To analyze and visualize the data.
14. Which method of data ingestion allows real-time access to data but may require knowledge of database languages and complex configurations?
- File-based ingestion
- Data streaming
- Web scraping
- Database connections
15. What does source data refer to? Select all that apply.
- Raw, unprocessed information collected, stored, and managed by an organization.
- Pre-processed data used for analysis and decision-making.
- Data that has been analyzed and refined for specific purposes.
- The initial input used as the basis for further processing, transformation, and analysis.
16. Which aspect of data management is primarily responsible for establishing clear policies and procedures for data handling throughout an organization?
- Data archiving
- Data security
- Data quality
- Data governance
Self-Review: Evaluating data for transformation
17. Based on the Adventure Works Inventory dataset, what is the RestockingFrequency for the product Kidz-K400?
- 90 days
- 45 days
- 60 days
- 30 days
18. In the Customer Feedback dataset, which ProductID received a feedback score of 3,5 on May 2023 23rd?
- 49
- 51
- 50
- 52
19. According to the Adventure Works Sales dataset, what is the total quantity of products sold on 2023-05-05?
- 4
- 2
- 1
- 3
Knowledge check: Introduction to transforming data
20. Which process involves altering the data's structure, format, or values to make it more suitable for analysis?
- Data aggregating
- Data cleaning
- Data transformation
- Data validation
21. What is a primary advantage of cleaning data at the source?
- Eliminating the need for data transformation.
- Ensuring future analyses have a clean and consistent foundation.
- Reducing the need for data documentation.
- Making it easier to import data into Microsoft Power BI.
22. Which Excel function can be used to convert text strings into date formats?
- PROPER
- UPPER()
- MATCH()
- SUMIF()
23. What is the primary function of Power Query in Microsoft's Microsoft Power BI suite?
- Data connectivity and preparation.
- Creating advanced calculations.
- Data visualization.
- Sharing and collaboration.
24. Which data transformation functions are commonly performed in Power Query? Select all that apply.
- Removing duplicates.
- Filling in missing values.
- Encrypting data.
- Changing data types.
Module quiz: The right tools for the job
25. What is the purpose of the transform stage in the ETL process?
- Removing duplicates and refining the data.
- Retrieving raw data from different sources.
- Loading transformed data into a data warehouse.
- Combining different data sources.
26. Which of the following tasks are related to data ingestion in the ETL process? Select all that apply:
- Loading data into a target database or data warehouse.
- Importing data for immediate use or storage in a database.
- Cleaning and formatting data for analysis.
- Obtaining data from various sources.
27. When estimating storage capacity for data storage, which factor is the least relevant?
- How long you need to store the data.
- The size of your organization.
- The time of day data is most frequently accessed
- The number of departments within the organization.
28. In the context of data analysis, which of the following statements are true about data cleaning and data transformation? Select all that apply.
- Data cleaning is only done at the source.
- Data transformation is an ongoing process, while data cleaning is a one-time process.
- Data transformation involves altering the data’s structure, format, or values to make it more suitable for analysis.
- Data cleaning involves identifying and correcting errors and inconsistencies in datasets.
29. Which Excel feature can help you quickly spot errors, outliers, or patterns in your data by applying different formats to cells based on specific conditions?
- Conditional formatting
- VLOOKUP()
- TRIM()
- Data validation
30. Which of the following are main purposes of Microsoft Power Query in the Microsoft Power BI suite? Select all that apply.
- To load data into Microsoft Power BI data models.
- To create real-time dashboards.
- To connect to multiple data sources.
- To clean and transform data.
31. What is a common issue in raw data that can hinder accurate analysis?
- Incompatible data sources.
- Too few data points.
- Missing values.
- Too many visualizations.
32. Which of the following are main goals of identifying and evaluating required data for a business decision? Select all that apply:
- To gather as much data as possible.
- To understand the factors that influence the decision and collect relevant data.
- To consider all types of data sources, including structured, semi-structured, and unstructured data.
- To consider both internal and external data sources.
33. True or False: An Enterprise Resource Planning (ERP) system is classified as an Unstructured data source.
- True
- False
34. True or False: The primary purpose of Microsoft Power BI Desktop is to share dashboards with other users.
- True
- False
35. What is a crucial factor to consider when estimating storage capacity for data storage?
- The operating system used
- The time of day data is most frequently accessed
- The size of your organization.
- The number of employees who analyze data.
36. What is the primary difference between data cleaning and data transformation in the context of data analysis?
- Data cleaning focuses on removing duplicate entries, while data transformation focuses on altering data structure.
- Data cleaning involves identifying and correcting errors and inconsistencies in datasets, while data transformation involves altering the data’s structure, format, or values.
- Data cleaning is a one-time process, while data transformation is an ongoing process.
- Data cleaning is only done at the source, while data transformation is only done in Microsoft Power BI.
37. Which of the following Microsoft Excel features can help you quickly spot errors, outliers, or patterns in your data by applying different formats to cells based on specific conditions?
- VLOOKUP()
- Data validation
- TRIM()
- Conditional formatting
38. True or False: Having too many visualizations is a common issue in raw data that can hinder accurate analysis.
- True
False
39. True or False: The main goal of identifying and evaluating required data for a business decision is to gather as much data as possible.
- True
- False
40. What type of data source is an Enterprise Resource Planning (ERP) system classified as?
- Streaming data
- Semi-Structured data
- Structured data
- Unstructured data
41. In a typical Microsoft Power BI workflow, what is the primary purpose of Microsoft Power BI Desktop?
- To design and create reports.
- To share dashboards with other users.
- To assign user permissions.
- To view and interact with reports.
42. Which of the following tasks are performed during the transform stage of the ETL process? Select all that apply:
- Loading transformed data into a data warehouse.
- Converting data types.
- Retrieving raw data from different sources.
- Handling missing values.
43. What is the primary purpose of data ingestion in the ETL process?
- To load data into a target database or data warehouse.
- To clean and format data for analysis.
- To analyze data and extract insights.
- To obtain and import data from various sources for immediate use or storage in a database.
44. What task is primarily involved in the process of data cleaning in the context of data analysis?
- Transforming the data to be more suitable for Microsoft Power BI.
- Altering the structure, format, or values of the data.
- Identifying and correcting errors and inconsistencies in datasets.
- Removing duplicate entries from datasets.
45. What is the main purpose of Microsoft Power Query in the Microsoft Power BI suite?
- To connect to multiple data sources, clean and transform data, and load it into Microsoft Power BI data models
- To create real-time dashboards for monitoring key performance indicators
- To automatically generate data visualizations
- To integrate with third-party applications for enhanced data analysis
46. What is the main goal of identifying and evaluating required data for a business decision?
- To focus only on structured data sources.
- To understand the factors that influence the decision and collect relevant data.
- To gather as much data as possible.
- To avoid using external data sources.
