O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data refresh

After importing data into the PowerPivot Workbook, keeping the data up-to-date for analysis is important, as data sources that were added would have some rows or columns that might have been added. Hence, using the features such as data refresh in the PowerPivot Workbook would come in handy in times like these. For instance, if the user is importing sales transaction data, refreshing the data must be done several times per day, in order to know the time interval for this kind of process. More importance has to be given to data refresh. Here, two types of industry data have been imported; they are e-commerce and retail. Both have relation database connection source and they would be all the more important if the users are using relational ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required