|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-with-oracle-analytic-functions/
课程评论：没有评论
**课程名称：** 使用Oracle分析函数进行数据分析 **课程概述：** 本课程面向希望学习如何利用数据进行分析以协助企业和组织做出重要决策的初学者。SQL（结构化查询语言）是与各种数据库进行数据操作的国际标准语言，对于数据分析至关重要。 本课程将重点介绍如何使用Oracle数据库中的分析函数进行数据分析。分析函数基于一组行计算汇总值，与聚合函数不同的是，它们会为每个组返回多行。这组行被称为“窗口”，由分析子句定义。对于每一行，都会定义一个滑动窗口，该窗口确定了用于当前行计算的行范围。窗口的大小可以基于物理行数或逻辑间隔（如时间）。分析函数常用于计算累积、移动、中心及报告汇总。 **课程内容：** * **分析函数的语法：** 学习编写分析函数的语法，包括`PARTITION BY`和`ORDER BY`的使用。 * **核心分析函数：** * `DENSE_RANK()` * `RANK()` * `FIRST()` 和 `LAST()` * `LAG()` * `LEAD()` * `LISTAGG()` * `ROW_NUMBER()` * **窗口子句（Windowing Clause）** 的应用。 **通过学习，您将能够解决以下业务问题：** * 每个区域的销售额前十名代表是谁？ * 组织中有多少名员工？ * 组织中有多少员工的收入低于45K？ * 过去18个月有多少新员工加入公司？ * 哪些商品在超市销售最快？ **目标受众：** 希望学习使用Oracle分析函数进行数据分析的初学者。
There is a demand for people who can use data to perform analysis thus helping businesses and organizations make important and critical decisions.SQL stands for Structure Query Language. It is an internationally standard language used to communicate with various databases for data manipulation. SQL is vital for data analysis. In this beginners course we will be using analytic functions to perform data analysis from an Oracle database. Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window and is defined by the analytic clause. For each row, a sliding window of rows is defined. The window determines the range of rows used to perform the calculations for the current row. Window sizes can be based on either a physical number of rows or a logical interval such as time. Analytic functions are commonly used to compute cumulative, moving, centred, and reporting aggregates.In this course we learn the syntax used to write analytic functions which includes the use of Partition By andOrder By. The analytic functions we will use for our data analysis include: • Dense Rank Function • Rank Function • First and Last Function • LAG Function • LEAD Function • LISTAGG Functions • ROW Number Functions • Windowing Clause Using analytic functions for data analysis can help provide answers to business solutions: • Who are the top ten sales-reps in each region? • How many employees in an organization • How many employees earn less than 45K in an organization • How many new employees joined the company in the past 18 months • What goods are flying off the supermarket shelves and so on..
