Understanding Window Functions in DAX
Explore DAX window functions and apply semantics through examples, gaining insights into their capabilities and performance optimization techniques.
Using ALLEXCEPT or ALL/VALUES in DAX Calculations
Optimize DAX calculations by mastering when to use ALL/VALUES instead of ALLEXCEPT for improved performance and clarity in data analysis.
Data Mining in SQL Server Analysis Services
Explore advanced data mining techniques using SQL Server Analysis Services to uncover hidden patterns and gain valuable insights from your datasets.
Integrating SQL Server Analysis Services with Hadoop
Explore the integration of SQL Server Analysis Services with Hadoop, focusing on leveraging big data for enhanced business intelligence and analytics capabilities.
SSAS Design and Performance Best Practices
Explore scalable SQL Server Analysis Services cube design patterns and optimization techniques to enhance SSAS performance for your organization's needs.
Introduction to Time Series Forecasting
Learn intuitive time series forecasting using Microsoft's algorithm in SQL Server Analysis Services. Explore data preparation, model creation, querying, and result interpretation through Visual Studio and Excel demonstrations.
DAX Formulas in Action
Explore DAX formulas for BI solutions in Excel and SQL Server. Learn to create calculated columns, measures, and effective PivotTable analysis through hands-on demonstrations.
Introduction to Data Mining in SQL Server Analysis Services
Learn to create and integrate data mining models in SQL Server Analysis Services for customer prediction, marketing optimization, and forecasting using various algorithms and tools.
Developing and Managing a Business Intelligence Semantic Model in SQL Server Analysis Services
Learn to create, manage, and troubleshoot BI Semantic Models using SQL Server "Denali" features, with PowerPivot as a starting point for enhanced business intelligence capabilities.
Handling Role Playing Dimensions in Tabular Models
Explore various methods for implementing role-playing dimensions in tabular models, including DAX expressions, with a focus on model maintainability and user experience in data analysis.
Defining Entities and Attributes for Tabular Models - 20 Minute Guide
Define entities and attributes for tabular models using real-life project examples to improve design and address common issues.