PowerPivot
- Excel PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013
- Excel PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size
- Excel PowerPivot Basics #03: Replace VLOOKUP with Excel 2013 Data Model & Relationships
- Excel PowerPivot Basics #04: DAX Formulas Can Be Easier & Faster Than Array Formulas
- Excel PowerPivot Basics #05: Import External Excel Tables, Build Data Model with SUMX function
- Excel PowerPivot Basics #06: Import, Filter, Edit From Multiple Data Sources: Access, Excel, Text
- Excel PowerPivot Basics #07: Calendar Table Calculated Columns: Month Year Quarter Fiscal Quarter
- Excel PowerPivot Basics #08: Edit Existing Connections, Import New Data, Existing Reports Update
- Excel PowerPivot Basics #09: Calculated Fields & DAX Functions 9 Examples
- Excel PowerPivot Basics #10: CALCULATE function to Change Filter Context (14 Examples)
- Excel PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable
- Excel PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table
- Excel PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data
Power Query
- Excel Power Query #01: Merge 3 Tables Into One in PowerPivot or Excel Table
- Excel Power Query #02: Transform Data and Import Into PowerPivot or Excel Table
- Excel Power Query #03: Import Multiple Text Files in 1 Step, and Amazing Pivot Chart For Grade Data
- Excel Power Query #04: Import Multiple CSV Files In 1 Step & Retrieve New Files Automatically
- Excel Power Query #05: Create Dimension Table From Fact Table for PowerPivot During CSV File Import
- Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model
- Excel Power Query #07: Extract Unique List For Data Validation List with Power Query
- Excel Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks
- Excel Power Query #09: Merge Multiple Worksheets in Workbook To New Table using Append Feature
- Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)
- Excel Power Query #11: Each Row Has 3 Records, Unwind Table into Proper Data Set
- Excel Power Query #12: Find & Replace, Group By 3 Columns, Load With Existing Connections
Power View
No comments:
Post a Comment