|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-warehouse-power-bi-for-beginners-dw-ssis-etl-bi/
课程评论：没有评论
课程名称：数据仓库与Power BI初学者课程 - DW, SSIS, ETL, BI 课程概述：数据仓库是一种数据管理系统，旨在支持商业智能（BI）活动，尤其是分析功能。数据仓库通常包含大量历史数据，能够执行查询和分析功能，数据来源广泛，包括应用程序日志文件和交易应用程序。数据仓库通过集中和整合来自多个来源的大量数据，帮助组织从中提取有价值的业务洞察，以改善决策过程。同时，数据仓库随着时间的推移建立了重要的历史记录，成为数据科学家和商业分析师的重要资产。由于其强大的功能，数据仓库通常被视为组织的“单一真实来源”。 数据仓库的主要优点在于允许组织分析大量多样化的数据，并从中提取重要价值，保持历史记录。一个典型的数据仓库通常包括以下元素： - 用于存储和管理数据的关系型数据库 - 用于准备分析数据的提取、加载和转换（ELT）解决方案 - 统计分析、报告和数据挖掘能力 - 用于将数据可视化并呈现给业务用户的客户端分析工具 - 更复杂的分析应用，通过应用数据科学和人工智能（AI）算法，生成可行信息，或利用图形和空间特性进行更大规模的数据分析。 Power BI是一系列软件服务、应用程序和连接器的集合，旨在将不同来源的数据转化为连贯、视觉化和互动的洞察。数据源可以是Excel电子表格，也可以是基于云的和本地的混合数据仓库。Power BI使您能够轻松连接数据源，识别重要信息并与他人分享。 Power BI的基本组成部分包括： - Windows桌面应用程序Power BI Desktop - 在线SaaS（软件即服务）服务Power BI服务 - 适用于Windows、iOS和Android设备的Power BI移动应用。 本课程旨在帮助初学者理解数据仓库及Power BI的基本概念与应用，以便于后续的数据分析与商业智能实践。
A data warehouse is a type of data management system that is designed to enable and support business intelligence (BI) activities, especially analytics. Data warehouses are intended to perform queries and analysis and often contain large amounts of historical data. The data within a data warehouse is usually derived from a wide range of sources such as application log files and transaction applications.A data warehouse centralizes and consolidates large amounts of data from multiple sources. Its analytical capabilities allow organizations to derive valuable business insights from their data to improve decision-making. Over time, it builds a historical record that can be invaluable to data scientists and business analysts. Because of these capabilities, a data warehouse can be considered an organization's "single source of truth."Data warehouses offer the overarching and unique benefit of allowing organizations to analyze large amounts of variant data and extract significant value from it, as well as to keep a historical record.A typical data warehouse often includes the following elements:A relational database to store and manage dataAn extraction, loading, and transformation (ELT) solution for preparing the data for analysisStatistical analysis, reporting, and data mining capabilitiesClient analysis tools for visualizing and presenting data to business usersOther, more sophisticated analytical applications that generate actionable information by applying data science and artificial intelligence (AI) algorithms, or graph and spatial features that enable more kinds of analysis of data at scale.Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.Power BI consists of several elements that all work together, starting with these three basics:A Windows desktop application called Power BI Desktop.An online SaaS (Software as a Service) service called the Power BI service.Power BI mobile apps for Windows, iOS, and Android devices.
