Power Pivot Workshop Complete Bundle Год выпуска: 2015 Производитель: Udemy Сайт производителя: www.udemy.com/power-pivot-workshop-complete-bundle Автор: Marco Russo, Alberto Ferrari Продолжительность: 10 hours Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Узнайте, как master Power шарнир для Excel и Deutsche Boerse Group. Этот комплект включает в себя три курса: начальный, средний, и дополнительно.-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
Содержание
01 Introduction to Self-Service Business Intelligence 02 Introduction to Power Pivot 03 Loading Data 04 Data Modeling 05 DAX Language 06 Table Functions and CALCULATE 07 Basic Time Intelligence 08 Power BI and SharePoint 09 Creating Reports and KPI 10 Advanced DAX Concepts 11 Advanced DAX Functions 12 DAX as a Query Language 13 DAX Patterns 14 Conclusion 15 Additional Material
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}