Pro DAX and Data Modeling in Power BI
Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics
| Price | $54.99 - $63.49
|
| 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
Expert Data Modeling with Power BI, 2nd Edition
by Soheil Bakhshi
This book is a comprehensive guide to understanding the ins and outs of data modeling and how to create full-fledged data models using Power BI confidently. In this new, fully updated edition, you'll learn how to connect data from multiple sources, understand data, define and manage relationships between data, and shape data models t...
Price: $53.99 | Publisher: Packt Publishing | Release: 2023
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI 
by Gil Raviv
Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming m...
Price: $29.28 | Publisher: Microsoft Press | Release: 2018
Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
by Daniil Maslyuk
Prepare for Microsoft Exam 70-778 - and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the exp...
Price: $31.30 | Publisher: Microsoft Press | Release: 2018
Introducing Charticulator for Power BI
by Alison Box
Create stunning and complex visualizations using the amazing new Charticulator custom visuals in Power BI. Charticulator offers users immense power to generate visuals and graphics. To a beginner, there are myriad settings and options that can be combined in what feels like an unlimited number of combinations, giving it the unfair label, ...
Price: $49.99 | Publisher: Apress | Release: 2022
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