As a cousin who just graduated from a state-owned enterprise and engaged in report work, I can basically deal with the demands from various departments with my Excel and SQL skills. In addition to the boring work, I often need to work overtime, and my work in recent years is quite satisfying. After all, I’m not an ambitious person, so it seems good to keep going at this pace. Until one day, the leader called me to his office and showed me several photos: “Chen, yesterday WHEN I went to other companies to communicate, I saw their statements are pretty good-looking, can you also do this, our present is not very beautiful ah!” After seeing these photos, I felt a little like committing seppuku. Could this kind of statement really be made by a cousin of mine? But in the face of the eager eyes of the leader, I really had no courage to refuse, so I could only accept.

Out of the leadership of the office, I take a long breath, ready to break the existing calm, learning 18 martial arts ready. Go ahead and do your research as soon as you get back to your desk. From then on, I found a new world. It was at this time that I realized how little PROGRESS I had made in the past two years and how satisfied I was with the status quo. As a person who deals with reports every day, I didn’t know there was such a thing as visual report tools.

After a period of comparison, THE personal version of Finereport, which is free to use, attracted me. It’s free, so let’s try it first. So I applied for a personal version of the download, followed the help documents and teaching videos to learn, more and more find the interesting and fast visual statements, in my eyes, it is basically impossible to complete those cool statements are now so easy. Later, I also tried some other visual reporting tools, and I was more attracted to finereport by comprehensive comparison.

First, Finereport is convenient and easy to learn and use. It has an Excel like style, so you don’t have to worry about getting used to Excel and not getting used to it. Basically, as long as you know how to use Excel, you can handle it easily.



Fansoft community has a very complete learning materials, with help documents and videos to learn, is a quick start. As long as you know some SQL and have some knowledge of data tables, you can get started quickly.

In addition, FineReport makes reports on data fields rather than specific data, and table extensions are also based on fields. After making the first template, most of the following operations can be completed by simple drag and drop. It can read data in the database automatically generate reports, using the template every time as long as the synchronization, can automatically synchronize periodic reports, such as daily, weekly, monthly, quarterly and so on. Also can batch export/print, you do not need to go to a statistical summary with Excel. I used to spend a day to complete the sales report, but now I use a template to spend more than an hour to do it, and export it in batches in minutes. “Quick” in one word. The efficiency of database integration is not the same as the efficiency of development.

Second, Finereport has great visualizations. It comes with over 50 visualizations to meet all kinds of needs.



There are also some cool visual motion-effects plug-ins that are great for creating large visual screens.





This is the result, and believe me, the leader loves this result, after all, everyone loves beauty.



Third, Finereport can quickly process much larger amounts of data. When I used Excel to make statements, there was no problem if the data amount was less than 100,000, but it was easy to be blocked when the data amount was large. Once, when I processed an annual data, my computer was directly blocked and I had to do it again before I could save it. With Finereport, you don’t have to worry about that, and you don’t have to deal with the pressure of having millions of dollars of data in your company.

Fourth, Finereport can realize unified collation of data without manual summary. Believe that many, including myself, statements workers have encountered such a problem, and is processed by excel form to find the last data to collect, such as a table, same operation on the different people, may be on the table to modify the data, or the wrong operation, resulting in all the data is not unified, And then our miserable Cousins had to work overtime to recheck the data. FineReport adopts the online deployment mode, supports online filling, and stores data in the database in a unified manner. Every time the data is modified in a unified manner, the problem of data mismatch can be avoided.



The above mentioned are just a few advantages of Finereport, many technical content I will share with you next time. In fact, this is a very powerful artifact, interested friends can contact me for a personal version of the application link to try.

As for me, you must have guessed that the leadership was very satisfied with my statement and decided to build a statement platform in the whole company. I became one of the persons in charge of this statement project and my salary was doubled. From an unmotivated cousin to the head of a corporate project, visual reporting tools have helped me a lot.