All blog articles

Lido's Blog

Data & Analytics

Learn about different data types, databases, SQL, and more.

What is ETL? (Basic Guide + FAQs)

What is ETL? (Basic Guide + FAQs)

Learn the basics of ETL, how it works, its benefits and challenges, and how to leverage an ETL pipeline for effective big data management

Modern Data Stack

Modern Data Stack

Discover what a modern stack is, why you should implement this process, and FAQs for building a robust and efficient data stack.

How to Make a KPI Dashboard With Google Sheets

How to Make a KPI Dashboard With Google Sheets

Open Source Data

Open Source Data

With the existence of the Internet and Big Data comes the emergence of so-called open source data. What is open source data? Can open source data be useful for your business?

Google Sheets Add-Ons for Number Crunching

Google Sheets Add-Ons for Number Crunching

Sometimes, Google Sheets is missing the perfect feature for your data analysis needs. However, here are some number-crunching add-ons to up your data analysis in Google Sheets.

The Ultimate Guide to Data Mining

The Ultimate Guide to Data Mining

Data mining is an important and often misunderstood process in computing today. In this article, we will discuss the basics of data mining and how your business can benefit from it.

Google Sheets Add-ons for Importing Data from Marketing and eCommerce Platforms

Google Sheets Add-ons for Importing Data from Marketing and eCommerce Platforms

Sometimes, Google Sheets does not have the perfect feature for your marketing needs, but this article will give you some easy data importation add-ons to up your marketing analysis in Google Sheets.

What is MongoDB?

What is MongoDB?

Learn about MongoDB and what sets it apart from other non-relational and relational databases

What is Snowflake Database?

What is Snowflake Database?

Learn about Snowflake databases and how they're different from other relational databases and data warehouses.

Relational vs Non-Relational Databases

Relational vs Non-Relational Databases

Learn about relational and nonrelational databases, what they are, the differences between them, and their comparative advantages in helping you to expertly process data.

Cloud Databases 101

Cloud Databases 101

This post explores the function, purpose, and utility of cloud databases. There are many advantages of cloud databases and this article will help you to identify the criteria for determining the database service that will best suite your needs.

Statistic vs Parameter

Statistic vs Parameter

Learn the various facets of different data analysis tools such as statistics and parameters. Additionally, learn the role they can play in your business.

Data Analysis 101: Data analysis pitfalls to watch for

Data Analysis 101: Data analysis pitfalls to watch for

Learn the various obstacles you will face when analyzing data. Biases, focus points, pattern conflation are all pitfalls you should learn about, among other things.

Data Analysis 101: Steps in Conducting Data Analysis

Data Analysis 101: Steps in Conducting Data Analysis

Learn how to conduct data analysis in the most efficient manner. Become acquainted with the various levels to the process of data analysis in order to become a more effective analyst.

Data Analysis 101: The types of analysis you can conduct

Data Analysis 101: The types of analysis you can conduct

Here we will help you clear up information by displaying the different types of analysis that you can conduct, and under what circumstances you should use them.

Data Analysis 101: Types of Data You Encounter in Data Analysis

Data Analysis 101: Types of Data You Encounter in Data Analysis

Learn about the different categories of data that are used in data analysis, as well as how they are analyzed. Examples are included to further your understanding.

Data Analysis 101: Why do data analytics and analysis?

Data Analysis 101: Why do data analytics and analysis?

Learn what data analytics and data analysis are, as well as how they can benefit your business. Realize the importance of these tools when applied to different aspects of businesses.

What Is Data Munging?

What Is Data Munging?

Learn about the role data munging plays in data analysis, as well as its significance and processes. Furthermore, learn about the range of tools from which you can choose from for data munging.

Your Guide to B2B SaaS

Your Guide to B2B SaaS

Learn what B2B SaaS is, as well as the variety among them to determine which is best for your business. Take account of their various functions in order to benefit your own business.

Key Performance Indicators and KPIs + More

Key Performance Indicators and KPIs + More

