Excel’s VLOOKUP FunctionUse VLOOKUP when you need to find things in a table or a range by row. For example, […] February 4, 2023 in Excel tagged look / VLOOKUP / lookup / up by Mike
Excel COUNTIF FunctionUse COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for […] February 4, 2023 in Excel tagged count / condition / countifs by Mike
Central Bank Digital Currency (CBDC)CBDC is a digital currency issued by a central bank rather than by a commercial bank. CBDC is […] February 4, 2023 in Cloud tagged money / cryptocurrency / digital by Mike
Data Cleaning IntroductionAs a data analyst or data scientist, you want to analyze data that is clean, not dirty. In […] February 1, 2023 in Data Analytics tagged data / clean / process / fix / prepare / cleaning / Data Cleaning by Mike
Cleaning Data for AnalysisPre-Cleaning Steps Before you clean your data there are three pre-cleaning steps you should take. Data analysts perform […] January 30, 2023 in Data Analytics tagged EDA / exploratory / data / clean / analysis / Data Cleaning by Mike
2 ChatGPTWhat is ChatGPT? ChatGPT is a natural language processing tool driven by Artificial Intelligence (AI) technology that allows […] January 30, 2023 in Data Science tagged AI / data / ChatGPT / excel / OpenAI / free / artificial / questions / bot / search / GPT / chat / ask / intelligence / analyst by Mike
SQL Best PracticesWhen you write SQL queries it is important to follow company policies and be consistent because others will […] January 27, 2023 in SQL tagged best / sql / case / practice by Mike
SQL IntroductionSQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in […] January 27, 2023 in SQL tagged query / language / introduction / beginner / structured / sql by Mike
BigQuery IntroductionBigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data with built-in […] January 25, 2023 in Database tagged data / sql / Google / query / big / bigquery by Mike
Accessing DataAre you looking for data? Do you have a project that requires data? Are you a data analyst […] January 25, 2023 in Data Science tagged gathering / data / getting / Data by Mike
Open DataWhat is open data? In data analytics, open data is part of data ethics, which has to do […] January 23, 2023 in Data Science tagged data / free / open / datasets / big / Big Data by Mike
An Introduction to DataWhat is data? Data are facts and statistics gathered together for reference or analysis. The small screenshot on […] January 22, 2023 in Data Science tagged information / data / file / name / conventions / metadata / naming / standards / organize / Data by Mike