Pro DAX and Data Modeling in Power BI Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics

Develop powerful data models that bind data from disparate sources into a coherent whole. Then extend your data models using DAX–the query language that underpins Power BI–to create reusable measures to deliver finely-crafted custom calculations in your dashboards. This book starts off teaching you...

Descripción completa

Detalles Bibliográficos
Otros Autores: Aspin, Adam, author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, CA : Apress 2023.
Edición:1st ed. 2023.
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009711815906719
Tabla de Contenidos:
  • 1. Using Power BI Desktop to Create a Data Model
  • 2. Extending The Data Model
  • 3. The Semantic Layer
  • 4. Calculated Columns
  • 5. Calculating Across Tables
  • 6. DAX Logical Functions
  • 7. Date and Time Calculations in Columns
  • 8. Introduction to Measures
  • 9. Filtering Measures
  • 10. CALCULATE() Modifiers
  • 11. The Filter() Function
  • 12. Iterators
  • 13. Creating and Applying a Date Dimension
  • 14. Time Intelligence
  • 15. DAX Variables
  • 16. Table Functions
  • 17. Extending the Data Model
  • 18. Evaluation Context
  • Appendix A: Sample Data.