Beginning DAX with Power BI

The SQL Pro's Guide to Better Business Intelligence



Bookstore > Books > Beginning DAX with Power BI

Price$23.70 - $25.03
Rating
AuthorPhilip Seamark
PublisherApress
Published2018
Pages264
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484234766
ISBN-139781484234761
EBook Hardcover Paperback

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, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario.

Turbocharge your Power BI model by adding advanced DAX programming techniques; Know when to use calculated measures versus calculated columns; Generate new tables on the fly from existing data; Optimize, monitor, and tune Power BI to improve performance of your models; Discover new ideas, tricks, and time-saving techniques for better models.


  1. (2 books)



Similar Books


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

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

Beginning Big Data with Power BI and Excel 2013

Beginning Big Data with Power BI and Excel 2013

by Neil Dunlop

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft's Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps.While Be...

Price:  $18.76  |  Publisher:  Apress  |  Release:  2015

Up and Running with DAX for Power BI

Up and Running with DAX for Power BI

by Alison Box

Take a concise approach to learning how DAX, the function language of Power BI and PowerPivot, works. This book focuses on explaining the core concepts of DAX so that ordinary folks can gain the skills required to tackle complex data analysis problems. But make no mistake, this is in no way an introductory book on DAX. A number of the top...

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

Microsoft Power BI Complete Reference

Microsoft Power BI Complete Reference

by Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell

Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life.In this Learning Path, you will learn to create powerful interactive reports by visualizing...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2018

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

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

The Definitive Guide to DAX, 2nd Edition

The Definitive Guide to DAX, 2nd Edition

by Marco Russo, Alberto Ferrari

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You...

Price:  $33.30  |  Publisher:  Microsoft Press  |  Release:  2019