Improve your Business Analytical Skills and Data Visualization in SQL and Tableau
As most of the business data stored in relational databases, learning SQL is essential for anyone wants to be a data analyst or scientist. SQL is the main tool used to manipulate data in relational databases, so mastering SQL is necessary to perform deep data analyses. This course teaches you SQL from scratch till writing complex queries. The course starts with you from the basic to the advanced level. In the beginning you will learn simple SELECT statement to retrieve data and after that increase the level of complexity step by step till learning to build complex queries. using the most important functions, such as: aggregation and date functions at your queries. Furthermore, you will learn joining multiple tables at your queries to retrieve the data you need for your analyses. You will learn performing data analysis on sales, customers and inventory. Before that, you learn how to install and use Microsoft SQL Server and Northwind database. In the next section, you will learn about data visualization and using Tableau to create insightful diagrams and charts. You will learn installing Tableau and be comfortable with creating varied diagrams, dashboards and stories and use them for business data analyses. You will learn how to import SELECT results in SQL Server into Tableau and use these data to create insightful diagrams. These diagrams can be very handy in data and business analysis. Enroll in this course to valuable knowledge to yours!
Understand Relational database Terminology
Install and Use Microsoft SQL Server and Tableau
Learn SQL commands and functions needed for Select queries
8 Lectures
6 Lectures
26 Lectures
19 Lectures
31 Lectures
9 Lectures
6 Lectures
9 Lectures
6 Lectures
6 Lectures
7 Lectures
4 Lectures
5 Lectures
8 Lectures
4 Lectures
My name is Abraham Joudah I have worked in IT and Data Science for more than 15 years. After completed my bachelor’s in computer science, I worked as Database Administrator in one of the engineering companies. I have obtained several certificates from Microsoft like MCSE, MCDBA and MCSA. After several years of working in IT, I started focusing on Data...
In the practice problems there are certain things that were not taught in the lecture portion of the course, so it was hard to figure out the question without looking at the answer. even in the answer video there are lines of code that is not explained, so i am unable to learn how to properly do it.
พูดช้าและชัด ใช้คำศัพท์ที่เข้าใจง่าย
ok
very good for those who like to start data analysis from zero to intermediate
SQL part needs to be somewhat better, I felt few queries required changes, I asked questions and didn't get any answers.
help to learn about SQL Server and tableau in breifly
Good.
Good basic refresh for someone already with SQL & analytics background. Easy to follow step by step of the core functions. I like that I could pause and return the next day to where I left off.
This has been a very informative course. There are many functions in SQL I have used and then many I have not when it comes to data analysis instead of standard querying. This helped me better understand what I was missing.
Your email address will not be published. Required fields are marked *
Mike M. F.
I think the instructor is well informed and has the diverse learners in mind