What software do you learn to work in a data center

1. Go to school to learn more professional theoretical knowledge, but also practical training courses.

2. List the software and learning methods you will encounter in data analysis work<

for beginners, it is recommended to start with Excel tools to lay a good foundation for reports

learning excel is also a step-by-step process

basic: simple table data processing, printing, querying, filtering, sorting

functions and formulas: common functions, advanced data calculation, array formulas, multi-dimensional references, and so on Function

visual chart: graphic display, advanced chart, chart plug-in

PivotTable, VBA program development

according to my usual method, first go through the basics, know what is, and then find a few cases to practice. Visit the excel home forum more often, think more about how to use Excel to solve problems, make good use of plug-ins, and remember to save

function and PivotTable are two key points. For learning from business scenarios, please refer to who says rookies can't do data analysis<

Excel functions that must be mastered in making data templates

date functions: day, month, year, date, today, weekday, weeknum. Date function is necessary for analysis template. You can use date function to control the display of data and query the data in a specified period

mathematical functions: proct, Rand, randbetween, round, sum, SUMIF, sumifs, sumproct

statistical functions: large, small, Max, min, medium, mode, rank, count, count, count, average, average if, average if. Statistical function plays an important role in data analysis. It can be used to calculate the average value, the maximum value, the median and the many digits

find and reference functions: choose, match, index, direct, column, row, vlookup, hlookup, lookup, offset, getpivot data. Needless to say, the functions, especially vlookup, are not complex. It is difficult for a report to move

text functions: find, search, text, value, concatenate, left, right, mid, len. Most of these functions are used in the data processing stage

logic function: and, or, false, true, if, if error

(learned above, can kill 90% of office white-collar workers.)< Objective speaking, finereport is a tool with simple operation but extremely powerful functions, but it is easy to get started and difficult to upgrade. It will take several months to reach the level of expert< The knowledge levels of finereport are as follows, and each level has many levels

operation: finereport can be divided into data table, chart, parameter query, data filling, mobile terminal, platform building, scheled scheling and deployment integration according to its major functions

extension: finereport is peripheral but very relevant, mainly for the underlying data processing, and needs to master database knowledge, SQL language, ETL, etc. for the front-end implementation development, we need to master JS

Development: finereport supports various plug-ins, and the unsatisfied functions can be customized, Need to master Java

next step focus on analysis and mining - two major languages R language

