Beginning DAX with Power BI

Beginning DAX with Power BI

Author: Philip Seamark

Publisher: Apress

ISBN: 1484234766

Category: Computers

Page: 262

View: 931

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. What You’ll Learn 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 Who This Book Is For Business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios.

Beginning DAX with Power BI
Language: en
Pages: 262
Authors: Philip Seamark
Categories: Computers
Type: BOOK - Published: 2018-05-15 - Publisher: Apress

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
Beginning DAX with Power BI
Language: en
Pages:
Authors: Philip Seamark
Categories: Business
Type: BOOK - Published: 2018 - Publisher:

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
Beginning DAX with Power BI
Language: en
Pages: 264
Authors: Philip Seamark
Categories: Computers
Type: BOOK - Published: 2018-03-31 - Publisher: Apress

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
Beginning Big Data with Power BI and Excel 2013
Language: en
Pages: 246
Authors: Neil Dunlop
Categories: Computers
Type: BOOK - Published: 2015-10-04 - Publisher: Apress

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
Pro DAX with Power BI
Language: en
Pages: 376
Authors: Philip Seamark, Thomas Martens
Categories: Computers
Type: BOOK - Published: 2019-12-09 - Publisher: Apress

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 Server Analysis Services