|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-pivot-workshop-advanced/
课程评论:没有评论
课程名称:高级Power Pivot研讨会 概述:本课程旨在帮助您掌握Excel中的Power Pivot。通过深入理解DAX(数据分析表达式),您将能够撰写复杂的计算式。您还将学习如何利用Excel和Power Pivot的高级功能创建复杂的报告和数据模型。本课程包含近4小时的视频,分为24节讲座。学员需具备一定的Power Pivot和DAX语言的基础,或者在参加本课程前需完成初级和中级课程。 课程内容包括: - 创建报告与KPI - 高级DAX概念 - 高级DAX函数 - 将DAX作为查询语言 - DAX模式 完成本课程后,您将掌握所有工具和知识,能够使用Excel中的Power Pivot创建复杂的计算和模型。
The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot. The course includes almost 4 hours of video in 24 lectures. You need some experience of Power Pivot and the DAX language, or you should take the Beginner and Intermediate courses before this one. Sections included in this course: Creating Reports and KPI Advanced DAX Concepts Advanced DAX Functions DAX as a Query Language DAX Patterns After this course, you will have all the tools and the knowledge to create complex calculations and models using Power Pivot for Excel.