Lynda – Data Modeling with Excel Power Pivot

Lynda – Data Modeling with Excel Power Pivot

Aggregating and analyzing data from different sources is made easy with Excel’s Power Pivot plugin. But before you can glean insights from your data, you’ll need to know how to build an effective data model, or collection of tables. In this course, Ron Davis covers all the steps for data modeling with Excel: adding data sources, setting up relationships between tables, and adding hierarchies. Additionally, he explores the power of DAX, the language behind the calculated columns and calculated fields that make for powerful PivotTables.
Topics include:
Data modeling concepts and terminology
Exploring the Power Pivot interface
Adding data sources
Working with date tables
Understanding perspectives and key performance indicators (KPIs)
Getting started with DAX syntax
Understanding evaluation context

Download uploaded
http://uploaded.net/file/vevp5z6b/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part1.rar
http://uploaded.net/file/9435vfx4/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part2.rar
http://uploaded.net/file/exmf5yle/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part3.rar
http://uploaded.net/file/kwsoy32k/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part4.rar
http://uploaded.net/file/6gsy26ty/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part5.rar

Download rapidgator
http://rg.to/file/67679c0c06d92c64acca2995195459c5/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part1.rar.html
http://rg.to/file/833640d766d2400c6bfbbf1b1f340d0b/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part2.rar.html
http://rg.to/file/ff57f7d5b02fe2328e6e65acbe1586ee/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part3.rar.html
http://rg.to/file/4f115feeb6d8462b1f21a989ab8a25e1/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part4.rar.html
http://rg.to/file/e6e9e2a517993b523a8959f529b7416b/Lynda.com-Data-Modeling-with-Excel-Power-Pivot.part5.rar.html

Download 百度云