Curso de lenguaje DAX

Data processing is one of the most important activities for companies and organizations; we live in the data age. To address this need, Microsoft created tabular models—stored in databases and consumed via reports in Excel and Power BI—that utilize an expression language called DAX. This book begins by covering the characteristics of the tabular model and the importance of achieving a sound design and optimal storage. When introducing DAX, the text examines its constituent elements, supported data types, and functions, as well as the necessary best practices and syntax. The content progresses from basic concepts—such as creating base measures—to advanced techniques like building efficient filters that leverage the language's specific features. The book also covers time-intelligence functions, which are ideal for making comparisons, calculating running totals, and performing calculations that combine different time periods. You will discover a range of functions that enable table iteration, windowing operations, and query functions, among others. DAX can be used to fine-tune graphical elements and their properties in analytical reports, resulting in creative and effective solutions. A dedicated section also focuses on optimizing DAX queries to ensure rapid report responsiveness and query efficiency.