4/1/2023 0 Comments Movie collector 5.0![]() Which of the following SQL queries would return only the athletes who play volleyball? The Sport column designates the sport each athlete plays. You are working with a dataset that lists student athletes at a school. Database references let them access objects from other databases. 元 Organize data for analysis Question 1įill in the blank: A data analyst uses _ to decide which data is relevant to their analysis and which data types and variables are appropriate.ĭatabase organization enables analysts to make decisions about which data is relevant to pull for a specific analysis. This is a step analysts take to rearrange the data to make it easier to work with. Sorting a list of students alphabetically is an example of formatting and adjusting data. ![]() This is an example of which phase of analysis? You sort the students alphabetically by last name. You are working with a dataset from a local community college. This is an example of transforming data, which involves identifying relationships and patterns between the datasets and making calculations based on the data. Then, you use formulas and functions to make calculations based on your data. First, you identify relationships and patterns between the datasets. You are working with three datasets about voter turnout in your county. Transforming data involves identifying the trends and patterns between the data. Getting input means soliciting information from other sources to inform your decisions. This is an example of getting input from others. Next, you will use the information provided by the volunteers to figure out which tasks still need to be done. You ask the volunteers which tasks they have already completed, then add that data to the spreadsheet. You are creating a spreadsheet that contains data about a volunteer theater production. Demonstrate an understanding of the steps involved in sorting and filtering data through the use of SQL queriesĪnswers to week 1 quiz questions L2 Data analysis basics Question 1.Describe sorting as it relates to data in a spreadsheet or database with reference to functionality and benefits.Discuss the importance of organizing data before analysis with references to sorts and filters.Describe what is involved in the data analysis process with reference to goals and key tasks.You’ll explore these processes in both spreadsheets and SQL as you continue to prepare your data for analysis. In this part of the course, you’ll learn the importance of organizing your data through sorting and filtering. Organizing data makes the data easier to use in your analysis. Week 1: Organizing data to begin analysis You may also be interested in Google Data Analytics Professional Certificate Course 1: Foundations – Cliffs Notes. Week 1: Organizing data to begin analysis.Coursera Google Data Analytics Professional Certificate Course 5 – Analyze Data to Answer Questions quiz answers to all weekly questions (weeks 1 – 4):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |