Business Intelligence Cohort 3 (EVENING)

Course Prerequisite(s)

Please note that this course has the following prerequisites which must be completed before it can be accessed
Quantitative Data Analysis Cohort 4 (EVENING)

About Course

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

We are proud to present you with 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

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 – is 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

 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

Course Content

Variable
Introduction to Variable/Object

Python programming

Numbers and Boolean Values
introduction to Data Types.

Strings
Introduction to strings Data Types

Arithmetic Operation
introduction to Arithmetic Operation

Endexing Elements
introduction

Indentation
introductions

Comparison Operator
introduction

Logical and Identity operators
introductions'

IF Statements
introductions

Defining Functions
introductions

Functions with Parameters
introductions

Using Function in another Function
introduction

Combining Conditional statements and Functions
introduction

Lists
introductions

Tuples
introductions

Dictionaries
introduction

List with Range Functions
introduction

Importing Modules Packages /Libraries
introduction

Relational Database Theory
Why use MySQL? Introducing Databases Relational Database Fundamentals Comparing Databases and Spreadsheet Important Database Terminology The Concept of Relational Schemas: Primary Key The Concept of Relational Schemas: Foreign Key The Concept of Relational Schemas: Unique Key and Null Values The Concept of Relational Schemas: Unique Key The Concept of Relational Schemas: Relationships Between Tables Descriptive statistics Types of Data Levels of Measurement Visualization Techniques (The Histogram, Scatter plot) Mean median and mode Skewness Standard Deviation and Coefficient of Variation Standard Deviation Correlation Installing MySQL Workbench and Server Installing Visual C Installing MySQL on macOS and Unix systems The Client-Server Model Linking GUI with the MySQL Server Creating a New User and a New Connection to it Inferential statistics – the basics The Normal Distribution/The Standard Normal Distribution Central Limit Theorem Estimators and Estimates Familiarize Yourself with the MySQL Interface

Select Statements
Using SELECT – FROM, Using WHERE, Using AND Using OR, Operator Precedence and Logical Order Using IN - NOT IN, Using LIKE - NOT LIKE Using Wildcard Characters, Using BETWEEN - AND Using Other Comparison Operators Using SELECT DISTINCT Getting to Know Aggregate Functions Using ORDER BY, Using GROUP BY, Using Aliases (AS) Using HAVING, COUNT, SUM, MAX, AVERAGE, ROUND

Data Visualization using Tableau
Why Use Tableau: Make Your Data Make an Impact Connecting Data in Tableau Exploring Tableau's Interface Create our first Chart in Tableau

Functionalities
Duplicating a Sheet Creating a Table Creating Custom Fields Creating a Custom Field and Adding Calculations to a Table Adding Totals, Subtotals, Custom Calculation Inserting a Filter Working with Joins in Tableau

Combining SQL and Tableau
Using Joins in Tableau Performing a Numbers Check Blending Data in Tableau Creating and Formatting a Dashboard Adding Interactive Filters for Improved Analysis Interactive Filters - fix

Integrating Python And SQL
How to Use the 'absenteeism_module' in Python Creating the 'predicted outputs' Database in MySQL Importing 'pymysql' in Python Creating a Connection and Cursor Creating the 'predicted outputs' Table in MySQL Executing and SQL SELECT Statement from Python Sending Data from Jupyter to Workbench - Part I

Student Ratings & Reviews

5.0

Total 3 Ratings

3 Ratings

0 Rating

Gloria Mwaniki

1 year ago

I had fun taking this course. It was interactive and I learnt so much

GEORGE ADAMS

2 years ago

Perfect

dalworth

2 years ago

Great

Course Prerequisite(s)

About Course

What Will You Learn?

Course Content

Variable Introduction to Variable/Object

Python programming

Numbers and Boolean Values introduction to Data Types.

Python programming

Data Types

Strings Introduction to strings Data Types

Python programming

Arithmetic Operation introduction to Arithmetic Operation

Python programming

Endexing Elements introduction

Python programming

Indentation introductions

Python programming

Comparison Operator introduction

Python programming

Logical and Identity operators introductions'

logical operator

IF Statements introductions

Defining Functions introductions

Functions with Parameters introductions

Using Function in another Function introduction

Combining Conditional statements and Functions introduction

Lists introductions

Python programming

Tuples introductions

Dictionaries introduction

Python programming

List with Range Functions introduction

Python programming

Importing Modules Packages /Libraries introduction

Python programming

SQL

SQL

Data Visualization using Tableau Why Use Tableau: Make Your Data Make an Impact Connecting Data in Tableau Exploring Tableau's Interface Create our first Chart in Tableau

TABLEAU

Functionalities Duplicating a Sheet Creating a Table Creating Custom Fields Creating a Custom Field and Adding Calculations to a Table Adding Totals, Subtotals, Custom Calculation Inserting a Filter Working with Joins in Tableau

TABLEAU

Combining SQL and Tableau Using Joins in Tableau Performing a Numbers Check Blending Data in Tableau Creating and Formatting a Dashboard Adding Interactive Filters for Improved Analysis Interactive Filters - fix

TABLEAU

Python programming

Student Ratings & Reviews

Find Us

Useful Links

Support

Variable
Introduction to Variable/Object

Numbers and Boolean Values
introduction to Data Types.

Strings
Introduction to strings Data Types

Arithmetic Operation
introduction to Arithmetic Operation

Endexing Elements
introduction

Indentation
introductions

Comparison Operator
introduction

Logical and Identity operators
introductions'

IF Statements
introductions

Defining Functions
introductions

Functions with Parameters
introductions

Using Function in another Function
introduction

Combining Conditional statements and Functions
introduction

Lists
introductions

Tuples
introductions

Dictionaries
introduction

List with Range Functions
introduction

Importing Modules Packages /Libraries
introduction

Data Visualization using Tableau
Why Use Tableau: Make Your Data Make an Impact Connecting Data in Tableau Exploring Tableau's Interface Create our first Chart in Tableau

Functionalities
Duplicating a Sheet Creating a Table Creating Custom Fields Creating a Custom Field and Adding Calculations to a Table Adding Totals, Subtotals, Custom Calculation Inserting a Filter Working with Joins in Tableau

Combining SQL and Tableau
Using Joins in Tableau Performing a Numbers Check Blending Data in Tableau Creating and Formatting a Dashboard Adding Interactive Filters for Improved Analysis Interactive Filters - fix