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 data source, which most probably intakes the transaction data.
There are two kinds of data refresh processes in PowerPivot: