| 001. Welcome.en.srt | 1.5 KB | ||
| 001. Welcome.mp4 | 8.2 MB | ||
| 002. Important Versions and compatibility.en.srt | 5.4 KB | ||
| 002. Important Versions and compatibility.mp4 | 18.8 MB | ||
| 003. Set expectations.en.srt | 3.1 KB | ||
| 003. Set expectations.mp4 | 10.2 MB | ||
| 004. Introduction to Power Pivot and DAX.en.srt | 819.2 B | ||
| 004. Introduction to Power Pivot and DAX.mp4 | 3 MB | ||
| 005. Create a Power Pivot table.en.srt | 8.6 KB | ||
| 005. Create a Power Pivot table.mp4 | 31.5 MB | ||
| 006. Power Pivots versus normal pivots.en.srt | 4.8 KB | ||
| 006. Power Pivots versus normal pivots.mp4 | 16.2 MB | ||
| 007. Introduction to Data Analysis Expressions (DAX).en.srt | 2 KB | ||
| 007. Introduction to Data Analysis Expressions (DAX).mp4 | 7 MB | ||
| 008. Calculated columns.en.srt | 13.9 KB | ||
| 008. Calculated columns.mp4 | 49.8 MB | ||
| 009. DAX measures.en.srt | 3.8 KB | ||
| 009. DAX measures.mp4 | 13.8 MB | ||
| 010. Create implicit measures.en.srt | 3.2 KB | ||
| 010. Create implicit measures.mp4 | 11.5 MB | ||
| 011. Create explicit measures (AutoSum).en.srt | 12.2 KB | ||
| 011. Create explicit measures (AutoSum).mp4 | 41.2 MB | ||
| 012. Create explicit measures (Power Pivot).en.srt | 13.8 KB | ||
| 012. Create explicit measures (Power Pivot).mp4 | 44.5 MB | ||
| 013. Understand filter context.en.srt | 15.1 KB | ||
| 013. Understand filter context.mp4 | 53.6 MB | ||
| 014. Step-by-step measure calculation.en.srt | 18.6 KB | ||
| 014. Step-by-step measure calculation.mp4 | 69.7 MB | ||
| 015. Recap Calculated columns versus measures.en.srt | 4.1 KB | ||
| 015. Recap Calculated columns versus measures.mp4 | 14.3 MB | ||
| 016. Power Pivot best practices.en.srt | 3.1 KB | ||
| 016. Power Pivot best practices.mp4 | 10.5 MB | ||
| 017. Introduction to DAX functions.en.srt | 716.8 B | ||
| 017. Introduction to DAX functions.mp4 | 2.9 MB | ||
| 018. DAX formula syntax and operators.en.srt | 6.9 KB | ||
| 018. DAX formula syntax and operators.mp4 | 23.5 MB | ||
| 019. Common DAX function categories.en.srt | 7.2 KB | ||
| 019. Common DAX function categories.mp4 | 22.5 MB | ||
| 020. Basic math and stats functions.en.srt | 20.9 KB | ||
| 020. Basic math and stats functions.mp4 | 73.7 MB | ||
| 021. COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS.en.srt | 15.6 KB | ||
| 021. COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS.mp4 | 60.9 MB | ||
| 022. Logical Functions (IF, AND, and OR).en.srt | 25.7 KB | ||
| 022. Logical Functions (IF, AND, and OR).mp4 | 96.9 MB | ||
| 023. Switch and Switch (TRUE).en.srt | 15.8 KB | ||
| 023. Switch and Switch (TRUE).mp4 | 60.9 MB | ||
| 024. Text functions.en.srt | 17.3 KB | ||
| 024. Text functions.mp4 | 62.7 MB | ||
| 025. The CALCULATE function.en.srt | 23.4 KB | ||
| 025. The CALCULATE function.mp4 | 84.5 MB | ||
| 026. Add filter context with FILTER Part 1.en.srt | 14.6 KB | ||
| 026. Add filter context with FILTER Part 1.mp4 | 54 MB | ||
| 027. Add filter context with FILTER Part 2.en.srt | 23.4 KB | ||
| 027. Add filter context with FILTER Part 2.mp4 | 82.9 MB | ||
| 028. Remove filter context with ALL.en.srt | 13.3 KB | ||
| 028. Remove filter context with ALL.mp4 | 52.6 MB | ||
| 029. Join data with RELATED.en.srt | 6 KB | ||
| 029. Join data with RELATED.mp4 | 21 MB | ||
| 030. Iterator ( X ) functions SUMX.en.srt | 19.1 KB | ||
| 030. Iterator ( X ) functions SUMX.mp4 | 71.1 MB | ||
| 031. Iterator ( X ) functions RANKX.en.srt | 7.6 KB | ||
| 031. Iterator ( X ) functions RANKX.mp4 | 32 MB | ||
| 032. Basic date and time functions.en.srt | 7.7 KB | ||
| 032. Basic date and time functions.mp4 | 28.7 MB | ||
| 033. Time intelligence formulas.en.srt | 24.2 KB | ||
| 033. Time intelligence formulas.mp4 | 98.1 MB | ||
| 034. Speed and performance considerations.en.srt | 5.4 KB | ||
| 034. Speed and performance considerations.mp4 | 17.6 MB | ||
| 035. DAX best practices.en.srt | 3.4 KB | ||
| 035. DAX best practices.mp4 | 11.9 MB | ||
| 036. Final section.en.srt | 1.5 KB | ||
| 036. Final section.mp4 | 5.4 MB | ||
| 037. Data visualization options.en.srt | 7.3 KB | ||
| 037. Data visualization options.mp4 | 25.3 MB | ||
| 038. Wrapping up.en.srt | 1.1 KB | ||
| 038. Wrapping up.mp4 | 6.7 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| FoodMart_Data_Model_Part2_Complete.xlsx | 15.6 MB | ||
| FoodMart_SOLUTION_FILE.xlsx | 16.2 MB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Glossary_ExcelBusIntelligence_PowerPivotDAX.pdf | 99.7 KB | ||
| Part 3_ Homework Exercises.docx | 18.8 KB | ||
| PowerQuery_PowerPivot_DAX.pdf | 7.3 MB | ||
| ▲ 83 total files | |||
Excel Business Intelligence: Power Pivot and DAX
https://CourseBoat.com
LinkedIn Learning
Duration: 4h 1m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 1.39 GB
Genre: eLearning | Language: English
Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course—the third and final installment of the Excel Business Intelligence series—experienced Excel trainer Chris Dutton spells out how to use the DAX language and Power Pivot to explore and analyze relational data models. Chris picks up where he left off in the previous installment of the series, nstrating how to add calculated columns and measures to data models in Excel. He highlights the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 379.37 MB | Nawel087 | 1 year | 36 | 0 | |
| 415.95 MB | Nawel087 | 1 year | 26 | 0 | |
| 602.97 MB | Nawel087 | 2 years | 20 | 0 | |
| 143.8 MB | Nawel087 | 2 years | 1 | 1 | |
| 223.39 MB | Nawel087 | 2 years | 36 | 0 |
All Comments