Recently, I plan to learn something about data analysis. In the figure below, although there are a lot of advertising elements, there are many techniques. It is said that programmers should have a little product thinking and be sensitive to data.
After reading the introduction of some training institutions, there are many knowledge points involved, including tools, thinking, practice and final report. Sure enough, you can’t be a fat man. Take your time.
In the tools, Excel and SQL should be the most basic, but my office license has expired, and I don’t want to crack it. Besides, now the localization is booming, use WPS to see if it can replace it
Download ODBC driver and download it
First, go to the following link and select psqlodbc_ 11_ 01_ 000.zip Click to download
Add data source after installation
Open control panel – management tools, select obbc data source (32-bit) and double-click
Click “add” in the pop-up dialog box and select PostgreSQL Unicode
Get your database name, service address, user name, port and password
Fill in the dialog box and click “test” to test the connection. What I am using here is a free cloud database memfiredb. When I prompt “connection successful”, it means the connection is successful. Click “save” to save. Finally, click “OK” to complete all the settings
Importing data in WPS
Click “data” – “import data”
Select “import data” in the drop-down list. Note that “connect database” is not selected here. Select the ODBC data source configured before, and click “OK” and “next”
Select the data table name and related fields to import
Select filter statement
Import data, see the results, then we can call function and drawing in WPS.