Library

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

6 Essential Skills to Make A Great BI Analyst Series 3

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

About This Class

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!

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

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

What you’ll learn:

  • Become an expert in Statistics, SQL, Tableau, and problem solving
  • Boost your resume with in-demand skills
  • Gather, organize, analyse 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
Curriculum
Number of Lectures: 54
Total Duration: 03:24:22
Relational Database and Intro to SQL
  • 1. Why SQL  
  • 2 Why MY SQL  
  • 3 Intro to Databases  
  • 4 Relational Database Fundamentals  
  • 5 Comparing Database and Spreadsheets  
  • 6 Importance of Database Terminology  
  • 7 The Concept of Relational Schema Primary Key  
  • 8 The Concept of Relational Database Foreign Key  
  • 9 The Concept of Relational Schemas  
  • 10 The Concept of Relational Schemas between Tables  
INSTALLING AND GETTING TO KNOW MY SQL
  • 1 Installing My SQL Work Bench Server  
  • 2 Linking GUI with MY SOL Server  
  • 3 Fmiliarise yourself with MY SQL Server  
SQL BEST PRACTICE AND LOADING EMPLOYEES FILE
  • 1 Coding Tips and Best Practice 1  
  • 2 Coding Tips and Best Practice 2  
  • 3 Loading the Employee Database  
Practical Application of the SELECT Statement
  • 1 Using SELECT FROM  
  • 2 Using WHERE  
  • 3 Using AND  
  • 4 Using OR  
  • 5 Operator Precedence and Logical Order  
  • 6 Using IN NOT IN  
  • 7 Using LIKE NOT LIKE  
  • 8 Using WILD CHARACTERS  
  • 9 Using Between AND  
  • 10 Using IS NULL NOT NULL  
  • 11 Using Other Comparison Operators  
  • 12 Using SELECT DISTINCT  
  • `13 Getting to know Aggregate Functions  
  • 14 Using ORDER BY  
  • 15 Using GROUP BY  
  • 16 Using Aliases  
  • 17 Using HAVING  
  • 18 WHERE VS HAVING  
  • 19 USING LIMIT  
Expanding on My Aggregate Functions
  • 1 Applying COUNT  
  • 2 Applying SUM  
  • 3 MINI AND MAX  
  • 4 Applying AVG  
  • 5 Rounding Numbers with Round  
SQL JOINS
  • 1 What are JOINS?  
  • 2 The Functionality of INNER JOIN 1  
  • 3 The Functionality of INNER JOIN 2  
  • 4 Extra Info of Using JOINS  
  • 5 Duplicate Rows  
  • 6 The Functionality of LEFT JOIN 1  
  • 7 The Functionality of LEFT JOIN 2  
  • The Functionality of RIGHT JOIN  
  • 9 The Differences Between Old and New JOINS  
  • 10 Using JOINS AND WHERE TOGETHER  
  • 11 The Functionality of CROSS JOIN  
  • 12 Combining Aggregate Functions with JOINS  
  • 13 Join More than Two Tables  
  • 14 Top Tips for Using JOINS  
Reviews (0)