With every new version of SQL Server, new features that support and expand business intelligence capabilities and facilitate BI reporting and analysis are getting popular.
The main purpose of this comprehensive course is to assist you on how to use SQL business intelligence to collect, analyze, and visualize crucial data and to support better business decision making and also to extend your knowledge of SQL, databases, and BI
The main purpose of this comprehensive course is to assist you on how to use SQL business intelligence to collect, analyze, and visualize crucial data and to support better business decision making and also to extend your knowledge of SQL, databases, and BI
Contents and Overview
This training program includes 2 complete courses, carefully chosen to give you the most comprehensive training possible.
The first course, SQL Fundamentals for Business Intelligence, will take you to an intermediate level of familiarity with SQL in the context of writing maintainable and sophisticated SQL for specific business queries. Start by importing your first dataset which will be the DVD rental database. Then explore and put into practice various SQL clauses and Join types. You’ll also learn tricks to get external data into the database, without worrying excessively about DBA functions and considerations. Also you’ll find out how to take the data into popular BI tools (Excel and Tableau) and refine the analysis further while discussing the interpretation of the data.
The second course, Advanced Applied SQL for Business Intelligence and Analytics, runs through the workflow from SQL to a localhost connection in Tableau and also analysis, all of which you'll need in your professional life. Concepts such as CASE statements, common table expressions, and subqueries will be explained via case studies. You'll generate web analytics acquisition source data using Python and then create tables to store your information. Finally, you’ll have gone through all the examples and coded them out, and be ready to confidently tackle non-trivial problems.
By the end of this training program, you will have developed your SQL skills and learnt how to answer business questions from the set of data.
About the Author
Jeffrey James has been working in the analytics and data space since 2006. With roots in digital marketing and web analytics, he’s applied analytical techniques to problems ranging from customer value analysis to financial forecasting, machine learning and process automation. He’s made his share of mistakes on the way to mastery and understands the mindset of a beginner/learner.
