2013
Pluralsight
Bill Pearson
4h 10m
English

Use PowerPivot for Excel to deliver self-service business intelligence! This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You'll soon be assembling data from diverse sources into models that deliver business intelligence upon demand. Throughout the rapid but practical exercises, you will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise.

01. Introduction and Foreword
01. Introduction and Installation.wmv

02. PowerPivot Installation and Overview
01. Introduction and Installation.wmv
02. Check for Installation.wmv
03. Demo Verify Installation.wmv
04. Self-Service BI and PowerPivot.wmv
05. Managed Self-Service Business Intelligence.wmv
06. How PowerPivot Works.wmv
07. Demo A Brief Overview of PowerPivot.wmv
08. Importing Text into PowerPivot.wmv
09. Demo Import a Text File.wmv
10. Importing from Excel to PowerPivot.wmv
11. Demo Import from Excel.wmv
12. Files Underlying PowerPivot.wmv
13. Demo Examine Files Underlying PowerPivot.wmv
14. PowerPivot with SharePoint.wmv
15. PowerPivot Features and Limitations, and Relationships.wmv
16. Demo Add a Relationship.wmv
17. Calculated Columns with DAX Examples.wmv
18. Demo Add Calculated Columns.wmv
19. Mount PivotTable with a Measure.wmv
20. Demo Create a Basic Dashboard with PowerPivot Data.wmv
21. Installation and Overview Summary.wmv

03. Building the Basic PowerPivot Data Model
01. Introduction and Distinctive PowerPivot Features.wmv
02. PowerPivot PivotTables vs. Standard PivotTables, and Data Sources.wmv
03. Demo Import SQL Server Relational Database Tables to PowerPivot.wmv
04. Examining Imported Relationships.wmv
05. Demo Examine Imported Relationships.wmv
06. Creating a Basic PowerPivot PivotTable.wmv
07. Demo Create a Basic PowerPivot PivotTable.wmv
08. Querying PowerPivot Data from within a PivotTable.wmv
09. Data Quality and Data Governance Considerations.wmv
10. Avoiding Disaster and Basic PowerPivot Data Model Summary.wmv

04. Working with the PowerPivot Model, and an Introduction to DAX
01. Introduction.wmv
02. Navigating PowerPivot and Manipulating Data.wmv
03. Manipulating Data Formatting.wmv
04. Manipulating Data Data Types.wmv
05. Manipulating Data Sorting.wmv
06. Manipulating Data Filtering, and Working with Columns.wmv
07. Calculated Columns in PowerPivot.wmv
08. Introducing Data Analysis Expressions (DAX).wmv
09. DAX Functions Type Groupings.wmv
10. Working with DAX The Basics.wmv
11. Enhancing the Model and Designing Calculated Columns.wmv
12. Adding Calculated Columns to the Model.wmv
13. Adding a Missing Relationship.wmv
14. The Related() Function and Concatenation.wmv
15. More about Concatenation, and Date Time Functions.wmv
16. Logical-type Functions.wmv
17. A Few More DAX Functions, and Summary.wmv

05. Build a Practical PowerPivot Application - Part 1
01. Introduction.wmv
02. Planning, Importing and Relating Data in the PowerPivot Model.wmv
03. Adding Support Tables.wmv
04. Creating a Calendar Support Table.wmv
05. Importing Data via a Linked Table and Creating a Relationship.wmv
06. Adding Date-related Calculations.wmv
07. Overview Holiday Support Table.wmv
08. Reviewing Results in a PivotTable.wmv
09. Summary.wmv

06. Build a Practical PowerPivot Application - Part 2
01. Introduction.wmv
02. Add Further Support Logic.wmv
03. Discussion Adding Support for Calculating Operating Days.wmv
04. Building Structural Support for Operating Days.wmv
05. Review Results via a PivotTable Operating Days.wmv
06. Adding Time Intelligence 'To-Date' Aggregations.wmv
07. Review Results via a PivotTable 'To-Date' Aggregations.wmv
08. Adding Time Intelligence 'Prior Time Periods'.wmv
09. Review Results via a PivotTable 'Prior Time Periods'.wmv
10. Adding Time Intelligence 'Prior Year plus Rolling Total'.wmv
11. Review Results via a PivotTable 'Prior Year'.wmv
12. Review Results via a PivotTable 'Rolling Total'.wmv
13. Averages, Sharing Calculations and More ....wmv
14. Review Results via a PivotTable Averages and More ....wmv
15. Summary.wmv

07. Practical PowerPivot Analysis and Reporting with PivotTables
01. Introduction and Objectives.wmv
02. PivotTable and PowerPivot Field List Overview.wmv
03. Demo Examine the PowerPivot Field List.wmv
04. Building a PivotTable with PowerPivot Data.wmv
05. Perform a Review from the PowerPivot Window.wmv
06. Demo Design and Construct a PivotTable from Scratch.wmv
07. Calculated Measures in the PivotTable.wmv
08. Demo Create Calculated Measures.wmv
09. Understanding Evaluation Context.wmv
10. Key Performance Indicators (KPI's).wmv
11. Demo Examine a Simple KPI.wmv
12. PivotTable Rules of the Road.wmv
13. Summary.wmv

http://pluralsight.com/

Download File Size:837.98 MB

---