Restore the relational database from backup: mssqltips_dw.bak

Restore the SSAS database from backup (connect to Analysis Services): SSAS.abf

The script that was used to populate mssqltips_dw from AdventureWorksDW is populate_fact_sales.sql
Don't run the script if you restore mssqltips_dw database; the data is already there