1. This part is mainly the most basic part of R, including data management (operation of vector, matrix, data frame, string, etc.), mathematical calculation and common functions, common functions of array and matrix operation, logic operation, and process control statements (if, else, while, 2. Master basic statistical model and analysis methods

3. Learn to use visualization tools, mainly learning ggplot2 package

4. Advanced R: master some niu packages

3. IDC, that is, Internet data center. Generally, the service groups of IDC companies are website owners / enterprise companies, including e-commerce platform and game operation companies. It mainly provides the renting and hosting of servers; Virtual host, domain name registration and bandwidth leasing services help them support the normal access of the website
IDC is an instry in which there are sales, technical and filing positions
sales are mainly responsible for the sales of the company's procts and the promotion and publicity of the company's business
technology is divided into after-sales technology and computer room technology. After sales technology is responsible for dealing with customer problems. For example, server installation software, some software settings and other troubleshooting... Computer room technology is mainly responsible for the server on the shelf, installation of various systems, as well as some hardware troubleshooting. Including computer room network and security monitoring, etc.
/
hope to help you
Guangdong Tianying Information Technology Co., Ltd

4. There are a lot of things to learn before going to work in a software company. It mainly depends on what you do. Software companies need secretaries, financial needs, handyman and so on as well as other companies. You have to learn what you want to do.

5. You can learn any software technology, instry, computer and software development. The premise is that you have to be proficient. Only when you are proficient in any instry can you have a meal. You can't live long by opportunism.

6. You can learn what you are interested in. Interest is the best teacher. You are interested in computer. I suggest you study computer art design. I'm not afraid that you laugh at me. I was a student who didn't graate from junior high school. At that time, there was no computer in my school and I never contacted with him. I went out of school and worked in the factory for four years. I really didn't have any future, so I resigned, With the attitude of having a try and the spirit of daring to move forward, I went into the computer training base. I felt that advertising design had a bright future, so I signed up. I had studied for three months and worked. Up to now, it has been smooth sailing. So I want to tell you that you should have confidence in yourself and be interested in something. If you work hard, you will surely get something in return, But the premise is that you have to choose a good school + hard + diligent, then you look up and stride forward! I believe we will have a good journey, because God is fair to everyone! If you are interested, please contact me, I will share more experience with you! So I suggest you study computer art design major! wish you success!

8. Take English as an example, now English is more and more popular, and more and more people are learning English. Based on the powerful Internet and the era of information explosion, the means of learning English become diverse
in this age of easy content sharing, we can easily get some information we want. Many English materials can be found on the Internet. Some websites will have BBC practice materials for oral English and listening, and some websites will have various test questions for exams, Even now some open class platforms will have some free open classes for English training. It can be said that in this era, learning English for free through some websites on the Internet is a very realistic thing
however, for English learning, it is one thing to find resources. More importantly, we have to rely on our own efforts, make scientific and practical learning plans, maintain a positive learning attitude, and persist in learning every day. Otherwise, no matter how many English learning websites are collected, they will not be used reasonably, not to mention waste, at least in vain.

9. I think you should choose software. The reasons are as follows: 1. For you who have just graated, the job of this major is relatively easy to find (first employment, then career choice). Many enterprises will conct large-scale recruitment in order to cultivate talents; 2. The work you are engaged in now is not very training, you also say it is physical work, and that is, operation and maintenance, operation and maintenance. I think that when there are problems in this kind of work, you can learn more, but there are not many problems; 3. I'm also a software professional. I feel very good. Sometimes I work overtime, but I'm not tired
it's very important to choose a good direction for work, especially after graation. Think carefully! ^ br^

10. If you want to become a data analyst, or a senior data analysis expert in a certain business, you need to understand the path to become a data analyst from the technical level. There are six steps:
the first step: statistics, data, machine learning
about mathematics, some of them will be learned in university classroom, If it is a major in mathematics and science, it will learn more. About the knowledge of statistics, we still need some exercise of thinking
the second step: coding
if you want to have professional standards, from basic programming to end-to-end development, some technical languages, such as R, python, SAS and SPSS of some commercial software, as well as in-depth interactive learning, you should be proficient in at least a few subjects, and others are the best
Step 3: understand database
data analysis is mostly applied in practice. Enterprise data is often stored in mysql, Oracle, Postgres, mongodb, Cassandra and other databases, so you need to understand these databases
Step 4: data management, data visualization, data reporting
data management includes data cleaning lattice processing ETL, which aims to make the data before analysis more accurate and clear, such as datawrangler
data visualization, front-end display of data analysis, which aims to make the data presentation clearer and more vivid, such as tableau, Spotfire
Data Report displays data through different tools, which can be classified together with data visualization, but in practical application, most of them are presented through ppt
at present, many companies in the market use business intelligence tools, such as finebi
Bi tool is a tool integrating data connection, data processing and visualization. Compared with the pure tool above, it can better adapt to business
Step 5: big data
big data is an inevitable trend in the future, and there are many types of big data technology, such as Hadoop, maprice, spark, etc. if you learn more than one, the level will be different
Step 6: accumulate experience and learn from peers
the above are all theories and tools, but practice is the only way to get true knowledge. No matter you are just in touch with data analysis, or you are professional in data mining and analysis, you all hope to participate in more competitions to learn professional gods in the same field and train your feelings in this aspect while learning the above content
of course, in the process of practical application, most people do not take data analysis as their main business. Data analysis is only a tool for business analysis. The content of the fourth step can already meet the daily business analysis. Of course, it is necessary to master excel and PPT.