Excel 2013 PowerPivot Basics 08

Edit Existing Connections, Import New Data, Existing Reports Update

DESCRIPTION

See how to:
(00:08) Overview
(01:45) Update Calendar Table in Excel file when we anticipate new transactional data with new dates.
(03:35) Update Existing Connections to Source Data Files when File Name or File Path has changed.
(04:17) Refresh Data Model with new data and new columns from Source Access File and new dates from Calendar table in Excel file. Refresh Data Model
(05:36) Use Table Properties to allow new column in fact table (new column comes from original data source).
(06:16) Reports automatically update!

WORKBOOKS

Download “Excel 2013 PowerPivot Basics 08.zip” Excel-2013-PowerPivot-Basics-08.zip – Downloaded 34 times – 3 MB







Be the first to comment

Leave a Reply