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

Author:   Adam Aspin
Publisher:   APress
Edition:   1st ed.
ISBN:  

9781484289945


Pages:   465
Publication Date:   26 November 2022
Format:   Paperback
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Our Price $171.57 Quantity:  
Add to Cart

Share |

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


Add your own review!

Overview

Full Product Details

Author:   Adam Aspin
Publisher:   APress
Imprint:   APress
Edition:   1st ed.
Weight:   0.927kg
ISBN:  

9781484289945


ISBN 10:   1484289943
Pages:   465
Publication Date:   26 November 2022
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

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.

Reviews

Author Information

Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for 17 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft data and analytics product suite. A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using the Microsoft data and analytics stack–both in Azure and on-premises. Business Intelligence has been Adam's principal focus for the last 20 years. He has applied his skills for a range of clients in the areas of finance, banking, utilities, leisure, luxury goods, and pharmaceuticals. Adam has been a frequent contributor toSQLServerCentral.com and Simple-Talk for several years. He is a regular speaker at events such as SQL Saturdays and SQLBits. A fluent French speaker, Adam has worked in France and Switzerland for many years. Adam is the author of popular Apress books: SQL Server Data Integration Recipes; Business Intelligence with SQL Server Reporting Services; High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform, and Power BI; Data Mashup with Microsoft Excel Using Power Query and M; and Pro Power BI Theme Creation.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

wl

Shopping Cart
Your cart is empty
Shopping cart
Mailing List