03-25-2017 08:12 PM
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.
03-26-2017 10:14 PM
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