Overview of data cleaning & integration- FineBI Help Document FineBI Document

Recent Updates: April 26, 2022

1. Overview

After acquiring business data, users may not be able to directly calculate and visually display and analyze the data quality. At this time, they need to use BI tools to process the existing data first to improve the data quality.

2. Index

Steps	Reference files
Data cleaning	Data desensitization
	Infinity/negative/null values are displayed as 0
	Date and string conversion
	Skillfully using IF function to process data
	Determine if a field contains a string
	Remove certain characters from a string
Data integration	Multi-conditional assignment
	Column perspective
	Inverse perspective
	Data match / find
	Data merging, interception, and split
	Group by time interval
	Splicing different columns of data
	Intercept the content after the specified character that appears multiple
	Intercept the specified characters in a field
Data operation	Conditional summation and counting
	Common date formula
	Count the number of occurrences of a character in a field
	Calculate the annual year-on-year cumulative amount
	Calculate the cumulative average
	Add a serial number to the table
	Find the percentage of the top six in the sum of the top six respectively
	Calculate the average of the previous n days/when data is not unique

Already the First

Already the Last

Helpful
Not helpful
Only read

售前咨询电话

400-811-8890转1

在线技术支持

在线QQ：800049425

热线电话：400-811-8890转2

总裁办24H投诉

热线电话：173-1278-1526

文档反馈

鼠标选中内容，快速反馈问题

鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

不再提示

10s后关闭

Overview of data cleaning & integration

1. Overview

2. Index

Attachment List