Shulou(Shulou.com)06/01 Report--

How to use EXCEL to operate the database, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

The Internet is a fast-paced era, not proficient in tools, not skilled in the use of tools, will greatly affect work efficiency. A long time ago, you could make a living as long as you learned to use a tool, but now in the Internet era, everything is changing so fast that only one move on the battlefield no longer works, and the individual's ability will become stronger with the development of the times. the big reason for making yourself strong is the rapid and skilled use of tools. For example, we use EXCEL as a common office tool when we deal with tabular data, but with the increasing amount of data, the processing capacity of EXCEL is extremely limited, so we need to master other more powerful tools, such as databases.

Xiao Wang works as an accountant in an e-commerce company. In addition to being responsible for financial matters, he is also responsible for counting the monthly sales of the company's online stores and the performance of his employees. At first, when the scale of the company is not very large, the amount of data is not very large. Xiao Wang can do it all by himself. Later, with the continuous expansion of the size of the company, the amount of data of the company has increased by dozens of times, and the processing with EXCEL is quite slow. When calculating the performance at the end of the month, Xiao Wang and another colleague have to work overtime for several days to complete the statistics. Since Xiao Wang is not a data analysis major, his EXCEL proficiency is mediocre and does not know how to use other more advanced tools, so he is very worried every time he sees some huge forms.

Why not connect to the database? If you get the data directly from the database, the work efficiency will certainly increase a lot.

Unfortunately, the database function of Excel is very difficult to use, and Microsoft does not integrate the drivers of various databases into the office installation package, so when you want to connect to the database, a prompt will pop up-"this connection requires the installation of one or more other components to use." It is believed that 99% of users will give up at this time. After installing the driver, the next step is to enter the user, password, and SQL statements. Needless to say, ordinary users must look confused.

Is there any easier way to do that? The answer is yes, it can be solved with a plug-in. Smartbi's intelligent analysis cloud platform is an EXCEL plug-in product launched to solve this problem, the main function of which is to make EXCEL more convenient to connect to the database, even if you are not a technician and cannot write code, you can still operate to connect to the database on EXCEL and enjoy the pleasure of pulling and pulling data, isn't it very sour? Will no longer be bothered by a large capacity of data, from then on to the peak of life, silently go their own way, let others work overtime …

Since the intelligence analysis is so amazing, what is so powerful? Don't worry, it's just a mule or a horse for a walk. let's use two application scenarios to introduce how to connect to the database through intellectual analysis in EXCEL.

1. Connect to DEMO database

After installing Smart Analytics, the Smartbi interface will appear in the EXCEL toolbar. Click Import File, and you can import your data source to the cloud platform of Intelligence Analysis. The operation is very simple, and there is nothing complicated and difficult to understand. You only need to click a few mouse clicks to complete it:

Import the data source into the intellectual analysis local DEMO database, you can find the data source you just uploaded to the database in the dataset panel on the right. Just drag and drop the field you want to EXCEL for analysis. Is it very convenient?

2. Connect to your database

If the address of the database can be accessed directly through the public network IP or domain name, or you can create a database connection, let's take MySQL database as an example, click MySQL database type, select the database type in the connection window, enter the connection string and user password, and allow excel data to be loaded:

After completing the above simple operation, find the database file in the dataset panel on the right, and you can freely drag and drop the data fields in EXCEL:

Through the introduction of the above two scenarios of connecting to the database, I believe you must appreciate the power of this plug-in, there is almost no technical threshold, as long as you are a technical rookie who often uses EXCEL and does not know how to write code, this plug-in will allow you to release yourself and become more comfortable when dealing with data big data, so that the database is no longer something that technicians can play with.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.