Lynda - Excel Power Pivot DAX in Depth
- Type:
- Other > Other
- Files:
- 67
- Size:
- 429.87 MiB (450748843 Bytes)
- Uploaded:
- 2016-01-20 07:33:40 GMT
- By:
-
2boweb
- Seeders:
- 3
- Leechers:
- 0
- Comments
- 0
- Info Hash: 4FAD6ED94F71483FA9AB9B2CC0F91AB543E7C913
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Excel Power Pivot DAX in Depth This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. 2h 25m Intermediate Jun 08, 2015 Updated Jun 08, 2015 | Uploaded in Jan 20, 2016 by 2boweb Subject: IT Software: Excel Author: Ron Davis You cannot get far in Excel Power Pivot, the future of personal business intelligence, without an understanding of DAX: Data Analysis Expressions. This course teaches you how to unlock DAX's power by understanding its fundamental elements: its syntax, operators, data types, and functions, including the revolutionary CALCULATE function. Author Ron Davis also helps you understand how evaluation context affects DAX expression output, and integrate time and dates into Power Pivot calculations. Start watching now to take your data analysis skills to the next level with DAX. Topics include: • Exploring DAX syntax and data types • Using functions • Understanding evaluation contexts • Using CALCULATE to change evaluation context • Working with dates • Utilizing many-to-many relationships • Implementing banding ////////////////////////////////////////////////////////////////////
| 022 Sourcing calendars.mp4 | 31.8 MiB |
| 006 Exploring data types.mp4 | 27.83 MiB |
| 015 Understanding single table evaluation context.mp4 | 23.88 MiB |
| 008 Exploring the PowerPivot data model.mp4 | 23.66 MiB |
| 019 Exploring how CALCULATE works.mp4 | 21.23 MiB |
| 025 Exercising caution with time intelligence.mp4 | 16.43 MiB |
| 026 Utilizing many-to-many relationships.mp4 | 16.38 MiB |
| 017 Exploring FILTERS and the ALL functions.mp4 | 16.26 MiB |
| 011 Using logical functions.mp4 | 15.92 MiB |
| 016 Understanding multiple table evaluation context.mp4 | 14.75 MiB |
| 010 Using mathematical functions.mp4 | 13.63 MiB |
| 023 Working with date functions.mp4 | 13.01 MiB |
| 004 Getting familiar with DAX.mp4 | 12.61 MiB |
| 007 Utilizing operators.mp4 | 12.21 MiB |
| 005 Exploring DAX syntax.mp4 | 10.86 MiB |
| 018 Understanding the syntax and rules of the CALCULATE function.mp4 | 10.81 MiB |
| 012 Using information functions.mp4 | 9.68 MiB |
| 021 Understanding time intelligence.mp4 | 9.43 MiB |
| 002 What you should know before watching this course.mp4 | 8.59 MiB |
| 020 Utilizing CALCULATE to change evaluation context.mp4 | 8.27 MiB |
| 014 Understanding evaluation context for calculated columns and fields.mp4 | 8.17 MiB |
| 013 How to proceed through this chapter.mp4 | 8.13 MiB |
| 001 Welcome.mp4 | 7.64 MiB |
| Exercise Files/4 Chapter/Time Intelligence Functions.xlsx | 7.43 MiB |
| Exercise Files/4 Chapter/Time Intelligence Functions Start.xlsx | 7.42 MiB |
| Exercise Files/5 Chapter/Many to Many.xlsx | 7.4 MiB |
| Exercise Files/4 Chapter/WorkingWithDates.xlsx | 7.36 MiB |
| 027 Implementing banding.mp4 | 6.56 MiB |
| 028 DAX Studio and EVALUATE.mp4 | 6.27 MiB |
| 009 Understanding errors.mp4 | 4.75 MiB |
| 024 Working with DATESINPERIOD functions.mp4 | 4.68 MiB |
| Exercise Files/5 Chapter/Banding.xlsx | 4.24 MiB |
| 029 Next steps.mp4 | 3.74 MiB |
| Exercise Files/2 Chapter/Extras/Basic Calender.xlsx | 2.41 MiB |
| 003 Using the exercise files.mp4 | 2.21 MiB |
| Exercise Files/3 Chapter/Evaluation Context End.xlsx | 1.36 MiB |
| Exercise Files/2 Chapter/Mathematical Functions End.xlsx | 1.3 MiB |
| Exercise Files/2 Chapter/Logical Functions End.xlsx | 1.3 MiB |
| Exercise Files/2 Chapter/Mathematical Functions.xlsx | 1.29 MiB |
| Exercise Files/2 Chapter/Information Functions end.xlsx | 1.29 MiB |
| Exercise Files/2 Chapter/Information Functions Start .xlsx | 1.28 MiB |
| Exercise Files/2 Chapter/Logical Functions Start.xlsx | 1.27 MiB |
| Exercise Files/2 Chapter/Extras/Using Functions Start.xlsx | 1.27 MiB |
| Exercise Files/3 Chapter/Evaluation Context Start.xlsx | 1.27 MiB |
| Exercise Files/1 Chapter/Extras/Data Model Start.xlsx | 1.27 MiB |
| Exercise Files/1 Chapter/Data Type Conversion Start_01_05.xlsx | 1.27 MiB |
| Exercise Files/3 Chapter/Evaluation Context Single Table End.xlsx | 1.1 MiB |
| Exercise Files/3 Chapter/Calculate Function Start.xlsx | 1.1 MiB |
| Exercise Files/1 Chapter/Data Type Conversion End.xlsx | 1 MiB |
| Exercise Files/1 Chapter/Using Operators End.xlsx | 974.73 KiB |
| Exercise Files/1 Chapter/Using Operators Start.xlsx | 971.27 KiB |
| Exercise Files/1 Chapter/Data Type Conversion Start.xlsx | 971.26 KiB |
| Exercise Files/4 Chapter/Calendar Demo Test.xlsx | 956.34 KiB |
| Exercise Files/3 Chapter/Evaluation Context Multiple Table End.xlsx | 705.36 KiB |
| Exercise Files/3 Chapter/Evaluation Context Single Table Start.xlsx | 493.44 KiB |
| Exercise Files/3 Chapter/Evaluation Context Multiple Table Start.xlsx | 434.68 KiB |
| Exercise Files/3 Chapter/Calculate End.xlsx | 199.28 KiB |
| Exercise Files/3 Chapter/Calculate Syntax.xlsx | 199.14 KiB |
| Exercise Files/3 Chapter/Calculate Start.xlsx | 198.34 KiB |
| Exercise Files/3 Chapter/Extras/ALL FILTER VALUE End.xlsx | 155.91 KiB |
| Exercise Files/3 Chapter/ALL FILTER End.xlsx | 155.87 KiB |
| Exercise Files/3 Chapter/Extras/374607_03_06_Calculate Start.xlsx | 155.83 KiB |
| Exercise Files/3 Chapter/ALL FILTER Start.xlsx | 142.55 KiB |
| Exercise Files/3 Chapter/Extras/ALL FILTER VALUE Start.xlsx | 142.52 KiB |
| Exercise Files/3 Chapter/Extras/Calculate Function Demo.xlsx | 142.52 KiB |
| Exercise Files/3 Chapter/Extras/Calc_Table.xlsx | 10.06 KiB |
| Exercise Files/3 Chapter/Extras/Single_Table.sql | 496 B |
