Advanced Tutorials

This section cover more advanced topics like:

• Auto Updating of data warehouse and SSAS databases.
• How to more efficiently use dimensions and manage its members and data types.
• Surrogate keys and slowly changing dimensions.
• Data source related topics like
  • table reload options
  • incremental tables
  • using Powershell script to import from a CSV file.
• SSAS related topics like
  • Processing of multidimensional databases.
  • Tabular SSAS models.
  • XMLA scripts for roles and permissions.