What is the job of a Data Analyst (Business)?
The job of a business data analyst consists of gathering, organizing and studying the information an organization generates (sales, customers, costs, production, use of a product) to answer specific questions for the people who make decisions. For example: which products sell less in a certain season, why customers stop buying, or at which step of a process the most time is lost. It is a position that links the technical side with the business departments.
A typical day starts by checking whether the data from the systems arrived complete and without errors. Then queries are written to pull out the information, tables are cleaned and combined in a spreadsheet or an analysis program, and charts or dashboards are put together. A good part of the day goes to short meetings with people from sales, finance or operations to understand what they need to know, and to explaining the results in plain words and pointing out their limits.
Typical tasks
- Extracting data from the organization's databases and systems by means of queries.
- Checking and cleaning the information: fixing duplicates, gaps and values that make no sense.
- Calculating indicators and comparing results across periods, products, regions or groups of customers.
- Building dashboards and reports that update automatically and that other people can consult.
- Presenting findings to non-technical teams, making clear what the data says and what it does not.
- Working out with other departments which questions are worth answering and with which data.
- Documenting how each figure was calculated so that other people can repeat it.
Subjects and content usually covered
- Descriptive statistics and the basics of probability and inference.
- Advanced spreadsheets and handling of data tables.
- Databases and the SQL query language.
- Programming for data analysis, usually with Python or R.
- Data visualization and tools for building dashboards.
- Basics of business administration, finance and marketing to understand the business context.
- Communicating results and writing reports.
Usual duration and type of training
It depends on the route and on the country. The university degrees that many people in this job come from (business administration, economics, statistics, industrial engineering, information systems or data science) usually take 4 to 5 years. Technical or vocational programs in data analysis or information systems usually take 2 to 3 years.
It is also common to add to another qualification with courses and practice lasting 3 to 12 months, focused on SQL, spreadsheets, programming and visualization.
How you get there and what is usually required to practice
There is no single route. Many people arrive from a university degree in business administration, economics, statistics, mathematics, engineering or information systems. Others come from technical training, or from an administrative, sales or operations job in which they began working with data and gradually took on more analysis.
In general no license or professional registration is required to practice. What companies usually ask for is a qualification or proven experience, solid skills with spreadsheets and SQL, and examples of analyses the person has done, such as coursework or personal projects. The first job is usually the hardest to get, and people often start as an assistant or junior analyst.
Skills that help
- Checking data with a critical eye and spotting figures that do not add up.
- Writing tidy queries and formulas that another person can read and repeat.
- Turning a business question into a specific analysis with the data available.
- Explaining results in writing and out loud without unnecessary jargon.
- Making clear charts that show what matters and do not mislead.
- Asking questions of the people who know the process to understand where the data comes from.
Career paths and job opportunities
- Retail and consumer goods companies, in sales, marketing or planning departments.
- Banks, insurance companies and other financial firms.
- E-commerce and technology companies.
- Logistics, transport and industrial companies, in operations departments.
- Consulting firms that work for several clients.
- Public agencies and social organizations that analyze their programs.
What you are not always told
- A large part of the time goes to getting and cleaning data, and less to the more eye-catching analyses.
- Data is often incomplete or spread across several systems, and sometimes the answer is that nothing firm can be concluded from what is available.
- Requests for figures are often urgent, and keeping quality up under pressure is part of the job.
- Many hours are spent in front of a screen, sitting and concentrating for long stretches.
- A correct result is not always used: part of the craft is explaining it well and accepting that other people will decide using more criteria than the data.
How the field is changing
Visualization software and tools with automated assistance already prepare tables, write queries and suggest charts, so repetitive tasks weigh less and the critical review of results weighs more. Organizations store more data from more sources, which makes the quality of the information, the clear definition of each indicator and the protection of people's privacy more important, with data protection rules that vary from country to country.
Want to know if this is the right career for you?
Take the free vocational test with 5 scientific methods — CHASIDE, Holland, Big Five, MMMG and VAK — to get your personalized profile. You can also explore all university careers or learn about the scientific methodology.