Reply
Frequent Visitor
Posts: 4
Registered: ‎03-24-2017

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.

Moderator
Posts: 1,386
Registered: ‎03-06-2016

Re: Seeking data sets for dax practice

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