Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Pro DAX and Data Modeling in Power BI : Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics, Paperback / softback Book

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

Paperback / softback

Description

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 how to define and enhance the core structures of your data model to make it a true semantic layer that transforms complex data into familiar business terms.

You’ll learn how to create calculated columns to solve basic analytical challenges.

Then you’ll move up to mastering DAX measures to finely slice and dice your data. The book also shows how to handle temporal analysis in Power BI using a Date dimension.

You will see how DAX Time Intelligence functions can simplify your analysis of data over time.

Finally, the book shows how to extend DAX to filter and calculate datasets and develop DAX table functions and variables to handle complex queries. What You Will LearnCreate clear and efficient data models that support in-depth analyticsDefine core attributes such as data types and standardized formatting consistently throughout a data modelDefine cross-filtering settings to enhance the data modelMake use of DAX to create calculated columns and custom tablesExtend your data model with custom calculations and reusable measures using DAXPerform time-based analysis using a Date dimension and Time Intelligence functionsWho This Book Is ForEveryone from the CEO to the Business Intelligence developer and from BI and Data architects and analysts to power users and IT managers can use this book to outshine the competition and create the data framework that they need and interactive dashboards using Power BI

Information

Save 10%

£54.99

£49.15

 
Free Home Delivery

on all orders

 
Pick up orders

from local bookshops

Information