The Business Intelligence Analyst Course 2019

The Business Intelligence Analyst Course 2019

image description

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

Curriculum

Section 1: Part 1: Introduction

Section 2: Intro to Data and Data Science - The Different Data Science Fields

Section 3: Intro to Data and Data Science - The Relationship between Different Fields

Section 4: Intro to Data and Data Science - What is the Purpose of each Data Science Field

Section 5: Intro to Data and Data Science - Common Data Science Techniques

Section 6: Intro to Data and Data Science - Common Data Science Tools

Section 7: Intro to Data and Data Science - Data Science Career Paths

Section 8: Intro to Data and Data Science - Dispelling Common Misconceptions

Section 9: Part 2: Statistics - Population and Sample

Section 10: Statistics - Descriptive Statistics

Section 11: Statistics - Practical Example: Descriptive Statistics

Section 12: Statistics - Inferential Statistics Fundamentals

Section 13: Statistics - Inferential Statistics: Confidence Intervals

Section 14: Statistics - Practical Example: Inferential Statistics

Section 15: Statistics - Hypothesis Testing

Section 16: Statistics - Practical Example: Hypothesis Testing

Section 17: Part 3: Relational Database Theory & Introduction to SQL

Section 18: SQL - Install and get to know MySQL

Section 19: SQL - Best SQL Practices

Section 20: SQL - Loading the 'employees' Database

Section 21: SQL - Practical Application of the SQL SELECT Statement

Section 22: SQL - Expanding on MySQL Aggregate Functions

Section 23: SQL - SQL JOINs

Section 24: SQL - SQL Subqueries

Section 25: SQL - Stored Routines

Section 26: SQL - The CASE Statement

Section 27: Part 4: Introduction to Tableau

Section 28: Tableau - Tableau functionalities

Section 29: Tableau - The Tableau Exercise

Section 30: Part 5: Combining SQL and Tableau - Introduction

Section 31: Combining SQL and Tableau - Problem 1

Section 32: Combining SQL and Tableau - Problem 2

Section 33: Combining SQL and Tableau - Problem 3

Section 34: Combining SQL and Tableau - Problem 4

Section 35: Combining SQL and Tableau - Problem 5

Section 36: Part 6: Introduction to Programming with Python

Section 37: Python - Python Variables and Data Types

Section 38: Python - Python Syntax Fundamentals

Section 39: Python - Other Python Operators

Section 40: Python - Conditional Statements

Section 41: Python - Functions

Section 42: Python - Python Sequences

Section 43: Python - Using Iterations

Section 44: Python - Advanced Python tools

Section 45: Integration - Software Integration

Section 46: Integration - What is contained in this Course?

Section 47: Integration - Data Preprocessing Step by Step

Course Description

The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included

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