Adventure Works is a free sample database of retail sales data that is used in the examples and practice exercises in my books and training. I have a modified version of the Adventure Works database that I use for these purposes. You will need this modified database to complete the sample exercises.
Before you download the database, please consider subscribing to my newsletter in the box below. I won’t spam you, but I will share the latest blog articles and learning opportunities which will help you to become a Power BI ninja.
About the Database File
There are 2 versions of the Adventure Works database that you will find in your downloaded zip file. Adventure Works 2005 and Adventure Works 2020. Both are identical in data content except that there is a difference of 15 years in the sales dates.
Adventure Works 2005
This is the original version of Adventure Works (I call it Adventure Works 2005) that I used in my books Learn to Write DAX, Supercharge Power BI (2nd edition) and Supercharge Excel (2nd edition).
Adventure Works 2020
This is a modified version of the Adventure Works database that I used for Supercharge Power BI – 3rd edition – I call it Adventure Works 2020. It is identical in data content to the original version of Adventure Works (Adventure Works 2005) except that
1. I have added 15 years to the original dates
2. I have added 20 years to the birth dates in the Customer table.
Which Version of Adventure Works to Use?
The simple answer is that you can use either – the data content is the same. You may just need to allow for the 15 year difference when checking some of your answers.