|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-business-intelligence-with-sql-2-in-1/
课程评论：没有评论
课程名称：SQL：商业智能与SQL：2合1 课程概述：随着每一个新版本的SQL Server推出，支持和扩展商业智能能力的新特性越来越受欢迎。本课程旨在帮助您如何利用SQL商业智能收集、分析和可视化关键数据，以支持更好的商业决策，并扩展您对SQL、数据库及商业智能的知识。 本课程包括两个完整的课程，精心挑选以提供最全面的培训。第一个课程《商业智能的SQL基础》将使您对SQL有中级的熟悉度，主要集中在编写可维护和复杂的SQL语句以实现特定商业查询的能力。您将开始导入您的第一个数据集，即DVD租赁数据库。然后，探索并实践各种SQL子句和连接类型。您还将学习将外部数据导入数据库的技巧，而不必过于担心数据库管理员的功能和考虑因素。此外，您将学习如何将数据导入流行的商业智能工具（如Excel和Tableau），并进一步精炼分析，同时讨论数据的解读。 第二个课程《商业智能与分析的高级应用SQL》将涵盖从SQL到Tableau本地连接的工作流程，以及您在职业生涯中所需的分析内容。课程将通过案例研究解释CASE语句、公共表表达式和子查询等概念。您将使用Python生成网络分析获取源数据，并创建存储信息的表。最终，您将经历所有示例并进行编码，准备自信地解决复杂问题。 完成本培训项目后，您将提升SQL技能，并学会如何从数据集中回答商业问题。 关于作者：Jeffrey James自2006年以来一直在分析和数据领域工作。他在数字营销和网络分析方面有深厚的背景，应用分析技术解决从客户价值分析到财务预测、机器学习和过程自动化等问题。他在通往精通的过程中经历了多次失误，理解初学者/学习者的心态。
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 OverviewThis 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.