Learn about Key Performance Indicators (KPIs) and how they can help your business thrive. We'll go over the difference between KPIs and metrics, KPI criteria, examples of KPIs, and more!

How to Create a Google Sheets Dashboard

How to Create a Google Sheets Dashboard

In this article we are going to show you the steps to creating dashboards in Google Sheets without needing to know how to code. Learn how to import data and use relevant features (pivot table, slicer, etc) to improve your data reporting skills in no time

A Beginner's Guide to SPARKLINE Function in Google Sheets

A Beginner's Guide to SPARKLINE Function in Google Sheets

Make mini line, column, bar, and win-loss charts with the SPARKLINE function in Google Sheets. Great for creating a graph within a cell for dashboards, analytics, and more.

Database Basics: Concepts & Examples for Beginners

Database Basics: Concepts & Examples for Beginners

Get started with relational databases by understanding organized data storage, an overview of management and analytics, and how it all relates to spreadsheets!

SQL Basics: Introduction to Queries

SQL Basics: Introduction to Queries

Get started with Structured Query Language (SQL), the ultimate tool for pulling, analyzing, and managing data. Learn query structure, SELECT, FROM, WHERE, etc.

Popular APIs: Google, Facebook, Instagram, and More

Learn more about the most popular application programming interfaces (APIs), find out how they work, and check out API examples that can help your business!

Advanced SQL Queries & Tutorial

Advanced SQL Queries & Tutorial

Guide to advanced SQL query types, Data Definition Language (DDL) and Data Manipulation Language (DML). Learn how to use CREATE, ALTER, DROP, and more in SQL.

APIs 101: What are APIs and how do APIs work?

APIs 101: What are APIs and how do APIs work?

Learn the basics of Application Programming Interfaces (APIs) by going over its definition, what APIs are used for, a Google Maps API example, and more.

Most Useful SQL Operators, Functions, and Clauses

Most Useful SQL Operators, Functions, and Clauses

Whether you're a beginner at coding or an advanced data professional, this article will help you learn the most important SQL functions, such as CASE-WHEN, AS..

9 Different Data Types to Better Understand Your Business

9 Different Data Types to Better Understand Your Business

A guide to understanding the key data types for your business and corresponding use-cases. We'll cover internal, external, structured, open data, and more.

Managing Internal & External Data to Optimize Your Business

Managing Internal & External Data to Optimize Your Business

Learn the pros and cons of internal and external data and how to leverage both types to inform your business decisions and facilitate future growth.

Definition and Comprehensive Guide to No-Code Programming

Definition and Comprehensive Guide to No-Code Programming

What does no-code really mean? Learn about the no-code movement by understanding its history, pros and cons, and various platforms you can get started with!

Operating Profit Margin

Your operating profit margin determines your companies efficiency and indicates room for improvement. Read on to discover what an operating profit margin is and how to improve an operating profit margin.

Learn how a user is counted in Google Analytics, how you can find the number of users and analyze them, what is the ideal number of users, and how you can further increase it.

Average Time on Page

When your website is based around blogging relevant content, you need a metric to reliably measure its effectiveness. One such metric is average time on page.

CloudTransfer-Yellow

How to Import Mailchimp Data to Google Sheets

Discover how to import Mailchimp data into Google Sheets and harness the power of both platforms in your data analysis.

CloudTransfer-Yellow

How to Import Shopify Data to Google Sheets

Discover 3 ways to import Shopify data into Google Sheets and harness the power of both platforms in your data analysis.

CloudTransfer-Yellow

How to Import Klaviyo Data to Google Sheets

Discover how to import Klaviyo data into Google Sheets and harness the power of both platforms in your data analysis.

How to Create an Order Tracker Sheet in Google Sheets

Learn how to create and use order tracking sheets that will allow you to better communicate with you customers, developing confidence, efficiency, and long-term business success.

SWITCH Function: An Alternative to IF Function in Google Sheets

Learn to use this useful and valuable function which will give you greater control in altering and exchanging values when working in Google Sheets.

