SDU Tools 144 Create Analytics View for Power BI and Analysis Services
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. This procedure takes the details of a data warehouse table in our suggested DataModel format, and scripts a view in our suggested Analytics format. It can be helpful for quickly creating analytics views in a data warehouse, particularly where they will then be loaded into Power BI or Analysis Services.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com