AdventureWorks Database
AdventureWorks 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 AdventureWorks 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.
Here is the download link for the database.
About the Adventureworks Database File
There are 2 versions of the AdventureWorks database in excel 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).
AdventureWorks 2020
This is a modified version of the AdventureWorks 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 AdventureWorks Database 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.