Home
Analogues
This section contains 1010data analogues for Excel and SQL users.
1010data for Excel users
1010data can solve the same problems that you are used to solving in Excel in one or more ways. Sometimes there are direct translations between the two, and sometimes a unique solution is needed in order to arrive at the same result.
Introduction

Analogues
This section contains 1010data analogues for Excel and SQL users.
- 1010data for Excel users
  1010data can solve the same problems that you are used to solving in Excel in one or more ways. Sometimes there are direct translations between the two, and sometimes a unique solution is needed in order to arrive at the same result.
  - Introduction
  - Function comparisons
    You know how to use certain functions in Excel, but you want to know how to complete the same tasks using 1010data's functions. While some Excel functions have a direct match to a function in 1010data, others match to a combination of functions/operations. The following sections show some of the analogous functions between Excel and 1010data.
  - Calculations
  - Visualizations
- 1010data for SQL users
  1010data users have backgrounds using different programming languages, databases, and analytical tools. One of the most widely used tools for data is SQL. This section of the 1010data Cookbook was created to help the users with SQL background learn how to complete tasks in 1010data. Each analogue will describe a problem that the user knows how to complete in SQL, and then show how to solve the problem in 1010data.

Introduction

Many people use Excel to analyze and visualize their data. This section describes how to solve the same problems and create the same visualizations using 1010data.

There are two main parts of this section, how to perform similar calculations and how to obtain similar visualizations. You can perform similar analyses in 1010data using both the GUI and the Macro Language. Some analogue solutions shown in this section will have both a GUI solution and a Macro Language solution, while others might only have a Macro Language solution. Additionally, some analogues might have multiple solutions that show how to solve the problem in different ways, keep in mind that the first solution listed is often the most efficient solution and therefore is preferred.

Visualizing your data in 1010data can be done in many different ways. Most simply, you can use the chart builder in the GUI to build multiple different types of charts. Additionally, you can build QuickApps to visualize different aspects of your data and allow end users to have control over what they see.

1010data allows you to analyze large amounts of data with more efficiency and faster speeds.