Seeking data sets for dax practice

[danielc]

Hey community,

Firstly I'm looking for suitable dataset sources, preferably public ones, to practice dax functions. Recently I've made use of the data sets on https://vincentarelbundock.github.io/Rdatasets/datasets.html however there are not many large ones. Creating my own data sets/databases is also an option however they dont provide the unpredictability and true randomness of real world data.

Also any decent ebooks/tutorials/websites which illustrate the use dax functions in many real world scenarios with an emphasis on application. The examples on the the official site do not click well with me.

Thanks.

[v-caliao-msft]

Hi @danielc,

You can use AdventureWorks sample database to practice dax functions. SQL Server introduces the Adventure Works Cycles company. This company with its business scenarios, employees, and products is the basis for the following sample databases: 

• AdventureWorks sample OLTP database

• AdventureWorksDW sample data warehouse

• AdventureWorksAS sample analysis services database

Reference
https://www.microsoft.com/en-us/download/details.aspx?id=49502

Regards,

Charlie Liao