How to analyze and process big data?

The data in the database will be extracted, cleaned, and transformed to integrate the scattered, fragmented, and inconsistent data together, and improve the query performance by modeling the data in the analysis database.

Big data collection refers to the use of multiple databases to receive data from the client (Web, app, or sensor form, etc.), and the user can use these databases to perform simple query and processing work.

In order to obtain useful information from it; data analysis: the use of big data analysis tools to mine the data in order to find useful information and laws.

excel in the selection of a particular value

IF function to determine whether the value of the summary table C2: C13 cell area and the corresponding worksheet table name is equal, if equal, then return the value of the C-column corresponding to the number of rows, otherwise return 4 ^ 8, the results get a memory array.

ROUNDDOWN function is down to the specified value, the first parameter is the need to round the source number, the second parameter is the number of decimal places, because it is a percentage of the data, so the conversion to a decimal, then 35 is the number of two decimal places, so take 2; TRUNC function is to extract the specified value of the digits, the same as the ROUNDDOWN function.

Select the need to filter the excel table by column, enter the editing interface, and select all the contents. In the menu bar, select the "Data" menu, click the menu under the "filter" button. The top of the columns will appear down the triangle symbol.

Click on the first line of the form, click on the toolbar above the filter, set the form can be filtered, click on the need to filter the cell, the filter conditions can be filtered out of the value of the specific conditions entered.

Open the excel table, in the A column cell enter the need to extract the value of the content. In cell B1 enter the function formula: = LEFT (A1, LEN (A1) -5), meaning that the value of A1 as the basis for the A1 countdown to 5 digits removed.

Use EXCEL's IF function to select a range and then return a specific value.

Excel how to filter a specified value of a column and display it

First click to open the excel table to be filtered, and then select the data to be filtered. Then click on the toolbar above the "Sort and Filter" tool option, in the pop-up tab click to select the "Filter" option.

Methods to copy the entire column to a blank space, point data under the Delete Duplicates button, the rest is the only value; methods to point to insert a pivot table, drag the field to the row tab, will show the only list of de-emphasized.

First of all, open the excel table, the mouse to select the need to screen a column of data. Once selected, click on the toolbar filter at the top of the form. In the drop-down menu of the screening tool to select the option of screening. At this point in the column of data above the see a drop-down button, click on the data can be filtered on this column.

Excel can use the Vlookup function to find a specified value in a column, and then output the column behind him.

Excel within the column to find specific characters and return the corresponding value of the specific method of operation is as follows: a simple example, the example is simple but very image, to be able to understand the use of the function can be.