Learn Data Analysis with SQL and Tableau (2 Courses in 1)

Improve your Business Analytical Skills and Data Visualization in SQL and Tableau

Ratings: 4.17 / 5.00




Description

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!  

What You Will Learn!

  • Understand Relational database Terminology
  • Install and Use Microsoft SQL Server and Tableau
  • Learn SQL commands and functions needed for Select queries
  • Create complex queries for data analysis
  • Load data into Tableau application to start data visualization
  • Create professional diagrams and graphs for data analysis
  • Create dashboard in Tableau for reporting and presentation

Who Should Attend!

  • Those who need to learn to create complex SQL queries and professional data diagrams and charts for data analysis