Data Analytics For Beginners - FAQS

Do you have to have an existing background in tech or can you get into the data industry from a non technical role?

You do not need to have a tech background. I know many analysts and engineers who come from psychology, education, linguistics, etc backgrounds. What you should do is leverage all the skills from your background to help you transition. People with a non-STEM background have a different perspective of how to tackle a problem and that perspective might yield a better solution. I recommend transitioning into a data analytics role that is located in the industry that you have experience in. Ex: If you have experience with HR, then go look for HR data analytics positions. Come from car sales, go look at sales operation data analyst positions or data analytics positions at car manufacturers.

In order to get a job in Data Analytics/Data Science, do you have to go to college or University?

You do not. If you don’t have a degree, I recommend getting certified in a specialized data tool, depending on which job role you're interested in (Tableau, Power BI, Azure, etc). I recommend getting the entry level cert for whatever tool it is you choose. Just remember, certs don’t equal experience so you should be doing projects and hands-on labs as you're studying. Those projects will give you experience AND confidence that you're learning and retaining the information you've been studying.

Do you need to have a strong background in math?

For data analyst and data engineering positions, you generally do not need an extensive background..and it really just depends on the industry that you're working in. Having a basic understanding of statistics(mean, median, mode, standard deviation) will suffice. When it comes to data science, the skillset does require probability and statistics knowledge (which can be picked up in a Udemy course).

Do you need to learn to programming? Can you get by pointing and clicking early in the career?

For entry level data analyst roles, you do not need to know how to program. However, learning basic Python or R can set you apart and give you more negotiation power when you receive an offer. It shouldn’t be a main focus when you’re studying for a data analyst position. Clicking and pointing is just fine. However, you do need to know how to code for data engineering, and data scientist positions.

Do I need to learn SQL? Is it hard to learn?

SQL is extremely important in the data industry and you should learn it. It is basically used to communicate with a database so you can retrieve the data to analyze. The basics are not hard to learn because it isn’t a true programming language like Python or Java or Golang, you aren’t building a program with SQL. It’s literally keywords that you use to communicate with a database, similar to how you use keywords to talk to google. It’s just a format that you use to talk to a database/data warehouse. If you're interested in becoming a data analyst.

Are there lots of job opportunities in Data Analytics & Data Science?

There are tons of opportunities. Companies are realizing that they need to leverage their data to understand how to improve their businesses on every scale! From internal process, external processes, improving customer satisfaction, understanding what new products and services to offer, etc. Companies who fail to utilize their data are and will be not be competitive, therefore they will be left behind. Many companies are in the beginning stages of sorting, managing, and analyzing their data. Therefore, they need data analysts, data engineers, and scientists to help them with that.

What is the difference between a business analyst, data analyst, data scientist, and data engineer?

Business analyst: They focus on analyzing processes, systems, problems and give suggestions on how to improve them. This is definitely more of a functional role. They receive data/dashboards from a data analyst and use that information to give suggestions to stakeholders on how to make improvements.

Data Analyst: They focus on creating dashboards which are then used by stakeholders(business analysts and managers) for insight on how to solve a business problem. This is a technical role since it focused on data.

Data Engineer: They gather and clean data from multiple sources/applications and store that data in one centralized place, typically called a data warehouse. This role is highly technical as it involves programming.

Data Scientists: They also gather and clean data from multiple sources, including data warehouses and unstructured data sources(text files, emails, videos, photos, etc)...and decide if the data will be useful for modeling(machine learning concept).

What skills do I need to have in order to become a business analyst?

  • Strong Writing Skills- You will need to get familiar with documenting requirements and summarizing details of projects for stakeholders
  • MS Powerpoint - This is typically used to present updates and project insights to stakeholders in meetings
  • Excel - This is typically used to store data and also do light visualization work
  • Business Acumen/Domain Knowledge - This is knowledge regarding the industry that you'll be analyzing data in. You'll need to know important KPIs and business problems that are related to the industry you're working in. Ex: Healthcare business analyst should understand patient intake KPIs and common problems.

What skills do I need to have in order to become a data analyst?

  • SQL
  • Data Viz tool - like Power BI or Tableau
  • Excel - This is basically the training wheels for data visualization tools. You'll use Excel for data manipulation/cleansing and analysis before transferring the data over to Tableau/PowerBI
  • Business Acumen/Domain Knowledge - This is knowledge regarding the industry that you'll be analyzing data in. You'll need to know important KPIs and business problems that are related to the industry you're working in. Ex: Healthcare data analyst should understand patient intake KPIs and common problems.

