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…
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…
Maximise databases in data analytics Databases enable analysts to manipulate, store, and process data. This helps them search through data a lot more efficiently to get the best insights. Relational databases A relational database is a database that contains a series of tables that can be connected to form relationships. Basically, they allow data analysts to organise and link data…
Content collected from Google Data Analytics course Feel free to download a .pdf version of this reading below: These best practices include guidelines for entering SQL queries, developing documentation, and examples that demonstrate these practices. This is a great resource to have handy when you are using SQL yourself; you can just go straight to the relevant section to review…
In this module, we will examine different types of businesses and the jobs and tasks that analysts do for them. You’ll also learn how a Google Data Analytics Certificate will help you meet many of the requirements for an analyst position with these organizations. Learning Objectives Ethical and fair decision-making process of a Data analyst Fairness means ensuring your analysis…
Concept Even though I already have some knowledge and experience in Data Analytics using Python, Pandas, Seaborn etc I wanted to take this certification out of curiosity and to learn something new. I am not going to go into the debate of Python vs R and which one is better. Rather, I will only focus on this course and its…
PostgreSQL is a powerful relational database management system. For local development, practice and learning one can run Postgres in docker container. This is a step-by-step guide how to run postgres in Docker. This tutorial is for Linux/Ubuntu systems! If you have Docker installed already, then jump to Step 2 Step 1: Install Docker This completes download and install of Docker…