Pro DAX and Data Modeling in Power BI

Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics



Bookstore > Books > Pro DAX and Data Modeling in Power BI

Price$54.99 - $61.99
Rating
AuthorAdam Aspin
PublisherApress
Published2023
Pages465
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484289943
ISBN-139781484289945
EBook Hardcover Paperback

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.


  1. (8 books)



Similar Books


Pro Data Mashup for Power BI

Pro Data Mashup for Power BI

by Adam Aspin

This book provides all you need to find data from external sources and load and transform that data into Power BI where you can mine it for business insights and a competitive edge. This ranges from connecting to corporate databases such as Azure SQL and SQL Server to file-based data sources, and cloud- and web-based data sources. The boo...

Price:  $51.08  |  Publisher:  Apress  |  Release:  2022

Pro Power BI Architecture

Pro Power BI Architecture

by Reza Rad

Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing a...

Price:  $40.88  |  Publisher:  Apress  |  Release:  2018

Advanced Analytics in Power BI with R and Python

Advanced Analytics in Power BI with R and Python

by Ryan Wade

This easy-to-follow guide provides R and Python recipes to help you learn and apply the top languages in the field of data analytics to your work in Microsoft Power BI. Data analytics expert and author Ryan Wade shows you how to use R and Python to perform tasks that are extremely hard, if not impossible, to do using native Power BI tools...

Price:  $29.88  |  Publisher:  Apress  |  Release:  2020

Learning IPython for Interactive Computing and Data Visualization

Learning IPython for Interactive Computing and Data Visualization

by Cyrille Rossant

You already use Python as a scripting language, but did you know it is also increasingly used for scientific computing and data analysis? Interactive programming is essential in such exploratory tasks and IPython is the perfect tool for that. Once you've learnt it, you won't be able to live without it.Learning IPython for Intera...

Price:  $14.81  |  Publisher:  Packt Publishing  |  Release:  2013

Problem Solving and Data Analysis Using Minitab

Problem Solving and Data Analysis Using Minitab

by Rehman M. Khan

Problem Solving and Data Analysis using Minitab presents example-based learning to aid readers in understanding how to use MINITAB 16 for statistical analysis and problem solving. Each example and exercise is broken down into the exact steps that must be followed in order to take the reader through key learning points and work through com...

Price:  $79.99  |  Publisher:  Wiley  |  Release:  2013

Pro DAX with Power BI

Pro DAX with Power BI

by Philip Seamark, Thomas Martens

Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI—Microsoft's leading self-service business intelligence application—and covers other products such as PowerPivot and SQL Serve...

Price:  $30.08  |  Publisher:  Apress  |  Release:  2019

Beginning DAX with Power BI

Beginning DAX with Power BI

by Philip Seamark

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges.Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoti...

Price:  $23.70  |  Publisher:  Apress  |  Release:  2018

Building Dynamics CRM 2015 Dashboards with Power BI

Building Dynamics CRM 2015 Dashboards with Power BI

by Steve Ivie

Dynamics CRM 2015 holds a wealth of information about customers and the sales pipeline, but sometimes leaves users with basic end-user reporting and dashboard options. Power BI is a great new tool for analyzing and presenting data, giving us the ability to dig deeper into the information. With the increased requests for real-time sales an...

Price:  $44.99  |  Publisher:  Packt Publishing  |  Release:  2015