Pro DAX and Data Modeling in Power BI
Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics
| Price | $54.99 - $61.99
|
| Rating |  |
| Author | Adam Aspin |
| Publisher | Apress |
| Published | 2023 |
| Pages | 465 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484289943 |
| ISBN-13 | 9781484289945 |
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.
- Adam Aspin (8 books)
Similar Books
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
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 
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
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
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
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
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
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