This section contains 1010data analogues for Excel and SQL 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.
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.
Performing a cross tabulation can produce a table that mimics a pivot table in Excel.
Cross tabulations allow you to view multiple metrics across two dimensions, which is similar to a pivot table in Excel.
Conditional formatting allows you to easily distinguish data in a table or chart.
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.
