COURSERA – STUDY GUIDEClick To Enroll in Coursera Show
Set up your toolboxCONTENT
As you’re learning, spreadsheets, query languages, and data visualization tools are all a big part of a data analyst’s job. In this part of the course, you’ll learn more about the basic concepts involved and explore some examples of how these tools work. Learning Objectives
Test your knowledge on Spreadsheet basic1. In a spreadsheet, what is text wrapping used for?
Correct: In a spreadsheet, text wrapping is used to allow all of the text to fit inside a cell. 2. The columns in a spreadsheet are ordered by letter, and the rows are ordered by number.
Correct: In a spreadsheet, columns are ordered by letter and rows are ordered by number. 3. Fill in the blank: In a data table, a row is called an observation. An observation includes all of the _____ for what is contained in the row.
Correct: In a data table, a row is called an observation. An observation includes all of the attributes for what is contained in the row. An attribute is a quality or characteristic of data. Test your knowledge on sql1. What does the asterisk (*) after SELECT tell the database to do in this query?
Correct: SELECT * tells the database to select all columns from the employee table. The criteria in the WHERE clause tells the database what data in those columns the query should return. 2. In this query, the data analyst wants to retrieve data from which table?
Correct: The data analyst wants to retrieve data from the employee table 3. In this query, what will be retrieved from the database?
Correct: This query will select all data from the employee table, where the jobCode is FTE and the last name is James. 4. You are working with a database table that contains data about music artists. The table is named artist. You want to review all the columns in the table.You write the SQL query below. Add a FROM clause that will retrieve the data from the artist table. How many columns are in the artist table?
Correct: The clause FROM artist will retrieve the data from the artist table. The complete query is SELECT * FROM artist. The FROM clause specifies which database table to select data from. There are two columns in the artist table. 5. You are working with a database table that contains data about music albums. You are only interested in data related to the album with ID number 277. The album IDs are listed in the album_id column from the album table.You write the SQL query below. Add a WHERE clause that will return only data about the album with ID number 277. What is the name of the album with ID number 277?
Correct: The clause WHERE album_id = 277 will return only data about the album with ID number 277. The complete query is SELECT * FROM album WHERE album_id = 277. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The name of the album with ID number 277 is Bach: Goldberg Variations. Test your knowledge on visualizing data1. Fill in the blank: A data visualization is the _____ representation of information.
Correct: A data visualization is the graphical representation of information. 2. When would a pie chart be an effective visualization? _____.
Correct: A pie chart shows how a whole is broken down into parts and is an effective visualization for a class broken down by age. 3. What are the key benefits of data visualizations? Select all that apply.
Correct: Data visualizations can clearly demonstrate patterns and trends, help stakeholders understand complex data more quickly, and illustrate relationships between data points. *Weekly Challenge 4*1. In row 1 of the following spreadsheet, the words rank, name, population, and county are called what?
Correct: These words are attributes, referring to the information in the columns below. An attribute is a characteristic or quality of data used to label a column in a table. 2. In the following spreadsheet, where can you find all of the attributes—also known as the observation—of Fayetteville?
Correct: The observation for Fayetteville is in row 7. An observation is all of the attributes for something contained in a row of a data table. 3. In the following spreadsheet, what feature was used to alphabetize the city names in column B?
Correct: Sort range was used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and find data more quickly. 4. To find the average population of the cities in this spreadsheet, you type =AVERAGE. What is the proper way to type the range that will complete your function?
Correct: The range is C2:C11. The full AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range. 5. You are working with a database table named employee that contains data about employees. You want to review all the columns in the table.You write the SQL query below. Add a FROM clause that will retrieve the data from the employee table. What employee has the job title of Sales Manager?
Correct: The clause FROM employee will retrieve the data from the employee table. The complete query is SELECT * FROM employee. The FROM clause specifies which database table to select data from. The employee Nancy Edwards has the job title of Sales Manager. 6. You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 28.You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 28. What is the billing city for the customer with ID number 28?
Correct: A formula is a set of instructions used to perform a specified The clause WHERE customer_id = 28 will return only data about the customer with ID number 28. The complete query is SELECT * FROM invoice WHERE customer_id = 28. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The billing city for the customer with ID number 28 is Salt Lake City. 7. A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. What type of chart is it?
Correct: The chart is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values. 8. A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create this data visualization. This is an example of an area chart.
Correct: This is a line chart. Line charts are effective for illustrating trends and patterns, such as how the population changes over time. Google Data Analytics Professional Certificate Study GuideFrom the Quiztudy TeamHi, Quiztudy is pleased to assist you with any study guide, certificate, or assessment test. More study guides will be published as we grow. Subscribe to our siteGet new content delivered directly to your inbox. |