Forum Discussion

danielc's avatar
danielc
Regular Visitor
9 years ago

Seeking data sets for dax practice

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.

Need Help
Tutorial Requests

1 Reply

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    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