|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dimensional-modeling/
课程评论：没有评论
**课程名称：** 多维建模：多表数据透视报表 **课程概述：** 本课程专为数据分析师、报表创建者以及使用数据透视表或仪表板的用户设计。课程将教授如何构建优秀的数据模型，以便快速进行数据分析并获得理想的报表结果。随着Excel Power Pivot和Power BI支持多表功能，掌握多表建模方法变得尤为重要。 您将学习如何在Power BI和Power Pivot中使用多表进行建模。课程将深入解释Microsoft示例中常见的`dimCustomer`（维度表）和`factSales`（事实表）概念，并指导您如何实际创建它们。 课程将提供一个**六步法**，适用于任何项目，帮助您正确构建Power Pivot和多表数据透视表的模型。通过掌握先进的数据模型，您可以简化工作流程，提升分析效率，获得更灵活、更精准的分析结果，从而给同事留下深刻印象。 您将理解**事实表**和**维度表**的含义，以及如何在**星型模型（star schema）**中有效运用它们。星型模型是一种流行的数据仓库设计方法，由Kimball提出，已被证明在数据分析领域非常有效。本课程将指导您如何遵循Kimball的指南设计多维模型，并将其应用于Excel Power Pivot，以获得灵活且强大的数据分析能力。 课程结束时，您将能够**设计、实现、填充并使用**多维模型。课程包含**三个演示**，直观展示如何将模型投入实践并进行数据填充。 **立即报名**，学习如何为Excel Power Pivot、支持多表功能的数据透视表，或任何数据仓库解决方案构建优质数据模型，高效完成您的报表工作！
Do you analyze data? Are you creating reports? Pivot Tables? Or Dashboards? This course teaches you how you can create the right data models for analytics and get results fast. With the multiple table option in Excel Power Pivot and Power BI this method is more important than ever!You will learn how to create a model for Power BI and Power Pivot tables with more than one table. If you look at the Microsoft Examples you will see dimCustomer and factSales. This course will teach you what that is and how to create it.You will learn a six step method that you can use for any project to get your model for Power Pivot and multi table pivot tables right. Make your work easier and impress co-workers with better data models to analyze your data and get more flexible results faster and even more accurate. Learn what fact tables and dimension tables are and how to use them within the star schema. Three words already to impress your co-workers. This course will teach you how to design a dimensional model according to the Kimball guidelines of creating start models for analyzing data. This model has been around for a very long time to create datawarehouses, but now you can use this for Excel Power Pivot. If you use this model for the structure of your tables, Power Pivot will give you great, flexible results.At the end of this course you will know how to design and implement the model, fill it and use it. There are three demos in this course that show you how you can put the model to work and how to fill it.Enroll in this course now to learn how to create the right models for Excel Power Pivot, Pivot Tables (using the multi table option) or any data warehouse solution and get that report done!