How to Lock Cells in Google Sheets [Ultimate Guide]

Use VLOOKUP to Convert Numerical Scores to Letter Scores

Learn an easy and valuable strategy for mastering Google Sheets which will allow you to convert numerical scores into letter grades or assign any one value to another.

Working with Date and Time in SQL in Google Sheets

Learn two functions that will allow you to work with and operate on dates and times in SQL queries in Google Sheets.

How to Find and Replace Strings in Google Sheets

This simple yet powerful tool will help users of all skill levels to maximize their usage of Google Sheets in efficiently processing and analyzing data.

How to Search in Google Sheets

This simple tool is important for every Google Sheets user in expertly tracking and analyzing data, no matter their skill level.

Find the Date X Days After The Start Date in Google Sheets

This tutorial seeks to supply the user with the necessary tools to navigate dates in Google Sheets as they account for specified changes in days, months, and workdays.

Image of a Google Sheets spreadsheet.

Find the Number of Days Between Two Dates in Google Sheets

Learn a vital tool in the navigation of Google Sheets.

AnalyticsGraph-Yellow

How to Create an Area Chart in Google Sheets

There are many different kinds of area charts. Learn how to navigate the creation of these charts in Google Sheets to better model your data and statistics.

SalesMarketIncrease-Yellow

How to Create a Column Chart in Google Sheets

Learn a vital yet simple aspect of navigating Google Sheets.

AnalyticsGraph-Green

How to Create a Line Chart in Google Sheets

Learn a vital yet simple aspect of navigating through Google Sheets, the line chart.

Image of a spreadsheet.

How to Calculate Standard Deviation, Variance, and Z-Score in Google Sheets

Learn how to better navigate Google Sheets and the tools it has to offer. Standard deviation, variance, and z-score are all important aspects and tools at your disposal.

Layered image of a spreadsheet on top of a window conducting data analysis.

How to Connect Google Analytics to Google Sheets

Learn how to connect to vital tools for your business. Doing so will greatly aid in many of your business's endeavors.

Layered image of pie charts within an open computer window.

How to Create a Pie Chart in Google Sheets

Become acquainted with the information necessary to perform this fundamental skill in Google Sheets. This will allow you to better consolidate and digest data.

Layered image of a number with a superscript within a spreadsheet

How to add a Subscript and Superscript in Google Sheets

Learn the basics of this important function of Google Sheets. This information will help you better navigate through the various facets of the program.

DataSearchBar-Yellow

How to Create a Bar Chart in Google Sheets

Learn a vital skill that can be applied to one of the most widely-used programs for data extrapolation. This article focuses one just one of the various services Google Sheets has to offer.

Layered image of a computer and calculations it's running.

How to Calculate the Mean, Median, and Mode in Google Sheets

Data analysis 101: learn the ins and outs of the mean, median, and mode calculations in Google Sheets. This is a very important skill for a widely-utilized computer program.

Double-clicking on the header zooms you in to that section, making it more possible for you to visually see the subdivisions in that category.

How to Make Tree Map Charts in Google Sheets

A tree map diagram is one way to visualize and comprehend data in a chart more easily. This article goes over how you can both add to and customize tree map charts, while also providing you with a sample sheet to work with yourself.

Google Sheet with the questions from a Google Form forming the top fixed row.

How to Integrate Google Sheets with Google Forms [Step-by-Step Tutorial]

Learn how to integrate these two Google apps by storing Google Form results in a Google Sheet and generating a Google Form from a Google Sheet. Great for data collection and analysis.

Google Sheet with FILTER function examples

Using Google Sheets FILTER Function [w/ Single & Multiple Conditions]

Learn how to use FILTER on Google Sheets with single condition, multiple conditions, LARGE sort conditions, and SMALL sort conditions. Useful for data analysis and Google Sheets mastery.

Google Sheets with a Pivot Table. The upper-leftmost cell of the Pivot Table highlighted.

How to Delete Pivot Tables in Google Sheets and Excel

