Pragmatic Self-Service BI with PowerPivot for Excel

1. pragmatic-self-service-bi-powerpivot-excel.zip55.93MB
2. 05. Build a Practical PowerPivot Application - Part 1/07. Overview Holiday Support Table.wmv25.66MB
3. 01. Introduction and Foreword/01. Introduction and Installation.wmv22.84MB
4. 07. Practical PowerPivot Analysis and Reporting with PivotTables/10. Key Performance Indicators (KPI's).wmv21.82MB
5. 07. Practical PowerPivot Analysis and Reporting with PivotTables/06. Demo Design and Construct a PivotTable from Scratch.wmv21.59MB
6. 07. Practical PowerPivot Analysis and Reporting with PivotTables/08. Demo Create Calculated Measures.wmv20.48MB
7. 02. PowerPivot Installation and Overview/20. Demo Create a Basic Dashboard with PowerPivot Data.wmv19.63MB
8. 06. Build a Practical PowerPivot Application - Part 2/08. Adding Time Intelligence 'Prior Time Periods'.wmv18.91MB
9. 05. Build a Practical PowerPivot Application - Part 1/03. Adding Support Tables.wmv18.66MB
10. 02. PowerPivot Installation and Overview/06. How PowerPivot Works.wmv18.16MB
11. 04. Working with the PowerPivot Model, and an Introduction to DAX/12. Adding Calculated Columns to the Model.wmv17.84MB
12. 06. Build a Practical PowerPivot Application - Part 2/07. Review Results via a PivotTable 'To-Date' Aggregations.wmv17.57MB
13. 05. Build a Practical PowerPivot Application - Part 1/06. Adding Date-related Calculations.wmv17.03MB
14. 06. Build a Practical PowerPivot Application - Part 2/09. Review Results via a PivotTable 'Prior Time Periods'.wmv16.64MB
15. 07. Practical PowerPivot Analysis and Reporting with PivotTables/02. PivotTable and PowerPivot Field List Overview.wmv16.29MB
16. 06. Build a Practical PowerPivot Application - Part 2/06. Adding Time Intelligence 'To-Date' Aggregations.wmv16.28MB
17. 07. Practical PowerPivot Analysis and Reporting with PivotTables/11. Demo Examine a Simple KPI.wmv16.22MB
18. 02. PowerPivot Installation and Overview/14. PowerPivot with SharePoint.wmv16.11MB
19. 04. Working with the PowerPivot Model, and an Introduction to DAX/15. More about Concatenation, and Date Time Functions.wmv16MB
20. 02. PowerPivot Installation and Overview/15. PowerPivot Features and Limitations, and Relationships.wmv15.88MB
21. 06. Build a Practical PowerPivot Application - Part 2/13. Averages, Sharing Calculations and More ....wmv15.55MB
22. 07. Practical PowerPivot Analysis and Reporting with PivotTables/05. Perform a Review from the PowerPivot Window.wmv15.49MB
23. 04. Working with the PowerPivot Model, and an Introduction to DAX/14. The Related() Function and Concatenation.wmv15.49MB
24. 04. Working with the PowerPivot Model, and an Introduction to DAX/07. Calculated Columns in PowerPivot.wmv14.98MB
25. 03. Building the Basic PowerPivot Data Model/10. Avoiding Disaster and Basic PowerPivot Data Model Summary.wmv14.48MB
26. 02. PowerPivot Installation and Overview/05. Managed Self-Service Business Intelligence.wmv14.42MB
27. 05. Build a Practical PowerPivot Application - Part 1/02. Planning, Importing and Relating Data in the PowerPivot Model.wmv14.4MB
28. 02. PowerPivot Installation and Overview/18. Demo Add Calculated Columns.wmv14.15MB
29. 02. PowerPivot Installation and Overview/04. Self-Service BI and PowerPivot.wmv14.11MB
30. 04. Working with the PowerPivot Model, and an Introduction to DAX/10. Working with DAX The Basics.wmv14.08MB
31. 04. Working with the PowerPivot Model, and an Introduction to DAX/13. Adding a Missing Relationship.wmv13.97MB
32. 05. Build a Practical PowerPivot Application - Part 1/05. Importing Data via a Linked Table and Creating a Relationship.wmv13.66MB
33. 02. PowerPivot Installation and Overview/09. Demo Import a Text File.wmv12.99MB
34. 07. Practical PowerPivot Analysis and Reporting with PivotTables/07. Calculated Measures in the PivotTable.wmv12.73MB
35. 05. Build a Practical PowerPivot Application - Part 1/04. Creating a Calendar Support Table.wmv12.61MB
36. 04. Working with the PowerPivot Model, and an Introduction to DAX/17. A Few More DAX Functions, and Summary.wmv12.27MB
37. 07. Practical PowerPivot Analysis and Reporting with PivotTables/03. Demo Examine the PowerPivot Field List.wmv11.98MB
38. 03. Building the Basic PowerPivot Data Model/03. Demo Import SQL Server Relational Database Tables to PowerPivot.wmv11.81MB
39. 04. Working with the PowerPivot Model, and an Introduction to DAX/11. Enhancing the Model and Designing Calculated Columns.wmv11.7MB
40. 06. Build a Practical PowerPivot Application - Part 2/12. Review Results via a PivotTable 'Rolling Total'.wmv11.63MB
41. 03. Building the Basic PowerPivot Data Model/02. PowerPivot PivotTables vs. Standard PivotTables, and Data Sources.wmv11.46MB
42. 04. Working with the PowerPivot Model, and an Introduction to DAX/16. Logical-type Functions.wmv11.43MB
43. 03. Building the Basic PowerPivot Data Model/08. Querying PowerPivot Data from within a PivotTable.wmv11.38MB
44. 02. PowerPivot Installation and Overview/16. Demo Add a Relationship.wmv11.1MB
45. 06. Build a Practical PowerPivot Application - Part 2/02. Add Further Support Logic.wmv10.92MB
46. 06. Build a Practical PowerPivot Application - Part 2/14. Review Results via a PivotTable Averages and More ....wmv10.77MB
47. 07. Practical PowerPivot Analysis and Reporting with PivotTables/09. Understanding Evaluation Context.wmv10.65MB
48. 04. Working with the PowerPivot Model, and an Introduction to DAX/08. Introducing Data Analysis Expressions (DAX).wmv10.48MB
49. 06. Build a Practical PowerPivot Application - Part 2/11. Review Results via a PivotTable 'Prior Year'.wmv10.22MB
50. 03. Building the Basic PowerPivot Data Model/05. Demo Examine Imported Relationships.wmv10.1MB
51. 02. PowerPivot Installation and Overview/01. Introduction and Installation.wmv9.78MB
52. 04. Working with the PowerPivot Model, and an Introduction to DAX/02. Navigating PowerPivot and Manipulating Data.wmv9.62MB
53. 07. Practical PowerPivot Analysis and Reporting with PivotTables/12. PivotTable Rules of the Road.wmv9.61MB
54. 06. Build a Practical PowerPivot Application - Part 2/03. Discussion Adding Support for Calculating Operating Days.wmv9.56MB
55. 02. PowerPivot Installation and Overview/07. Demo A Brief Overview of PowerPivot.wmv9.44MB
56. 04. Working with the PowerPivot Model, and an Introduction to DAX/06. Manipulating Data Filtering, and Working with Columns.wmv9.37MB
57. 02. PowerPivot Installation and Overview/11. Demo Import from Excel.wmv9.2MB
58. 06. Build a Practical PowerPivot Application - Part 2/10. Adding Time Intelligence 'Prior Year plus Rolling Total'.wmv9.16MB
59. 03. Building the Basic PowerPivot Data Model/01. Introduction and Distinctive PowerPivot Features.wmv8.73MB
60. 06. Build a Practical PowerPivot Application - Part 2/05. Review Results via a PivotTable Operating Days.wmv8.14MB
61. 03. Building the Basic PowerPivot Data Model/07. Demo Create a Basic PowerPivot PivotTable.wmv7.87MB
62. 03. Building the Basic PowerPivot Data Model/09. Data Quality and Data Governance Considerations.wmv7.6MB
63. 06. Build a Practical PowerPivot Application - Part 2/04. Building Structural Support for Operating Days.wmv7.17MB
64. 05. Build a Practical PowerPivot Application - Part 1/08. Reviewing Results in a PivotTable.wmv7.07MB
65. 04. Working with the PowerPivot Model, and an Introduction to DAX/05. Manipulating Data Sorting.wmv6.77MB
66. 04. Working with the PowerPivot Model, and an Introduction to DAX/09. DAX Functions Type Groupings.wmv6.69MB
67. 04. Working with the PowerPivot Model, and an Introduction to DAX/03. Manipulating Data Formatting.wmv6.66MB
68. 04. Working with the PowerPivot Model, and an Introduction to DAX/04. Manipulating Data Data Types.wmv5.7MB
69. 07. Practical PowerPivot Analysis and Reporting with PivotTables/13. Summary.wmv5.07MB
70. 02. PowerPivot Installation and Overview/13. Demo Examine Files Underlying PowerPivot.wmv5.05MB
71. 02. PowerPivot Installation and Overview/02. Check for Installation.wmv4.83MB
72. 05. Build a Practical PowerPivot Application - Part 1/01. Introduction.wmv4.64MB
73. 07. Practical PowerPivot Analysis and Reporting with PivotTables/01. Introduction and Objectives.wmv4.6MB
74. 04. Working with the PowerPivot Model, and an Introduction to DAX/01. Introduction.wmv4.55MB
75. 02. PowerPivot Installation and Overview/10. Importing from Excel to PowerPivot.wmv4.11MB
76. 05. Build a Practical PowerPivot Application - Part 1/09. Summary.wmv3.82MB
77. 02. PowerPivot Installation and Overview/17. Calculated Columns with DAX Examples.wmv3.7MB
78. 02. PowerPivot Installation and Overview/21. Installation and Overview Summary.wmv3.61MB
79. 07. Practical PowerPivot Analysis and Reporting with PivotTables/04. Building a PivotTable with PowerPivot Data.wmv3.53MB
80. 02. PowerPivot Installation and Overview/19. Mount PivotTable with a Measure.wmv2.97MB
81. 06. Build a Practical PowerPivot Application - Part 2/15. Summary.wmv2.81MB
82. 06. Build a Practical PowerPivot Application - Part 2/01. Introduction.wmv2.81MB
83. 02. PowerPivot Installation and Overview/12. Files Underlying PowerPivot.wmv2.26MB
84. 03. Building the Basic PowerPivot Data Model/06. Creating a Basic PowerPivot PivotTable.wmv1.87MB
85. 02. PowerPivot Installation and Overview/03. Demo Verify Installation.wmv1.86MB
86. 03. Building the Basic PowerPivot Data Model/04. Examining Imported Relationships.wmv1.31MB
87. 02. PowerPivot Installation and Overview/08. Importing Text into PowerPivot.wmv1.18MB