“I’m drunk at present. I can’t sleep if I don’t make the report. I have to make it up for a night if I ask where the wine house has it.” behind the doggerel poem with some sense of humor, it’s my sad experience of working for many years. Yes, I’m your brother, cousin, who makes the report.
A few days ago, in the process of communicating with others, I found that the market is changing so fast that not only excel is behind in making reports, but also the final data should be displayed in a beautiful, direct and cool way. I don’t know anything and don’t want to learn, and I only use Excel’s old grease sticks. Facing this news, I can’t help but feel a sweat for my career.
So how to present the data is what you call beautiful and cool, which makes people happy? I got an answer that everyone agrees with, data visualization.
What is data visualization?
When we talk about data visualization, we will think of these characteristics. Compared with traditional reports, data visualization makes data presentation more intuitive, fast and easy to receive. Let’s see what data visualization is like.
I’m a veteran of IT industry for many years, but I’m dazzled by this effect! If I was a leader, I would like to hire someone like this. What kind of bike would I need?!
In fact, the visualization chart is not complicated. Many people recommend python, R language, tableau and other professional data analysis tools that can be easily implemented. However, this is only for professional data people or proficient in these professional tools for people! People like college students, business people or people who often make reports, who want to realize some visual analysis, can’t take the time to study professional tools like python, tableau and R. the learning cost and difficulty of these tools are quite large.
So is there a visualization tool suitable for novices, which can be used in just a few minutes, and the effect is cool and practical? Of course, there is. For example, the finereport I would like to recommend today.
Fineport is an enterprise level Web report software, which solves the problem of enterprise data query, display and entry. It can form a large visual screen by dragging, simple and convenient. Traditional reports are often presented in the form of tables, which can highlight the data itself, but it is not conducive to the reader to see the relationship between the data intuitively. In addition to the realization of complex table styles, finereport also has extremely rich charts, which can meet the requirements of various data visualization scenarios.
How to use fineport for visualization?
The purpose of the large screen is to make leaders and colleagues see each data indicator more clearly, so we need to analyze which dimensions need to be displayed first, such as:
Time dimension: what time nodes do the best business and the comparison between different times
Geographic dimension: which region’s projects do the best and the differences between regions
Then you need to put all the points that need to be displayed for these different dimensions in the designer, and then drag the data on the left side into each point that needs to be displayed.
Seemingly complex and cool data visualization large screen, learn this tool to easily handle
2. color matching
A cool large screen, the background color is very important, generally choose a dark color or picture, you can match with some pictures with stars, stripes and other effects to make the large screen look more technical. Specific operation: server – chart predefined color – add new predefined style – edit chart – series color selection, secretly tell you a trick, set chart predefined color in advance, you can change color for chart series.
Details will greatly affect the overall effect. It is necessary to add some decorative effects such as borders and pictures to elements, titles, numbers, etc. to help improve the overall beauty.
4. Dynamic visualization
The dynamic visualization mentioned above also benefits from various built-in components of fineport. Here, we divide the data visualization in finereport into three categories: statistical chart, dynamic chart focusing on large screen and plug-in.
I. statistical chart
Here’s a suggestion: there are too many chart styles, and the large screen will be disordered. Generally, in the whole large screen, the proportion of histogram should be larger.
Fineport provides dozens of statistical charts, each of which contains a variety of styles.
The actual examples of each chart are as follows. Because there are too many officially provided styles, some examples are as follows.
2. Personalized configuration
The product has built-in official predefined styles, which can be selected as needed.
In addition to the official custom style, there are also options for users to adjust, including title, label, legend, background, coordinate axis, etc.
The extended chart plug-in is developed based on technologies such as web GL. It can achieve multiple effects such as automatic playback and 3D animation effects by simple drag and drop. It can also provide “automatic rotation” and “regular refresh” according to the chart type and data to meet the business needs of users in different scenarios, and make the large screen cool while reflecting the data value.
1. 3D composite map
Open server > plug in Management > install / update the extension chart, select the extension chart – map class, rotate 3D composite map, and select data sources for four map forms respectively, so that the sub 3D composite map is completed.
2. 3D effect components
Broadcast GIS point map in turn, according to the user’s pre input data, play the relevant information of each geographical point in order, 3D perspective and jump animation are just like immersive.
3. Dynamic indicator card
Fineport provides a variety of optional effects, such as round robin, particle technologist, etc., to display the most basic data in a ‘cool’ and ‘concise’ way.
III. dynamic loading effect
Fineport uses components to load dynamic effects to make each component module dance and make the whole large screen interface static. More importantly, component loading dynamics can be combined with our monitoring refresh function. From where the original data comes from, from where the old data goes, to how the new data comes in, taking into account the whole closed-loop good experience.
IV. drilling and linkage
Drilling includes up and down. Roll up is to observe more general data by rising in dimension level or by eliminating one or some dimensions. RIH is a more detailed observation of data by descending in dimension level or by introducing some dimension or some dimension.
If you want to filter out the interested points for a comprehensive understanding, you can use the graph linkage function. For example, in the visual Kanban above, I want to know the specific situation of Zhejiang Province. Just click “Zhejiang” in the map, and other charts will be linked together:
Maybe we are still immersed in the traditional data processing methods, and we can’t accept this kind of visual large screen representation, and think it’s flashy and only eye-catching.
It’s hard to avoid doubt about new things, but we need to focus on the question of whether this way can make data produce value? Does it stand the scrutiny of the business department? Is it helpful for business operation?
Come out from the cool appearance, conduct multi-dimensional analysis, pay attention to the value of data itself, and devote to empowering enterprises with data. This is what fansoft has been doing: make data become productivity.