The Education of a Data or Business Intelligence Analyst, Part I – Introduction to Recommended University Classes

More and more employers are looking for Data Analysts or Business Intelligence Analysts in order to get meaningful information out of the data they collect from their operations. According to, the average salary for a Data Analyst in Dallas, TX is $63,000, while the average salary for a Business Intelligence Analyst in Dallas, TX is $86,000 .

find out what Business Intelligence actually is here

However, it is often not clear what one needs to study to work in either field. Below is a quick list of all of the university classes that you should take to become a Data Analyst or Business Intelligence Analyst. Keep in mind, you do not need to take all of the classes below, but the more you take the easier your career will be.

In future posts, I will go into more detail about each of the general subjects shown below as well as discuss the type of certifications one should pursue.

Calculus I
Calculus II
Calculus III – Multivariable Calculus
Differential Equations
Partial Differential Equations
Other Mathematics
Linear Algebra
Discrete Mathematics
Formal Logic
Probability Theory and Statistics
Introduction to Probability Theory using Multivariable Calculus
Introduction to Statistics
Computers and Programming
Introduction to Programming
Data Structures
Object Oriented Programming
Relational Databases
Introduction to Operating Systems
Introduction to Networking
Micro Economics
Corporate Finance
Introduction to Accounting

An Explanation In Plain English Of What Business Intelligence Actually Is, With Two Real World Examples

OK, Explain It To Me

Companies and organizations now feel that they need “Business Intelligence” (BI) to make sense of the data that they gather in order to make better decisions. However, they can be awfully vague on what that means. Before I got hired to work in Business Intelligence, I used to wonder about what on earth they were talking. So what are employers actually doing when they say that they are creating “Business Intelligence”?

The answer is straight forward once you get past the buzzwords:

Business Intelligence means to use SQL queries and scripting to extract information that a human being can easily digest from an organization’s database or databases.

That’s It?

Yes, that’s it. It’s a branch of data analysis.

Fantastic, I am going to set up Business Intelligence for my organization tomorrow!

Now hold on there. Just because one can explain BI easily in one sentence does not mean that it is easy to do. There are at least four major barriers.

  1. The SQL queries can be very complex. They can take days or even weeks to write.
  2. Scripting, using a stats package like SAS or R, or a reporting program like Crystal Reports is often needed in addition to SQL to get the answers you need and to present it in an easily digestible format.
  3. The previous two statements assume that the databases, querying applications, and other software have been set up well in the first place, which often takes a large staff beyond those in an organization’s BI section.
  4. The data needed to do the analysis may not be currently collected. Developers’ of live business databases main priority is usually to ensure that an organization’s information infrastructure runs smoothly from day to day. It is very likely that it never occurred to your organization’s developers to record the data points that you need.

OK, fine, it’s tougher that it looks, but I want to see these real world examples so I can have some idea what I should expect.

No problem.

I can actually give you two good examples of Business Intelligence which I helped create. I used to work for the marketing company LivingSocial as a Business Intelligence Analyst. While most of my work was proprietary, I did BI for two articles for LivingSocial’s Blog.

  1. What are the Nicest Cities in the US? – discusses which of LivingSocial’s American cities have the largest percentage of gift purchases
  2. Who’s Leaving on a Jet Plane? – discusses which of LivingSocial’s American cities have the largest and smallest percentages of travel purchases

I wrote the SQL queries that returned the percentages and tables used in both blog posts. While both are simple examples of BI, they are very typical of the information that organizations wish to get from their data.


Related books picked – and if possible read – by me. Sponsored by Amazon Associates.