Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Business Intelligence with Excel, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:02:41
    Business Intelligence with Excel
  2. Урок 2. 00:10:56
    Introducing Power Query
  3. Урок 3. 00:12:14
    Applying Basic Transformations
  4. Урок 4. 00:08:47
    Editing Transformations
  5. Урок 5. 00:08:44
    Numerical Transformations
  6. Урок 6. 00:07:46
    Text Transformations
  7. Урок 7. 00:08:54
    Date Transformations - Building a Calendar Table
  8. Урок 8. 00:07:10
    Conditional Transformations
  9. Урок 9. 00:11:35
    Merging Datasets
  10. Урок 10. 00:08:57
    Appending Datasets
  11. Урок 11. 00:08:57
    Introducing Excel's Data Model
  12. Урок 12. 00:13:09
    Putting the Data Model to Work
  13. Урок 13. 00:10:30
    Relationships
  14. Урок 14. 00:15:15
    Relationships in The Excel Data Model
  15. Урок 15. 00:13:06
    Power Pivot Tables
  16. Урок 16. 00:06:49
    Calendar Tables
  17. Урок 17. 00:02:57
    Exercise: Imposter Syndrome
  18. Урок 18. 00:08:06
    Power Pivot Pitfalls
  19. Урок 19. 00:11:23
    Multiple Data Tables
  20. Урок 20. 00:10:23
    Calculated Columns With DAX
  21. Урок 21. 00:11:36
    The IF Function in DAX
  22. Урок 22. 00:15:11
    The SWITCH Function
  23. Урок 23. 00:09:45
    The RELATED Function
  24. Урок 24. 00:12:08
    Introducing Measures
  25. Урок 25. 00:10:40
    Using DAX Functions in Measures
  26. Урок 26. 00:13:34
    The CALCULATE Function
  27. Урок 27. 00:10:49
    The ALL Function
  28. Урок 28. 00:17:33
    Introducing Time Intelligence Functions
  29. Урок 29. 00:04:43
    The ISBLANK Function
  30. Урок 30. 00:10:41
    The DATEADD Function
  31. Урок 31. 00:13:02
    The DATESINPERIOD Function
  32. Урок 32. 00:10:34
    Variables in DAX
  33. Урок 33. 00:08:43
    The X Functions
  34. Урок 34. 00:09:26
    The RANKX Function
  35. Урок 35. 00:09:46
    The TOPN Function
  36. Урок 36. 00:08:53
    Pivot Table Formatting Tips
  37. Урок 37. 00:15:03
    Conditional Formating: Data Bars, Color Scales, and Icon Sets
  38. Урок 38. 00:10:12
    Custom Conditional Formats
  39. Урок 39. 00:14:59
    Introducing Pivot Charts
  40. Урок 40. 00:06:07
    Column Charts
  41. Урок 41. 00:11:44
    Line Charts, Area Charts, and Timelines
  42. Урок 42. 00:05:50
    Combo Charts
  43. Урок 43. 00:13:29
    Changing Measures With Slicers
  44. Урок 44. 00:17:19
    Using Pivot Tables as Formulas
  45. Урок 45. 00:01:18
    Thank You!