Step-by-step guide on how to delete a pivot table in both Google Sheets and Excel. We'll provide multiple methods and helpful screenshots!

IMPORTFEED importing the latest news headlines with their summary and timestamp.

How to Use Google Sheets IMPORT Functions [IMPORTDATA, IMPORTFEED, & More!]

A beginner's guide to using IMPORTDATA, IMPORTFEED, IMPORTHTML, and IMPORTRANGE to retrieve external data for your Google Sheet.

The int function applied to the entire array using arrayformula.

Guide to Using ARRAYFORMULA in Google Sheets (+ Examples!)

Learn how to use ARRAYFORMULA to copy entire rows, columns, and arrays; apply functions to entire arrays; and apply formulas to entire arrays! Great for improving data analysis and spreadsheet skills.

The Admin API section lists all the possible data that can be accessed via the Shopify API.

How to Find Your Shopify Store's API Key [in 6 easy steps]

Easy step-by-step tutorial on how to generate a private API key for your Shopify Store. Important for exporting Shopify data to Google Sheets and other business apps.

The ranges from multiple sheets combined in the single destination Google Sheet via IMPORTRANGE.

How to Import Multiple Sheets Using the IMPORTRANGE Function

Learn the workaround to combine multiple sheets into one using the IMPORTRANGE function in Google Sheets! We'll take you through the formula and syntax you need to make it happen and improve your data analysis.

Integrations tab, specifically the Google Analytics section, on Webflow Project Settings

How to Track Webflow Button Clicks on Google Analytics

Straightforward step-by-step tutorial on how to set up Google Analytics Events on Webflow elements, like buttons, links, and more! Great for improving website analysis and A/B Testing.

Google Sheet with sample data and VLOOKUP equations on the right

How to use VLOOKUP with Multiple Criteria in Google Sheets

Learn how to combine two or more criteria in the VLOOKUP function on Google Sheets. Great for data analysis with multiple variables.

How to Use ISBLANK Function in Google Sheets

Learn how to use ISBLANK function in Google Sheets without getting FALSE results on blank cells. Important for data validation and analysis in your spreadsheet.

A table of total profit from each product from a specific week, with a row per day of the week, using pivot. The table is essentially transposed, with each item getting their own column.

How to Use the SQL Pivot Clause in Google Sheets

Learn how to use Google Sheets SQL’s Pivot Clause clause to summarize large amounts of data by using two categories, one defining the rows and another defining the columns.

pop-up box for importing workbooks. Has four tabs for four options of importing the workbook: from your own Google Drive, from other users’ workbooks shared with you, from workbooks you recently opened in Google Sheets, and for uploading a spreadsheet file from your computer or smartphone, often as Excel workbook.

3 Easy Ways to Import Data from Another Workbook in Google Sheets

Step-by-step ways to import data from another workbook in Google Sheets. Learn about File>Import, IMPORTRANGE, and QUERY options to get the task done.

Google Sheets list of total profit from each product from a specific week, arranged by decreasing total profit

How to Arrange the Order of SQL Query Results in Google Sheets

Learn how to arrange queried and aggregated data using SQL command 'order by'. Organize in ascending and/or descending order with our tutorial!

Results of the query. The first column contains the specific item, the second column contains the “sum profit” per listed item.

How to Use the 'Group by' SQL Clause in Google Sheets

Learn how to use Google Sheets SQL’s Group by clause to summarize large amounts of data by category defined in the source sheet, whether it’s summarizing by the date of entry or by the items involved.

Pivot table on top of corresponding data

How to Add Custom Formulas in a Google Sheets Pivot Table

Step-by-step guide on how to add custom formulas in a pivot table on Google Sheets. We'll take you through how to add it in the source sheet first and in the Pivot Table directly.

Spreadsheet containing several sheets. Names of sheets are week27, week28, and items. The displayed sheet, week27, contains the list of sales, costs, and the resulting profits.

How to Consolidate Several Sheets into a Single Pivot Table

