Blog
Join us on Slack
Try for free
All blog articles
Lido's Blog
Data & Analytics
Learn about different data types, databases, SQL, and more.
Search
Blog Posts
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
Blog Posts
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.
Blog Posts
How to Make a KPI Dashboard With Google Sheets
Blog Posts
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?
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
What is MongoDB?
Learn about MongoDB and what sets it apart from other non-relational and relational databases
Blog Posts
What is Snowflake Database?
Learn about Snowflake databases and how they're different from other relational databases and data warehouses.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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.
Blog Posts
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!
Blog Posts
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
Blog Posts
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.
Blog Posts
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!
Blog Posts
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.
Blog Posts
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!
Blog Posts
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.
Blog Posts
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.
Blog Posts
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..
Blog Posts
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.
Blog Posts
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.
Blog Posts
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!
Metrics
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.
Metrics
Unique Users
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.
Metrics
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.
Next
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
How to Lock Cells in Google Sheets [Ultimate Guide]
Tutorials
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.
Tutorials
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.
Tutorials
How to Search in Google Sheets
Tutorials
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.
Tutorials
Find the Number of Days Between Two Dates in Google Sheets
Learn a vital tool in the navigation of Google Sheets.
Tutorials
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.
Tutorials
How to Create a Column Chart in Google Sheets
Learn a vital yet simple aspect of navigating Google Sheets.
Tutorials
How to Create a Line Chart in Google Sheets
Learn a vital yet simple aspect of navigating through Google Sheets, the line chart.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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!
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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!
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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!
Tutorials
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!
Tutorials
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.
Tutorials
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!
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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!
Tutorials
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!
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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.
Tutorials
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!
Tutorials
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!
Tutorials
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.
Tutorials
Highlight Duplicates in Google Sheets (The Easy Way!)
Tutorials
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.
Tutorials
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.
Tutorials
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!
Tutorials
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!
Tutorials
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!
Tutorials
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!
Tutorials
How to Remove Duplicates Google Sheets [2023 Update]
Tutorials
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.
Tutorials
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