Refresh, Reuse, and Recurring Reporting

A model-driven workbook does not need to be rebuilt when data changes — it only needs to be refreshed. This is the practical payoff of all the work done in earlier sections: instead of spending hours updating formulas and fixing broken references, updating the dashboard takes minutes.

New data must match the existing table structure exactly — same column names, same order, same data types, and consistent key values. A mismatched column or an unexpected blank in a key column will cause measures to produce incorrect results after the refresh.

If the new data contains dates that fall beyond the current end of the dates table, those rows will not be reachable by time intelligence measures. Before refreshing, check the dates table covers the full range of the new data — including any new months — and extend it if needed.

Because all pivot tables and charts draw from the same data model, a single Refresh All updates every view simultaneously — a monthly dashboard, a quarterly dashboard, and any other pivot-based report in the same workbook. There is no need to update each chart or dashboard separately.

Task

Your task is to carry out a complete monthly data refresh from start to finish, following the seven-step checklist from the theory handout. Each step below maps directly to that checklist.

Step 1 — Check the incoming data

Go to the NewData sheet. Before touching the Sales table, verify the following:

• The column headers match the Sales table exactly: OrderID, OrderDate, CustomerID, ProductID, Quantity, UnitPrice, Total.
• There are no blank rows within the data.
• The OrderDate values are real dates (left-aligned text dates will cause problems in the Dates relationship).

Note down: what date range does the new data cover? You will need this in Step 3.

Step 2 — Add the new rows to the Sales table

• Go to the Sales sheet. Scroll to the bottom of the Sales table and identify the first empty row inside the table border.
• Go back to the NewData sheet. Select all data rows (not the header row). Copy them.
• Click the first empty cell inside the Sales table on the Sales sheet. Paste.

Verify: the new rows should have the table's alternating row shading. If they do not, the paste landed outside the table. Undo and try again, clicking one cell higher.

Step 3 — Extend the Dates table

The Dates table currently ends on 28 February December 2025. The new data includes March 2025 rows.

• Go to the Dates sheet. Click the first empty cell in the Date column below 28/02/2025, inside the table.
• Add a row for each day in March 2025. Fill the Year, Month, MonthName, and Quarter columns consistently with the existing pattern.

Tip: if the existing rows use formulas for Year, Month, and Quarter (e.g. =YEAR(A2)), extend those formulas alongside the new dates rather than typing the values manually.

Verify that the last row of the Dates table now reads 31/03/2025 (or the last date in the new data, whichever is later).

Step 4 — Refresh the model

• Go to the Data tab → click Refresh All.
• Watch for any error messages or yellow warning bars. If none appear, the refresh was successful.

Optional verification: open the Power Pivot window and check the row count at the bottom of the Sales data view. It should be higher than before.

Step 5 — Spot-check the results

Navigate to the Dashboard sheet and answer the following:

• Is March 2025 now visible in the monthly trend line chart?
• Has the grand total on the PT_Region PivotTable (you may need to unhide it temporarily) increased by a plausible amount?
• Do the Region and Category slicers still work correctly, with no blank or unexpected entries?

If any of these checks fail, return to Steps 2 and 3 and verify the data was pasted inside the correct table range and the Dates table covers all new dates.

Steps 6 — Final checks and save

• Confirm the slicers show no '(blank)' entries in any list. A blank entry in the Region or Category slicer indicates that some rows in the Sales table have no matching CustomerID or ProductID in the respective dimension table.
• Re-hide any PT_ sheets you temporarily unhid.
• Save the workbook.