Pro DAX and data modeling in Power BI : creating the perfect semantic layer to drive your dashboard analytics

Pro DAX and data modeling in Power BI : creating the perfect semantic layer to drive your dashboard analytics / Adam Aspin.

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...

Full description

Saved in:
Bibliographic Details
Main Author: Aspin, Adam (Author)
Format: eBook
Language:English
Published: New York, NY : Apress, [2022]
Edition:[First edition].
Subjects:
Microsoft Power BI (Computer file)
Dashboards (Management information systems)
Business intelligence > Computer programs.
Information visualization > Computer programs.
Visual analytics.
Information visualization > Computer programs
Visual analytics
Online Access:Click for online access
Table of Contents:
  • 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.

Similar Items