Tableau is a business intelligence and analytics platform that helps people visualize, understand, and make decisions with data. In this part of the course, you’ll become well-versed in Tableau’s dynamic capabilities and learn to inject creativity and clarity into your visualisations, ensuring that your findings are easy to understand. Learning Objectives
Course Overview Welcome to the sixth course in the Google Data Analytics Certificate! In this course, you’ll learn how to create data visualisations. Visualisations, along with compelling data storytelling, will help you communicate the meaning of a dataset to your audience. Sharing the results of an analysis is one of the most important parts of an analyst’s job. This course…
Calculations are a common task for data analysts. In this part of the course, you’ll explore formulas, functions, and pivot tables in spreadsheets and queries in SQL, all of which will help with your calculations. You’ll also learn about the benefits of using SQL to manage temporary tables. Learning Objectives Functions with multiple conditions Conditional functions and formulas perform calculations…
VLOOKUP core concepts Spreadsheet functions can be used to quickly find information and perform calculations using specific values. VLOOKUP, or Vertical Lookup, is one such function that vertically searches for a certain value in a column to return a corresponding piece of information. In this reading, you’ll examine the intricacies of this extremely useful function so you understand how it…
In this module, you will learn about converting data from one format to another, data validation and adjust the data for our analysis. One of the ways to help ensure that you have an accurate analysis of your data is by putting all of it in the correct format. This is true even if you have already cleaned and processed…
Organising data makes the data easier to use in your analysis. In this part of the course, We’ll learn the importance of organising your data through sorting and filtering. We’ll explore these processes in both spreadsheets and SQL as you continue to prepare your data. Learning Objectives Course content Course 5 – Analyse Data to Answer Questions Module 1: Organise…
When we clean data, you make changes to the original dataset. It’s important to verify the changes we make are accurate and to let your teammates know about the changes. In this part of the course, we’ll learn to verify that data is clean and report our data cleaning results. With verified clean data, we are ready to begin analysing!…
Knowing a variety of ways to clean data can make a data analyst’s job much easier. Learning Objectives How a junior data analyst uses SQL In this reading, you will learn more about how to decide when to use SQL, or Structured Query Language. As a data analyst, you will be tasked with handling a lot of data, and SQL…
What is dirty data? Earlier, we discussed that dirty data is data that is incomplete, incorrect, or irrelevant to the problem you are trying to solve. This section summarizes: Types of dirty data Duplicate data Description Possible causes Potential harm to businesses Any data record that shows up more than once Manual data entry, batch data imports, or data migration…
Scenario: calendar dates for a global company Calendar dates are represented in a lot of different short forms. Depending on where you live, a different format might be used. Now, think about what would happen if you were working as a data analyst for a global company and didn’t check date formats. Well, your data integrity would probably be questionable.…