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…
File organisation guidelines Every data analyst’s goal is to conduct efficient data analysis. One way to increase the efficiency of your analyses is to streamline processes that help save time and energy in the long run. Meaningful, logical, and consistent file names help data analysts organise their data and automate their analysis process. When you use consistent guidelines to describe…
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…
Creating SMART questions about your datasets is crucial for several reasons. SMART is an acronym that stands for Specific, Measurable, Achievable, Relevant, and Time-bound. Here’s why each aspect is important and how these questions benefit your work as a data professional: Importance of Creating SMART Questions: Benefits of SMART Questions for Data Professionals: In summary, SMART questions help to create…
Disclaimer: I am not affiliated with any of the links I am providing here. My goal for this post is to gather the resources under the same page so it can be helpful for people who like to learn. Also, any free course now can be found behind a paywall, and that’s totally up to the provider’s discretion. But I…