FineBI Application Tutorial Collection- FineBI Help Document FineBI Document

Recent Updates: April 26, 2022

Overview

This article sifts, organizes, categorizes, and arranges the practical application documents of FineBI in the help documentation, and forms a collection of content, which basically covers all aspects of the practical use of FineBI. It is categorized into different chapters by difficulty level and content module. Click the title to enter the corresponding article.

Continuously updating......

FineBI Special topics

Classification	Document
Linkage	Component setup linkage
	Clear all linkages
	Cancel linkage settings between components
Jump	Introduction to component jump
Drill	Introduction to drill
Sort	Overview of sort
Filter	Introduction to dashboard filter Overview of filter components
Proportion	Profile of proportion
Year-on-year/Chain growth rate	Profile of year-on-year/chain growth rate
Chart	Beginner's guide to chart
Data Cleaning&Integration&Operation	Overview of data cleaning&integration&operation

FineBI Functions

Classification		Document
Function primer		Beginner's guide to computing Calculation type selection Function calculation format
Common questions/formula combinations		Common function syntax FAQ
Common questions/formula combinations		Common date formulas
Important function		Handling data with IF functions
		Aggregation functions
		Quick calculation functions
Data cleaning	Text character processing	Special character handling
		Data desensitization
		Infinite/negative/null values shown as 0
		Remove certain characters from a string
		Find duplicate data in different column fields
	Date data processing	Count the number of times one character appears in a field
		Remove certain characters from a string
		Infinite/negative/null values shown as 0
		Determine if a field contains a string
		Regular expression examples
		Take one of the two columns of time data
		Calculate the number of working days in the two-day period
Date integration	Intercept/Splice characters	Data merging, interception, disaggregation
		Data Matching/Finding
		Splicing different columns of data
		Intercept the specified characters in a field
		Cut off multiple occurs of specified characters after the content
		Splice different text in one column of data
	Group and assign values	Grouping by time interval
	Group and assign values	Multi-condition assignment
Date operation	Calculate statistics	Conditions Counting
	Marker serial number	Adding serial numbers to a table
	Mean/plural calculation	Find the average of the previous n days/average under the condi-tion of no unique data
		Find the plural
		Calculate the cumulative average
	Accumulated value calculation	Calculate the cumulative value from the specified time

FineBI Applications

Classification	Document
Sorting Application	Dynamic display of TOPN data
	Multi-column sorting
	Tied rankings no occupying positions
Custom Chinese Units	Custom Chinese Units
Dynamic display title	Dynamic display of titles
Field format conversion	Convert text-based or numeric time values to date format
	Convert a text field to a numeric field
	Display the characters corresponding to the numeric code
	Convert year-month-day date format to year-month
Merge data tables	Multiple indicators combined for percentage analysis
Merge data tables	Multi-table merge/statistical scenarios
Filtering Applications	Dynamically display data before and after filtering component values for a period of time
	Dynamically calculate the number of additions in a certain time period
	Dynamic filtering of three months of data on component values
	Filter weekday time data
	Find the maximum value in a certain time period
	Filter indicator fields that do not appear in the table
	Filtering custom time period data
Row transformation (perspective)	Self-service dataset row to column conversion
	Base table row to column conversion
	Inverse Perspective
Take the latest time	Take the data of the latest time
Others	Two ways to see the data behind the chart
	Judging sales by the sales of a certain day
	Group aggregation to remove duplicate data

FineBI Analysis

Summary: Summary of common data analysis methods

Classification	Document
External user analysis	RFM Analysis
	ABC Analysis
	Boston Matrix Chart
	Transformation Analysis
	Shopping Cart Analysis - Association Rules
	Repurchase rate analysis
	Retention Analysis
	AARRR User Operation Analysis
	Monthly Repurchase Analysis
	User life state analysis
	User inflow and outflow analysis
	Requirements Analysis Methodology
	Break-even analysis
	User stickiness analysis
Internal Operations Analysis	Inventory turnover analysis
Internal Operations Analysis	DuPont Analysis
Counting statistics scenarios	De-duplication Counting Scenarios
	Number of occurrences of category summary statistics
	De-duplication count statistics filtered to participate in the calculation
	Comparison of Total Remittance

FineBI Design

More visual presentation tips can be found at: Visualization Guide

Classification	Document
Chart Display Tips	Left and right axis 0 scale alignment
Chart Display Tips	Chart showing both current and prior year data
Mapping Tips	Specifying data in a tagging table
Mapping Tips	Mark the maximum and minimum values with a special color
Creative Charts	Population Pyramid Chart
	Calendar Chart
	Bullet Chart
	Interval bar chart (box chart alternative)
Chart Show	Stacked bar chart comparison showing the total score relationship
Chart Show	Chart showing both current and prior year data

FineBI New theme scenes DEMO

Classification	Document
Financial Topics	2020 First Half Operating Analysis
	Asset and liability analysis
	Profit Analysis
	Marketing performance analysis case
	Business Analysis Report Case
Sales Topics	Category Business Analysis
Sales Topics	Marketing performance analysis case
Inventory Topics	Analysis of goods inventory structure
Personnel Topics	Personnel separation analysis
	Separation Analysis Report
	Departmental Attendance Analysis
	Timed scheduling simple example of weekly report
Conference Topics	How to efficiently support meeting decisions with data Meeting Scenario Examples

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后关闭

FineBI Application Tutorial Collection