The Business Intelligence Analyst Course 2020
4.5 (21,274 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
105,236 students enrolled

The Business Intelligence Analyst Course 2020

The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included
Bestseller
4.5 (21,274 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
105,236 students enrolled
Created by 365 Careers
Last updated 6/2020
English
English [Auto], French [Auto], 6 more
  • German [Auto]
  • Indonesian [Auto]
  • Italian [Auto]
  • Polish [Auto]
  • Portuguese [Auto]
  • Spanish [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 20 hours on-demand video
  • 151 articles
  • 136 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Become an expert in Statistics, SQL, Tableau, and problem solving
  • Boost your resume with in-demand skills
  • Gather, organize, analyze and visualize data
  • Use data for improved business decision-making
  • Present information in the form of metrics, KPIs, reports, and dashboards
  • Perform quantitative and qualitative business analysis
  • Analyze current and historical data
  • Discover how to find trends, market conditions, and research competitor positioning
  • Understand the fundamentals of database theory
  • Use SQL to create, design, and manipulate SQL databases
  • Extract data from a database writing your own queries
  • Create powerful professional visualizations in Tableau
  • Combine SQL and Tableau to visualize data from the source
  • Solve real-world business analysis tasks in SQL and Tableau
Requirements
  • No prior experience is required. We will start from the very basics
  • You’ll need to install MySQL, Tableau Public, and Anaconda. We will show you how to do it step by step
  • Microsoft Excel 2003, 2010, 2013, 2016, or 365
Description

Hi! Welcome to The Business Intelligence Analyst Course, the only course you need to become a BI Analyst. 

We are proud to present you this one-of-a-kind opportunity. There are several online courses teaching some of the skills related to the BI Analyst profession. The truth of the matter is that none of them completely prepare you.

Our program is different than the rest of the materials available online.  

It is truly comprehensive. The Business Intelligence Analyst Course comprises of several modules:  

  • Introduction to Data and Data Science  

  • Statistics and Excel  

  • Database theory  

  • SQL  

  • Tableau  

  • SQL + Tableau  

These are the precise technical skills recruiters are looking for when hiring BI Analysts. And today, you have the chance of acquiring an invaluable advantage to get ahead of other candidates. This course will be the secret to your success. And your success is our success, so let’s make it happen!  

Here are some more details of what you get with The Business Intelligence Analyst Course:   

  • Introduction to Data and Data Science – Make sense of terms like business intelligence, traditional and big data, traditional statistical methods, machine learning, predictive analytics, supervised learning, unsupervised learning, reinforcement learning, and many more;  

  • Statistics and Excel – Understand statistical testing and build a solid foundation. Modern software packages and programming languages are automating most of these activities, but this part of the course gives you something more valuable – critical thinking abilities;  

  • Database theory – Before you start using SQL, it is highly beneficial to learn about the underlying database theory and acquire an understanding of why databases are created and how they can help us manage data  

  • SQL - when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business  

  • Tableau – one of the most powerful and intuitive data visualization tools available out there. Almost all large companies use such tools to enhance their BI capabilities. Tableau is the #1 best-in-class solution that helps you create powerful charts and dashboards  

  • Learning a programming language is meaningless without putting it to use. That’s why we integrate SQL and Tableau, and perform several real-life Business Intelligence tasks  

Sounds amazing, right?  

Our courses are unique because our team works hard to:  

  • Pre-script the entire content  

  • Work with real-life examples  

  • Provide easy to understand and complete explanations  

  • Create beautiful and engaging animations  

  • Prepare exercises, course notes, quizzes, and other materials that will enhance your course taking experience  

  • Be there for you and provide support whenever necessary  

We love teaching and we are really excited about this journey. It will get your foot in the door of an exciting and rising profession. Don’t hesitate and subscribe today. The only regret you will have is that you didn’t find this course sooner!

Who this course is for:
  • Beginners to programming and data science
  • Students eager to learn about job opportunities in the field of data science
  • Candidates willing to boost their resume by learning how to combine the knowledge of Statistics, SQL, and Tableau in a real-world working environment
  • SQL Programmers who want to develop business reasoning and apply their knowledge to the solution of various business tasks
  • People interested in a Business Intelligence Analyst career
Course content
Expand all 413 lectures 20:18:24
+ Intro to Data and Data Science - The Different Data Science Fields
5 lectures 31:11
Intro to Business Analytics, Data Analytics, and Data Science
08:26
Intro to Business Analytics, Data Analytics, and Data Science
5 questions
Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture
09:31
Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture
2 questions
An Overview of our Data Science Infographic
1 question
+ Intro to Data and Data Science - The Relationship between Different Fields
1 lecture 07:19
When are Traditional data, Big Data, BI, Traditional Data Science and ML applied
07:19
When are Traditional data, Big Data, BI, Traditional Data Science and ML applied
1 question
+ Intro to Data and Data Science - What is the Purpose of each Data Science Field
1 lecture 04:44
Why do we Need each of these Disciplines?
04:44
Why do we Need each of these Disciplines?
1 question
+ Intro to Data and Data Science - Common Data Science Techniques
11 lectures 53:34
Traditional Data: Techniques
08:13
Traditional Data: Techniques
1 question
Traditional Data: Real-life Examples
01:44
Big Data: Techniques
04:26
Big Data: Techniques
1 question
Big Data: Real-life Examples
01:32
Business Intelligence (BI): Techniques
06:45
Business Intelligence (BI): Techniques
4 questions
Business Intelligence (BI): Real-life Examples
01:42
Traditional Methods: Techniques
09:08
Traditional Methods: Techniques
4 questions
Traditional Methods: Real-life Examples
02:45
Machine Learning (ML): Techniques
06:55
Machine Learning (ML): Techniques
2 questions
Machine Learning (ML): Types of Machine Learning
2 questions
Machine Learning (ML): Real-life Examples
02:11
Machine Learning (ML): Real-life Examples
5 questions
+ Intro to Data and Data Science - Common Data Science Tools
1 lecture 05:51
Programming Languages & Software Employed in Data Science - All the Tools Needed
05:51
Programming Languages & Software Employed in Data Science - All the Tools Needed
4 questions
+ Intro to Data and Data Science - Data Science Career Paths
1 lecture 03:29
Data Science Job Positions: What do they Involve and What to Look out for?
03:29
Data Science Job Positions: What do they Involve and What to Look out for?
1 question
+ Intro to Data and Data Science - Dispelling Common Misconceptions
1 lecture 04:10
Dispelling common Misconceptions
04:10
Dispelling common Misconceptions
1 question
+ Part 2: Statistics - Population and Sample
1 lecture 04:02
Population vs sample
04:02
Population and Sample
2 questions
+ Statistics - Descriptive Statistics
22 lectures 47:59
Types of Data
04:33
Types of data
2 questions
Levels of measurement
2 questions
Categorical Variables - Visualization Techniques
04:52
Categorical variables. Visualization Techniques
1 question
Categorical Variables Exercise
00:03
Numerical Variables - Frequency Distribution Table
03:09
Numerical variables. Using a frequency distribution table
1 question
Numerical Variables Exercise
00:03
The Histogram
02:14
The Histogram
1 question
Histogram Exercise
00:03
Cross Table and Scatter Plot
04:44
Cross Tables and Scatter Plots
1 question
Cross Tables and Scatter Plots Exercise
00:03
Mean, median and mode
04:20
Mean, Median and Mode Exercise
00:03
Skewness
02:37
Skewness
1 question
Skewness Exercise
00:03
Variance
05:55
Variance Exercise
00:03
Standard Deviation and Coefficient of Variation
04:40
Standard deviation
1 question
Standard Deviation and Coefficient of Variation Exercise
00:03
Covariance
03:23
Covariance
1 question
Covariance Exercise
00:03
Correlation Coefficient
03:17
Correlation Coefficient
1 question
Correlation Coefficient Exercise
00:03