|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-pivot-workshop-complete-bundle/
课程评论：没有评论
课程名称：Power Pivot Workshop Complete Bundle 课程概述：该课程包包含了Power Pivot Workshop的三个课程：初级、中级和高级。初级课程面向熟悉Excel的用户，介绍如何使用Power Pivot创建比单一几千行的数据表更复杂的报告。中级课程提升您在Excel中的Power Pivot技能，介绍DAX语言和重要特性，如CALCULATE函数和时间智能功能。高级课程让您掌握Power Pivot，深入理解DAX，能够编写复杂计算，并创建复杂的报告和数据模型，利用Excel和Power Pivot的高级功能。 Power Pivot适用于Excel 2010和Excel 2013，是微软自助分析工具Power BI的核心组成部分。学习此课程不需要任何Power Pivot的先前经验。课程总时长近10小时，共73节视频讲座，内容包括： - 自助商业智能简介 - Power Pivot简介 - 数据加载 - 数据建模 - DAX语言 - 表函数和CALCULATE - 基础时间智能 - Power BI和SharePoint - 创建报告和KPI - 高级DAX概念 - 高级DAX函数 - DAX作为查询语言 - DAX模式 该课程适合希望深入了解数据分析与建模的Excel用户，无论其经验水平如何。
This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Intermediate course improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions. 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. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course. The course includes almost 10 hours of video in 73 lectures, divided in these sections: Introduction to Self-Service Business Intelligence Introduction to Power Pivot Loading Data Data Modeling DAX Language Table Functions and CALCULATE Basic Time Intelligence Power BI and SharePoint Creating Reports and KPI Advanced DAX Concepts Advanced DAX Functions DAX as a Query Language DAX Patterns
