Photo by Author | Ideogram
Introduction
Air Table Cloud-based, user-friendly, and AI-driving platform to make, manage and share a database. It connects the best Excel spreadsheet with a relative database management system. The air table offers a freeium subscription model, under which some limited features can be used for free, which is ideal for small projects or initials, while the paid version provides a large amount of advanced features and computing resources.
This article provides a preliminary point for anyone who is interested in the air table and especially offered it at the initial level of data analysis. The article runs from the process of creating a new air table app that contains some data and is used for some of the basic analysis methods.
To sign up and make your first project
As a cloud -based tool, the air table does not need to download desktop application, but only to access it Website And sign up. If you have a Google account, for example, you can use it for quick signup. Otherwise, there is the option to enroll using an email address.
Once you sign up, we are ready to create our first project. Concept of, in the air table, Principle Or App According to a project or app – basically, a container for all data – so let’s create a new base. If you can’t see the “Create an empty app” button at first glance, you may have to check the “Create” button on the bottom left corner or, as an alternative, if there is an “X” icon to click on the top right corner, click on it and you will be indicated to create an empty app.
Then you should see such a screen:
New Base (Project) in Air Table
It’s time to import some data. Air table bases include one or more tables. As default, an empty table called “Table 1” appears. Next to him, a tab called “+ Add or import“In the air table, there are different options for adding data to our project, for example, from Google Sheets or Excel, Sales Force, Google Drive, Trillo, and more from spreadsheet. We will use a simplest approach: Uploading a CSV file, selecting a concrete from a URL.CSV file“, And on the left of the emerging window, select”Link (URL)“, As shown below:
Uploading CSV data via URL
Copy the following URL in a datastate that I have made available to you in the Gut Hub, and paste it into the text field that appears. Then click the blue button on the right, and when asked to create a new table or use a table current, make sure you create a new table. Don’t be tempted to use the existing default table called “Table 1”, as it is not compatible with the table scheme dataset that we are importing.
This is! Now you have a new table set up with imported data, which is recorded Consumers in shopping mallWith the following attributes:
- Customer ID: Numeric identifier of a user.
- Genre: Customer’s gender, namely male or female.
- Age: The customer’s age expressed as a number.
- Income: Consumer annual income in thousands of US dollars ($).
- Scores scores: A common score between 1 and 100 of the customer’s expense level.
Starting data analysis
In the imported table, all the columns are of the numeric type, except for the “gender”, which is the dot. In the air table, one of them is called “single -select” a double column with a potential price between a fixed set. You can check or edit the features of a “gender” or another field by clicking on the icon, such as the V -V, on the column header, and select the “Edit Field”. We will leave like the type of column, and move on to do some analysis.
Grouping users through gender: Grouping data records according to the values ​​of a clear attribute is as easy as clicking on the “Group” button above the table. Choose “gender” and then “eliminate all” to see the summary of your data collected by each gender. By default, you will see the total (amount) of per attribute and gender values, but you can also choose to look at the values ​​of the average (or median, minute, maximum, etc.) of income, costs, and similar columns. This can be done as shown in the following screenshot:
Analyzing Group -Group users by gender
We can observe that men earn more than women, but women spend more than men.
Average income and expenses scores by gender
To remove the grouping of the data, just click on the “group” icon, then click on the Ben Eicican with the grouping created to remove it and see your full, unorganized table again.
To filter young users: Next, let’s try filtering. It is an easy and intuitive operation available on the “Group” icon, the “Filter” icon, available on the previously used. In the popup dialog, select “Add+ Condition”. Filtering condition includes three elements: a field or column name, operator, and one value. Examples of the terms “age> = 39”, “costs score = 10”, “gender is not male”, etc. To filter young users, we will set this condition “Age <30". It should filter 55 users a total of 55. One of the interesting things to do at this point is to connect the filter (once again) with a gender grouping, to find out if the results of the income and expenses scores in men with the results of women are still applying for young consumers. Once you try this, the filters can be easily removed like grouping.
The use of formulas to describe the “Income Class” field: Air table allows for new columns under many different ways, formulas are one of them. Click the “+” button with the right-all columns in your table to add a new column, and select the “formula” as a type of creation method or column. For example, we can use the following formula:
IF({Annual Income (k$)} < 40, "Low",
IF({Annual Income (k$)} < 70, "Medium", "High"))To create a new column called “Income Class”, whose values ​​(categories) depend on the cost of the annual income column, comprises two nasd conditions, following the above formula. If you are not familiar with the syntax of the spreadsheet -like formulas, don’t panic, the “Create a Formula with AI” button under which the Air table AI assistant can help create a formula based on your characteristics or purpose.
Use of formulas to create a new column
Use of interface to imagine your data: Air Table Interface Data are used to produce visual. This feature is limited to the free level, but still it is possible to create simple dashboards with elements such as charts and axes tables-that is, cross column tables that summarize and collect the field-based data. To try to create an interface, click on the “interface” in the top toolbar, and follow the assistant steps. You can get something like this dashboard:
Interface dashboard in the air table
Note that the interface is designed to share between teams, such as to run the business intelligence process.
Wrap
This article introduces a versatile and user -friendly cloud -based platform for air tables, data management and analysis, combining the features of the spreadsheet and relative database with AI -powered functions. The purpose of the guide provided in this article is to introduce new users to the air table and outline some of the basic functions for data analysis. Needless to say, when they are not our central attention, the AI ​​features provided by this device are one of the next steps to look beyond this point.
Ivan Palomars Carcosa AI, Machine Learning, Deep Learning and LLMS is a leader, writer, speaker, and adviser. He trains and guides others to use AI in the real world.