SQL COALESCE() Function
COALESCE() returns the first non-null value in the list. If you have a list of arguments that you […]
Blog
Excel’s VLOOKUP Function
Use VLOOKUP when you need to find things in a table or a range by row. For example, […]
Excel COUNTIF Function
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for […]
Central Bank Digital Currency (CBDC)
CBDC is a digital currency issued by a central bank rather than by a commercial bank. CBDC is […]
Data Cleaning Introduction
As a data analyst or data scientist, you want to analyze data that is clean, not dirty. In […]
Cleaning Data for Analysis
Pre-Cleaning Steps Before you clean your data there are three pre-cleaning steps you should take. Data analysts perform […]
SQL Best Practices
When you write SQL queries it is important to follow company policies and be consistent because others will […]
SQL Introduction
SQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in […]
BigQuery Introduction
BigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data with built-in […]
Accessing Data
Are you looking for data? Do you have a project that requires data? Are you a data analyst […]
Open Data
What is open data? In data analytics, open data is part of data ethics, which has to do […]