Learn how to use a pivot table for data from multiple sheets in Google Sheets. We'll teach you how to merge sheet data with the QUERY function, allowing you to have all your data in one pivot table.

Snippet of the output sheet. The column headers were replaced by new ones.

How to Use SQL Labels in Google Sheets

Guide on how to use SQL labels in Google Sheets to make your QUERY functions more efficient and to add column headers to your data!

On top, data of US states and name origins. On bottom, query result listing the states, the year their name was first attested, and language of origin of their names. All the listed states have their name first attested before 1800.

How to Select Multiple Columns through SQL Query in Google Sheets

Learn how to select multiple columns with the QUERY function in Google Sheets and SQL language to add conditions to the query. Great for breaking up large sets of data!

end of data displayed by query. There are 1267 rows loaded by the QUERY command. Selected columns loaded: date of entry, total price of order, and profit from the order.

How to SQL Query Multiple Sheets in Google Sheets

Learn how to query data from multiple sheets of the same workbook, multiple sheets from a different workbook, and more! Useful for handling several sheets of data.

List of states whose names originated from either Spanish language or English language: Arizona, California, Colorado, Delaware, Florida, Georgia, Maine, Maryland, Montana, Nevada, New Hampshire, New Mexico, New York, North Carolina, South Carolina, Texas, Utah, and Washington. Queried from the source worksheet.

How to Use SQL Queries to Search for Specific Words in Google Sheets

Learn how to use the Google Sheets QUERY function to search and filter for specific words and phrases within your dataset. Helpful for analyzing text-heavy spreadsheets!

Image: U.S. states whose names did not originate from Spanish, English, nor French. The ones shown on the screen, in alphabetical order, are near the end of the list: Minnesota, Nebraska, North Dakota, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Dakota, Tennessee, Virginia, West Virginia, and Wyoming.

How to Use SQL Query with Multiple Criteria in Google Sheets

Learn how to create a SQL query based on multiple criteria in Google Sheets. We'll go over some key logical operators like AND, OR, NOT to better enhance your data analysis abilities.

How to Filter Charts Using the Slicer on Google Sheets

An easy 5-step guide on how to filter charts and tables using the Slicer functions on Google Sheets. Improve your data analysis and visualization by harnessing the power of this function.

filtered data loaded into the spreadsheet using the same ImportJSON code.

How to Filter SQL Data Before Importing into Google Sheets

Easy guide on how to filter SQL data before importing into Google Sheets. We'll take you through the specific JSON code and alternative methods.

sample table. Includes columns for the title of the product, the description as the “body html”, the product type, the product handle, date of launch as “published at”, and the price as “variants price”.

How to Use Basic SQL Commands + Query Another Sheet in Google Sheets

Learn more about the QUERY function and easy ways to query another sheet (within the same workbook or from a different workbook) on Google Sheets. Improve your data analysis in no time with basic SQL knowledge!

Returning customer rate graph over time on Shopify, shows a slight dip on average

Finding Shopify eCommerce Metrics: Repeat Customer Rate

Learn how to find the Repeat Customer Rate (or, Returning Customer Rate) on Shopify as well as related metrics like customers over time, one-time customers, and more!

A portion of a spreadsheet of order information. Contains the order timestamp as “Created At:, the total price, the customer name, and two columns where the timestamp was split into one column for the date of order and the time it was ordered.

How to Use SQL Queries to Search by Date on Google Sheets

Search items and data by date via the QUERY function in Google Sheets. Find entries for a specific date and within a date range with step-by-step SQL commands.

Shopify Analytics Dashboard showing AOV

Finding eCommerce Metrics in Shopify: Average Order Value (AOV)

Average Order Value (AOV), the average amount spent per order, is central to measuring the performance of your Shopify store. Check out this tutorial to learn step-by-step how to find this metric.

Online store conversion rate box in Overview dashboard on Shopify

Finding eCommerce Metrics in Shopify: Conversion Funnel Metrics

