https://i123.fastpic.org/big/2024/0627/80/c5b214a1f3d59cf92088bdd3fdcf6080.jpg
The Business Intelligence Analyst Course 2023
Last updated 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.95 GB | Duration: 22h 27m
The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau - Everything is included
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!
Overview
Section 1: Part 1: Introduction
Lecture 1 What Does the Course Cover
Lecture 2 Download All Resources
Section 2: Intro to Data and Data Science - The Different Data Science Fields
Lecture 3 Why Are There So Many Business and Data Science Buzzwords?
Lecture 4 Analysis vs Analytics
Lecture 5 Intro to Business Analytics, Data Analytics, and Data Science
Lecture 6 Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture
Lecture 7 An Overview of our Data Science Infographic
Section 3: Intro to Data and Data Science - The Relationship between Different Fields
Lecture 8 When are Traditional data, Big Data, BI, Traditional Data Science and ML applied
Section 4: Intro to Data and Data Science - What is the Purpose of each Data Science Field
Lecture 9 Why do we Need each of these Disciplines?
Section 5: Intro to Data and Data Science - Common Data Science Techniques
Lecture 10 Traditional Data: Techniques
Lecture 11 Traditional Data: Real-life Examples
Lecture 12 Big Data: Techniques
Lecture 13 Big Data: Real-life Examples
Lecture 14 Business Intelligence (BI): Techniques
Lecture 15 Business Intelligence (BI): Real-life Examples
Lecture 16 Traditional Methods: Techniques
Lecture 17 Traditional Methods: Real-life Examples
Lecture 18 Machine Learning (ML): Techniques
Lecture 19 Machine Learning (ML): Types of Machine Learning
Lecture 20 Machine Learning (ML): Real-life Examples
Section 6: Intro to Data and Data Science - Common Data Science Tools
Lecture 21 Programming Languages & Software Employed in Data Science - All the Tools Needed
Section 7: Intro to Data and Data Science - Data Science Career Paths
Lecture 22 Data Science Job Positions: What do they Involve and What to Look out for?
Section 8: Intro to Data and Data Science - Dispelling Common Misconceptions
Lecture 23 Dispelling common Misconceptions
Section 9: Part 2: Statistics - Population and Sample
Lecture 24 Population vs sample
Section 10: Statistics - Descriptive Statistics
Lecture 25 Types of Data
Lecture 26 Levels of Measurement
Lecture 27 Categorical Variables - Visualization Techniques
Lecture 28 Categorical Variables Exercise
Lecture 29 Numerical Variables - Frequency Distribution Table
Lecture 30 Numerical Variables Exercise
Lecture 31 The Histogram
Lecture 32 Histogram Exercise
Lecture 33 Cross Table and Scatter Plot
Lecture 34 Cross Tables and Scatter Plots Exercise
Lecture 35 Mean, median and mode
Lecture 36 Mean, Median and Mode Exercise
Lecture 37 Skewness
Lecture 38 Skewness Exercise
Lecture 39 Variance
Lecture 40 Variance Exercise
Lecture 41 Standard Deviation and Coefficient of Variation
Lecture 42 Standard Deviation and Coefficient of Variation Exercise
Lecture 43 Covariance
Lecture 44 Covariance Exercise
Lecture 45 Correlation Coefficient
Lecture 46 Correlation Coefficient Exercise
Section 11: Statistics - Practical Example: Descriptive Statistics
Lecture 47 Practical Example
Lecture 48 Practical Example Exercise
Section 12: Statistics - Inferential Statistics Fundamentals
Lecture 49 Introduction
Lecture 50 What is a Distribution
Lecture 51 The Normal Distribution
Lecture 52 The Standard Normal Distribution
Lecture 53 The Standard Normal Distribution Exercise
Lecture 54 Central Limit Theorem
Lecture 55 Standard error
Lecture 56 Estimators and Estimates
Section 13: Statistics - Inferential Statistics: Confidence Intervals
Lecture 57 What are Confidence Intervals?
Lecture 58 Confidence Intervals; Population Variance Known; z-score
Lecture 59 Confidence Intervals; Population Variance Known; z-score Exercise
Lecture 60 Confidence interval clarifications
Lecture 61 Student's T Distribution
Lecture 62 Confidence Intervals; Population Variance Unknown; t-score
Lecture 63 Confidence Intervals; Population Variance Unknown; t-score Exercise
Lecture 64 Margin of Error
Lecture 65 Confidence intervals. Two means. Dependent samples
Lecture 66 Confidence intervals. Two means. Dependent samples Exercise
Lecture 67 Confidence intervals. Two means. Independent samples (Part 1)
Lecture 68 Confidence intervals. Two means. Independent samples (Part 1) Exercise
Lecture 69 Confidence intervals. Two means. Independent samples (Part 2)
Lecture 70 Confidence intervals. Two means. Independent samples (Part 2) Exercise
Lecture 71 Confidence intervals. Two means. Independent samples (Part 3)
Section 14: Statistics - Practical Example: Inferential Statistics
Lecture 72 Practical Example: Inferential Statistics
Lecture 73 Practical Example: Inferential Statistics Exercise
Section 15: Statistics - Hypothesis Testing
Lecture 74 The Null vs Alternative Hypothesis
Lecture 75 Further Reading on Null and Alternative Hypothesis
Lecture 76 Rejection Region and Significance Level
Lecture 77 Type I Error and Type II Error
Lecture 78 Test for the Mean. Population Variance Known
Lecture 79 Test for the Mean. Population Variance Known Exercise
Lecture 80 p-value
Lecture 81 Test for the Mean. Population Variance Unknown
Lecture 82 Test for the Mean. Population Variance Unknown Exercise
Lecture 83 Test for the Mean. Dependent Samples
Lecture 84 Test for the Mean. Dependent Samples Exercise
Lecture 85 Test for the mean. Independent samples (Part 1)
Lecture 86 Test for the mean. Independent samples (Part 1). Exercise
Lecture 87 Test for the mean. Independent samples (Part 2)
Lecture 88 Test for the mean. Independent samples (Part 2)
Section 16: Statistics - Practical Example: Hypothesis Testing
Lecture 89 Practical Example: Hypothesis Testing
Lecture 90 Practical Example: Hypothesis Testing Exercise
Section 17: Part 3: Relational Database Theory & Introduction to SQL
Lecture 91 Why use SQL?
Lecture 92 Why use MySQL?
Lecture 93 Introducing Databases
Lecture 94 Relational Database Fundamentals
Lecture 95 Comparing Databases and Spreadsheets
Lecture 96 Important Database Terminology
Lecture 97 The Concept of Relational Schemas: Primary Key
Lecture 98 The Concept of Relational Schemas: Foreign Key
Lecture 99 The Concept of Relational Schemas: Unique Key and Null Values
Lecture 100 The Concept of Relational Schemas: Relationships Between Tables
Section 18: SQL - Install and get to know MySQL
Lecture 101 Installing MySQL Workbench and Server
Lecture 102 Installing Visual C
Lecture 103 Installing MySQL on macOS and Unix systems
Lecture 104 The Client-Server Model
Lecture 105 Linking GUI with the MySQL Server
Lecture 106 Read me!!!
Lecture 107 Creating a New User and a New Connection to it
Lecture 108 Familiarize Yourself with the MySQL Interface
Lecture 109 SQL Fundamentals - MySQL Session and Databases
Lecture 110 SQL Fundamentals - DROP, CREATE, SELECT, INSERT, DELETE
Section 19: SQL - Best SQL Practices
Lecture 111 Coding Tips and Best Practices - I
Lecture 112 Coding Tips and Best Practices - II
Section 20: SQL - Loading the 'employees' Database
Lecture 113 Loading the 'employees' Database
Lecture 114 Loading the 'employees' Database
Section 21: SQL - Practical Application of the SQL SELECT Statement
Lecture 115 Using SELECT - FROM
Lecture 116 Using SELECT - FROM - Exercise
Lecture 117 Using SELECT - FROM - Solution
Lecture 118 Using WHERE
Lecture 119 Using WHERE - Exercise
Lecture 120 Using WHERE - Solution
Lecture 121 Using AND
Lecture 122 Using AND - Exercise
Lecture 123 Using AND - Solution
Lecture 124 Using OR
Lecture 125 Using OR - Exercise
Lecture 126 Using OR - Solution
Lecture 127 Operator Precedence and Logical Order
Lecture 128 Operator Precedence and Logical Order - Exercise
Lecture 129 Operator Precedence and Logical Order - Solution
Lecture 130 Using IN - NOT IN
Lecture 131 Using IN - NOT IN - Exercise 1
Lecture 132 Using IN - NOT IN - Solution 1
Lecture 133 Using IN - NOT IN - Exercise 2
Lecture 134 Using IN - NOT IN - Solution 2
Lecture 135 Using LIKE - NOT LIKE
Lecture 136 Using LIKE - NOT LIKE - Exercise
Lecture 137 Using LIKE - NOT LIKE - Solution
Lecture 138 Using Wildcard Characters
Lecture 139 Using Wildcard characters - Exercise
Lecture 140 Using Wildcard characters - Solution
Lecture 141 Using BETWEEN - AND
Lecture 142 Using BETWEEN - AND - Exercise
Lecture 143 Using BETWEEN - AND - Solution
Lecture 144 Using IS NOT NULL - IS NULL
Lecture 145 Using IS NOT NULL - IS NULL - Exercise
Lecture 146 Using IS NOT NULL - IS NULL - Solution
Lecture 147 Using Other Comparison Operators
Lecture 148 Using Other Comparison Operators - Exercise
Lecture 149 Using Other Comparison Operators - Solution
Lecture 150 Using SELECT DISTINCT
Lecture 151 Using SELECT DISTINCT - Exercise
Lecture 152 Using SELECT DISTINCT - Solution
Lecture 153 Getting to Know Aggregate Functions
Lecture 154 Getting to Know Aggregate Functions - Exercise
Lecture 155 Getting to Know Aggregate Functions - Solution
Lecture 156 Using ORDER BY
Lecture 157 Using ORDER BY - Exercise
Lecture 158 Using ORDER BY - Solution
Lecture 159 Using GROUP BY
Lecture 160 Using Aliases (AS)
Lecture 161 Using Aliases (AS) - Exercise
Lecture 162 Using Aliases (AS) - Solution
Lecture 163 Using HAVING
Lecture 164 Using HAVING - Exercise
Lecture 165 Using HAVING - Solution
Lecture 166 Using WHERE vs HAVING - Part I
Lecture 167 Using WHERE vs HAVING - Part II
Lecture 168 Using WHERE vs HAVING - Part II - Exercise
Lecture 169 Using WHERE vs HAVING - Part II - Solution
Lecture 170 Using LIMIT
Lecture 171 Using LIMIT - Exercise
Lecture 172 Using LIMIT - Solution
Section 22: SQL - Expanding on MySQL Aggregate Functions
Lecture 173 Applying COUNT()
Lecture 174 Applying COUNT() - Exercise
Lecture 175 Applying COUNT() - Solution
Lecture 176 Applying SUM()
Lecture 177 Applying SUM() - Exercise
Lecture 178 Applying SUM() - Solution
Lecture 179 MIN() and MAX()
Lecture 180 MIN() and MAX() - Exercise
Lecture 181 MIN() and MAX() - Solution
Lecture 182 Applying AVG()
Lecture 183 Applying AVG() - Exercise
Lecture 184 Applying AVG() - Solution
Lecture 185 Rounding Numbers with ROUND()
Lecture 186 Rounding Numbers with ROUND() - Exercise
Lecture 187 Rounding Numbers with ROUND() - Solution
Section 23: SQL - SQL JOINs
Lecture 188 What are JOINs?
Lecture 189 What are JOINs? - Exercise 1
Lecture 190 What are JOINs? - Exercise 2
Lecture 191 The Functionality of INNER JOIN - Part I
Lecture 192 The Functionality of INNER JOIN - Part II
Lecture 193 The Functionality of INNER JOIN - PART II - Exercise
Lecture 194 The Functionality of INNER JOIN - PART II - Solution
Lecture 195 Extra Info on Using Joins
Lecture 196 Duplicate Rows
Lecture 197 The Functionality of LEFT JOIN - Part I
Lecture 198 The Functionality of LEFT JOIN - Part II
Lecture 199 The Functionality of LEFT JOIN - Part II - Exercise
Lecture 200 The Functionality of LEFT JOIN - Part II - Solution
Lecture 201 The Functionality of RIGHT JOIN
Lecture 202 Differences between the New and the Old Join Syntax
Lecture 203 Differences between the New and the Old Join Syntax - Exercise
Lecture 204 Differences between the New and the Old Join Syntax - Solution
Lecture 205 Using JOIN and WHERE Together
Lecture 206 Important - Prevent Error Code: 1055!
Lecture 207 Using JOIN and WHERE Together - Exercise
Lecture 208 Using JOIN and WHERE Together - Solution
Lecture 209 The Functionality of CROSS JOIN
Lecture 210 The Functionality of CROSS JOIN - Exercise 1
Lecture 211 The Functionality of CROSS JOIN - Solution 1
Lecture 212 The Functionality of CROSS JOIN - Exercise 2
Lecture 21
Видео
