Across
- 2. : SSAS mode that queries data in real-time from source systems
- 4. : Optimization tool in SQL Server Management Studio
- 6. : Power BI feature that allows syncing filters across pages
- 10. : Language used to define and manage multidimensional structures in SSAS
- 12. : SQL function to get the current date and time
- 13. : Power BI view used for creating reports
- 14. : Power BI feature that allows building calculated columns or measures
- 15. : SQL clause to filter grouped data
Down
- 1. : Tool in SSMS to analyze and improve query performance
- 3. : Type of join that returns all records when there is a match in one of the tables
- 5. : Power BI feature to preserve and restore filter context
- 6. : Tool to design ETL processes in MSBI
- 7. : DAX function to iterate and return a single value from a table
- 8. : SSAS feature that enables multidimensional analysis
- 9. : SQL function used to rank rows in result set based on a partition
- 11. : SQL keyword to eliminate duplicate rows