Learn how to find conversion funnel metrics, shopping cart abandonment rate, and abandoned carts on Shopify to improve your eCommerce and sales performance.

Google script editor. Code from bradjasper’s ImportJSON at GitHub inserted.

How to Export SQL Data to Google Sheets & Update Export

Learn how to import data from a SQL database to Google Sheets and also have the data update/refresh automatically! We'll take you through the specific script and functions needed to accomplish this task in no time.

Google Sheets pivot table, with the items rearranged from biggest profit to smallest.

How to Sort the Rows in the Pivot Table in Google Sheets

Simple 2-step guide on how to sort pivot table rows in Google Sheets. Perfect for enhancing your data analysis and improving your spreadsheet knowledge!

Pivot table in the new sheet. Displays the date as rows. The data cells contain the total profit for each day, as specified under the Values label of the Pivot table editor...

How To Use Pivot Tables To Summarize Data by Time On Google Sheets

Learn how to summarize your data by data, month, year, or any other relevant time period on Google Sheets by using the Pivot Table function. Follow our step-by-step tutorials to complete the tasks in just a couple of clicks!

Overview Dashboard on Shopify under Analytics

Finding eCommerce Metrics in Shopify: Profit and Cost Metrics

Learn how to locate Gross Profit, Gross Profit Margin, Cost of Good Sold (COGS), and Sales on Shopify in order to monitor your online store's profitability.

ResponsiveDesign-Green

Highlight Duplicates in Google Sheets (The Easy Way!)

Spreadsheet named "How to Vlookup From Another Spreadsheet..." with data below and the second column using VLOOKUP.

How to Vlookup From Another Spreadsheet on Google Sheets

Step-by-step tutorial of how you can use VLOOKUP between two spreadsheets on Google Sheets. We'll also take you through what search_key, range, and index means.

How to Count Non-Empty Cells in Google Sheets

Google Sheets 101. Step-by-step tutorial of 3 ways you can count cells IF NOT blank on Google Sheets. We'll take you through how to use COUNTA, COUNTIF, and SUMPRODUCT for this use-case, as well as other Google Sheets tips and tricks.

Google Sheet titled "Using Conditional Formatting Based On..." with a table of Customer Name and corresponding payments for months May, June, and July

How to Use Conditional Formatting Based On Another Cell

Step-by-step tutorials on how you can apply conditional formatting based on the value of other cells in Google Sheets. We'll provide an example of a Sales use-case!

Annual sales data, one column per branch, with line chart

How to Create a Chart with Multiple Ranges of Data in Google Sheets

Step-by-step tutorials on how you can create a chart with multiple ranges of data. We'll also take you through how to flip rows and columns so chart input is easier!

A table with values, percentage column empty

Absolute Reference in Google Sheets: A Beginner's Guide

A simple guide on how to use absolute references, the infamous F4 keyboard shortcut, and what other reference types (i.e. A$1, $A1) mean!

Completed chart with title and labels

How to Add a Title and Label the Legends of Charts in Google Sheets

3 step-by-step tutorials on how you can customize your charts in Google Sheets, including adding a title, labeling legends, and changing the position of your legend!

Remove duplicates option under Data highlighted

How to Remove Duplicates in Google Sheets

3 step-by-step tutorials on how you can remove duplicates in Google Sheets via Remove Duplicates tool, the UNIQUE function, and external add-ons!

Header image. The cell on another sheet selected.

How to Reference Another Sheet in the Same Workbook on Google Sheets

Easy step-by-step tutorial on how to reference cell(s) from another sheet in the same Google Sheets workbook! Useful for organizing large amounts of data.

Import file window. Upload tab shown

How to Convert Excel Files to Google Sheets (and Vice-Versa!)

As a free alternative to Microsoft Excel, you're likely interested in how to convert .xlsx files to Google Sheets. We'll take you through 2 simple methods for this!

Article Tags

Metrics calculator

Profitability metrics

Predict performance metrics

Customer behavior metrics

Customer satisfaction metrics