Library

Course: 6 Essential Skills to Make A Great BI Analyst Series 2

6 Essential Skills to Make A Great BI Analyst Series 2

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

About this course

Hi! Welcome to our Business Intelligence Analyst Course Series. This course entails the six essential skills you need to make a great BI analyst

We are excited to present you a course series that stands out.

This BI program is different than the rest of the materials available online. 

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! 

  • Introduction to Data and Data Science 
  • Statistics and Excel 
  • Database theory 
  • SQL 
  • Tableau 
  • SQL + Tableau 

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 Awesome, right?  Our course comes with

Our courses are unique and is equipped with:

  • 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!

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
  • Analyse 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

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
Basic knowledge

Are there any course requirements or prerequisites?

  • 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
What you will learn

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 
Curriculum
Number of Lectures: 45
Total Duration: 02:14:04
Descriptive Statistics
  • Lesson 1: Understanding Population and Sample Data  
  • Lesson 2: Types of Data and Levels of Measurement  
  • Lesson 3: Visualisation Techniques for Categorical and Numerical Variables  
  • Lesson 4: Calculating Measures of Central Tendency  
  • Lesson 5: Calculating Measures of Asymmetry  
  • Lesson 6: How to Quantify Variability  
  • Lesson 7 Standard Deviation and Coefficient of Variation  
  • Lesson 8: Measuring Relationships Between two Variables  
  • Lesson 9: Correlation Coefficient  
  • Population vs Sample  
  • Types of Data and Levels of Measurement  
  • Resources Exercise 1  
  • Resource Exercise 1b  
  • Resources Exercise 2a  
  • Resources Exercise 2b  
  • Resources Exercise 3  
  • Resource Exercise 3b  
  • Resource Exercise 4  
  • Resource Exercise 5  
  • Resource Exercise 6  
  • Resource Exercise 7  
Inferential Statistics
  • Lesson 1: Distribution  
  • Lesson 2: Normal Distribution  
  • Lesson 3: Standard Normal Distribution  
  • Lesson 4: Central Limit Theorem  
  • Lesson 4b: Standard Error  
  • Lesson 5: Estimator and Estimates  
  • Lesson 6: Confidence Interval  
  • Lesson 7: Confidence Intervals Clarification with Student's T Distribution  
  • Lesson 8: Population Variance Unknown  
  • Resource Exercise 1  
  • Resource Exercise 2  
  • Resource Exercise 3  
  • Resource Exercise  
Hypothesis Testing
  • Lesson 1: Null and Alternative Hypothesis  
  • Lesson 2: Establishing A Rejection Region  
  • Lesson 3: Type 1 and Type 11 Error  
  • Lesson 4: Test for the Mean Population Variance Known  
  • Lesson 5: The P-Value Why is it an Important tool in Statistics  
  • Lesson 6: Test for the Mean Population Variance Unknown  
  • Lesson 7: Test for the Mean Dependent Samples  
  • Lesson 8: Test for the Mean Independent Samples Part 1  
  • Lesson 9: Test for the Mean Independent Samples Part 2  
  • Resource Exercise A  
  • Resource Exercise B  
  • Resource Exercise C  
  • Resource Exercise D  
Rating
Enrolled Students
(1)
Level
All
Price
$ 10.00
Course Language
English
Reviews (0)