|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/applied-data-modeling-using-snowflake-and-power-bi/
课程评论：没有评论
course-name: 应用数据建模：Snowflake 与 Power BI course-overview: 本课程旨在教授数据分析、商业智能和数据工程领域的专业人士如何更有效地组织和管理数据。您将从数据建模的基础概念、重要性及实际应用入手，深入了解概念、逻辑和物理设计方法，包括数据规范化、ER图以及星型和雪花型等维度建模技术。 课程包含两个实战项目： 1. **Snowflake 项目：** 使用网站销售数据集，学习如何设计和构建数据模型，定义表间关系，并利用 Snowflake 及生成式 AI 工具创建和填充表格，涵盖数据加载、测试和分析等全过程。 2. **Power BI 项目：** 使用旅客航班数据集，学习如何在 Power BI 中构建维度表和事实表，定义关键关系，验证数据模型，并创建基础的 Power BI 报表。 通过本课程，您将全面掌握数据模型的创建与应用，并能熟练运用 Snowflake 和 Power BI 工具实现数据建模。 key-learning-objectives: * 理解数据模型的目的和类型：概念型、逻辑型、物理型 * 掌握 ER 图和数据规范化技术 * 学习构建维度模型，包括星型和雪花型模型 * 学会使用 Snowflake 创建和填充数据模型 * 了解如何利用生成式 AI 加速数据建模任务 * 掌握在 Power BI 中设计和验证数据模型的技能 * 学习如何连接 Power BI 到 Snowflake 并进行可视化分析 tools-used: * Snowflake (云数据建模与存储) * Power BI (数据建模、验证与报表) * 生成式 AI 工具 (辅助建模与自动化) target-audience: * 希望更有效地组织数据的**数据分析师**和**BI专业人士** * 希望学习现代数据建模技术的**数据工程师** * 任何使用 Snowflake 或 Power BI，并希望改进数据管理和使用方式的**从业者** * 希望清晰、实用地了解数据模型构建和应用过程的**初学者**
Understanding how to structure and organize data effectively is essential for anyone working in data analytics, business intelligence, or data engineering. This course is designed to teach you the foundations and practical skills of data modeling using real-world tools and projects.You will start with the basics of data modeling - what it is, why it matters, and how it's used in the real world. From there, you'll explore conceptual, logical, and physical design approaches, including normalization, ER diagrams, and dimensional modeling techniques like star and snowflake schemas.Once the fundamentals are in place, you'll work on a guided project using a Website Sales dataset. You'll design and structure the data model, define relationships, and use Snowflake with Generative AI tools to build and populate your tables. From data loading to testing and analysis, each step is explained clearly and applied practically.In the second hands-on project, you'll use Power BI and a Passenger Flight dataset to build dimension and fact tables, define key relationships, and validate your data model inside Power BI. You'll also learn how to build a basic Power BI report based on your model.By the end of this course, you'll have a complete understanding of how data models are created and used, with the skills to apply them in tools like Snowflake and Power BI.What You'll Learn:The purpose and types of data models: conceptual, logical, and physicalHow to use ER diagrams and normalization techniquesBuilding dimensional models including star and snowflake schemasCreating and populating data models using SnowflakeUsing Generative AI to accelerate data modeling tasksDesigning and validating data models in Power BIConnecting Power BI to Snowflake and visualizing insightsTools Used:Snowflake for cloud-based data modeling and storagePower BI for data modeling, validation, and reportingGenerative AI tools for assisted modeling and automationWho This Course Is For:Data Analysts and BI professionals who want to structure their data more effectivelyAspiring Data Engineers looking to learn modern data modeling techniquesAnyone working with Snowflake or Power BI who wants to improve how they manage and use dataBeginners who want a clear, practical path to understanding how data models are built and applied