What skills do I need to have in order to become a data scientist?

  • SQL
  • Excel - This is basically the training wheels for data visualization tools. You'll use Excel for data manipulation/cleansing and analysis before transferring the data over to Tableau/PowerBI
  • Python(and it's data related libraries) or R - These languages are used for web scraping, data wrangling/cleansing, visualizing data, and running models
  • Statistics - You'll need to know descriptive and inferential statistics to do in-depth analysis
  • Algorithms - Classification/Regression/Clustering Algorithms will help you get started with understanding Machine Learning
  • Data Viz tool - like Power BI or Tableau
  • Business Acumen/Domain Knowledge - This is knowledge regarding the industry that you'll be analyzing data in. You'll need to know important KPIs and business problems that are related to the industry you're working in. Ex: Healthcare data scientist should understand patient intake KPIs, common problems, and have ideas on what predictions are useful based on those problems.

What skills do I need to have in order to become a data engineer?

  • SQL
  • Python/Java/Scala - Knowledge of one of these languages will help if you need to write any automation scripts/use apis while working on a data pipeline
  • Data Warehouse Fundamentals - You'll need to understand ETL, Data Modeling, Schemas, and more to see what goes into merging disparate data into one location
  • Data Pipelines - This is the process (or steps taking) too ingest data from multiple sources and move it into one place for storage and analysis
  • Pro Tip: I recommend learning about the data stack from a popular cloud platform(Azure, GCP, AWS, etc), since many companies are using the cloud for their data infrastructure

Which data visualization tool should I learn?

I tell people to start with Tableau or PowerBI since those are very much in-demand and are too complicated to learn. All data viz tools do the basics, it’s similar to choosing which gas station to go to...they all pump gas, but they offer different pricing, snacks, features like a car wash, etc. There's lots of demand for each of the different tools. Just pick one and go.

Which cloud provider's data stack should I learn?

Same answer as above, pick one of the popular ones and just start learning. The data services they offer all basically do the same thing to a certain extent, the services just have different names. I would focus on learning the fundamentals behind the service itself, that way if you do need to switch to another cloud providers adjacent tool...it won't be a steep learning curve because the skills needed are the same. Ex: Learning Amazon Redshift and applying for a job that uses GCP BigQuery. If you already know the fundamentals of Data Warehousing and SQL, BigQuery won't be hard to quickly pick up.


What are the salary ranges for business analyst, data analyst, data engineer, and data scientist roles?

Entry level business analyst salary: $60-70k (USD)

Entry level data analyst salary: $65-85k (USD)

Entry level data engineer salary: $85-95k (USD)

Entry level data scientist salary: $90-100k (USD)

Which certifications should I get?

  • Business Analyst - I recommend specializing in a specific tool like Salesforce or ServiceNow. You can also get a business analyst certification from the Project Management Institute and become a business analyst in a preferred industry. Ex: Marketing Business Analyst, Financial Business Analyst, etc

  • Data Analyst - I recommend doing it in the data visualization tool that you're learning, since that will indicate to companies that you are SPECIALIZED. If you're learning Tableau, the entry level Tableau cert is Tableau Desktop Specialist. I also have a Twitter thread on Tableau certs. PowerBI's cert is Microsoft Certified: Data Analyst Associate. If you want a general Data Analyst Certification, checkout the Google Data Analytics Cert. I like this one because they have packaged all the skills you need as a Data Analyst into one comprehensive course.

  • Data Scientist - I recommend a data scientist certification from a popular Cloud(Azure, IBM, etc) company so that you're specialized.

  • Data Engineer - I recommend a data engineering certification from a popular Cloud(Azure, IBM, GCP, etc) company so that you're specialized.

I've decided which data role I want to pursue. What steps should I take to land this role?

I got you covered. I actually created a masterplan infographic that gives you the fundamental steps you should take to land your next role. Feel free to save and share it with your friends!

Ready to take the next step in your data career? Head to our services page to see which service best aligns with the next step in your journey to landing a data role that fits your background, lifestyle, and career goals.

View Services
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.