data visualisation
Data Analytics, Technical

Course 6: Share Data Through the Art of Visualisation, Course Overview plus Module 2: Create Data Visualisation with Tableau

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

data visualisation
Technical, Data Analytics

Course 6: Share Data Through the Art of Visualisation, Course Overview plus Module 1: Visualise Data

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…

Continue Reading

graphical user interface
Technical, Data Analytics

Course 5: Analyse Data to Answer Questions,  Module 4: Perform Data Calculations

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…

Continue Reading

graphical user interface
Technical, Data Analytics

Course 5: Analyse Data to Answer Questions, Module 3: Aggregate data for analysis

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…

Continue Reading

graphical user interface
Technical, Data Analytics

Course 5: Analyse Data to Answer Questions, Module 1: Organise data for more effective analysis

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…

Continue Reading

Technical, Data Analytics

Course 4: Process Data from Dirty to Clean, Module 2: Clean it up

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…

Continue Reading

Technical, Data Analytics

Course 4: Process Data from Dirty to Clean, Module 1: The importance of integrity

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.…

Continue Reading